Search results for query: *

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...

Should have mentioned the portion of the code that is highlighted is .rowsaffected

Thanks MajP. Using your proposal I received a different error. Compile Error: Method or Data member not Found.

Thanks Prattaratt, I got a syntax error using that code on the line with the RowsChanged.

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...

Read only should be ok. I need to export the results to excel to do some pivot stuff that is beyond what I can do in access.

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...

Thanks PHV - Simple solution. Works great. Just needed a guiding hand. Here's a star for simplicity!

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...

Actually it appears to be an issue with saving the txt file as Unicode. Once I saved it as ASCII it worked fine. Thanks for the post.

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...

thanks for the suggestion, I'll see if I can make it work.

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...

Worked like a charm. My debugging skills aren't too great. Thanks for the help!