Search results for query: *

what would be the best procedure to automate a calculation in a forms textbox. I was able to utilize the following code and have it work once the 4 textboxs had the values entered and I utilized the double click event. Should I be creating a module or using an event with after update or change...

Here is the query that is called from a button for the current record being viewed from the form. SELECT TTLOG.[Log ID], TTLOG.Date, TTLOG.[First Name], TTLOG.[Last Name], TTLOG.[Title Name] FROM TTLOG WHERE (((TTLOG.[Log ID])=[Forms]![TTLOG]![Log ID])); Macro: I have two actions, the first is...

The query is used to show the current record, it does open a report and looks fine, however when I print the very first time with the report open it prints what the form looks like, if I print again, it prints the report from then on.

access 07 Report Prints Form first time instead of Report. If I print again it prints Report fine from then on. Using a macro to call the query, and don't think its the query since it only happens the first time. Didn't find anyone with similar issue

By placing the following code in the Where Condition of the macro i was calling the "Search by Date" query I was able to find a work around: ((([TTLOG].[Date]) Like [Forms]![TTLOG]![Search By Date] & "*")) Thanks for all the help, I know I will never use spaces in things again.. still am not...

That produced the same errror: The Error is Run-time error '3061' to few parameters. expected 1 Field RunSum are #error. I saw another person with the same error and it was because the form was not declared. The "Therefor part" is: In my form and report each record has a TotalHrs that changes...

SELECT TTLOG.[Log ID], TTLOG.HoursTrained, TTLOG.TotalHrs, TTLOG.Date, CCur(RecRunSum("Search by Date","Log ID",[Log ID],"HoursTrained")) AS RunSum FROM TTLOG WHERE (((TTLOG.Date) Like [Forms]![TTLOG]![Search by Date] & "*"));

I Would use the non-code solution with the running sum control property but the issue I run into is if the user changes a record inbetween on the form it changes it on the fly but the records after that don't change on the form until each record is viewed. Therefor the report when viewed using...

I have a textbox that the user can enter a date into __/__/____ also a button that calls a macro that calls the Search by Date query based on the date the user enters and opens a report. If no date is entered the query / report produces all records. I don't have any query code and beleive the...

when the code: Like [Forms]![TTLOG]![Search by Date] & "*" is removed it will work, am trying to narrow it down further

The Error is Run-time error '3061' to few parameters. expected 1 The Search by Date is called from a button where the user can input the date, if not date is entered it pulls up all records in the report. The like.... is on the criteria of the Date field. I have also tried the RunSum.. with...

Thank you, I had noticed it also after posting and got as far as #Error in the runsum field with the query and have not solved it yet.

Yes I have that and seems correct, The field that is summed "HoursTrained", if I change it, it updates the "TotalHrs" on the fly for that record, but If I have records 1-10, and go back and change the field that is summed for record 5, "HoursTrained", 6-10 don't have the correct "TotalHrs" until...

referencing FAQ702-5248: that I used for the Form works with the exception if I make a change the running sum only changes for that current record and not any records after that, unless I move forward through each record manually. This was causing the issue I was having with the Reports. Is...

OK, that makes sense and got me further. I am now stuck with a syntax error and not seeing it. I working with faq on Running sums with query and have the following syntax, I am guessing my issue is with the spaces in the names again. used in my query "Search by Date" : RunSum...

No, just the following: VB for applications, Microsoft access 12 object library, OLE automation, microsoft office 12 access database engine object

faq702-5248 "Name Conflict with existing Module, Project or Object" Can you tell me why I get this error when enabling DAO 3.6 Object Library in Access 2007 under VBA, Tools, References.

Can't believe I Didn't see that, I can tell you it works without even trying it. thanks...

It is Hours Trained and Log ID with a space between them. Is there a way to Sum the current record plus the previous records or prior, where if the current record is number 3, it would include record number 2 and 1 in the sum or DSum. I am not sure if I can do this with a querry or should use...

This is where I am at but now need to find the method to set the current Log ID for the criteria and sum the current and prior Log ID for the field Hours Trained. I was reading way to much into it before thanks... It currently just multiplies the last Log ID # by the Current Hours Trained. If...