473,836 Members | 1,462 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

User Forms to Search, Display and result

88 New Member
Hello Everyone.
I have a question and i would appreciate if any one can help....
Attached is a user form with 3 Search critira. I would like it to seach the worksheet display result in text box and on update that filtered list add a number(From the userForm)into in a column that says ppo #. any guidance in this will help.
Oct 21 '11
25 3172
sandy armstrong
88 New Member
How do i get it to automatically put the ppo# i do not want to have the users accidentally add the ppo# twice, thanks for always answering my questions...
Nov 1 '11 #11
Guido Geurs
767 Recognized Expert Contributor
This is a demo how to add the PPO automatically and how to use arrays (tables in the memory) when you have to many records.
Attached Files
File Type: zip New user form_v2.1.zip (22.5 KB, 113 views)
Nov 2 '11 #12
sandy armstrong
88 New Member
Thanks GUido That works Awesome!!!!!! I Can I transfer that user form to this datebase
Attached Files
File Type: zip Physician Database.zip (2.17 MB, 127 views)
Nov 2 '11 #13
Guido Geurs
767 Recognized Expert Contributor
Sandy,
There is a major problem in the workbook: the data in the columns to search on are not standard !
What I mean: there is 2x "Emergency Medicine", 2 x "Pulmonolog y", "NY" ,... once ending with 1 space, once with 2 spaces, ....
If you want to search on these data, they must be have a standard value like "NY" and not " NY" or "N Y " or "NY "...
The only way is to write a macro for standardization the data in the sheet.
Nov 5 '11 #14
sandy armstrong
88 New Member
Hey Guido Im sorry for the late respone. But thanks for looking at this for me. I understand there is no standards with the states or specailties. This data was collected from 3 different sites by mulitiple people. What i was trying to do is every time a college of my does emails blast using word mail merge she can track who she sent to and the date with the number of ppo# I thought creating a user form would be easier the trying to do some hard coding since iam very new to VBA. I really apprecaite your guidance and expertise so much Thank you...
Nov 7 '11 #15
Guido Geurs
767 Recognized Expert Contributor
Would it help when I write a form for standardizing the data in the 3 columns?
Nov 7 '11 #16
Guido Geurs
767 Recognized Expert Contributor
Hello Sandy,
I'm back on this call and working on a tool for standardizing the data.
Do You still want it?
Nov 18 '11 #17
sandy armstrong
88 New Member
Yea that would be awesome!!! thanks SO much!!
Nov 18 '11 #18
sandy armstrong
88 New Member
I would love that... Thanks Guido that awesome...
Nov 18 '11 #19
sandy armstrong
88 New Member
Hey Guido I am going to Uplaod a search user form that im using Can i use that same one that you helped me with but with some modifiations and changes to fit this porpose or do i need to create something from scatch.
Attached Files
File Type: zip BYtes.zip (23.6 KB, 104 views)
Nov 18 '11 #20

Sign in to post your reply or Sign up for a free account.

Similar topics

1
2038
by: Greg Brady | last post by:
How to display result set in random order? Thanks.
1
962
by: devccon | last post by:
Hi all, I'm quite stuck with this problem here. I have a search form (search.aspx) and I want the results to be displayed in another form (result.aspx). So far so good, I've implemented a datagrid and and the data shows up the first time. Now when I want to implement paging it can't find the next page. Obviously, because the querystring is empty. I also tried caching, it worked but I'm afraid of the memory overload and that the user...
1
1416
by: paavani krama via .NET 247 | last post by:
(Type your message here) I am using two forms.From the first form i need to getinformatiom.After performing necessary calculations,the resultshould be displayed in the 2nd form.i am storing the results inpublic variables in 1st form.I want the 2nd form to access thepublic variables in the 1st form and display the same in thesecond form.How can i do it? -------------------------------- From: paavani krama ----------------------- Posted by...
2
2621
by: Dursun | last post by:
Collegues, is it possible to do the foloowing: Let end user draw specific shapes (a circle that has a number within it and a connector that points to a specific area on the background image) using Windows Forms and controls. To be more specific, I want to design a VB.Net Windows form where end user will mark damages on an airplane picture (which might be background picture of the form) using a marker object that has a circle (with a...
6
2120
by: johntarr | last post by:
I hope I am not asking about something that has been done before, but I have searched and cannot find an answer. What I am trying to do is to run a query, and then perform some logic on the rowcount and then possibly display the result of the query. I know it can be done with ADO, but I need to do it in Query Analyzer. The query looks like this: select Var from DB where SomeCriteria
1
1004
by: Terry Olsen | last post by:
I have an ASP.NET web page that can display about 25 columns of data from an SQL database. I have it right now using a CheckedListBox to allow the user select the columns for display in the DataGrid. I have hardcoded 3 columns for filters and allow the users to type in to a TextBox the filter data. Are there any Query Builder GUI examples that I might use to allow the user to build their own query using any and all the columns?
6
4080
by: gunanallasamy | last post by:
hi Folks, i came across a situation for which still i couldn't get a solution. i have table like below(some other columns are also there) option value ------- ------ 100 1 101 200
0
1822
by: =?Utf-8?B?QW5pdGhh?= | last post by:
Hi, Currently for Announcement library a custom column "publish start date" is added and under the search result webpart changed the xslt by filtering the result based on the publish start date .Publish start date is not mandatory. if the publish start date <"" and publish start date <= today then the item get displayed under the search results else the item won't get displayed.
2
7161
by: metparker | last post by:
Hi everyone. I am trying to create a web form that will let search for records. the form will display the results on a screen that will enable the viewer to edit the record and then re-save it or cancel if wanted. I have the database. its has sample data. I can see the sample data from another machine. 'ssh'd' into the server and running mysql with appropriate commands. I have forms to retrieve the data and display the data on the screen...
0
9816
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9668
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10840
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10588
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10254
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7790
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6978
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4448
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4013
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.