Search results for query: *

Thank you. I was able to figure this out a couple of months ago.

I have a small database on a SharePoint site. I created 2 new tables - Orders and OrderDetails. The database is now working online, but I need to append Orders and OrderDetails from the original stand alone database for history. How can I append the data in the old tables and keep the...

That worked perfectly! Thank you very much for your time and your patience.

Sorry - those are the fields in my table. I cannot show real data because of the sensitivity of the information plus my real table has many fields. I hope this sample with fake information will help. SummaryDate BankDepositToday BankDepositMTD BankDepositYTD 9/24/2010 2380 30269.29 292655.22...

Sorry- a record in the table would have the following: SummaryDate DepositsToday DepositsMTD DepositsYTD InterestEarnedToday InterestEarnedMTD InterestEaernedYTD There are approximately 30 fields in the table. All of these are a currency data type except for the SummaryDate field...

Yes, I have a form - frmTrialBalance - with a start and end date to choose. I have a table - tblDailySummaryStoreInformation which captures information posted every business day. If I want to run the Trial Balance for 10/1/2010 to 10/31/2010, I would want to find the values in the...

I am working on a Trial Balance with fields on a form called txtStart and txtEnd. I need to get the values in a table on the record before the txtStart date. Any Suggestions? Thank you.

Honestly, I've tried about everything. I've created extra text boxes to hold the values of the calculations. I've tried combining every single calculation with "Sum(...) What I have right now is: Sum([Quantity]*[ItemKey].[Column](4)).I'm currently looking into trying to make this form a split...

I have a form that is keeping track of miscellaneous sales. The items first have to look up the cost of an item, then find out of there is sales tax on that item and add to it. So I have: =([Quantity]*ItemKey.Column(2)) which is the cost of the item...

Thank you! I got it! Many thanks for your persistance.

frmClient Information is the main form. frmCallAudit is a subform on a page on that main form. This is my exact code: If Forms!frmClientInformation!frmCallAudit.Form.txtStatus = 1 Then Forms!frmClientInformation!frmCallAudit.Form.btnNewCourtesyCall.Caption = "Click here to make a Courtesy...

I am not getting any error messages when I put the code on the main form, but it also isn't accurate. It is only showing the "No calls to make" message whether the account has an appropriate status or not.

Adding the .Form. in gave me a new error: "...expression that has an invalid reference to the property Form/Report.

That is the total code on the OnCurrent of the subform frmCallAudit. I stated earlier that it was OnCurrent.

Thanks, but same error message: "Object doesn't support this property or method" with debug going to If Forms!frmClientInformation!frmCallAudit.txtStatus = 1 Then

yes

I don't get any errors when I compile. When I open the main form, I get an error message and the debug goes to the line If Me.txtStatus = 1 Then The error message is "Object doesn't support this property or method

Yes, I compiled it with no errors until I place this code On Current. Thanks anyway.

I tried it on Current and on Load and I get the same error message: the expression has an invalid reference to the property form/report and the debug goes to: If Me.txtStatus = 1 Then

I have tried to run the code from the subform.I have the status text box on another subform, however I put a txtStatus on this subform which references the other subform and the status comes through accurately. This subform is a single form, not continuous.