Search results

Access 2010. I've re-written a database in version 2010 to mimic the old 2003 version, but this time I've normalized it. I have a total of 12 tables (so far). I'm using one form for all 12 tables. I have a one-to-one relationship from one table to the other eleven. I've input dummy data and...

I'm not too familiar w/relational databases, but I'm trying my best to make this work. I'm improving the old w/the new. I hope you can open my Word 2010 file (.docx) I've attached. In reading my attachment, my question is: Am I on the right track? Thank you!

I think what I can also do is name a field Example1a and Example1b in order to separate one scenario from the other. It might be easier to do it this way. Still thinking...

So, Scenario A table and Scenario B table. Where data is not collected in one table, it might be recorded in the other table. Two different tables for two different scenarios, but when I run a query or report I want to pull the data from both in order to get one result.

This doesn't look right...standby for explanation.

Scenario A (Design View) Field Name Data Type Example1 Number Example2 Number Example3 Number Scenario A (Datasheet View) Example1 Example2 Example3 1 4 0 0 3 2 7 5 9 2 1 14 4 2 0 0 0 0 5 3 1 Scenario B (Design View) Field Name Data Type Example1 Number Example2 Number Example3 Number...

Elaboration. Basically, I would be plugging data into one of two tables with some of the same fields and would like to run a query/report on those particular fields and get one result. Two different inputs...one output. See attachment. Thanks!

Greetings. Access 2010. I've created a table utilizing certain fields that may be necessary during scenario A. However, if scenario A doesn't apply to the situation...then scenario B can come into play. The fields are the same, but can be recorded in either situation...not both. When I run...

Thanks Bob! You've been a big help to me on many occasions. Greatly appreciated! Chris, I appreciate your input as well. You guys are great!!!

Bingo Bob! That worked (Please excuse my excitement)!!! Question. In REFERENCES, I've deselected the Calendar Control, however there is also a "Microsoft ActiveX Data Objects 2.1 Library" reference. Do I deselect this one as well or leave it alone? :)

Greetings. So, two years ago I customized a database to suit our office statistical needs. It's been working like a charm. I created it in 2003, but now our office is migrating to Windows 7 (MS Access 2010). 2010 will not open my 2003 version based on a 'MACAL.OCX' error. I think I've...

Hey Wayne! Thanks for your reply. You guys have always been very helpful. Bear with me as the code is a little chinese to me. Can you elaborate on the following: Set rst = CurrentDb.OpenRecordset ("Select * From Your Table") Can you also point me in the right direction as to...

Access 2003. I have a table with 90+ Field Names. The table currently contains 2000+ records. I would like to run a query that will find any blank fields for the entire table. HELP!!!

MS Access 2003 Adobe Acrobat 9 Pro When I convert various reports from Access to PDF the conversion creates black and white files instead of color. I'd like to convert the reports as is...in color. Anyone?

Hi Bob! I'm opening the form via switchboard. I'm wondering if when I created the form (a year ago) I set it to add only???

Access 2003. I have a form with a Macro to GoToNewRecord on Open. Upon opening this form I want to be able to see the previous records. Data Entry is set to "No." Help.

Again Bob...just wanted to thank you for your patience and help. The statement worked after removing the asterisks from the brackets. Big relief! Thanks a mil Bob!!! :)

Lesson learned. I've pasted exactly what you sent, but still the syntax error.

Here is my SQL statement: UPDATE stats Set p-enf = 0 WHERE p-enf Is Null It's telling me: "Syntax error in UPDATE statement"

It's not liking me Bob. In the SQL view it starts with: SELECT; I've pasted the first line of your response replacing my TABLEname and FIELDname, but it keeps telling me: "The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the puncuation is...