VBA in Microsoft Access
2
votes
0answers
41 views
I am getting a C++ runtime error while running access vba module. Consistently reproducable
I have taken 2 sample databases from online - one for a calendar and one for drag and drop functions - and pulled some code together for a result that is ALMOST functioning as I had hoped.
There is a ...
2
votes
0answers
403 views
Why would Access 2010 not trigger the form unload event when browseto is invoked from subform, instead of parent form?
As stated, this is an Access 2010 .accdb.
I have a main, navigation form: frmNav.
On frmNav I have a Navigation subform control: NavigationSubForm.
I use docmd browseto to move between tabs on ...
1
vote
0answers
37 views
Chicken or Egg… Define Engine before Export to MySQL from Access, how?
In a bit of a quandary here, having been trying many ideas I think I'm stuck with a several hour export.
I have a handful of queries that export out to MySQL from Microsoft Access every 24 hours, ...
1
vote
0answers
33 views
Importing Excel files to access with macro
I need to import a couple hundred excel files into one access table. I found this code online but it doesn't seem to be working. I put this is in a new Module, click run, and nothing happens.
Any ...
1
vote
0answers
65 views
access vba: referencing other accdb's & late binding
I'm working in Access 2013 VBA, trying to collect back-end functions & user-defined types in a separate package, separated the code into 2 .accdb files with a reference from the front-end to ...
1
vote
0answers
33 views
DoCmd.TransferText with non-US regional settings
My client has a Windows regional settings that has comma as a decimal place separator and semicolon as a list separator, which is a typical format settings for most European countries. When my code ...
1
vote
0answers
70 views
Recordset contents to excel using access vba
I'm trying to write record set contents to excel sheet. My code is not working when trying to move record set contents to Movefirst. My vba code
Set cnn = CurrentProject.Connection
Set rst = ...
1
vote
0answers
34 views
Error when trying to use AttachDSNLessTable function
I am trying to connect to a SQL Server 2008 using a dsn-less connection. I'm trying to use the AttachDSNLessTable routine but have not been able to get it to work. I get the message
Run-time ...
1
vote
0answers
141 views
How can I save an Access database as ACCDE (from VBA)?
I am developing an application in Access. What I would like to do is be able to script the creation of a deployed version.
For this, I want to:
Rename a macro (m_AutoKey) to AutoKey
Compile VBA ...
1
vote
0answers
99 views
Return type in findById method, control could not be found by id
I'm writing a VBA script that read some values from a SAP procedure (ME23N).
I'm using findById method to read some values but I dont know if the object extists or not.
...
1
vote
0answers
153 views
Use MS Access 2010 to attach a file in MySQL database
I checked for few days how to do this and I'm getting close to the solution, but I still can't find how to do it.
Back-end is MySQL and I have a table called Product with
different fields, one of ...
1
vote
0answers
36 views
Update 1 record in a column with calculations
I'm using MS access for a work project
I've got a table with figure 1 and figure 2
figure 1 is prepopulated but figure 2 is entered using the ".edit" function.
i can get the edit function to work ...
1
vote
0answers
86 views
Access label controls have different properties listed - how can I resolve this?
I have a problem I believe is related to this problem. I have many label controls. Some of them become "weird" and start exhibiting a weird "extra bold" display:
These labels have the same ...
1
vote
0answers
37 views
How do I refer to a calendar object on MS Access form in VBA?
I am trying Forms("FormName").CalendarName.Date but it isn't working -- what's the correct syntax? Is there a similar syntax for use in queries?
1
vote
0answers
247 views
VBA Access: Wrap Text into Lines of an Array
So I have written a module that breaks up text into multiple lines mimicking word wrap. Each line of text becomes an item in an array which can be later used for populating text boxes, list boxes, ...
1
vote
0answers
65 views
Access outputto report to pdf with selection: selection sometimes wrong
I've got a database that exports invoices to pdf and mails them, using the outputto command for generating the invoices. I've got the outputto in a function that takes the name of the invoice report ...
1
vote
0answers
575 views
Access/ODBC error 3146
I have an MS Access 2007 front end to a MS SQL Server 2008R2 back end.
I've got a query that's part of a loop, and it's suddenly started generating Run-time error '3146': ODBC--call failed. errors on ...
1
vote
0answers
85 views
Scrollbar size wrong after filtering a forms record source
The forms recordsource is 1900 records & then gets filtered based on what user selects in a combobox list, in VBA I have a SELECT CASE statement to do something like the below for each selection
...
1
vote
0answers
111 views
MS Access Query Timeout When inserting row in SQL Backend
My users are receiving the query timeout error when they try to insert data to SQL server 2008 through an Access 2010 form. The error msg specifically occurs when users move off the record having ...
1
vote
0answers
103 views
Refreshing a subform from a control inside another subform
I have 3 forms:
frmDateRangeGeneral
frmOrderConfirmationReport
frmconfirmationStockSubform
Inside the Date Range subform I have a textbox with an event of onChange
Inside the subform ...
1
vote
0answers
520 views
Import Word Form Fields into Access,
So I've been working on a method to import Word Forms into my Access Database. Things are working for the most part, my goal was to have a dialog box appear, a user selects the filled out form, and ...
1
vote
0answers
78 views
MS Access crashes when trying to close down a connection to Blackbaud's Raiser's Edge API
I am the IT department of a Non-Profit organization. I have a question today which might be too specialized for this forum and I hope I do not waste my time writing it up. We are using Blackbaud's ...
1
vote
0answers
2k views
how to fix Run time error 62 ''Input past end of file'
I have a problem while trying to read a text file. Basically, the text file is comprised of blocks of information, between each block I have a blanck row. Hier is a sample of my text:
FESTWERT ...
1
vote
0answers
187 views
Performance Drop / Query Slow after Compact Repair - Access 2007
I am performing a large number of insert operations using VBA - Access. the VBA code is in a file "control.accdb" performing operations on "data.accdb"
Few tables in the process are created from the ...
1
vote
0answers
311 views
How to filter specific records using a combobox and display in a subform
I am trying to filter records from a combobox, if I select Cape Town only Cape Town records must show in the subform but if I select Durban only Durban records must display in the subform. I dont get ...
1
vote
0answers
314 views
Importing excel file to access and set up columns field name
I'm having an access tool where I'm importing an excel file with table information. The system is creating a new table with this info with column fields (F1,F2,F3, etc.) and under it there is 10 lines ...
1
vote
0answers
322 views
selecting a row in a combo box fails if bound column is hidden
Using Access 2010 I have an unbound combo on my form, it looks like this...
RowSource: SELECT EventID, DocRef FROM Events
BoundColumn: 1
ColumnCount: 2
ColumnWidths: 0cm;2cm
setting the combo ...
1
vote
0answers
774 views
Hide new row on form in Access
My project has a form with tabs, each tab displaying data from a different table based on the current record (I will call the main form's record the client) selected in the main form. If there is data ...
1
vote
0answers
3k views
MS Access Copying value from a form into another form text box
Here's my problem: I have the below code which copies the employee username from FormB and puts it in FrmEmployee when i click on a record in FormB (which is opened through a cmd button on FrmEmployee ...
1
vote
0answers
97 views
Mass picture export
I inherited a database with about 5000 records in it. Each record as an embedded OLE with a picture. I want to move all of the pictures out of the database and replace them with a filepath. What would ...
1
vote
0answers
412 views
Creating Excel 2010 Instance in Access 2010
Crazy thing here, but I am trying to initialize an Excel 2010 instance from Access 2010. (Something I've done in 07 / 03 many times before). Whether I use late or early binding I get an error message ...
1
vote
0answers
1k views
Adding a format condition in Excel through Access VBA
So currently i got these lines in my code,
.Range("C2").Formula = "=IF(B2 = """"," & """REQUIRED""" & "," & """""" & ") "
.Range("C3").Formula = "=IF(B3 = """"," & """REQUIRED""" ...
1
vote
0answers
557 views
Access 2007 VBA Error 2467 for function
Having a very weird problem. I have a function which is called when a form field gets focus. The function is passed four arguments, three of which are values from form fields and the fourth is a ...
1
vote
0answers
226 views
VBA Reference object created in a form module
I have created my own class called Organisation. In a pop out form that the user enters the details of the organisation, an instance of the Organisation class is instantiated.
e.g.
Public myOrg as ...
1
vote
0answers
168 views
Receiving Null when attempting to retrieve checkbox values from Access table
What I did was append the checkboxes as additional columns of a query which was then used to create a recordset. This recordset was then assigned to a combobox control.
Previously, it worked fine ...
1
vote
0answers
208 views
Lock records when certain conditions are met
I'm creating a database that registers working hours.
People can introduce start working day, when and how long they take lunch break, and the end of the working day.
All works well, and I've created ...
1
vote
0answers
492 views
Moving an Excel Worksheet to Access with VBA error
Hello I am trying to move an Excel worksheet to an Access database, both of which have identical field names. The Code is written in Excel.
The user inputs several form fields and upon clicking ...
1
vote
0answers
1k views
access to oldValue for control in continous form generates error 3251 in beforeUpdate when a checkbox on form is updated
This is one of the stranger issues I have seen in MS Access. I have the following code in a continuous form:
Private Sub thisForm_BeforeUpdate(Cancel As Integer)
If Not Cancel Then
Debug.Print ...
0
votes
0answers
14 views
Updated version of Lebans SetGetSrollBar Code
I am looking anyone who has managed to re-write the code written by Stephen Lebans to Get or Set Vba Access's Scroll Bar for Access 2013.
The code does not seem to work in the latest versions of ...
0
votes
0answers
11 views
MSAccess - Limit user changes to sub-forms
I have an app that is working as expected with many US & India users.
One nagging issue I have is that some users will modify the format of a datasheet contained within a subform ...
0
votes
0answers
24 views
Access VBA XML load Access Denied error - fixed
Team - had an issue with Access VBA - got Access denied error. I seem to have resolved it with further help from other posts. This code lets extract an XML and read its attributes. I have reduced the ...
0
votes
0answers
43 views
The ForEach Loop Enumerator is Empty - SSIS Error when executing through CMD via VBA
I am currently working on a SSIS package that is to be triggered through CMD via VBA (Access). All that the package does is read a bunch of files from a folder and upload them into a table in SQL ...
0
votes
0answers
18 views
Microsoft Access (accdb) and Sharepoint Users Integration
I am creating an application using a regular accdb (not a web database using access services) database using linked SharePoint Lists as the source tables. Is there a way I can also get the SharePoint ...
0
votes
0answers
11 views
Access vba export the pivot chart to other softwares with transparent background
I want to export the pivot chart i have in the database. tried writing a macro and linked with a button but doesnt seems working. and i also need the transparent background. so there's a certain file ...
0
votes
0answers
26 views
MS Access Call VBA from After Update Table Event
I am trying to call some VBA code any time the contents of a table has changed. I also want to call VBA code when a value from an OPC server has changed state.
Thanks for any help.
0
votes
0answers
20 views
How to reduce the file size of an image in access using vba
I have an access file and i want to find a way to reduce the file size of the images that i insert using VBA code.
More specifically they gave me an access application where you can insert an image ...
0
votes
0answers
24 views
MSAccess - Using Form's On_Unload event with runtime clients?
I have an app that is used by 2013 & 2010 users. I have a collection of users still on Access 2007 for which I create a 2010 Runtime copy. Everything has been working well for quite a while.
...
0
votes
0answers
9 views
How to add users in asp.configuration from a list of users in an access table
I have a project in which I have table that has usernames and passwords in my access database. I want to be able to add all those users to the asp.configuration in order to login to the website with a ...
0
votes
0answers
16 views
Combine data from multiple tables into one table
I have a database from a third party vendor that I can import job data to Access. I have attached a screen print of the query that will display the data I need. The problem I am having is that it ...
0
votes
0answers
24 views
Change the SourceObject or RecordSource in Access 2007 VBA
I have a subform that is linked to a query. I need to be able to change the subform to display five different queries that all have different fields in them while also being able to lock certain ...
