Search results for query: *

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

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

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

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.

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