Search results

I wil review your link about splitting the database. Regarding the macro...on Unload, I set it to "QuitAcess." Without it...the database closes, but Access remains open so I have to Exit the application. It's no big deal, but it would be nice to hit the "Exit" command button on my switchboard...

Sorry for the the various postings here. One more clarification regarding the splitting of THIS database. In my previous post, I mentioned 2 people would be inputting and 3-4 running reports. Since our office is very small the 2 people inputting will always be inputting at different...

Oh, the thing about the error message I was getting...it had something to do with a macro I had on Unloading the switchboard form (QuitAccess). I removed the macro and the error stopped. Why can't I use this macro?

You're scaring me Bob! :D What type of corruption are you talking about? I believe you meant to include a hyperlink perhaps, to further review splitting a database, but I don't see anything. Regarding our shared network...there will be 2 people inputting data and 3-4 people running reports...

Access 2010. I've created a database on my thumbdrive and I'm now wishing to place it on our network for multi-users. In copying/pasting the database the the network drive I'm getting the following error message when either trying to Compact and Repair and/or just simply close the darn thing...

Disregard...I rewrote the switchboard items and it works fine.

I will try what works. Thanks guys! Ran into another issue when setting the database to display the switchboard upon opening. What does this mean and how can I fix it? Thanks again! See attachment.

Okay, you were right Bob. The first time around I didn't completely finish creating a switchboard and accepted at that point. I deleted the original switchboard, recreated and can now see where the form was created on it's own. Whew! One more issue: I have a layout (Access 2003 version)...

Access 2010. I've created my switchboard, but I just need someone to slap the back of my head when creating a switchboard FORM. Do I do this manually? Linking command buttons, option labels, etc.? If you could just point me in the right direction to get me started. Thanks!

Okay, here are my real fields/tables: SELECT I407, I181, MS92 FROM Archived Records UNION SELECT I407NotTraveling, I181NotTraveling, MS92NotTraveling FROM Administrative UNION SELECT I407Traveling, I181Traveling, MS92Traveling FROM Main; The error message I'm getting is: "The Microsoft...

I've written my SQL statement as such (below), however I'm getting a syntax error (incomplete query clause). Can you please review? Thanks! SELECT Field1, Field2, Field3 FROM Table1 UNION ALL SELECT Field1, Field2, Field3 FROM Table2 UNION ALL SELECT Field1, Field2, Field3 FROM Table3; UNION ALL

A bit chinese for me. Could you break this down a little further based on what I've provided? Greatly appreciated!!!

Access 2010. I have three unrelated tables. Each table has it's own Date Field. There are three fields in each table I want to query. Instead of using any of the date fields for any of the tables, can I create a general date field in order to pull data for the specified records entered on...

Access 2010. I've created a query with four fields: Date Trucks Buses Cars The Date field in my query is set to "Group By." The other fields are "Sum" totals. On any one particular day there can be numerous records. The "Sum" fields will give me the sum for each day. I would like to...

Pat...would it be too much to ask for a sample?

Thanks for your reply Bob! In my "infinite" Access wisdom, I've changed the new database in that I've tried making it a more "normalized" database. The Access 2003 database has one large table (90+ fields) using one form to input. In the new, I've broken everything down into a variety of...

I've exported data from Access 2003 to an Excel 2003 spreadsheet in preparation for a data transfer from the old to the new. I've rearranged my field names to match exact table field names in Access 2010. I've elimated my primary key data from the old (Excel column) and created a PK in the new...

Interesting setup StarGrabber. Let me study this a bit. I appreciate your response and time. Thank you!

Thank you for responding. All of my tables (with the exception of a few other fields) are designed to collect numbers (statistics). Lagbolt - all of my tables basicly have the same structure and are set up to collect a number, but are categorized by different situations. David - Can you...

Let me see if I can break this down as easy as possible. Currently, we have 3 ferry companies sailing throughout the year (all sail more than once a day throughout most of the year). One boat can have many sailings, on these sailings we categorize passengers, vehicles, and any special...