Search results

Hi Is there any setting that I can use that will make a form always open to a new entry? I don't want people to be able to edit the form. On the form I have created a New form button and a Save and clear button, but i would prefer it to be that when they open the form its always a new entry...

Just wanted a bit of advice regarding 2 things about foreign Keys. 1. When I am importing data into a table and I will be importing data into the foreign key should I be using an append query on that field only. That would then allow the referenced table to either update or choose Fkey ID in...

HI i was reading allen brownes guides in particular this one http://allenbrowne.com/casu-06.html . I am setting up my tables now but am wondering if there is a good guide or how-to on pulling a data sources (csv, xml or excel) file into multiple tables. Most examples I find show how to...

I wonder if I am overdoing the normalization and there might be a smoother better way to form my data. I was hoping a picture would explain it better. Essentially per competitor there could be multiple comments of multiple events but only singular comments per event for each competitor. I hope...

Whilst trying to develop my access db I have been reading a lot of different information and advice. Some conflicting. In Matthew MacDonalds book Access the missing manual he advises on using Lookup's in tables. So that when entering information into tables and you don't know an ID number that...

I am investigating how to format my time entries to match that of a sports stopwatch. I need it to be accurate to hundredths of a second, however I don't need a timer function as data will be either imported or manually input. I found this on google Stopwatch Tek tips. It basically advises...

I am doing a sports database and would like some advice on table structure. Using access 2007. I am trying to stop the repetition of "location" in tables. I already have created a location table with LocationID, State and Location Name. What I want to record is that each location will have...