Search results

For various purposes and reasons, I create separate databases that load in the same set of text files. The record formats of these files are lengthy. Currently I either copy a database with the spec already in place to a new db and delete the non-relevant tables, queries, etc or retype the...

DaniBoy Try using the the format() command to convert the date field to a formatted text string before exporting.

Why not use Outlook or your preferred calendar app instead of building scheduling functionality?

I'm not sure if this will help, so I'll throw it out for others to answer: Is is worth moving the temporary tables to a separate back-end db? It just seems more effecient to put the tables that'll benefit most from compacting onto one location. The separate db's can then be compacted on...

I've been visiting this site often and found many answers. I recently joined because I though I could contribute. If it is not too labor intensive, a list of commonly asked questions with links to that discussion would be helpful - or perhaps a forum for known/common bugs or problems and their...

Gill, Create a table in Access with the fields you want saved from the questionnaire. Create a blank form, linked to this table. Copy the text from the word document and paste in into a form. Select and place the access fields on top of your pasted text. 12 pages is a bit much and the layout...

I had a similar problem using a poorly designed legacy database. It seems the programmer decided to split every possible element - SSNs (xxx-yy-zzzz), dates (mm,dd,yy) and times (hh,mm,ss) were all stored separately. I created a query to join the two tables, then recombined the fields. The...

Try importing the database instead of linking. A copy of the table will reside within your access db and you change change or modify to your hearts content. :D