Hi- I am a beginner in Access and need to do the same thing as below- Except instead of months, i have 3 years of wks ( so 156 columns)
Could you walk me through the whole code? starting with...
I have limited Visual Basic knowledge, so any precise input would be appreciated. I am looking to create a macro in Access 2007 that will export multiple queries to a single Excel workbook wi...
We have the following bit of code originally created in Access 2000 (Windows XP). Now that we are upgrading to Access 2007 the code is no longer supported.
Set fs = CreateObject("Scripting...
I need the ability to import an Excel Worksheet into a specific access table. The tables are identical except:
1) The destination table has an additional Date Field. This field needs to be ...
Experts,
I have a question that can either be solved in switchboard manager or form design. Basically, when we go to tools -> database utilities -> switchboard manager to edit a switchboard...
I'm having a problem keeping some complex nested subforms in sync, so I thought I would try a different approach. Here is the layout of the forms/subforms:
frmMain
subfrmModule
...
I am generating SQL code in Private Sub CloseForm_Click() and passing it as an argument, strSQL, to the form, "2007 Job Log" which I open inside CloseForm_Click() with the following command:
...
Hi
I have a form which allows the user to enter a new record into a table.
I've used the HOWTO: Create a search form posted by Shanesuebsahakarn to then find possible matching records an...
Dear Experts,
when I open an Access 2003 database in Access 2007 and tell Access to hide the navigation pane (see attached file), the pane keeps reappearing everytime I open the Access appl...
I am trying to do the following:
Update Table TMain to set PendingTX in Table TMain to True when PendingTx is False, Ordered is Null Hold=False and Date()-DateEnter >89. DateEnter, Hold, ...
I'm trying to change the "Between" Date-Parameters in a Query. I'm getting an error that reads:
Run-time error '3075': Syntax error in query expression
'((([_dbo_ncv_audit_val_allocs].PPEn...
When coding in VBA (Specifically MS Access 2007) how can I get a list of a folder's security permissions, specifically what users/groups have access to them?
Hi,
I have this code which allows a user to select a CSV file to import into the database. I am a little stuck when it comes to actually getting the CSV file imported and named [tbl_temp]....
I'd like a control button on my form to close all open forms.
It is possible?
I am getting this error when I try to create an Excel spreadsheet through VBA. The code is:
Set wbXL = GetObject("file.xls")
This had been working in the past but I have been getting this ...
I currently have an access 2003 database that automatically creates an email in outlook 2003 using the .htmlbody body function. I have figured out how to format and insert data using html cod...
Easy question
I want to know how to refer to a table field.
I have tried on my own for a good hour now and unfortunately cant figure it out myself!
what I want is to find the value in...
I have two tables, however, there is no relationship between them and there is no common field.I would like to merge these two tables. for example first table might have 2 records and the seco...
How do I get the selected index of a listbox?
I am using a subform which I bound to an SQL string to display a filtered datasheet of records for a specific client. I am using the code shown below to bound the form to the SQL. The tbl-pe...
I'm pretty new to Access 2007 & VBA and I've been hunting around the help files and my Access 2007 Bible. I haven't found any info on whether or not the Data Collection Wizard in Access 2007 ...
I have a worksheet filled with rows of data. My problem is that I wish to delete only those rows that are completely blank, say for esample I have a worksheet having data from A1:Z1 to A16636:...
Hi!!!
I've been searching this site for about 3 days now trying to get my problem solved. Here's the situation: I have a combo box that I want to populate 2 other text boxes. I got the c...
In VBA in Access 97 how do I change the vertical scroll bar position of a list box?
Preferably I need to be able to get the vertical scroll bar position, store it, and then return the list ...
I'm trying to create a table using the attached VBA code. However, when I try to execute it I get the following error
run-time error
-2147217859 (80040e3d)
The error occurs at line 30 ...
