Search results

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

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!

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

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

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!

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

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

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?

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.

Access 2003. I've created three additional Field Names to my main table after the fact. I currently have 1800 records with a numbered format for each field. We recently began recording data for the new fields. Up to this point that field was non-existent, therefore the recorded number should...

Help! I'm nervous about doing this only because I am a self taught MS Access novice so be nice. I'm using MS Access 2003. I've created a nifty database for our office and it works like a charm. I'm trying to add another field (same type as others) to my main table, however when I attempt to...

Access 2003. Greetings. Does any have a sample copy of a simple appointment database. Basically, I want to be able to take a phone call, record basic infomation from customer, and book them in the database. I would like be able to block times and get a view of past, present, & future...

Access 2003. I have a report that spits out data pertaining to boats. The report displays vessel name, sailing date, sailing time along with other data. In my sorting and grouping fields, I have the following: Date - Ascending (Group header, grouped on month) VesselName - Ascending ( Group...

Does anyone have a link similar to Access Help Center for Excel???

Access 2003. How can I get a calendar that displays the current date when the form is opened?

Access 2003. I have a form allowing users to enter a: FeeType and a FeeAmount. I also have a report (based on this form) calulating just the FeeAmounts. The FeeTypes consist of six choices. The user chooses one of the six. Along with their choice is the appropriate FeeAmount. I want to...

Access 2003. Why isn't the "Time" field sorting in ascending order just like the date. It sorts ascending in query, but not in report?