I cannot locate anyway to convert my access data into excel format. There used to be an "analyze data with excel" button in earlier versions of office but I...

I have a form with fields from two tables (tblAttendeeInformation and tblMeetings2001). I am trying to put a macro on one field that will set the value of two...

This is probably simple, but I can't seem to get around it. I have a form that is sourced to a query. The query main source is a linked to table in another...

Private Sub V_InvoiceNumber_BeforeUpdate(Cancel As Integer) If DLookup("", "", "Not IsNull(=!!) ") Then If MsgBox("Invoice number already exists....

I have built an inventory control database for a mid-size police department. I have several tables (employee,firearms,radios,vehicles). I am working on...

Hi Guys, Can anyone tell me the best way to load and store variables to call when users are in my application. In particular, I have a number of...

A gép valami hibát jelez sárga háromszöggel,de nemtalálom holvan????

After deleting a database in access 2003 how do I clear the database file from showing up on the task pane or the file open pull down menu?

If Access returns an Error for data how do I get it to change to a value?

In the Law Tracks example db in the frmSplash form the on timer event has a feature called ReConnect that goes through a series of functions checking to...

How would I append a row to an excel spreadsheet using access vab code? I think I know how to open an existing spreadsheet, but I don't know how to find the...

Are we able to hyperlink a field name in query to pivot table view? This hyperlink would go to internal application using the field name as link.

Hi All, I have a main form (frmFacility) with a subform (fsubTraining) with a subform (fsubUserTraining). Whenever I add a new record, while inserting...

Hi, How to change currency from $ to Php in my table? I am using access 2003 thanks for the help

I have some textboxes that are prevented from data being entered. Now I can't find the setting to do that for another text box. I thought there was an...

Is the any way that I can hide the access window to just leave up the form, but on a certain key stroke for it to reappear. I am a basic user so if you...

I want to make an ODBC link from Access 2003 to a large table in an Oracle database. Unfortunately this table has approximately 300 fields and only the first...

I'm aware that this is probably a silly question but is there a way of pulling sharepoint lists back as access 2007 local tables - I've got a client who needs...

Hello, I have created a pivot table and the data that I am attempting to work with is a number that is less than one. (i.e. .23 quarts) The tables, querys...

Hi all, I will like to create a button in my report to allow user to forward the report as attendment in the email by clicking on the button. Anyone can...