All - I'm creating a form that exports a Report to a PDF. I'd like to have it set up in VBA so that the report would go to the current user's My Documents...

Can anyone help? I need to calculate age in years, months and days from a date field. I found an early post and tried the suggested 'diff2dates' function...

After a few months of inactivity I am getting a response to using my well known password for the user "Admin" from microsoft access as "not a valid account...

I have an application that I've been working on for several years. The problem is that at one time I started to add a new function to the application and got...

I have a date field called RNDate with a long date format (i.e. 07/15/2007 9:29:00 AM). I want a separate field Called StartMonth which would be the first...

I have expense form in Access 2003, 1. I need to automate the check number control that if check number 100 has been entered previously when user is entering...

One of our former coworkers developed an Access report that pulls information from our online database for its table. The problem is this online database is...

Why would a linked table be bringing more rows than those that actually have data in them? The size of the linked table changes from day to day but the...

Some of my code windows have begun opening with the blue "drag" bar obscured so I cannot move or resize them. Is there a way to remedy this? viz:...

Hello, Mr. Falzon I would like to inform you that rachel has created a new e-mail adress; . She will be using this adress in...

LOT ALL BUILDING#9 KB HOMES CB $ 120.00 4-15-09 LOT 832 AND 840 BUILDING#4 PUNCH INSPETION $1,119.00 3-15-09 LOT...

I'm running Access 2007, and I want to add a TransferSpreadsheet option into my macro and I don't have that as a choice. It will not let me add it in.

Hi I have a report with 3 sub reports, unfortunately each subreport comes from a query which askes for start date and end date. So the outside form when I...

i created a page using access 2003 page wizard. It worrks when testing using page view. When I use web page view, it asks for saving the page first, and it's...

I am designing a report that has about fifteen columns on legal size paper. Sometimes the results in a column are longer than others and need more than one...

I am trying to use a Macro to run a query and update an exisiting Excel Spreadsheet. I have the following actions OpenQuery RunCommand...

Hi, never seen, Compiler corruption ??? ******* MICROSOFT COMPILER WRONG !!!!! ******** =============================================== !!!!! EXAMPLE FOR TEST...

Do any DBAs out there have preferably an MS Access routine that does the following: You populate a table name with either the server name or the server...

My app is designed to assist users in scheduling Contacts for Classes. There are a few steps of communication that must be sequentially followed throughout the...

MS-Access 07 - It displays ugly. I try to edit the swithbox and the pop-up message happens: "Compile error, in query expressing 'IIf(IsNull...