Search results for query: *

[MachineXREF] table contains a field for [State] and [Distributor]. I need to make a query to return the [Distributor] and all the states in a single field. For Example: DistA: NC,PA,OH DistB: NC,SC,WV and so on. How do I go about this?

I want the user to be able to type in < > or = and a number into a text box and use that expression in the where clause of a query. However, it seems that whenever there is an operator in the text box it doesn’t return any values. Is there any way to have a user select between < > or = and...

I am trying to import data to an existing table with a primary key of Machine_ID. The data file I am importing has a few repeat instances of Machine_ID so about one fifth of the records fail due to key violations. I want to record the most recent record (where Start_week is at it’s max). If I...

I have two forms that are viewed as a Datasheet to allow users to change data in the tables. I want to create a record in the history table each time a field in a record is changed. If a user changes five fields on the same record, I want there to be five different entries in the history...

I have some VBA code that pushes a query out to Excel. It works fine on my machine with Windows XP and Access 2003 but not on my managers machine which has Windows 2000 and Access 2000 (don't ask me why the interns machine is brand new and the managers is 3+ years old). Here is the code I...

I have a query returns a single integer that I need to assignt put into a variable. This doesn't work: intCurrentUnits = [qry_sum_units_per_com]![SumOfComp_Units_Per_Component] I have a list box that displays the query also, would it be possible to use CInt() to pull the value from there...

Here's the deal. I have a list box that I want users to be able to select (multi select = Extended) rows to export to excel, but before that can happen I think I have to populate a report to use as a template. I have a Shipper table and each table is made up of one or more Components from...

I have a form where users will enter a new Shipper. While the Material Code is not the primary key, it does need to be unique for each shipper. I want to place code in the AfterUpdate event of the text box to ensure that the value entered does not already exist. Suggestions? Brian