Search results for query: *

I need to update two tables using two forms. (Subform is not an option in this application) On form1 the user enters data to create a record in table1. Upon the user moving to another record or leaving the form, I check for pre-existence of the record. Regardless of existence, I want form2 to...

OK; so I just needed to look a little further. Another thread provided the clue I needed. I'm on my way. Sorry you needed to read through this unneeded post.

blackduck, your solution is exactly what I am attempting. Using Access 2003 and its so-called Help, I have not been able to find how to create a customer menu bar. I can create a custom toolbar and custom menu on the standard/default menu bar. I know in situations such as this, there is always...

SkipVought, Believe me, using a text field for a date is not an option I want to exercise. However, in reading other posts on this forum, it was mentioned that Excel and Access handle dates diffently. I am trying options to find anything that works. I changed the Excel field back to a date...

Thank you ProgramError and SkipVought. SkipVought, the Excel field originally was a Date & Time field. When I changed the Excel file type to text, I made the corresponding change to the TempLoad table. That's why I attempted to use the DateValue() function so the text field would be converted...

I have looked at several posts and I have not been able to find the answer to my situation. Using MS Excel 2003, I have a worksheet that contains a date entry in the format of mm/dd/yy. When I use the TransferSheet command within an MS Access 2003 function, the value populated within my Access...

Works great. thanks.

To add to what Petrosky needed assistance with, I would like my users to be able to enter multiple keywords (i.e., Canon, Nikon, Sony) and have all records with any of these values in the Keywords column returned. How would the solution already provided be modified so this would occur? Keep in...