Recent content by glalsop

Some things you might consider: Do you already have Crystal, or would you need to purchase it? If you already have it, then try both solutions. I think that you would find Access more suitable for some tasks and Crystal more suitable for other tasks. I think that you would also find that either...

Something like this: Dim ctl As Control For Each ctl In Me.Controls 'Do stuff to controls Next ctl -Gary

Have a look here: faq703-1594 -Gary

Access 2000 has OpenArgs for forms, it is not available for use in reports until XP. Perhaps consider a hidden text box on the form that opens the report, or a global variable. -Gary

The controls on a tab control all belong to the same form, so you can reference them as if they were on the same page: Me.lstListBox.RowSource = "" -Gary

When this happens to me, I usually find that I had a sort on the field and didn't remove it. Perhaps check there first. -Gary

The easiest solution might be to have the user enter the dates on a form and then reference the form fields in all of your queries. -Gary

To elaborate on the comments of lespaul and cmmrfrds: You generally will not see the speed of record retrieval improve much if you create queries based on tables that are LINKED to a SQL Server database from an Access front end. However, oftentimes the retrieval rate will improve dramatically...

Are you using the DoCmd.OpenReport method? If so, you just need to set up a loop that iterates once for each community and prints a report using the Where parameter of the OpenReport method. Something like this: Dim dbsCurr as DAO.Database Dim rsCommunities as DAO.Recordset Set dbsCurr =...

As you are passing a string, enclose the parameter in quotes: Dim dirPath As String dirPath = Pickfolder("C:\") -Gary

You will also need to wrap each OR "section" in parentheses: If Not IsNull(Me.txtSrchSCity) Then If sql <> " WHERE " Then sql = sql & " And " End If ok = True sql = sql & "([po_c1] LIKE '" & Me.txtSrchSCity & "' OR [po_c2] LIKE '" & Me.txtSrchSCity & "' OR [po_c3] LIKE...

You could place a text box on a form, and enter the date once in the text box. In all 5 querys, reference the text box in the criteria section of the date field: Between [Forms]![YourFormName]![txtStartDate] And [Forms]![YourFormName]![txtEndDate] -Gary

I imagine that part of the flickering may be due to the fact that you are always setting the color, regardless of whether it is already the color you want or not. If you MUST use labels this way, perhaps consider testing for the color with an if statement: if Me.lblHandheld.ForeColor <>...

If the record source for the report is a query, make sure ProdDate is selected in the query. Ultimately, you need to make sure that ProdDate is available in the record set that serves as your report's record source, be it a table or a query. If you click View -> Field List from the report's...

Are you refering to a recordset? Try: rs.MoveLast: rs.MoveFirst before you use the count. -Gary