Search results

I believe I would not have this issue, as I am using the combobox instead of the navigation buttons. I have turned the navigation buttons off.

I solved this using Method 1 here: https://support.microsoft.com/en-us/kb/287658

I have: tblCase which has Primary Key CaseID. tblReview which has Primary Key as CaseID + PCLevel. There may be 1 or 2 records in tblReview per CaseID. frmCase which is based on tblCase. frmReview which is based on a query which contains fields from tblCase and tblReview. frmTDReason, a pop...

stopher: Thanks! Your suggestions worked. smig: I am using Access 2007. Now on to the other part of my problem. The report is now successfully displaying the new records for each date in the entered date range (those with a RequestDate on that day). It also needs to show "carryover" records...

I have 1.a table where one of the fields is RequestDate. 2.a form in which a date range (FromDate and ToDate) is entered. 3.a query which will select all records with RequestDate in this date range. 4.a report which prints the results of this query. How do I get the report to print the...

Yes, changing the order of the parameters worked. All the expected records were appended to tblHTLClean by running the code. Thanks!

CJ_London, That could be it. I will change the order of the parameters in the query. After I receive the next set of data, I will run the code again and let you know if it works.

ExecuteQuery: '************************************************************************************** '- Is called by multiple subs in various modules '- to assign parameter to a query and then execute the query...

The code is: Public Sub TransferCleanData(strAUID As String, strRevType As String, strSample As String) Dim rst As Recordset2 Dim qry As QueryDef Dim n As Integer On Error GoTo Err_TransferCleanData Set qry = CurrentDb.QueryDefs("qryTransferToCleanQueries") Set rst =...

Hello, I am calling 3 append queries from my code. The first and the third queries are working fine. The second query works from design view or the database window but does not work from the code. The query is called exactly the same way as the other two. I compiled the code and did compact...

I got it to work. The query qryClaims was causing the problem. I updated CaseID in one of the underlying tables. Then I was able to simplify qryClaims so it (and the queries based on it) would run quickly.

The query is:

I have a query which has worked in the past. Today it ran slow, and when it finally came up with results, it hung and did not display the number of records. I tried changing the query. Before saving, I ran the query and it ran quickly, giving the expected number of records (162). After I saved...

Looking at it again, it actually looks like those queries were working. However, the field ListNbr in FacilityHits had an old value in it. That was partly what made me think that the table was not updating. After I compacted the back end, which contains the table that ListNbr comes from, I reran...

Here is my code. This has been running OK for years, now suddenly the delete and append queries do not seem to be running. This code is supposed to: 1.delete all data in table FacilityHits 2.Append new data to table FacilityHits 3.Call Calc_Fac_Total to calculate a facility distribution from...

I have solved the problem. The parameter is entered on a form. When I opened the form and entered the parameter value there, I was able to open the report in design view and make changes.

When I open one report in design view, it keeps prompting me for a parameter so I cannot do anything with it. The prompt keeps reappearing whether I enter the parameter, just click OK, click Cancel, or close the prompt. I cannot get out of it except by closing Access with Task Manager. What...

I have a main report with numerous subreports. Everything is fine except for one report. The subreport is correct when run by itself. However, when I run the main report, one line on this subreport is incorrect. There is no linkage to the main report to worry about, as the main report has no...

There is OK and Cancel: OK saves the query, if I click Cancel the query stays open.

Sometimes when I create a quick query just to check something, then try to close the query, I am prompted for the name to save the query to instead of being asked if I want to save the changes to the query. I cannot close it unless I save it. What causes this and how can I fix it so it will ask...