I'm trying to extract the field names of a one-row table but keep gettning "Error 91 : Object variable or With block variable not set". The code...

Hi Folks, I have a database which uses a bunch of lookup tables. Many of these lookup tables have auto-generated indicies, and can have records added to them...

It seems that I've learned by default, that when using margins on a text box, it does not show the vertical scroll bar. Is this right, and is there anyway...

I have built a database in Access 2000 that makes use of the ODBC function to link three tables from a Lotus Notes Database. On my machine, the tables...

Hello everyone I need help with string! I have for ex. the string "Tomorrow will be a nice day" and I want to remove "will be a" in order to get final string...

I just wanted to know if there was a way to actually change the background color of a document without using a template or theme? If so, how?

Hello all, I am working with a database which has a main table, and then a few sub-tables with a one-to-many relationship. As far as I've been able to...

Hi yall I am trying to set a form to enter data into a table, but I want to be able to set up a validation rule that will stop users if they enter in a value...

So I have this simple db I created and one end-user wants to start entering data BUT I know there will be changes coming to reports/queries/forms etc. Do I...

Hello Everybody. A user has created a 'Select' query in MS Access. He normally 1/ runs the query (the user is prompted for an 'end' date / filter) 2/...

How do I Multiply Column A, Column B, and Column D within a table? I want the product to go in Column F within the same table. The data is well over 65K...

When I tuirn on my computer it says I"m missing .DLL file.XPRT5.DLL where do I get it?

I am using John Viescas Inventory database. Great database. frmVendorInvoices is the form and fsubVendInvoiceProducts is the continguous...

When I open outlook it goes to inbox. I can switch to sent box, outbox, etc. but I can't get the opening page with the "send and recieve" header, "new", and...

An mdb file we have been using between 3 or 4 users with sharing options is now only allowing one-at-a-time user to access the file (ToolsOptionsAdvanced...

Hi Folks, I have a database which uses a bunch of lookup tables. Many of these lookup tables have auto-generated indicies, and can have records added to...

hi, I have 2 tables: 1 with participants: ParticipantID Name 1 John 2 Mike 3 Elena

I have a tabbed area in a form yet I have done something to where when I add a new record the form it opens on the second tab instead of the first how do I...

I want to add draft as a watermark to a form, can this be done?

Hello, I have this formula: =IF(COUNTA($J2,M$1)2,"",INDIRECT("'"&$J2&"'!"&M$1)) I would like to modify it to only display results for dates that are no more...