Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: snub
  • Order by date
  1. snub

    3 questions about pivot form

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

    Adding info to a combo box that is dependant on another combo box

    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?
  3. snub

    Adding info to a combo box that is dependant on another combo box

    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...
  4. snub

    Adding info to a combo box that is dependant on another combo box

    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...
  5. snub

    One more combo box question

    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...
  6. snub

    Linking Combo Boxes

    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.
  7. snub

    Linking Combo Boxes

    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...
  8. snub

    Packagin Wizard?

    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...
  9. snub

    Access 2003 Developer Extension

    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.
  10. snub

    Access 2003 Developer Extension

    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...
  11. snub

    No Data event question

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

    No Data event question

    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?
  13. snub

    Parameter query problem

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

    Parameter query problem

    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...
  15. snub

    Parameter query problem

    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...
  16. snub

    Question about a tabbed form

    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?
  17. snub

    If...Then statement

    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.
  18. snub

    If...Then statement

    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?
  19. snub

    Unbound text box is repeating on all of the other records

    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?
  20. snub

    If...Then statement

    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...

Part and Inventory Search

Back
Top