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 Chriss Miller 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: dragongunner0351
  • Content: Threads
  • Order by date
  1. dragongunner0351

    Controls and Records will NOT update

    Hello All, today something very strange happened to our DB, none of the records will update, the command buttons do not point were they are supposed to, if I click on a calendar control (example here) I get a cannot update error, I cannot select anything from any combo box controls because this...
  2. dragongunner0351

    Opening form from dbl click blank if no data in control

    Hello all, I have an event that executes when the user double clicks a partNumber Control: code: DoCmd.OpenForm "Product Details", , , "[Products]![ID] = " & Me![Product ID] This opens a details form for that partNumber. Is it possible for it to open a blank Product Details form if there...
  3. dragongunner0351

    Best Method for Archiving Data

    Hello All, I have a DB that mimics a CRM to some extent, the area for this question I am most intrested in is in the inventory portion of the DB. Throughout the year pricing changes. For the industry I work in sometimes monthly if not weekly, at times depending on the Asian markets we have seen...
  4. dragongunner0351

    How to allow for mulitple selections from a Combo Box Control

    Hello all, I was wondering the best way to allow the user to make multiple selections from a combo box control. I'm thinking that I will need to have an unbound control that allows for the mulitiple selections to be stored in. Also, I would like to seperate each selection with a comma or...
  5. dragongunner0351

    Conditional Formating a Control based off of Order Date Age

    Hello all (Access2003 DB) I have a subform that displays in list view, one of the controls is an OrderDate, I would like to change the background color to red (for the whole row if possible) if the Order is 15 days old. I've tried the following conditional format: Expression is...
  6. dragongunner0351

    User passing parameters will not show records

    Hello all, I have a query that is not functioning as completly as I would like, I have a form that has two unbound combo boxes on it cboCompany & cboMachine, When the user selects the company name the query returns the appropriate data for that customer Criteria =...
  7. dragongunner0351

    Filter Certain Records based off of users selection

    Hello all I have an Access 2003 DB, I have a table that holds Machine Lead information. Fields include: Id, CompanyName, MachineType, Quoted, DateQuoted, and Status. I want to have a form that has predefined parameters (via list boxes or drop down list) for the user to select to help...
  8. dragongunner0351

    Query opening blank when begin and end dates are entered

    Hello all, I've made a query to view sales orders by a particular date. In the OrderDate field I have this listed under criteria: Between [Begin Date] And [End Date]. For some reason if I don't put in a date I can view a report that shows me all sales orders, but if I put in a date I don't see...
  9. dragongunner0351

    Undefined Function 'Nz' in expression

    Hello all I have a slight problem I am hoping someone can help me with. I have a query that keeps giving me the following error message: Undefined Function Nz in expression Example: Qty Sold: Nz([Quantity Sold],0) However when I create it this way: IIf(IsNull([Quantity Sold]),0) I do not...
  10. dragongunner0351

    Criteria Expression Error

    Hello all, I have a table that I am trying to build a query off of. There is a Field in my table called status. It is linked to another table called tblStatus, there a three choices for the user to select in the Status Field 1. Open 2. In Process 3. Closed I have built my query and I am hoping...
  11. dragongunner0351

    Form Opens Blank (No controls visible)

    Hello all I have a form that opens fine when viewing previous record entries. However when I open the form to create a new record it loads blank. Any ideas why? The form is opening based off of a command button control. One control is "View Previous Orders" (This control loads the form properly)...
  12. dragongunner0351

    Problems adjusting Inventory Levels

    Hello all, I have a bit of a problem that seems to be snow balling on me. I'm not sure if I should go back to design to resolve this but here is my problem: I have a table that holds all product information Product Name, Description, Quantity, etc... The two controls that are critical to what...
  13. dragongunner0351

    Forms will not stay maximized

    Hello all, I have a simple little macro that Maximizes the form window from the 'On Open' event fo the form. Works great, however whenever I open another form and then close it none of the other open forms are maximized, they are nearly maximized but not completely. does anyone know how I can...
  14. dragongunner0351

    Alphabetical Listing Not Correct

    Hello all, I have a form that has an unbound combo box that is linked to my customer table. The user begins by typing in a few letters of the company name then the rest is autofilling, pretty routine. However, the company names in the combo box are not showing up in alphabetical order. At a...
  15. dragongunner0351

    Filter Issue?

    Hello all I have a Customer Order form that has a control (button) that when clicked will open all repair work orders for that customer. Here is the code behind the button: DoCmd.OpenForm "Repair Work", , , "[Repair Work]![CustomerID] = " & Me![CustomerID] Works great when the button is...
  16. dragongunner0351

    Multiline Textbox?

    Hello all, I have a textbox control on my form that I would like for the user to be able to press the enter key and go to the next line for further data entry. Currently, as the user types in information it will only advance to the next line when they reach the edge of the control. any help is...
  17. dragongunner0351

    How to include an OrderID number in the subj. line of an email

    Hello all, I have a report that is emailed out of my database in snapshot format, I would like to automatically include the OrderID number of the order in the subject line of the email. Any help is greatly appreciated
  18. dragongunner0351

    Quantities in Products Table not updating properly.

    I have posted this problem twice and unfortunately I still need assistance. I have a Products table which holds quantity levels of parts. BeginningBalance and Available Units. The Products table is linked to the Order Details Subform via OrderID -> Product ID (Relationship) This is the code I...
  19. dragongunner0351

    Should I use "On load" Event Proceedure?

    Greetings all, I have a bit of a problem. Let me begin by describing the structure. I have 3 Tables 1. Products a. Hold info on products, Available Units, Beginning Balance, List Price, Sale Price, etc... 2. Orders a. User input for processing customer orders. 3. Order Details a...
  20. dragongunner0351

    Question about Combo Controls

    I have a Form with an embedded subform. The subform is in Datasheet view, one of the controls is a Combo Control when I select the part the Base Price associated with the part autofill on the subform but the sale price and units on hand do not. Any ideas why?

Part and Inventory Search

Back
Top