Search results for query: *

I think my new structure is much more normalized now with one exception that I can tell. It also appears more simple. Here are my tables and their relationships: tblSITE ========== site text prikey relates to tblSITE_DATES.ID_site tblDATES ========== sampledate Date/Time prikey relates to...

Thanks Ace for the resources, the fundamentals article is one of the best resources on normalization I have seen yet. Yes, I see the advantage of organizing the data as you mentioned, Duane. Keeping all the results in their own table makes a lot of since, that way you don't have any null values...

ok here it is, no luck with VB script though. I hope I didn't miss anything, and sorry I didn't get this to everyone sooner. Thanks again for your help, it means a lot. Let me know if I need to clarify anything, and sorry about the messy field names! TABLES SITES ===== Site_NM text PriKey...

Thanks for your patience. I've been working with the VB script on the page with out success. I will post as soon as I get it to work. Thanks again for your attention, and I'll post my tables and relationships as soon as I can.

Thanks everyone for the help. I don't have a way to post my database and I can't explain table structure better than I already have. Thanks again.

Besides the probe data (pH, DO, temp, conductivity) does this sound about how it should be set up? So, how did referential integrity play out in your database? Did you use it and when would you do so? Also, did you set up a form for your database? Excuse my ignorance here, but which table was...

Great, I'm glad I got the key business correct. I've been working in databases for the last couple of months and I can't seem to get past not seeing the data in tabular format. Up until now I have been using excel to store data and separating the data from its time and location is a bit scary at...

I am Using Access 2007. I have tables with environmental data separated by data type (i.e. turbidity). I want to relate those tables to a table containing sample site names and date times. I have a unique ID as a primary key linking the date time table to the tables containing the environmental...

Ha! I just got it to work! Here's the VB code: Option Compare Database Private Sub Command18_Click() CurrentDb.Execute "INSERT INTO [DesinationTable] SELECT * FROM " & _ "[dBase IV;DATABASE=C:\DirectoryToDBF;].[DBFtoAppend];" End Sub

Maybe I missed it but Transferdatabase process seems to do what the wizard already offers in Access 2007, where the DBF is added as a new table or a link. What I'm trying to do is append the data from a dbf to an access table that already exists with the same schema, just like you can do via the...

It appears that I Access was "protecting" me from the error message. I now have a syntax error in the second line. I will try to sort this out.

I've found several code solutions for this task but have yet to find one that works for me or is elementary enough for me to preform successfully. I'm am exporting dbf files from a program called EcoWin and I need to append those files to tables in Access, preferably in Access 2007. I have...