Search results

  1. K

    Open a form which contains a subform, such that the subform's fields are blank

    Hi there! I have a [Order Central table] that compiles products from four different categories that employees can order from. Employees using the database will select from four categories on buttons which opens up the order form EX: [Category 1 form]. They enter their order info on...
  2. K

    Require input to be within a given interval

    Awesome! That worked great, thanks a bunch.
  3. K

    Require input to be within a given interval

    Hi CG_London! So one column 1-999 would not be allowed, 1000 is allowed 1001-1999 is not allowed, 2000 is allowed. 2001-2999 is not allowed, 3000 is allowed. I have another column that has to be entered in blocks of 20, 1-19: not allowed; 20: allowed 21-39: not allowed; 40: allowed Any thoughts?
  4. K

    Hi I need help with Autonumber sorting out in order

    I think the quickest solution (and probably the laziest/least professional) is to: 1.) Remove the Primary Key from your table 2.) Copy and paste the data into an excel file or another blank table 3.) Delete all the data in the original table 4.) Delete the autonumber column from your pasted...
  5. K

    Require input to be within a given interval

    Hi there! I am trying to make a quantity column in my table only allow input with intervals of 1,000! Any suggestions? -Nick
  6. K

    Missing Objects, sort of

    Hi there! Not sure what your SQL statement looks like but you'll have to add With clause into the mix! Here's a link regarding 'With Clause's' if you need it: technet.microsoft.com/en-us/library/ms175972.aspx Sorry it's not a hyperlink, not enough posts yet!
  7. K

    Run a lookup with unique criteria based off each individual record

    Yeah I noticed my mistake right after I sent that reply! Update's nearly instantly right now. Thank you :)
  8. K

    Run a lookup with unique criteria based off each individual record

    Here's what my final statement ended up looking like to whoever is interested UPDATE [DSL Carrier CLLI's] INNER JOIN [Customer NPA-NXX's - ADSL - Test] ON [DSL Carrier CLLI's].DSLCarrier = [Customer NPA-NXX's - ADSL - Test].[LowCap(L)].Value SET [Customer NPA-NXX's - ADSL - Test].[LowCap...
  9. K

    Run a lookup with unique criteria based off each individual record

    Thank's so much for the response Pat! This works great, a little slow but it gets the job done!
  10. K

    Problem with relationship

    You tables and relationships look spot on in regards to how the info will be displayed. Here is my suggestion: 1.) Create another table (lets call it tblNew) with Surgeon Name & Equipment Needed in the columns. a.) Set a temporary variable for whomever the current surgeon logged in is. Ex...
  11. K

    Run a lookup with unique criteria based off each individual record

    Also, I'm pretty new to this site! Any first-timer pointers you want to give me would be appreciated :)
  12. K

    Run a lookup with unique criteria based off each individual record

    Hi there! I am having an issue with my lookup function. :banghead: I want the lookup to be performed with criteria based off of the same row that record being selected is on. I wrote typed out the Columns and rows that my queries return, and attached a screenshot as well. Here’s an idea of...
Back
Top Bottom