Search results

I often use queries based on information in forms. For example, if I want to find all orders for a particular state between two dates, the user would fill in the appropriate information on the form. (probably using a combo box to select the state so spelling won't be an issue). Lets say the...

Well, I got this to work by allowing the append to take place, querying using "group by" on all fields, making a temp table on the result, deleting the original master, and renaming the temp table to the master table. Let me know if there's a cleaner way. Thanks.

I have a database for metallurgical defects in castings. The database contains fields for the casting part number, lot number, defect code, defect zone, inspection cycle and defect size. It's possible for a single lot to have multiple defects, therefore none of the data fields lend themselves...

Thanks Pat - I agree that its the way to go Have a great day.

I've been working with this for a while and have come up with the following, but something is still missing - any ideas ? Dim rst As Recordset Dim strarray(6, 1) As String Dim counter As Integer Dim dbs As Database strarray(1, 1) = str1 strarray(2, 1) = str2 strarray(3, 1) = str3 strarray(4...

After a series of queries, I'd like to export the resulting table to Excel to graph the data. I'd like to include a "descriptors" field in the table that show the settings that were used as criteria to form this table. I have six strings that I would like to reside in the "descriptors" field...

Pat - thanks for setting me straight - I've got the query working great now & have learned a lot in the process.

Now that I've been working with this a bit, I'm still having trouble with 2 issues. The first is getting the query to evaluate an expression such as ">0" as the criteria. If I simply type >0 in the grid, it works fine but if I try to set a variable to equal >0, it doesn't work. It says "the...

Okay - I guess I need to goto the SQL view for the query instead of the design view. I work with this for a while... Thanks.

My apology for sounding repetitive. Maybe I need to reword my question. I was wondering if the public variable or function can be used as criteria right on the query form. Also - if I do need to go the route of using the code Pat described, can this be done in an event procedure ? I'm not...

Can a public variable be used as the criteria in a query ? What I'd like to do is have the user fill in a form to identify criteria for a select query. At times, the user may decide not to limit one or more of the fields at all. For example, the user may want to limit the items displayed by...

I set up a form using a select query. I automatically added the fields to the form by dragging them out of the field list box. When I go to form view, all of the fields display properly except one that was based on a picklist. It shows up blank when there's suppose to be data in it. If I run...

I know that dLookup reads the contents of a specified field and stores it to a variable. I'd like to do just the opposite. I'd like to take the contents of a variable and store it to a specified field in a specified record in a specified table. The table has two fields: CoreSN and Comment...

I have a continuous form that is used to enter serial numbers. When the user types a number and presses enter, I run an event procedure to check for three possible errors. I'd like a textbox to become visible next to only serial numbers with errors. The the trouble is that the text becomes...

groovy - this worked great !!!!

Is there a way to make text on a form blink to attract attention ?

I'm using a list box for data entry on a form. It's used to enter the product serial number and the source is a table of all valid serial numbers. Its a long list and its also numeric. I want the user to be able to type in the number and as he's doing that, the list box hones in on the number...

Hi Ginger, I'm working on a database that will require a Pareto Chart too - so let me know how this works .... Put a field for your Areas and a field for your Inefficiency in a select query. Then right mouse click to add the totals line in the field table. For the Ineffiency and Area, use...

I have a field on a form that contains part numbers for a specific product. I want to make sure the user is entering a valid part number prior to accepting it. If not, a message will be reported - so I'm trying to use the after update event. It seems more complicated than a simple combo box...

Okay - this has got to be easy but .... I have a macro that I use to import data and manipulate it by opening several queries. The first task in my macro is to turn on the hourglass because the import takes a little time. When I run the macro from the Macros tab, I get the hourglass. When I...