1

I have two tables.. Both have field names (AccountDescription, Amount, WTAX, InputTAX, NetofVAT, StatementCode) The Statement Code is either a BS or P&L. I...

Can someone please help me with and If statement. In my database I have a field which lists (via Combo Box) the following service...

hi, i have 2 forms, a "client details" form & a "visits" form. when i open the "visits" form i want a text box on that form to display the last record for that...

How would I be able to have two autolookup combo boxes on the same form one for CustomerID and a second for customer AccountNumber, both retrieving the same...

Dear all, Can you advise me how to hide a field up, i mean not to be amended. For example, I want to protect the "Passport No#" field not for further...

Hello, i have a db and i want to run just one ore more forms, but i dont want to see Access it self. i made this db for people how are 'afraid' of acces...

I have been wondering: when I compiled an MDB file into an MDE file with certain references, are those references "compiled" together into the MDE file? Or do...

I have a table named tracking with the following fields date and tasks. I would like to count how many days in a month that the tasks occured. e.g. if on the...

Hi all, I am building a new database and some of the table information has been imported from Excel. I have not yet set up my relationships, so that may be my...

We are a small multi-user workgroup, using an Access 2003 database which resides in a folder that all users have read/write access to. The database attributes...

I have two tables and i want to add the data from one table at the bottom of the other table. is there an SQL for doing this?

I am using Microsoft 2000, access to create a German English Dictionary of words I have learn't. Can anyone help? on how to put an Umlaut " over different...

I have a filter on a form for my reports and it consists of: 6 comboboxes and 2 date fields. The user may use one or all the filters for reports of the same...

I link to a "vendor" table. Then I open a form and depending on a code field, the subform displays data fronm the vendor table. The subform shows the correct...

I have been given a word document that uses FORMTEXT fields for the user to enter numbers and then the form calculates sums from what user enters. I want to...

Can Microsoft Access 97 open and run audio files from a given location e.g. when a database or form within the database opens? Specifically, I am trying to run...

I have a macro that simply runs a query which produces a report and then attaches it as an email attachment - in a snapshot file format. However, when i send...

I have a list box that is connected to a table that has a primary key that is made up of two fields (key1, key2). WHen you click on it the form goes to that...

Help! WHEN DOING A MAIL MERGE THE MERGED DOCUMENT IS ONLY PRINTING 1 ADDRESS PER PAGE. HOW DO I CHANGE IT TO PRINT ALL THE LABELS ON TO ONE PAGE ? ANY HELP...