I'm writing a Microsoft Excel Macro that copies information from one sheet in a workbook to another and concatenates the values to create a single string. The string is then used in a batch ...
Anyone have a VBscript to loop through a recordset of an Access table an mark all Yes/No boxes as Yes (default is No). I can connect to the database with the script, but can seem to find how ...
I have a database built in Access 2003. When I open in Access 2007 I find that I cannot export to Excel using a Macro although I have set (or think I have done it correctly) the Trust Centre ...
I'm trying to figure out the best way to refresh data in a dropdown list on a form. The dropdown list contains customers, and the form that the dropdown list is on has a button to click on to...
Hello,
Long time searcher first time poster....
I have an Access app that I am building and I am having to do some custom VBA coding. Problem is I found my solution, but access crashed bef...
I'm trying to take the value in a textbox on a form into a table using an update statement. The textbox value is populated by a calendar control, but when this is passed into the date/time fi...
I have a database that shows a splash screen on open while it runs some background scripts to check versions and pre-load some information for the user. How can I make it so when they open th...
I need to create a formula so that a total can be divided by a calendar of only Week Days not Weekends.. This calendar needs to be based on a 4 - 4 - 5 callendar...ie..5 weeks in the months o...
I have a report that feeds directly from a query. In the detail section of the report, I have a label ("ProdNotes") and a text box ("Comments"). The goal is to allow the user to click on "No...
Hello Experts,
I think there is a straight-forward solution to this, but I am struggling with it.
I have a query (qryConvertProdNum) that returns the following fields
Product, Old...
I've got a system whereby if a user navigates to a record that is 'locked' i.e. a field value is -1, the user is alerted and should be put back to either the previous record or the first recor...
Option group (optTransportType) is on a form is and is set to null by default. In the Before Update Event of the form, I want to check optTransportType to make sure that the user has selected...
Is it possible to dyanamically add controls to a report w/ VBA in its open event?
Do not want persistent controls, just want to add them on the fly as needed on each report run (they do not g...
I have been looking everywhere for resources that explain how I can create an ActiveX DLL in Visual Studio 2005 that I can use in Access. I have a class in Access currently that I need to con...
What is a good example of a useful vba class modules for Access 2003? Are class modules something that a beginning vba programmer should look into?
In access I have 6 queries that I need to use. I need to run query1 take the results and send to excel sheet1. I then need to move to query2 and have that create a record set and the result fr...
Dear Experts,
Access 2002 w/SP3
Access 2003 w/SP2
Windows XP Pro w/SP2
The API: Shell and Wait, by Terry Kreft is not working to me
http://www.mvps.org/access/api/api0004.htm
I k...
Hi,
I'm trying to add a record with vba to a remote mysql database table using a dsnless dao connection.
Unfortunately I keep getting the "Cannot Update. Database or object is read-only"....
I type the following line in access 2003
Dim fso As New FileSystemObject
it prompts me the error
---------------------------
Microsoft Visual Basic
---------------------------
Compil...
Using Access 2003 VBA. I need to take a table that has one record in it. It has 10 fields.
Each field contains a number.
I need VBA to read the numbers in this record and then create ...
I'm using MS Access VBA and would like to open a dialog open box, similar to MS Excel's "GetOpenFileName" function for the user to select a specific file. I then would like to capture the com...
I am trying to schedule a distribution of a report to run in ACCESS every Monday morning. I have a module in ACCESS that does the logic I need and it works. However, when I try to schedule i...
Hi,
My table is in access, and I need help in transposing the following format:
Lodge# Year Jan Feb Mar Apr
1 2007 10 15 12 20
Into this:
Lodge# ...
Hi,
I am trying to open another MDE file in RUNTIME mode though the code of a button of another MDE running in RUNTIME mode.
I have tried opening with a command line string that works wh...
Hi,
I'm writing a report in Access and I need to calculate a field that is based on a value on the current record minus the value on the previous record. Is there an easy way to do that? I...
