Search results

Where do I find it?

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

Ah cool, I already have my tables and relationships set up so I just need to figure out an append query and how to set these to a macro and I should be fine.

As I will go down the Excel path. It seems the "One table" method would be used. Do I define a "Dummy" table for the imported data to go in or just let it create its own table, perhaps create a macro to always rename it to a fixed name and delete table at end of process. In the middle of this...

So import data into a holding table containing all values of other tables and then set a macro to split the imported holding table up into the relationalized tables. This would be extremely common wouldn't it? I don't want to re-invent the wheel with something that would have been done many...

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

Thanks for the reply, I will have a little bit of a think about the way to go. My day has been inconveniently interrupted by work so I will have a peep a little later tonight.

Should I combine the two comment tables or keep them seperate?

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

Went and got Access 2007 inside out, there above table datatypes in table 4-1, a warning not to use lookups in tables. Makes me doubt Matthew McDonald a bit, its a commonly recommended book and highly rated on amazon.

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 still trying to implement a good solution. I have been given the below from Arvin Meyer MVP. I haven't yet been able to test it but thought it may benefit others who could require it.

okay so if I store it as a real number I am going to need the user to input the time which commonly occurs as 02:30:45 for example. So then I would need three separate fields for input and a calculation to convert it to real numbers. so mm*60 + seconds +0.xx which is good because then I can...

My times will never break an hour, and I will be measuring down to hundredths of seconds.

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 will use lookup wizard to lookup locations table to reference locations. Thats normalized isn't it, separating each characteristic isn't it? Separating each element until its smallest element, then referencing to reduce redundancy. I am learning and I see I may have been unclear in my first...

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