Hi, I am an office manager for a non-profit organization, and part of that is our campground and rental cabins. Right now everything is being done by hand,...

Currently I have a select query that prompts for a value when I run the query. It is a single value that does not vary with any records. How would I go...

I have a database that has the street number in one column and part of the street name in two other columns. How can I combine them?

Have just finished my first database for the elementary school where I teach. We have set the permissions so that the teachers have read and read/execute...

Hi all My query does not work: SELECT .(Max(.)) AS NotLatestEnd FROM Q_Tasks_Accs; I manage to save the query, but when I run it I get: "You tried to...

I have been entering records in a database, and saving it when am done for a session. When I reopen the database, I find the records are not in the order as...

How do I add a new transaction to an already existing record (member). I need to basically create a new transaction for a record that already exist. When I...

A while ago I created an Access database simply to contain the list of all Stargate SG-1 episodes, ordered by season number and disk. I thought I was being...

I want to start the Backup option from File Backup via VBA I tried DoCmd.RunCommand acCmdBackup I get a message like "Not available" Original in...

If I set up several action queries (append or update), is it possible to have one "master" query that calls the other specified action queries and run them...

I have split a access database into a frontend and backend. The frontend and backend are placed on two different computers. I have tryed many times where the...

Is there a way to use VBA to trim and entire record? I have a table that has 37 columns, each column need to be "trim" I know that I can create a update...

Greetings from the backpackers hostel in Panama. I have gotten for the most part my forms and tables OK, and now I am just suffering with unnecessary...

I am in Access 2000 for design view. Access will not let me drag footer down in order to extend the page and continue inputting design. I have searched for...

I've been working on a database project for a few months, and now that it's nearly complete I have split the database so that the tables reside on the server...

I want to have Access auto fill in the complete city name when I begin to type in the first few letters of the name

Please help me. I am an access newbie and cannot figure this one out. I have stumped the IT folks and others that know access well. I have been trying to...

Hello, I use MS Access 2003 on Win XP (SP2). I am opening 'exported' (DTS) data from a Solomon DB that has about 1400 tables and from 10 to 50 fields per table...

My db has a link to another's db which is only used to display a combo box list that I choose a name from. When I'm in my db choosing my name, apparently,...

How can I use Access to keep tract of church members & finances?