I'm making a Micorosoft Access 2000 DB. What I want to do is to declare several constants (in VBA6) that I can reuse in other code such as me.caption,...

I am trying to subtract example Billed $ -Paid $ = Saving $

Hello All In Excel I can use Index & Match to return a value from a 10 row 5 column grid. How do I do this in Access please. Many thanks Mark (InWales)

Hello All I have now been tasked with designing a questionnaire for audit purposes. Does anyone know of a web resource for examples as I am floundering! Many...

Hi, This problem is driving me mad, please help!!!!!!! I have installed access 2003 each time I try to open a database (including the sample database...

Not sure if this is the correct newsgroup for this post, but here goes: I have imported ASCII data into an Access table. All of the fields show a 255 size....

Can anyone help please? I am using the following formula to try and tell me if an entry is greater than a certain date: IIf(1/1/2008,"YES","NO") However,...

Hi, Microsofot's help claims that it is possible to create a link between a table and itself. The text follows below from MS help: "You can also create a...

I have created a form with two dropdown lists from two seperate tables. I'd like to populate a third table with the selection from the drop down lists. Is this...

can anyone tell me how to get my email links, when I try to get links on my email it says application not found?

I have a form which has a control bound to a hyperlink field in a table. I want to be able to click on the hyperlink and have it open a word document to a...

Hi guys, Do you know if there is some place where you can consult the (complete) list of all MS Access SQL functions? I'm also looking for a comprehensive...

Hello, Does anyone here has an idea what this could mean and how to fix it? ODBC -- call failed. The sum or average aggregate operation cannot take a varchar...

Hello guys, I'm quite new to the MS Access. I would like to know how to handle the following issue: My MS Access database contains 4 tables linked to an...

We are about to purchase Access for our office, but I first need to make sure that along with all of the basic data, that it will also give us the...

if i have two different worksheet and i would like to know if there are items of each worsheet that has the same information. e.g. both worksheet have an item...

I'm a new user to Vista Ultimate and have just transferred over a lot of data & progs from my old XP computer. I notice that when I click "Start Search" on...

A database we use in Access 2003 has a form named frmJobInfo. It is a large form, with many fields, date and time picker contros, unbound controls with...

One of our Access 2007 databases seems to have encountered some difficulties with crashing. There are 18 users, and approximately 75000 unique records. This...