Say, is there an easy way to have the Navigation Pane collapse when a form loads? I'm not a programmer. Thanks.

How to sent an email in VBA via SendObject without using Outlook (no mail profile created). My company only uses Thunderbird? PLEASE help? Thanks -- smoeller

I would like to retrieve the DATA where Date_quote= Max(Price_Data.Date_Quote) What is wrong this this query? SELECT Car_Models.Manufacturer, & " " & & "...

Please help! My boss has ask me to set up a database with a search function and i cant remeber how do to it! He wants a box where you can type a small part,...

I've seen alot of entries for finding out who is logged on to the database. I am running a FE/BE Access 2007 database and would like answers for Access 2007...

Hi there! I'm a complete novice to database programming and am currently working my way through various online tutorials as I work on my application. I...

I have a report with a chart based on a query. The chart aggregates query results. Unfortunately, the report creates a chart and a page for every row...

I have a main form with several subforms connected to it. 1 of the subforms shows the material cost and the qty. used. Another subform shows the price of a...

I have a form that has a query as a record source based on criteria requested on another form: Query name: qryFieldPlacements-Counts SELECT...

I’m curious why my listbox treats SQL code differently than a regular query object. I’ve created this code to avoid having to create two queries: SELECT...

I'm trying to create a lookup query from Table A that includes three fields, however, when using the wizard only two of the three fields show...

Hi, I have an Access 2K reporting solution that pulls data (40 rows) from a remote SQL server database using a paramatised stored procedure call - A...

Hello, I need to generate letters from a query with parameters. I have found sample code, but keep bumping into lots of confusing messages (the task is taking...

I currently have many forms that are built and a queries built to fill other fields within a letter. Is it possible to add a button to the form that brings...

I've a problem with my access database because when I try to open it an error occur like this "Impossible to read record. You don't have permission to read...

How to sent an email in VBA via SentObject without using Outlook (no mail profile created). My company only uses Thunderbird? PLEASE help? Thanks -- smoeller

Hi, Im a first time access user so I may be doing things the wrong way round. Ive created a switchboard and linked forms to it that are to open in add mode....

Hi all, I have this table named "TBLDamagesDetail", The primary key of this table is "DamageID". It act as a auto number. I will like to change the format of...

I have a form that I use to lookup, create and modify records. I used a template and modified it to fit my needs. However, when I opened the form it opened...

-- Michael Randall Technical Writer Trend Micro, Nanjing China