Reference Variable in multiple Subs Hello, I’m trying to accomplish the following: Sub WriteQuery() Dim strSQL as String strSQL = _ “Select * from myTable”

I have a main form for material inspection, and another form for the inpsection results, and tables for each that store the data. For example, you have to...

The problem I have is this: I send a Access snapshot document as a .snp Person opens document with Access 2007 snapshot - no problem Person then sends me back...

Hi all I am trying to create Excel spreadsheets from a button pressed in the footer of a continuous form. What I want to do is create two Excel files for...

Is it possible in Outlook 2007 to invite all of the recipients in an email into a Calendar invite where the subject matter will automatically populate as...

"jhall2microsoft.com" wrote in message news:... "jhall2microsoft.com" wrote in message news:... "Jim...

"jhall2microsoft.com" wrote in message news:... "Jim Bunton" wrote in message ...

Hi I don't play with Access much. Mainly sql server 2005 I have a table. 2 fields are starting to annoy me now. The first Draw is a long integer. The last is...

I wish to generate and send an email from with vb code. Windows XP media center version Access 2000 I have outlook express installed but NOT outlook I don't...

This might be a dumb question but its got me. I have linked to a sql table via odbc and can read the table in access. The problem is that the date time is...

I'm getting the Warning message - these email messages might contain data that is of a confidential or sensitive nature - and it's not giving me access to...

Hi I have an access database which I would like to store in a document library on a SharePoint site. I don't wish to have any SharePoint lists linked to...

What access rights does a user needs in order to import data from the backend database , which sits in the server, to the front end in the local drive.

If there is a large group of girls chasing, is not feeling very confused

I have a subform with a combobox derived from a query like: SELECT COA.AcNo, COA.Acc, COA.Cl FROM COA WHERE (((COA.Cl)=!!.!)); So as to allow limited number...

I am needing check stub templates that calculate. I downloaded 1 using MS Office, but it won't allow me to input.

What program you guys use for opening dll files ?

Is their any way I can install Office on XP? At one time I had Office 2003 and now I have Office 2007. I can't find my program for Office 2003. -- Don M

I have a form which contains a subform. The subform contains text only. I have set the scrollbars to vertical only on the subform because the space for the...