Tagged Questions
0
votes
0answers
9 views
Access Subform Sourse object
What I am trying to achieve is for a combo box ( Combo_sf) selection to dictate the form( I have about 10 forms there names are in the combo box) that appears in a subform (sf_record). I am new to VB ...
1
vote
1answer
39 views
Create a log for all SQL action in Access
I'm currently having a problem at work.
Someone in the is modifying the table directly.
For example in my database I have school names like ETS. Well, today it was named Polytechnique.
What I'm ...
1
vote
1answer
29 views
Query result in a variable
Here's what I'm trying to do. Once the btnDraw is clicked, I want Access to go run the query Test and bring back the results into the string winner. Then display the result in lblWinner.
Private ...
1
vote
0answers
42 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 ...
0
votes
1answer
100 views
Improvement in SQL Query - Complex Join / IN / Exists
Looking for suggestions on speeding up this query. Access 2007.
The inner query takes a few minutes , full query takes very long (40 - 80 minutes). Result is as expected. Everything is Indexed.
...
0
votes
2answers
68 views
Access SQL Query to Add or Update Values
I have an Access database that I need to update every week based on a fixed length text file
The file contains some new records and some updates.
Currently, I am using an ADODB connection to treat ...
3
votes
1answer
44 views
Updating tables in VBA ACCESS [closed]
i need help solving my problem with vba update statement:
In my form i have a click form that when i click it execute this procedure :
Dim strSQL As String
Dim rst As New ADODB.Recordset
strSQL ...
0
votes
2answers
642 views
Multiple databases in MS Access VBA?
This Microsoft KB article details how to run a query on another database than the current one used by the Access project. However it only states how to connect to DBase, Foxpro, Paradox, BTrieve and ...
1
vote
1answer
32 views
Add File listing loop to table using runSQL with variables
Having trouble getting this to work.
I am looping through a dialog generated file list and inserting into a table. I can not get the variable to work right. Syntax error (missing operator) in query ...
1
vote
1answer
48 views
Access create table vba
The idea is to type in the name of a new table into a form field and click a button to make a table on a remote database with the name the user enters into the field. However, the new table is created ...
0
votes
2answers
110 views
MS Access 2010 vba query
OVERVIEW
I am attempting to break down or decompose a assembly list. We are starting with an input table generated by a design program. The format is fixed.
I am attempting to breakdown each ...
0
votes
0answers
26 views
Querying two tables in access
Hi I’m having some difficulty with an access database I’m creating. I’m trying to use a combo box to display a query the query is of the products table and is based on a sub query of Customer Order ...
0
votes
0answers
64 views
How to show all records in the form from the table for the same given ID
I am working on Access forms(unbound). I have a question that I want to search records in the table by the field [ID]. When there is only one record in the table for the given [ID], form shows that ...
1
vote
1answer
65 views
MS Access Asynchronous Queries
I have a basic SELECT query fired from an Access form that takes a while to execute, so I would like to run the query asynchronously and allow my users to continue using the form (or at least keep ...
1
vote
1answer
73 views
select [combobox value] & “text”
I am trying to build SELECT statement in Access VBA, based on value chosen by user in ComboBox.
Example :
"SELECT [8_SV_RT] FROM DATA WHERE condition = value
I need 8 to be dependent on ComboBox ...
