I have several databases that I have set to compact on close. Now that we are running Access 2007, I occasionally find that a database is missing after the...

What is the lowest level I can use to access the Jet Database Engine? I know I can use ADO or DAO. Are there any COM objects that msjet40.dll exposes that I...

This is the first of many questions believe me! The first question which most concerns me is the following: I am creating quite a unique database for a...

hi, I want to pull data from more then one field ( as it seems with a combo box with multiple fields listed in a row ) and have it save these fields to a...

I have an XP machine (all updates installed) with both Office 2003 and Office 2007 installed. 2003 was installed first and has been running fine for years. I...

Well as the name states I'm tyring to open a specific excel sheet from access 2000 for editing another poster helped me get this far Option Compare...

i have created a unbound local form to record details and wish to save the record to a table which is linked to the database on the server Access 2003 --...

Hi folks, I have a field Yes/No and when the box is (checked) I want the data to be transfer to another table with the same value "Yes" Dosen't anyone knows...

I tried to ask this on the reports area but got zero response. Is this to easy or is there no answer? I have tried everything to eliminate the problem but...

Been racking my brain for this one but cant think!! I have a form with 'Account Ref' as one field (and a company name field) which is a lookup from a master...

Hi! I have in main form two check boxes. OI would like when If Checkbox1 = Yes Then Checkbox2 = No else Checkbox2 = Yes Then Checkbox1 = No

.... a new record. (Sorry for the lame joke). What I want to do is have one form with a command button that when pushed will pop up a record from a table...

What would I have in the query for all records plus1 and and all records minus1 Thanks for any help................Bob

Hello, Could anyone help me - Im trying to covert text to date. The text represents a date in the format of year, week and day of week e.g. 2007421 (yyyywwd...

My text box has a control source to my table that is BillID , it shows the Bill ID numbers, What I would like it to show is the letter "C" before each...

I see both terms used. It appears that there is a developers tool kitt hat one can obtain to use with his or her existing access application. However, the...

I'm having three very unusual problems with Access 2007: 1. When I exit Access after making changes (forms or VB code) to any database, I get a message that...

Each time I run a query, a dialog pops up that asks me to enter a parameter value. The value requested reads "Query1.FIRST_NAME." The problem is that there...

To set the context- I'm a long-time IT techie with a career including everything from coding in assembly language to being an IT executive in a Fortune 100...

I have a table that has a Date field which I use a criteria to retrieve certain information. Also, I have a field on my report that shows the last date...