Search results

It works great!! One more question, if the user types in uppercase, how can I tell it to display the name in lowercase?

I have 3 fields that the user fills in. [1] First Name [2] MI [3] Last Name What I need is it to pull the 1st six letters of the last name and the MI and the 1st character of the first name. Example: Steven M Cunningham Would be: cunninsm

Not sure if this is the correct question: I have a form that has a drop down list. When I select an item from the list, I want it to fill in the information on the correct query name. Ex: I select TENNESSEE and it should right the information that I put into the form in the query...

I have a query that contains all my information for the different sites. What I would like is to have a text box display the total number of the routers listed in the item field. The item field contains entries like routers, servers, remote sites. I just want to display the total # from the...

tjs206, Can you email a copy to greg.smith@setechusa.com? Thanks

I have a list box the displays: routers, servers, remote sites. When you select one of the 3 from the list box, I would like the combo box view to become available and list the correct fields based on the selection from the list box. I have 4 tables created. Table 1 lists routers, servers...

How can I check to see if something has been added to a form? When you open a form and enter in no entries, it's considered blank till you select an option from a drop down box or enter text in a field. Is this correct?

Here is the code that I am using on a before update event: Private Sub Media1_BeforeUpdate(Cancel As Integer) Dim strMsg As String strMsg = "Data has changed." strMsg = strMsg & "@Do you wish to save the changes?" strMsg = strMsg & "@Click Yes to Save or No to Discard changes."...

One more question... If the day=1 it pops up my message telling me it's the end of the month and now I would like to have it fill in 3 fields that are combo boxes. Any idea??

Got it!! Thanks for the help.

I am clicking on it but it closes the form out of design mode...

Where is the Current event located? I only see where you can put events that require some type of action from the user...

David R - that works great but my main problem is that when you add a new record and it goes to the new screen and updates the record # and the date field automatically. How can I get it to test the day right after it inputs the date for you? Right now, I have to grab focus of the field for it...

I have a form that uses the =date() to get todays date. I need it to pop up a message if the day is the 1st of each month. Any clues?

When you select the command button (find record) it pops up the " Find and Replace " box. Is there anyway to type in a word in a unbound text box and have it search with the look in field set to: Tape Entry ( my form ) and the match set to: Any Part Of Field? Click the find icon to see what I...

That did it!! I figured out what I was doing... Thanks for the help!!

That did it!! Thanks

I am doing this but when I press the query button in my form, nothing but a blank query comes up. It's the correct query thou...

I have a form and a command button to display a query called "tape entry". What I want is a vb code that I can insert into the event procedure that will prompt you for a begin ID and a end ID. I do not want to insert the serach in the query from the query field (criteria) Any ideas??

Session 1 Name is my combo box that lists my entries: daily monthly yearly and it's from a table called backup specs BTW: I tried your code and it does not update correcly... The "d" works great but the "m" or "y" does not work correctly... [This message has been edited by GregSmith...