Search results

Sorry, got distracted whilst answering, I meant Allow Zero Length, the one below it

One way, though I would be surprised if it is the easiest, would be to do the following in code: 1/ Count the number of records 2/ Work out how many records per page 3/ limit the feeding query to show the first 16 (for example) records (use the top X command). 4/ Output report 5/ query for...

Make sure that the field in the table hasn't got 'Required Yes' in the General properties

You can create a macro in Access to update the rows and call it from the command line: "c:\program files\microsoft office\office\msaccess.exe" c:\yourpath\yourdb.mdb /X MacroName HTH

Try changing the splits of the 2nd/3rd lines and the 5th/6th lines so that you are doing the ..." & _ "... within the string rather than kicking straight into a variable on the new line.

="For the period from " & format([Forms]![frmLookupDevFeeBillingRpt]![BeginningDate ],"mm/dd/yy") & " to " & format([Forms]![frmLookupDevFeeBillingRpt]![EndingDate],"mm/dd/yy")

The way to 'link' it is: 1/ Output the query as "MySource.xls" 2/ Open MySource.xls 3/ Open a new excel workbook and call it "MyGraph.xls" 4/ Create the graph in "MyGraph.xls" referencing the info in "MySource.xls" Now you can output the query on a daily basis as "MySource.xls" and when...

Why not change the code of the query to output all quotations for the day?

whats doing the calculation, the VBA code or the textbox?

you shouldn't need focus to assign value to variable so try without the first line and try [Forms]! instead of me (not sure about sunforms whether this work as don't use them!)

try .Value

Or use the mode or median figure

2 column Table (expand code to suit) Table: Case_Data Fields: Case_ID, Name SELECT Case_Data.Case_ID, Case_Data_1.Name FROM Case_Data INNER JOIN Case_Data AS Case_Data_1 ON Case_Data.Case_ID = Case_Data_1.Case_ID WHERE (Case_Data.Name="John Smith"); Basicaly, in the query design select the...

Create 2 queries: Query1: Select all records where user name is 'John Smith' Query2: Select all records from table where CaseID = CaseID from query1 HTH

How is the data stored? Do you have a table with case and case ID and then another table with userID and CaseID? If so then you can create a query selecting all users where caseID = x. Let us know how you store the data and we can help

Try this: Set variable Smallest to a ridiculously high number so that it will be replaced by the first textbox value, then you do not need to make Smallest = Num for the first instance. Smallest = 1000000000 For Each control In subfrmRepeats.Controls If control.ControlType = acTextBox Then...

You need to open the form ARTScript before you can assign values to the controls. ie somewhere near the top of your code DoCmd.OpenForm "ARTScript"

MyRS.FindFirst MySearch

Make sure: 1/ That you have Microsoft DAO 3.6 Object Library selected in references 2/ Declare MyRS as DAO.Recordset HTH

Where does it fail? PS MyRS.Close ought to be at the end!