Recent content by gavine

Thanks again for the response. I agree with the logical assupmtions you specified. These statements are all true. I applied your Not IsNull code below, however, the code is still not working as expected. The Invalid Entry message is firing when I try to change the Date Issued of an...

Thanks again for the instructive response. With the change you recommended, the code works such that I see the "Invalid entry" message box when I make a change. However this box triggers even when the update should be accepted, so I think the logic is not yet right. I'm trying to learn to...

Excellent, thanks so much! Works like a charm.

I have one table with phone numbers [Phone Assignment List], and another table with phone usage transactions [Call Detail Data] I want to have a report which lists the unqiue phone numbers which appear on the transaction report but not in the phone number table. I wrote the below query which...

Many thanks for the quick and useful reply! I'm confident that this is the right direction, but I can't get the code to work yet. I made a few small field name corrections below to match my field and table names. However when I run this I get a "Run Time Error 3464: Data Type Mismatch in...

I have a form validation challenge for which I humbly request your support. I am building a database for phone bill management. Phone numbers are assigned to users for a period of time, and then the same number is assigned to a different user for another period of time. Users should be...

Hello, I've installed this API and the Browse button appears to be working corrrctly (it triggers the file selection window). However, when I select a file and click "Open", the selection window closes but the file name and directory path is not populated on my form. I have a "Browse" button...

Perfect! This solves my problem, thank you so much for the help!

Thanks so much for the quick response! I've now tried the following but the syntax is not correct. Can you help? DCount("File Name","Data File Load History","Criteria= '" & [Forms]![SelectFile]![DataFileName] & "'")=0 I expect this statement to return TRUE if the DataFileName in the form...

Hello, I have a form where a user can specify a file name and upload it. I want to prevent users from loading the same file more than one time, creating duplicate records. I am trying to prevent this with a macro using the CONDITION field. When a user loads a file for the first time, after...