Access 2000. I am trying to find info on how to select a drive to export an excel file created from a query. I need to be able to select any drive using a...

I am listing a bunch of sequential dates in a continuous forms form. I want weekend dates to be sort of "greyed out". Having trouble with this one...can you...

I use a form that accepts text in a memo field. The data in the field is ultimately displayed in a text box on a report. What I would like to be able to do...

We have a network filing system which we store jpeg files on under a common directory with sub folders named according to the year ("2008", "2009" etc). As...

Hi I have a form with a Tab control on it with various sub forms on each tab. Each page of the Tab box has been enable set to no. So that users can view...

Hi I have a surname field which i want to be able to trim in an unbound field to only show the first 3 charecters. Ie: Blake ...

Hi everyone, I've never taken an Access course,but have taught myself over the years a lot of the backend and am very comfortable working just within the raw...

Hi, I have a an unbound mainform with ActiveX calendar and some buttons. It contains an unbound subform whose record source I update from a button event on the...

Hi, I have a form called "Project" where for every project we have, an overview is calculated with participants, statistics etc... This calculation is made...

Hello ... When adding data to a subform, I would like the prompt, ie the new line to appear in front of the data already in the table and shown on the...

I would like to be able to use VB to change the background colors in circles on a form. I can do this with rectangles, but can't find a "circle object" to...

Hi, I am just learning Access 2007 and have created a Search Button on a form that can be used to search all fields. Problem is the pop-up has two tabs...

I am trying to update an existing Access db form, Clients, that maintains a table of the exact same name; I want to add in a new table of information and...

I have a simple form that calculates cookie production and retail value. Everytime I open the forms the formula fields show errors. I then delete and...

One of my Acc07 forms has a subform that my users like to filter and sort. When I first designed it I was sorting on three fields, but when users sort on any...

When I use this code on a Close the Database button, it beeps loudly, but I don't see where it is telling it to beep. Users HATE the beep. Dim Msg,...

I have a form which i use combo boxes to select info on the form from querys. As i select from the first control the form will requery for the next selection....

Hi. I've created a form that returns records based on multiple filters (using http://allenbrowne.com/ser-62.html). I would like to be able to double click on a...

I am hoping someone can help me out with a problem that I am having. I am setting up a database that will serve as an archive for our reporting results. I am...

I am in Access 2000 and I have an event in a field on a form that takes a date and adds 29 days. It works on the form but does not populate the table. That...