Tagged Questions
0
votes
1answer
15 views
Handling Error 3021 (EOF) VBA
I am trying to compare two tables by using a serial number as the primary key. Since they can vary in sizes a serial number may be in SerialAccount_b, and not in SerialAccount_a. When this happens, I ...
1
vote
3answers
12 views
DCount with 2 criteria
I am using DCount to help display an error message if the data signals an error. I have it working with one criteria where a number is equal to another number. Now I wanted to add another criteria ...
0
votes
1answer
8 views
VBA Access Conditional Formatting Reset New Record
I have created a database with one form and one table. The form is basically an application and asks questions about each person/applicant. I've written skip logic/conditional formatting in ...
1
vote
1answer
23 views
Editing only imported records in table
Set f = Application.FileDialog(3)
f.AllowMultiSelect = True
f.InitialFileName = "S:\Formware\outfile\ucppt12\Storage"
f.Filters.Clear
f.Filters.Add " Armored TXT Files", "*.asc"
If f.Show Then
...
0
votes
1answer
31 views
Access VBA code combination not working, issue with exit sub?
I'm very new at VBA and I can't seem to solve this problem. It seems like it should be an easy problem to fix, I just don't know how. I've looked around on the web, but the question remains unsolved.
...
1
vote
2answers
34 views
Creating a table with data from 2 other tables
I have 2 tables:
tblKabelInfo
And a table with a name that varies depending on something else in my program
tblName1 as String
the tables look like this:
tblKabelInfo:
...
0
votes
2answers
31 views
Updating a record on another table that corresponds to the same record
I am trying to update a record on another table. So I have my first table InfoDetailsTable that has a bunch of records with one of the values being KitNumber. In this InfoDetailsTable table I am ...
0
votes
2answers
31 views
How to fix “out of stack space” error?
I have code which takes a table, and rearranges the table to form a new table. It worked with a small amount of data, but now that I tried to run the same code with over 1,000 records, it is getting ...
0
votes
2answers
35 views
MS Access: Trying to select a value in a record corresponding to a certain value
Sorry if the title is confusing. But I have a table with a few different columns. One column is the KitNumber and the other is the ReturnDate. I am trying to select the value of the ReturnDate to ...
0
votes
1answer
23 views
Drop all tables with <String> in their name
I am looking for a function or sub (in a module) wich I can call to drop all tables that have "tbl" in their name. I have found several pieces of code that just don't work right.
To clarify my ...
0
votes
2answers
31 views
Entire Table Search Form - Microsoft Access 2010
I am trying to create a search form that can search from one table at a time based on the table selected by the user from a combo-box. I have a text box called searchCriteria and the combo-box is ...
1
vote
1answer
22 views
MS Access : How do delete one record with multiple criteria?
I am trying to delete one record in a table. I have two unbounds, one with a number and one with a date and then a command button to execute the code. So in my table I assign these values and they ...
0
votes
2answers
43 views
Outer Loop Running 1 time VBA
I have this code, that I am trying to filter and compare data from tables, the inner loop runs the correct number of times, but the outer only runs once and I cannot figure out why.
Do While Not ...
0
votes
2answers
25 views
Is it possible to run VBA code only affecting one row in a continuous form?
I have a continuous form that display the results of a query. I'd like to include a button on each line of the form that expands that line of the form to show some supplamentary data. I want to do ...
1
vote
2answers
45 views
Moving Files in MSOffice Access 2010
I am attempting to create a button on one of my forms in Access that will move a file from one folder to another. The filepath of the item is stored in the database. My current approach is using VB ...
0
votes
1answer
43 views
Access 2007 vba to find last row in Excel 2007 worksheet
I have some VBA code within an Access 2007 database that exports data to an Excel 2007 file. I have a problem with this piece of the code:
Sub GetLastRow(strSheet, strColum)
Dim MyRange As Range
Dim ...
0
votes
1answer
36 views
Alle Browne's Concatenate Function with 2 criteria
I have been happily using Allen Browne's VBA:
Option Compare Database
Public Function ConcatRelated(strField As String, _
strTable As String, _
Optional strWhere As String, _
Optional ...
0
votes
1answer
22 views
Keeping multiple file names while importing via transfertext
Private Sub Command38_Click()
Dim f As Object
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim strUpdate As String
Dim strFile As String
Dim strFolder As String
Dim ...
0
votes
2answers
44 views
Reference a Microsoft Access 2010 Table Value in a VBA Subroutine
I am trying to reference a particular field from a table within a function call. Specifically, I would like to open an executable and get the path from the table.
Here, the path is hardcoded in:
...
0
votes
1answer
24 views
“Method or data member not found” Access Error
I am trying to compare two tables Data with this code:
Set rstA = dbs.OpenRecordset("SerialAccount_a")
Set rstB = dbs.OpenRecordset("SerialAccount_b")
While Not rstB.EOF
serialNumber = ...
0
votes
2answers
32 views
Check if value has changed when moving data
I have built a macro already that moves values inside about 10 different tables from one database to another. It takes a unique identifier so say columns "nid" and checks to see if it already exists ...
-1
votes
1answer
23 views
Determine if Attachment field is empty
How can you determine if in Attachment field in Access does not contain an attachment using VBA? I tried
If IsNull(rstMassBalance.Fields("FileName"))
and
If rstMassBalance.Fields("FileName") = ...
0
votes
1answer
22 views
Adding attachments in Acess VBA
I need to add boxes to my form to allow me to add attachments, so I tried bounding them to the proper field in the table. (The purpose of my form is to add to an existing table) However when I try to ...
0
votes
2answers
25 views
VBA close access after all functions finished
I have got vba which I am running from a batch that starts a macro to execute them, I am trying to close down access once all the functions have finished however making a new function and placing ...
0
votes
1answer
41 views
MS ACCESS : Syntax error in FROM Clause
I am trying to have a command button insert data into a new table and at the same time select a record and update it. I will paste my code below and try to explain my problem.
CurrentDb.Execute " ...
0
votes
1answer
16 views
Running Access VBA sub from Batch
I have about 8 Subs inside my access file that I would like to run externally from a batch file.
I have little experience with Batch so am not entirely sure where I start writing this, does anyone ...
1
vote
1answer
21 views
Access VBA OpenForm Grouping and Sorting
I have a form that is used for data entry. We have to go back through and add data to these records. Is there a way to pull up the form that groups the records by field "A" and sorts by field "B"? ...
2
votes
2answers
34 views
How to combine 5 tables together with same ID in a query?
I have 5 different tables T_DONOR, T_RECIPIENT_1, T_RECIPIENT_2, T_RECIPIENT_3, and T_RECIPIENT_4. All 5 tables have the same CONTACT_ID.
This is the T_DONOR table:
T_RECIPIENT_1:
...
1
vote
2answers
50 views
Copy Row to same Table in new Database
I have very little experience with Access Databases however I have wrote a similar VBA macro in excel. I am trying to copy rows from one .mdb file into the exact same table on a different .mdb file. ...
1
vote
2answers
70 views
Dividing a table in 2 seperate tables by parsing a string
I have a table that roughly looks like this:
the 1300 and 850 stand for frequency on wich these fibre cables are checked
The real problem is that the 1300 and 850 aren't set values. In a different ...
