How can I get my dates in a list box on my form to display in date order and not number order? My dates are in a separate table call "Dates" with two...

I have imported files from an excel spreedsheet into a new database in an attempt merge some fields. In previous years this data was provided to me with...

I am adding a new table to an old database. The new table will store name and address info for each of our stores. The existing table stores (no pun...

We have an unbound form & would like to load the text box on the form with data, then wait for the operator to make changes on the form. After that we would...

How can I get a table to show leading zeros, eg I enter 0123 and I get 123 I have it formatted as a general number. If I format as text it will allow leading...

I created a form from multiple queries and tables. When the form displays it is blank. I don't think I have applied any filters. I created the form using...

Where can I find a copy of this DB for the training on the eLearning site?

I am importing data from excel files. I have ranges that contain dates, most of which are simply numbers. However, I have a lot of dates that take the form:...

I'm working on automating my emails from Access to work through Outlook. I found a nifty code for VBA but it would seem the first line is wrong. It reads...

I would like to find the jobs that I have that have no ending date because they are not yet finished. I would like to find the total hours, billable...

I have a form that I created using the wizard. I now want to add controls that are I did not include when I originally designed the form. How do I do this?...

I am in the process of creating a document based on fields in a table, unfortunately the fields have some duplicating values and I cannot filter what I need...

I have looked around and can't seem to find any basic code to support crystal reports viewing in access. The report generator will allow me to make and...

I want to link one form from a database to our Intranet Sharepoint Portal, The team members would fill out a form and the information would show up in the...

I use Microsoft Access 2000 and have found the need to go beyond the Access basics. I do not see the need at present to upgrade my software. I have some VBA...

Regarding Visio and flowchart symbols. How do I make flow chart symbols/stencils/shapes (such as process and decision) expand and shrink to fit the text...

I have a delete command button on my form which I want to perform data validation on several fields before carrying out the action if all is correct. I have...

I work with 13 partners for 6 core clients. Each partner has a unique reference with each client. I have a table with the headings partner / client / referece....

I would like to create a simple Access Database and link it to Viso. I've tried all the tutorials and templates, but they just don't provide me with the...

I have an automated emailer code set up so Access tells Outlook to send out an email. I was wondering if I can link this automated email to a specific field...