I have a database containing just 2 simple tables: T_Main Fields a MainID (Autonumber, primary key) MainField (text) LookupField (text) T_LookUp Fields...

I am setting some variables with file names and want to check for their existence before proceeding in my VB code - how do I do that ? All files will be held...

I would like a command button on a form that will ask which field to search and what word(s) to search for. These are memo fields with info on books. I have...

I have a form that is bound to a Customer Table. On that form, I have 4 different methods of searching the Table that are done through Unbound Combo Boxes,...

List Box subform 200601 content of 200601, 200602, 200603.....etc data 200602 200603 * 200601 = 1st record, 200602=2nd record...

All - I have a field in a table that is numeric. It should be 11 characters but the table is omitting the leading zero's. Ex: 00092557589 is showing as...

I’m having problems with one unbound combo box filtering another unbound combo box. I’ve got the Row Source on cboContact set to filter by cboCompany. ...

I have a general information form that displays names, addresses etc from the "Customers Table and I also have a sub form "frm_sub_ExtraInfo" that I display...

Hi there, I have a new position where I will be maintaining (and hopefully creating) access databases. I have enough knowledge to make me dangerous (I warned...

I am having problems with a formula - I did not write it originally and am not very skilled at formula's either. Does something appear to be...

I have an Access database with 6,000 books entered. I have barcodes in the books and want to do a year end inventory. I will scan the barcode and would like...

I have a select statement as follows. Select * from qryClassSummaryDetail WHERE = 'ML2' AND Student_ID -1 I use it in a bit of code in this way...

How do I write a query returning all contact names begining with the Letter "A"?

Hello. I created a multiple select (extended) listbox field in my table and then selected it from my field list to add to my form. When I select values in...

I selected a layout from the six offered and I don't like it. How can I change it?

I have split a access database into a frontend and backend. The frontend and backend are placed on two different computers. I have tryed many times where the...

I am a self trained user of Word and Excel and have been using these programs for years. I imagine I only take advantage of 30% of the Excel features. I am...

I have multiple users that run reports off of my database - each of them have security to run the reports. Only one user gets an error when trying to run...

I'd like a message box to display after the form has loaded, but I can't find an event to use. Open and Load cause the message box to appear before the data...

I am real new to access. I need to make a customer service database. I'm not sure what I should use. Tables, forms, or reports. I need to be able to...