I hate to ask such a boneheaded question, but the internet just doesn't seem to be able to help me. I'm running Access 2003 on MS Vista. I'm trying to write...

I have linked tables between excel and access 2003 that contain cells with text. In excel they are formatted as "general" and in access they are formatted as...

I need to update a field in a record using the "On Click Button". This is what I'm trying to do. I know there's an SLQ routine I can use but I'm doing this...

USING A IIF STATEMENT IN ACCESS THIS IS WHAT IT IS IN EXCEL=IF(ISBLANK(F4)," ",(WEEKNUM(F4))) I am not sure how to write this in access any help would be...

Hi all. I have some form letters that we send out periodically. I know that I can perform a mail merge using an Access data source and Word's mail merge...

Hi, I am using source code from Albert Kallal mailmerge to insert data from an Acces form to a word template. It works perfectly except for I have a combo...

How can I set my form to update my fields as soon as a data changed? I tried to do the AFTERUPDATE, BEFOREUPDATE, ONLOAD, but they are all not doing it...

Hello, I am working on a union query and I am not sure if I need to learn vba or sql?

When data is deleted from fields in a record in the Access '03 database that I am using, the report continues to reflect that information. How can I remove...

Hi there, I want to ask you which will be the best way to make the database. Maybe the way I am thinking to make it (with option buttons and so on is not the...

I can't figure out how to get ACCESS to calculate years, months, days for a birth date. I want to take the current date, a birth date, and have ACCESS...

I have a database which is located on my server in a shared company folder. When one of my end users opens the database and then closes it, I automatically...

I have a Table containing Suppliers Information and the two fields I am interested in are "SupplierID" and "SupplierName", I have a Customer Table that...

I have a question and I'm not sure if it is a XP or Access one. I'm running Access 2000 under MS XP Media center edition and XP profesional I have 2 links to...

I've got 4 users who have Access '97. When they exit the application I'm responsible for, the application does close, but Access remains running. They have to...

In Access 2003, there's a button to backup. However, in 97 I don't see that option. Is there a way to backup the database without having exclusive...

I have a query that I transfer to a text file using the 'Transfer text' option in a macro. I have this macro assigned to the close event on my form so when...

Hi, I have made a macro that runs another macro and copies the results to a new column thus creating a list. I want to make the macro run over a large...

is there some way i can track what events might be causing the on cuurent event to fire on a given subform. it appears that the subform's current event fires...

Can I use something like DateDiff , ) to calculate elapsed time? I'm not interested in the date. I have the fields set to medioum time, i.e 11:30 AM I...