Search results

But if the user sets the default once on first open (probably validation rule, too)... that should be that, right? I am going to disable that particular field in all of the forms.

BobLarson: would you explain why text shouldn't be used?

Yes. This could be an option. One I was initially going to use. But for various reasons am now considering this option. If I can't figure out this particular route, I may have to use the one you suggested.

Because at some point we will be adding data from multiple sites into ONE database. So eventually, the tables will contain records from multiple sites and we have to be able to tell which site each record came from.

Also... I'm definitely looking for some example code, if you could oblige.

Data will be collected for analysis at multiple sites. A separate copy of the database will be sent to each individual site. After data collection is complete we will be taking the data from all sites and compiling it into one database to analyze. I'm try to minimize the redundant data...

Because at some point we will be compiling data collected at multiple sites into one database for analysis. I'm trying to minimize the redundancy involved on the data entry end, but we need this information for every record so once compiled we can still distinguish which data came from which site.

I have a database. Every table in that database has a field called "Site". When the database is opened for the first time by the end user they will be prompted to enter the name of their site. I want the value entered to become the default value for the field "Site" in every table contained...

I have a database. Every table in that database has a field called "Site". When the database is opened for the first time by the end user they will be prompted to enter the name of their site. I want the value entered to become the default value for the field "Site" in every table contained...

Dear Bob, I need your help! The solution you provided to this particular issue is on the right track to what I am needing, but my brain is having trouble wrapping itself around some of the concepts necessary to achieving this. I tried the example you gave. While it printed the appropriate...

Maybe I can try to make a better illustration of the two tables: (1) Document Table would have something like: ----Document -- Revision -- Release Date-- ECO # SOP-001 ----- B ---------- 6/12/11 ----- 0250 SOP-002 ----- D ---------- 5/10/10 ----- 0199 SOP-003 ----- A ----------12/13/10...

Hm... this could work I suppose. I'd have to play with a bit, but could I get it to display for all duplicate documents, not just once? And, yes, it sounds like you have the right idea, but understand that there are many more pieces of data to be updated than 3. It will be different for every...

"Documents" Table - List of documents & related info. All document #'s unique. No Duplicates "Employee Training" Table - List of document / employee relationships to identify training requirements. Duplicate records with the same document #/info. I want this Employee Training Table to...

Here is a copy of my text database if that helps.

The explanation is much appreciated... So... Another issue of sorts. A bit complicated perhaps. So my command button will append and update the selected information :). Now I have been attempting to create a query that will prevent duplicate records from being added to the training table...

NM... yay! Fixed! I guess some examples I was looking at had parentheses, but it actually should have had quotations.

This is what I tried last Private Sub Command6_Click() DoCmd.OpenQuery (DocumentListQuery1Query), acViewNormal, acReadOnly DoCmd.OpenQuery (Table1Query), acViewNormal, acReadOnly End Sub Keep getting an error "The action of method requires a...

I didn't particularly follow your last comment 100%. However, your first comment motivated me to explore other options. I'm on my way. I created a series of queries that will append and update a separate table based on form selection combo boxes, one selection for the document and one that...

Yeah, so I've heard. So, I am inexperienced. I know there would be an alternate way... I've tried creating a link to the original document table, but I don't think I can selectively link specific records in a table, nor can I add additional fields. I'm trying to avoid having to manually enter...

Ok... Hopefully I'll get a response for this issue. I'll try to keep it simple. I have two multivalue fields. One field indicates who should be trained on a particular document/procedure. The second indicates who has not yet been trained on the document/procedure. So I've successfully...