Recent content by Jurni

I've tried adding a combo box to the contact database that came with access. (I'm trying to add "salesperson.") When I click on one of the names on the drop down list, it puts that same name in all the records. I've tried putting in my own values and having it look up the values in a new...

I have a form created which has 25 fields for part names to be entered into. I need to get a count of how many of each part we are using. The name may be repeated several times. I do not know VBA, so I need a simple way to do this. I tried doing a pivot table, but I kept getting an OLE...

That looks pretty easy to me. I'll try it. Thanks...

Is there any way to have Access automatically type out an entry you have already used previously (on a form, in datasheet view) as in Excel? For example, in Excel, if you type "whatever" on one line, you only need to type in "w" or "wh" on the next line; Excel then fills in the rest. I would...

Is there any way to have Access automatically type out an entry you have already used previously (on a form, in datasheet view) as in Excel? For example, in Excel, if you type "whatever" on one line, you only need to type in "w" or "wh" on the next line; Excel then fills in the rest. I would...

Good news!!! The "Switchboard Manager" in Access 2000 is under "tools" then "database utilities."

Good news!!! The "Switchboard Manager" in Access 2000 is under "tools" then "database utilities."

I just created a database in someone else's computer, because he (along with most of the people that will be using the database) have Access '97. I have Access 2000. Anyhow, I emailed myself the database, but I couldn't open it on my computer. I got a msg saying that I didn't have permission...

I am using Access 2000. Unfortunately, most of the people who will accessing a database I need to create are still using Access '97. I know I can convert the finished database to "an earlier version," but once I do that I can't make any design changes, which is a big problem. I don't see any...

I am trying to import several Excel worksheets (different workbooks) into an Access Database. The option to add the data to an existing table is greyed out. I don't understand why. The columns in each table are exactly the same. I just installed Office 2000. I converted the original...

Problem resolved. Thanks anyhow...

I do have a field in the report that matches what is in the paremeter value box, but I want to keep that in the report. I'm not getting an "error message," just a box asking for a parameter value. I just want to get rid of the parameter box.

Whenever I run a report it asks for a parameter value (date sent to accounting). This report is based on a table (not a query). I can't find anything in the report properties or table properties that will allow me to delete this. What should I do?

I need to create a form that will treat all the records on a table/form as one record. I created a form from a table, which lists 21 items, a description of the item, a check box, the desired quantity of each item, the model no. for each item and its serial number. I tried to use this form as a...

I have created a form with a combo box that lists repair types. Below that I've got parts,labor and total (all formatted as currency). For Cylinder Repairs (one of the choices in the repair types combo list) the fixed cost will be $1,000. I have tried all sorts of iif expressions,but nothing is...