Search results for query: *

Why don't you post the query and the table structure you are trying to update?? Kevin

Hi again PHV. Thanks for prior help. I also have Excel code that simple tells Excel to read a recordset (that is created by Access or Excel and presumably others) that I hand it. Is that still working?? Thx Kevin

Hi Duane, Just saw this and am wondering about the specific meaning of "Access can no longer update Excel files.". I have several Access mods that document Access queries, tables, etc into an Excel sheet. It specifically says " wbExcel.Sheets(1).Range("A" & lngRow) =...

Error is "Could not delete from specified table. I your version is generally it. Thx much. The fog is lifting. Kevin

Thanks for answering but that gets the same error. I am pretty sure that the structure required in the query is of the nature of : DELETE tblName.* FROM tblName WHERE FieldX IN(SELECT ..... (with joins etc in here) My problem is I forget the syntax. Thx Kevin

Here it is: DELETE DISTINCTROW tblClaimsData.* FROM tblClaimsData LEFT Join tblVendorStatus ON tblClaimsData.Vendor_ID = tblVendorStatus.VendorNo WHERE (((tblClaimsData.Service_Date Not BETWEEN tblVendorStatus.EffectiveDate AND tblVendorStatus.TermDate)) OR(((tblClaimsData.Vendor_ID) IS NULL()...

I am having a brain freeze the Morning. I've done this type of query many times but it's not coming to me today. I believe that Access is barking at the join in the qry. I want to delete records from tblClaimsData when the tblClaimsData.ServiceDate is not Between the tblVendorStatus.EffDate...

Hi Skip Thanks for looking at this. I am not an Excel guy but I did think of preformating the cells. I did it for general, I did it for Number no decimals I did it for percentage where appropriate. It will still display, seemingly at random, dates for the numbers. If it matters, I am using...

I am moving data from access to excel with "copyfromrecordset". It works fine with the exception that the data sometimes comes in formatted as other than what it is. Example: one set has three fields. they are typed in access as Long integer, long integer and percentage. Excel randomly turns...

Duane, Thank you for the response and particularly the info on Jet's SHOWPLAN. I have been working with Access since the early 90s when I gave up on FoxPro and Clipper. I have never heard of or seen the SHOWPLAN feature. Does MS have a site where such things are discussed/catalogued? Thx Kevin

I am looking for some fairly technical information on the processes Access applies to queries. My interest is mainly in getting access to work as little as possible and thus respond as quickly as possible. So that there is some context for this let's say that I am querying invoices and the...

I just quickly reviewed an article on the intro to MS Access 2013 ( http://msdn.microsoft.com/en-us/library/office/jj250134%28v=office.15%29.aspx). If I read this correctly, Access is to become a web development environment. Queries, forms, et al are to be stored in Sharepoint with data housed...

Here is the quick and dirty code that I usedto find my data. Sub SampleData() '********************************************** '*This is designed to walk the table definitions in an access db '*and print out the top five records from each similarly named '*table. you could...

I want to iterate thru TDFs, set a strSQL to get the top 5 records, open and print the query result and move on to the next TDF. I have code for looping the TDFs but after opening the query how do I print it and close it ? Thanks.

Thanks for answering. This db(it is not a front end - my presumption), it houses everything but the link files. So maybe more information since I posted. There are other dbs out in the same directory. They open and operate fine from his machine. We made another copy of this db and placed it...

I told a friend I would stop over and fix a form for him but it has me baffled. This is Access 2K. The startup routine opens a form Named "Welcome". On that form are many cmdbuttons that open subordinate forms. The buttonsrecently stopped working for him. If the form is opened through the...