Search results for query: *

For question number 2: Go to the design view and set all views except pivot to no.

Yes, it is a compound primary key. Should I make only ID the primary key? If so, why is it important to be designed that way?

AceMan, Here is the Row Source for the second combo box: SELECT tblProductName.ProductId, tblProductName.Product, tblProductName.ManufacturerId FROM tblProductName WHERE (((tblProductName.ManufacturerId)=Forms!frmAddNewVehicle!cboManufacturer)) ORDER BY tblProductName.Product; The Primary Keys...

I have an inventory control database that allows me to add and sell products. On my frmAddNewProducts form it asks for Manufacturer and ProductName, these are in combo boxes. The combo boxes are linked so that the cboProductName box is dependant on the cboManufacturer box, this works well. I...

I have an inventory control database that allows me to add and sell products. On my frmAddNewProducts form it asks for Manufacturer and ProductName these are in combo boxes. The combo boxes are linked so that the cboProductName box is dependant on the cboManufacturer box, this works well. I...

Thanks ClydeData and PHV it works now. PHV, sorry for not finding the FAQ before I posted. I did a search but couldn't find what I was looking for. I'll dig deeper next time.

I have a form that has two combo boxes. The first combo box asks for manufacturer and the second combo box asks for product. I want the second combo box to only show products from the manufacturer specified in the first combo box. Sort of like selecting a state and only having the cities from...

I have Office Professional 2003 and purchased Visual Studio Tools to get the Access 2003 Developer Extension tools. When I run the packaging wizard and select English as the default language it tells me that the language files are not cached and to select the folder or CD where the full Access...

Is it possible to get the Access 2002 Runtime environment without purchasing Office XP Developer? I think that Visual Studio Tools package has the Access 2003 Developer Extensions but from what you're saying that won't work because of the version differences.

I have Office XP with Access 2002 installed on my computer. Will the Access 2003 Developer Extensions work with Access 2002? If so, how? I need to package a DB with Run Time but when I click on the Package Wizard link from the Start Menu I get an alert saying that MSACCESS shortcut has been...

Thanks for the input. LittleSmudge you indicated On_No_Date event property did you mean OnNoData?

I have about 10 reports that are printed from my database. I know there is a NoData event for the properties. My question is can I make create a module that makes the procedure available to all my reports or do I have to go to each individual report and put in the procedure?

PHV, It works, but you probably knew that. I don't fully understand why yours works and mine didn't but thank you anyway.

Leslie, Here is the SQL view of the query. Again when I take the parameter function out it runs properly, but with the parameter there I get different results. SELECT tblProducts.ProductNumber, tblProducts.Make, tblProducts.Model, tblProducts.Cost, tblProducts.Received, Date()-[Received] AS...

I have a query that does a calculation on how long a product has been in inventory (=DATE ()-[Received]). I want to set this up as a Parameter query so that I can look at only products over a certain number of days. As a select query it runs fine but when I add my Parameter statement [You're...

I am trying to create a multi-tabbed form that will display products based on cost. For example: Products under $100 on tab1, between $101 and $200 on tab 2, etc. Is it possible to display multiple records/products on a single page? If so how?

Thanks PHV, I used the code and it worked perfectly, I also added to it so that if the date that was entered went too far in the past it gave another error.

Thanks PHV, I'll go back and try it again, I was putting it in the On Exit section of the event, I'll try it in the BeforeUpdate. How do I get it to go back to the same control field until an acceptable date is entered, or will the incorrect date force it back automatically?

Once the field is added to the table then the field should be added to the form from the field list box, which will allow the information that is put into the form to be stored in the table, is this correct?

I am setting up a form and I want to be able to display a message box and have a certain control receive focus if an incorrect date is entered. For example: If a date in the future is entered I want my message box to come up and state that the date is incorrect and then have that field receive...