Search results for query: *

I have generated a form that would run off a query. Now I would like to create a menu bar for user friendly purpose. How would I do this? Thank you in advance.

Eric, Did exactly what you had instructed and when I click on the button, it would give all warehouse locations. Just to clarify things, the "unbound" text box, in the "other" tab, I should label it txtWhseLoc. In the command button, since I am using Access 2000 still, the button wizard...

Yes. My report is an inventory report that consists of all warehouse location and I was able to do that. As you know, at the query level, I can input a warehouse location and pull the inventory info. from there. I would like to perform a macro that would give me a form so I can input my...

If I have generated a query successfully and would like to create a macro to automatically pull the query and give me a form format to input my criteria before running the query. How would I do this? Thank you in advance.

I am currently using Access2000. I am using it to perform custom functions drawing data from our ERP system (Visual Foxpro 8). With the latest upgrade of our ERP system, Access is indicating an error code 3146 ODBC - Call failed. How do I find out what this error mean? Thank you.

What would be the best way to convert a field display, ie. "standard" into "std"? For example: if I have fields that contain text "standard", "mfg hold", and "cancel" and I want them to show as "std", "hold", and...

I am using CR8. Most likely due to some multiple linking but it would take too long to explain the inadequate databse structure (Manex). Yet, my results are showing up but it has multiple items that are the same.

I am using CR8 but it does have the "distinct" function. Thanks a million!

How do I select only unique records? For example, if CR is showing me duplicate records such as: workorder# qty sales order# Line# 1111 100 4555 1 1111 100 4555 1 How do get CR to show me only one record? Suppressing will not help my calculations.

How do I select only unique records in Crytal Report? For example, if my report is showing duplicate entries of record such as: Workorder# Qty Sales Order Line# 1111 100 4555 3 1111 100 4555 3 How would I tell CR to just show me one record only if...