Tagged Questions
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.
...
3
votes
2answers
103 views
Is there a preferred way to create dynamic, form-based queries in MS Access?
General question regarding the approach to take with a database I'm constructing. I plan on having a few forms that will allow DB business users to enter criteria, restrict their search via radio ...
1
vote
1answer
127 views
building a search form in Access 2010
I am trying to make search customer form for access 2010.
I like to have an option group based on a query search. I made a search query looking for first name or last name. two textboxes are also ...
0
votes
1answer
52 views
Runtime Error 3012 VBA Access DB
Dim db As DAO.Database
Set db = CurrentDb()
Dim qd As DAO.QueryDef
Dim sqlQry As String
sqlQry = "SELECT x,y,z " & _
"INTO MyTable2 " & _
"FROM mytable1 " & _
"WHERE ((Condition1) And ...
1
vote
0answers
85 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 ...
0
votes
1answer
136 views
Microsoft Access 2010 VB Script and Query
I am doing a report in MS Access, and I want to use VB Script to filter some of my data, but I have never used it before. I have a table (query) that I would like to return the customers who have made ...
0
votes
0answers
126 views
Access query fields within VBA
Is it possible to reference a query field with VBA?
The idea in my head was to check this field if it is equal to a certain value and if so, do something else on the form, based on this query field.
...
0
votes
1answer
99 views
Use a macro to create a simple access query
I'm trying to create a very simple access query. I've done some googling, but everything I find asking about access queries seems to be more advanced.
I'm trying to create a basic query in access.
...
0
votes
3answers
335 views
Add Criteria To VBA Code and Requery
So the following VBA code I have will requery the form based on the Combo1 value equal to January. Eventually, I'll have X number of years in the Combo value and only want to display all records based ...
1
vote
1answer
655 views
Add attachment via VBA in MS Access
One of my form is as follows
It is a form made in MS Access which allows my users to add observations. An observation may include attachments as shown. I am able to click on attachment control and ...
1
vote
2answers
1k views
Refresh MS Access Form/Query Based On Combobox Value
Pretty simple explanation. I have a table with 10 entries, 5 entries with the year 2010 and 5 entries with 2011 in a column.
In the query I have, I use Like *2010 to filter out all entries equal 2010 ...
2
votes
1answer
61 views
MS Access Update All Dates in a Table
I have a table in Access where I am trying to update all the dates to one month prior than what the table shows. If the table shows 2012/11 it should be updated to 2012/10 etc. I'm assuming the best ...
0
votes
2answers
94 views
How to get the last record id of a form?
I currently have a form in access.
What I want to do is get the value of the last record added.
For example, if i have 10 records, I want to get the value "10", because this is the id of the added ...
1
vote
2answers
374 views
How to Requery a subform inside a form?
I'm having a problem in which I can't requery a subform inside of a form in Access.
The form's name is frmSearch
The subform's name is SearchResults
I've tried
Private Sub Command38_Click()
...
3
votes
4answers
166 views
Access query to partition data and sum each partition?
I have a query with the fields date hour and value.
It looks something like this
date hour value
xx/xx/xx 15 100
xx/xx/xx 30 122
xx/xx/xx 45 50
...
2
votes
2answers
499 views
Automatically updating/duplicating a table in Microsoft Access with VBA
Back again! So I am currently trying to programmatically have a table (Table2) update after a button is pressed. I would like for Table2 to resemble exactly another table (Table1). I'm going through ...
1
vote
1answer
2k views
Transpose a set of values in rows to columns in Access 2010
I have an Access database that looks something like this:
ID | TestDate | Test1 | Test2 | Test 3 |
1 | Date1 | 10 | 20 | 25 |
1 | Date2 | 8 ...
0
votes
1answer
72 views
Why does this SQL statement ask for a value?
I have a form which lets you add names to the table and shows it in a dropdown menu.
When I click on the form, it should ask the user to enter the name they would like to add and click "ok". Once the ...
0
votes
1answer
156 views
Reference active table in split form without using actual table name
I'm writing an Access database. I have a number of forms that are identical. These are used to edit look up lists for different fields in my main contacts table.
e.g. there is a company field and a ...
1
vote
2answers
2k views
How to query number of attachments from Attachment field in Microsoft Access?
One of my users has a Microsoft Access database and in the table he has an attachment field. In one of his queries, he wants to return the number of attachments that the field contains. I have tried ...
1
vote
1answer
233 views
Show difference in records - MS Access 2007
I have a subform with the following layout:
ID---Count---Difference---Weight---Difference
Populated with data looks like this:
ID---Count---Difference---Weight---Difference
...
0
votes
2answers
1k views
Ms-Access how to use a query with a parameter inside a form
I have an SQL query with a question(alert like) that pops up every time I open it...
For every value inserted in that question you get diffrent result.
I Want to be able to use that query in my form ...
0
votes
1answer
3k views
Saving a Query via Access VBA code
I need to "physically" create an SQL query via VBA code.
I know how to execute a query in VBA, but I need to save it in the menu. If I could I would post a picture. I'll try to make you imagine.
In ...
1
vote
4answers
801 views
Need to Allow Null or “” values for Dates - Access Query Data type mismatch
Basically I'm trying to use a Module or Public functions to pull a datediff that is only for business days. Everything works as far as the code is concerned but for some reason with a particular date ...
0
votes
2answers
3k views
In Access 2003, how can I call a custom VB function from a query?
Is is possible to call a custom VB function, saved in the same Access Db, from a query written in that db, and if so, how?
