Ok, fixed the spelling. Actually shortened the query names completely. Getting run-time 3265 Item not found in this collection. Row affected is Set qdf = CurrentDb.QueryDefs(Qname. Is there some other object library I need to have slected? This is an Acess 2010 db.
Dim Qname As...
Maj - Now getting a runtime error 3265 Item not found in this collection. Row highlighted is
Set qdf = CurrentDb.QueryDefs(Qname)
I am not familiar with QueryDef object so am not sure hot to troubleshoot. Here is what I have currently
Dim Qname As String
Dim qdf As dao.QueryDef...
Looking for some help running queries based on a combo box. Have looked through the forums and couldn't find anything on running different queries based on values.
I need to allow the user to switch back and forth between two different recipients of documents that are to be printed and...
I have an MS Access 2007 DB we are using to record and track user requests in (sales type stuff). We are also using this db separately as the source for a merge document which creates a document that is printed and sent back to the requestor. I have looked in this forum and others for a...
It has been a while since I did any serious work with queries and then of course my machine was upgraded to MS Access 2007 so there is probably some newer way to do what I need to accomplish.
I have two tables, and need to use the value in Table A to return a value from table B to a query...
I have a table with approx 8000 records in it which contain names and addresses. Many of the names are repeated with different addresses. I am trying to break the table apart into two tables one for names and then a separate table with address records that relate back to the names. Each Name...
My users are asking for a button in an access form that will create a Windows folder (Directory) on a shared drive to store customer documents in. When we create the customer record in Access they want to have a button to create the folder using the CustomerID as the folder name. The...
I'm using the Export function in access to generate a semi-colon delimited file. My upload of this file failed for some formatting problem. when I got the diagnostic back, there were 3 characters on the front of the first row of my data that I didn't export and that I couldn't see in the txt...
I have a database to which I import names and other information about businesses and then export the data as delimited txt files. Users are very bad about putting restricted characters in the name field for businesses. One of the services that I export to is very fussy about only certain...
Excellent point! I need to have a future date 3 business days from the [EndingDate, not including the date entered by the user in the text box.
Ending Date of Tuesday 1/3/2006 returns [FutureDate] of Friday 1/6/2006.
Ending date of Friday 1/6/2006, returns [FutureDate] of 1/11/2006. (This...
I have a form that has two text boxes for dates (these drive my report criteria). I need to be able to calculate a future date that is on a working day (M-F) off of the [EndingDate} text box. It would be even better if I could somehow weed out holidays, but I don't want to get greedy. Anyone...
Actually what I was thinking would work is rather than merging directly from a table, use a MSAccess query to pull the records for the merge instead of SQL. In the query create a field called something like
CurrentDate: Date()
And use that field to populate the field in your merge word...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.