I have three tables that I would like to merge into one report. I have tried linking the files, exporting one into another, but neither action gives me the...

I've used an telephone number mask to enter area code and telephone numbers. I would now like to build a query to match an area code to a major city and...

Hai I been struggling to get my subform updated but it just won't update from the comboform. whenever I close and save it and reopen again then the subform...

I have a data entry form with four rows and two fields per row. I have a set a default of the current date in one column. If I enter a new record, the...

Hi guys, I have a little database that has a form that operates as a main menu. This menu opens a form that allows the user to enter data. It does...

I am having problems connecting to my secure Access DB through Citrix. It seems as though the Shortcut: "C:\Programs Files.. portion is causing the problem. If...

I am a very new user with very limited knowledge about Access or computers for that matter. I am using Access2000, and have been tasked with building a...

Hi All, I posted this in the General category but there was no response. I have an Acess application compiled to an .mde in 2002 and it would not open in...

Hi, I am trying to edit the downloaded database from my wifes web site. I download the file, edit it and as soon as I close it Access sends it straight to the...

Kristel Don't use tables for data entry. (you did ask "how", right?! g) Actually, don't use tables for data entry -- that's what forms are for. -- Good...

Hi all, i have a prob with Access. "NO" Yes, well i have Office 97 pro, bought it.... and it has been working fine up until 3 months ago when i had to buy...

I'm looking to put all my users on to the same version of office... currently have 97,2000, 2002 & 2003 !! I've only used office 97 so if anyone has any...

Queries desk copy, for short cuts and examples for formulas.

How can I get rid of extra blank spaces or cells in my columns? if I have a column with 26 numbers in it and the next column has letters "a b c d & f" in the...

anyone knows what the formula is for finding a distance betweeen 2 zip codes? Aaron

When I report in Access I would like for the report to sum up the items in the report? For ex: on the report I have 20 differnt part #'s for the month, but I...

A friend gave me her database to help her with (she barely knows access but has been developing this for a while) . When I try to import or export the forms...

I've inherited a rather large access database. I've been asked to change a field size (3 decimal positions instead of the current 2). I know how to find...

I have a subform in datasheet view and I want to hide one of the fields so that only certain fields display when the main form loads. How can I do this?

I am trying to activate a form in Access and go to a control from an entry in a combo box using either “OnChange� or “AfterUpdate event. It pops a...