Recent content by bgotis

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 what part of the class module do I name the boolean?

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...

Eureka! Figured out how to store the value - it is rough, but it works. I added another field to the form and bound it to the Initials field in the Names Table. I wrote a macro for the DLookup field that only works if it is set to run On Exit. The command is to goto the Dlookup Field, select...

PDX: Ruh-Roh.... I'm confused! :-P The Combo Box to pull up the full name is bound to the Name field in the project table. It looks up the names from the Names table, and stores the values in the projects table under "Assigned to." Does that clarify? Again, I appreciate your help. I...

Reply to Rich: Hi Rich, I have a table with the names of the department members. I have another table where I am storing the information about what projects have been assigned to each member of the department. We want to do lookups on those projects based on the initials of the person the...

Thanks for your response. A question: When I set the value, where am I setting it? (I'm using Access 97) I tried writing the code you suggested as BeforeUpdate for the InitField and also as an AfterUpdate for the Name field. Neither worked - any other suggestions? Thanks for your help --...

Worked!!! Thank you *very* much! :-)

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...