Search results for query: *

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

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.

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

I have a subform with a command button. I want the caption on the command button to change depending on the value in a text box. I have tried on current, on load, on open, etc... i get the same message - Method or data member not found. My code is simple: If Me.Status = 1 Then...

I have a form with a subform for "sales". The subform uses some calculations and some dlookups to produce the cost of the sale on the form. They work fine, but before the sale is entered, they show #Error in the text box. Is there any way to hide these? Thank you.

I need to run a report with different options. I have two Option Groups on my form with the following code on open of my report: Private Sub Report_Open(Cancel As Integer) If Forms!frmPrintCheckRegister!FrameSort.Value = 1 Then Me.OrderBy = "CheckDate" End If If...

I'm trying to "blank out" a field in a table on update of a field on a form. My code is: db.Execute "UPDATE tblClients SET DeniedCreditDate = Null, & " WHERE ClientID = " & Me.ClientID, dbFailOnError I've tried updating the field to "", but that doesn't work either. I'm getting an...

I am using macros on a customized menu in Access 2007. I have the same form being opened from 2 different macros and in one case, I want a command button on the form to be disabled. Is this possible? If not using the macro, can I do it in vba?

I need to keep an autoexec form maximized at all times so that if an employee closes another form or report, the form with the logo will be in the background. Every time they currently close a report or other form, the autoexec form resizes to small. DoCmd.Maximize is on the "on open" event of...

I'm understanding the basic idea of customizing the ribbon but I have one major question. I created a group and I want to add "links" to run specific reports. When I couldn't find the idMSO for running code, I created macros. That works fine, but it only allows one instance of "MacroRun" or...

I have a report being run by a form which offers different sort options. There is one group in the report - call it "Status". I need the users to be able to sort within the status by "client name" or "days past due". I'm having no luck. The sort order is being offered by a combo box...

I am using a form for users to make their choices before running a report. I have two fields that I would like for them to be able to not choose anything so that the report runs for all of those options - for example, all transaction types instead of just one. I can do this when I only have one...

Is there code to copy all records in an Access table to the clipboard? The final step is pasting them in a specific location on an Excel spreadsheet. I have that worked out, but would like to automate the part of opening a table, selecting all records and copying them. Thanks!

I am running a DAO recordset in a report. There is a total in the report footer using Sum - Over All. The references on both computers include DAO 3.6 Object Library. On one computer the totals are correct, on the other, it simply picks up the value of one of the items. What could cause this?