Hi, I am currently writing a database and what i want it to do is when one particular field is filled in eg. Cylinder, then it will pick up only "cylinder"...

I would like to set up Outlook for me to use, so I added my email to the outlook that was already on my comp when I bought it used. Here is the situation: I...

Import spreadsheet from Excel and rec'd error message method of columns of object IIMEXGRID failed.

Hi I have two forms FrmA and Frmb. A command button on FrmA is used to open FrmB. What code do I need to use to prefill controls on FrmB with values...

I am working on a report I created to track training classes and hours taken. I need to sum the hours in seven different categories to show the total hrs taken...

Hi I've written a macro to export a table to Excel format, and then email it. When it is opened in Excel, 'Wrap text' is automatically set to ON, which means...

Fisrt timer I am new to access I have a database that I want to make better. In a form I have the following fields: Country, State, City I have 3 tables...

What's the easiest way to let users browse all records using a data sheet and then double click on a particular row to open that record in a different form for...

I have created a database that will track board members. One of the records on my member table is "current" ... the field is a yes/no field. I have reports...

Before you run a mile, because if you've ever used one, i know just the words "Combo Box" is enough to send shudders down your spine. They seem potential...

Hi I have a continuous form in Access 97 with several fields including a date field. I would like to show any record with today's date in a...

In programs like Excel, Quattro Pro, Wordperfect, dBase and many, many others I can think of that include a macro, programming or such capability, the user...

How can I get a combo box to come up when previewing a report so that the user can select an event name and then print preview the report specific to that...

I just can't figure out how to do this. A colleague created a db solution and I'm to help with creating the forms. So far, so good except for create a search...

I've got 2 tables, one with company locations/addresses and another with contacts for the company. Table 1 has an ID field for the company name and and ID...

I want the default value for a date field (short date format) to have the same value as another date field. I have tried entering this into Expression Builder...

--

How do you display a total from a subreport on the main report. If it makes a difference, the total is a total of a calculated field (Qty * Price). Does the...

Hello, i have corrected the join property of my related tables and have now encountered a second problem i can't update my records. the form i am useing is...

I have the following piece of code trying to pass 3 parameters to a query but get the error message 'Object Variable or With Block variable not set' on the set...