Search results

I am creating an Access database that I want to be able to use to change a header table and its associated detail table. I have created a fmain-form that shows the header table fields. This form also has a subform which shows the detail records which are linked to a field in the header table...

I would love to create a bat file that will do this. But, I do not even know where to begin. I have used Winbatch and created a number of batch files running in windows, but never anything like this. Any code suggestions? Thanks.

I have an access database that I would like to upload daily to an ftp page on the Internet. I need to come up with a way to automate this process so that a secretary that knows little about uploading will simply have to click a button and the database will automatically upload. I know the...

Pat, Thanks for the insight. I was able to locate a simple but effective search/replace add to MS Access at: http://www.freewarefiles.com/program_10_109_7251.html Thank you so much .. this will save me countless hours! Mike

Actually, I am attempting to link the database into another application and the other application gives errors due to the two-word field names. That is why I am wanting to change the field names to one-word instead. Thanks

Years ago I created an Access database that holds employee information. There are multiple reports, queries, etc. I am working on a project and realize that I was not very smart in giving some of my database field names two words (i.e. First Name, Last Name, etc.). I should have used an...

Thanks! Pat, Thank you very much for your help. Your if-then-else statement worked perfectly! Mike

Friends, I want to create an if-then-else expression that will determine the number of people in a family. It is assumed that there is a head-of-household in all cases. Also, if there is a spouse allowance, there must be a spouse. I thought that determining the number of people in the family...