Search results

I'm transferring a table as a .txt file. I'd like the user to specify the filename each time the file is exported, since we're using Julien dates as filenames for the text files. Isn't there a way to do this with the File Name property of the TransferText command?

My table contains a field containing whole names (last, first, MI). Some of the names have middle initials, some don't. I am moving the data into a table where last name, first name and initial are all separate fields. I was able to separate the last name from the rest, but how do I separate...

I have a lookup db where I'm importing information that is transmitted on a monthly basis. The users of the db will check to see if an individual or group was included on the last transmission. The forms (and there are many) are based on parameter queries. In this example, I have a...

In my subform, I want to required entry in the END_DATE field if the field Status ="Complete" So far the code will continue to take the user back to the END_DATE field and prompt for a date as long as the Status is complete --- *except* if the user just closes the form. They'll get the error...

I am using the DLookUp function to automatically fill in a user's initials when their name is selected in a combo box on my form. The function works fine, and the initials are automatically filling in on my form. The problem is, they aren't storing in my table! I tried setting up a...

In the form I'm working on, when the status of a project as entered in a field named "Status" is "Complete," I want to required the user to enter a completion date. Otherwise, the completion date field may be left blank. I've tried writing this as a validation rule using the =Iif expression...