VBA in Microsoft Access
0
votes
0answers
5 views
Excel VBA module that sends data to Microsoft Access?
I have a project that i would like to have an option to export certain sheets into microsoft access. I have googled around and the methods I have found use Access VBA in order to get data from excel. ...
2
votes
2answers
13 views
Converting measurements in a form to update a table
I am using Access 2010 to create a database of fish caught by local fishermen. I have a table with all the information about each fish caught (location, day, length, etc) and a form to add new ...
1
vote
1answer
19 views
Attempting to update combo box updates table instead?
I am a bit of an Access novice, but I'm slowly catching on. I am rebuilding a database at work, and I'm struggling with an odd issue in regards to updating combo boxes.
What I am trying to do, is ...
1
vote
2answers
11 views
Adding New ADODB.Recordset instantly causes Crash
I'm fairly new to Access, but I have never had anything like this happen to me.
I have an Access DB that I am creating, and I have been using recordsets to grab values for variables. I have several ...
0
votes
1answer
15 views
MS Access List Box multiple value selection
I have created form based on query output. I had used 3 combobox and one list box. 1st combo box gives me list of Dept, selection of dept on 2nd gives me location of that dept (distinct), the 3rd ...
1
vote
3answers
18 views
Access report, populate label with results of query
I have, what I think, is a pretty basic Access file, with a report. The report is based off a query. The query is:
SELECT * FROM dbo_NewPatient WHERE id=[Patient to view];
This works good, and ...
1
vote
1answer
16 views
MS Access - What is the use of “!” , exclamation symbol
I am new to MS Acces and would like to know what does the symbo "!" mean.
For e.g.
1) What does "Tbl!Field" means and how does it differ from "Field" where "Tbl" is a atable name and "Field" is a ...
1
vote
3answers
20 views
where condition with data in access
I want to use date in a where clause. I am building where clause such as this:
WhereCondition = WhereCondition + "DOB =" + DOB.value
DoCmd.OpenForm "InputForm", , , WhereCondition
DOB is a textbox ...
0
votes
1answer
11 views
Having to call SetFocus twice in MS Access 2010
I found that for a couple of hours this code worked:
If KeyCode = 37 Then
Me.Text12.SetFocus
End If
Then it mysteriously stopped working. I thought it might have had something to do with ...
-2
votes
0answers
25 views
Hang / Unresponsive UI : VBA
Is there a way to avoid hanging and unresponsiveness of windows while running inside vba code/macro on large data. At times I can't even move window from one position to another.
What is role of ...
0
votes
0answers
27 views
Show/hide watermark on a MS-Access report
I am trying to hide the watermark on a report based on a condition. It does not seem to have the slightest effect, even when the code is executed (in debug mode). Any idea ?
Private Sub ...
0
votes
1answer
24 views
How to retrieve data from multiple selected rows in a table?
I am using MS Access 2007. I have a form that has inserted a subform. The subform appears essentially as a grid of rows and columns of data, with each row representing a record in a table.
I have a ...
0
votes
2answers
18 views
Refresh form from subform event handler
I seem to be having a problem that looks an awful lot like it could be a bug in MS Access. I have a form which enumerates all the rows in a table and lets you edit them in a subform. Upon clicking ...
2
votes
1answer
19 views
Access 2003 - VBA - Joining on two types (string = date)
Background: Im busy with a research, in which I receive data stored in a oracle database. I myself use an Access database to store the data from the oracle database (and as well data from other ...
0
votes
1answer
13 views
Equivalent cURL in VBA?
I have an API for my application which allows me to make cURL requests to it.
I need to implement this into VBA so my desktop database can fire CURL requests to my web app.
curl -i --user ...
0
votes
2answers
39 views
Vba Access error: Method or data member not found
I have been trying to open a contracts form from contracts_all page. I want to open all the records on the contracts_all form but only show the specific one clicked on. To show this one particular ...
1
vote
1answer
37 views
vba code not doing INSERT into database
I am very new to access. I was told that the way to do a database insert in access is with the CurrentDb object (as long as the table is in the same database, and it is in my case.) I made this code, ...
0
votes
3answers
34 views
Open a form using ID from a different form in Access 2010 using vba
I am trying to open a form from a button in another form. The form with the button,contracts_all form, has a field ID and I want to open up the form that contains the information with that ID. This ...
1
vote
1answer
22 views
Why clicking in a report on a textbox garbages results?
Can anyone help, I don't know what's happening.
For the table that looks like this:
part value
BAC 102
BS1 275
MAV 425
BAC 519
BSF 653
BAC 1072
The result would be:
...
0
votes
1answer
11 views
Ms Access 2003 VBA. Random order of table recordset?
I open a recordset (A) and use record value to process some data, and write a new recordset (B), with record value from recordset (A) and data value returned from processing.
E.g
RS A RS B
...
0
votes
2answers
23 views
Issue using VB in access to open up form with OpenForm
I have a Inventory form. I want to create an Update button which, when clicked, will open up a new form frm_add-remove, which will contain only the selected inventory item and will allow you to edit ...
0
votes
1answer
14 views
Conditional Saved Import in Access/VBA
I'm fairly new to this stuff, so hopefully someone our there can help me out.
The setup: I've got an Access 2007 database that imports data, then performs a set of queries and exports the results on ...
0
votes
1answer
30 views
What are all the fields available in a Notes document in VBA
I have written VBA code to send an email from a group mailbox. I set the principal field to say where the mail comes from. It almost works correctly, putting the message in the sent items of the ...
-2
votes
1answer
19 views
Access: Opening new form when a record is selected
I've made an access project that displays cellphone usage, there are several screens showing different kind of statistics. They're all subforms inside the main screen, and they are all different pages ...
-4
votes
0answers
24 views
Filter a large csv file using VBA code [closed]
I have a CSV file dailylog.csv with 4 million records.
The format is:
name, value, acccounttype, master_account
The master_account field has around 200,000 unique values.
I have some selected ...
-2
votes
0answers
29 views
Import pictures into an Access 2010 database [closed]
i am currently working on data base for student in which we have main Table name "Master Data" having detail of student along with their snaps (attachment), we have round about 1000 students data and ...
1
vote
3answers
43 views
IN Function for Access VBA
Is there a function in Access VBA that works like the IN function in SQL?
I'm looking for something like:
if StringValue IN(strA, strB, strC) Then
0
votes
1answer
25 views
VBA Access Page Break
I'm fairly new to VBA and I'm trying to bring data from access form to a word document using bookmarks. The problem I'm having is that I'm finding it very hard to create a new in MS word with the next ...
1
vote
1answer
37 views
How do you programmatically update a linked table in Access that will refresh data types too?
I'm working with a legacy Microsoft Access database that we've recently updated to use linked tables/SQL Server backend.
I'm making some changes to the structure of the data and would like to ...
0
votes
1answer
27 views
Searching Tables from VBA
As much as I hate asking without having a good start I am stuck on something very simple I think.
I have a table with only 3 fields. I want to be able to search them using a InputBox which I call ...
0
votes
1answer
8 views
Setting parent record field value based on Maximum Child record field value
I am working with MS Access 2007.
I have a table called [tblDonors] linked to child records in a table called [tblReceipts].
I am trying to set the value of a new Boolean(y/n) field ...
0
votes
1answer
20 views
MS Access 2000 to MS Access 2007 migration
I have application in MS Access 2000.
It is connected to Oracle 9.2.06 database.
I have to migrate the application to MS Access 2007 and Oracle 11G.
I've created a blank .accdb file and imported all ...
0
votes
0answers
12 views
docmd.openquery times out but manual runs fast
I'm running an update query through vba docmd.openquery on a linked sql view and another table. I get an odbc time out. When I manually run that same update query it runs really quickly.?? I've not ...
0
votes
0answers
9 views
Open Access.Application from VBA with write access
I'm trying to import data into an access database (from excel), then run some queries & macros and export the results into a table. I'm using an Access.Application object to run the macros. The ...
2
votes
0answers
32 views
Export Access Table to dBase file from Excel VBA?
I have an Excel "Application" where users add/edit/etc. data. When ready, they export this data, the final deliverable needing to be a dBase file. Since Excel 2007 no longer has the Save As dBase ...
1
vote
1answer
20 views
Passing information from form to form in MS Access
My setup. I have a form that searches through a table names Students containing student information, ID, Name, Home Room, etc. The form text boxes are parameters in a search Query, which then puts its ...
0
votes
0answers
20 views
Formatting Issues in MS Access Report - The Height property does not change with the CanShink and CanGrow property
In an MS Access Report, I have text-boxes with the CanShrink and CanGrow property set to true. A procedure runs when the form is opened, dynamically adding data to these text boxes. I retrieve the ...
0
votes
2answers
30 views
combining two SQL SELECT COUNT(*) statements
I'm using Microsoft Access 2007. I have two SELECT COUNT(*) statements which run ok without combining, but I want to combine those statements to use as a form recordsource via VBA.
1. SELECT ...
0
votes
1answer
37 views
Generate Excel Spreadsheet with Macros using Microsoft Access
While generating hundreds of Office Excel spreadsheets with Office Access is certainly possible, it would be great to add macros to the generated workbooks.
I would like to add the functions to the ...
0
votes
0answers
23 views
Type Mismatch when using CreateControl in Access VBA
I am trying to dynamically create controls on a form as needed and I have therefore used the CreateControl Method.
DateControls(i) = CreateControl(Reports!Comments_R, acTextBox, acDetail, , , ...
0
votes
0answers
32 views
Calling a VB.NET DLL from VBA (Access)
another question wich was asked before but got no solution:
System: Windows 7 Ultimate 64, MS Office 2010 64 and VS2010
VS2010: I created a new project "Class Library" enabled both "Visible in COM" ...
-2
votes
1answer
33 views
How to import forms,reports and module data in .accdb file
I am work on office access 2013 database. I need some forms,Reports,modules are import one .mdb file to .accdb file using progmatically (OLE and any other technology).
0
votes
0answers
17 views
Can't select any data from subdatasheet in subform
I'm making a form that contains subform and subdatasheet.
I have main form name : planning_form
Subform name : Groups_Query (ID, Name)
Subdatasheet : Groups_Detail (Account, Name)
I want to get data ...
0
votes
1answer
40 views
Writing continuous form data back to table
I have continues form that is bound to a query (see query below). The query is the record source for my continuous form, and is non-updateable.
The query filters data down to provide a list of ...
0
votes
0answers
38 views
Access 2007: Unexpected error (40230)
I am getting an Unexpected error (40230) when trying to access VBA code for the form I have in Access 2007.
I tried decompiling, which is how I found out the project is corrupt. I received the ...
1
vote
1answer
47 views
Remove confirmation when using DoCmd.RunSQL for INSERT and DELETE
I am using the DoCmd.RunSQL method to INSERT and DELETE records based on actions that a user makes in a form. It works fine but it asks for a confirmation before deleting or appending a record. How ...
0
votes
1answer
39 views
VBA Access SQL - Zip Code (9 Digit) Split to 4 DATA TYPE MISMATCH ERROR
I currently have a system of importing an Excel into a table, which includes the Zip Code. The Zip Code has instances of 10 Characters (#####-####) - and sometimes just the first 5 Characters (#####).
...
0
votes
2answers
27 views
If Else block error
I am have trouble with this If ElseIf block and I cannot figure out where the error is.
The message I get is "Else without if".
I am very new to using if elseif any help or guidance would be ...
0
votes
2answers
26 views
How to create VBA loop for Access 2010
I want to loop some VBA code on Form_Load that will update one field in my Form based on 2 other fields. Currently it will only update the first record or when I click on a record.
Currently it ...
0
votes
1answer
53 views
VBA error on PageSteup.PrintArea when using Excel 2007, works fine in Excel 2003
I've inherited responsibility for a web app that uses Access for the database and Excel for the reporting (lucky me, I know). Everything has been working fine with Office 2003, however the company ...
