Search results

  1. C

    Database design question

    I am trying to create a scheduling program to help out one of my coworkers and I'm having some trouble designing the db. I have figured an employee table to assign a pkEmployeeID to keep track of who is putting in availability. I have broken out tables for the dates(tblYear, tblMonth, tblDay...
  2. C

    I helped someone!

    I had to say it somewhere, because this is the first time I actually offered advice on these forums, and as I am still learning A LOT of this, I felt I needed to express my joy in the fact that I came up with an answer to help someone with an SQL query!! YAY!:D (I didn't create the answer, I...
  3. C

    Code check

    I'm wondering if someone could look at this code and let me know if I'm doing something wrong? Thanks in advance if you take a look! Public Function fnGetAddTransactions(vLastStockTakeID, vLocInvID) ' This function will take in the last stock take ID: varLastStockTakeID ' which was...
  4. C

    Multiple WHERE conditions

    I am trying to write an SQL statement with multiple conditions. Can I write it as: SELECT * FROM table WHERE condition1, condition 2, condition 3 Or should it be: SELECT * FROM table WHERE condition1 AND condition 2 AND condition 3 Or something else completely? Thanks!
  5. C

    Inner Join syntax

    Okay, so I want to join two tables based on a pk and fk...but only where a field in the first table is equal to one of my variables. I know the INNER JOIN comes before the WHERE, but I'm confused as to where to put the ON and the WHERE. Here's what I have: strSQL = "SELECT pkManColorSizesID...
  6. C

    Adding data using VBA and form data

    So I have a form with about 6 fields that will hold numeric values that need to go into a "transaction" table. I have the form built and a combo box for searching for a specific item. Basically, I want to go select an item from the combo box, have the fields populate with the current values...
  7. C

    Is there an "isset" function in VBA?

    I'm trying to use a TempVar to pass along a value from one form to another to hide or unhide a control based on the user's action on the previous form. I want to put some error checking in for this, so I want to start my hide-unhide constraints with an If statement like: If TempVar!myVar isset...
  8. C

    Centering a form

    Okay, so I searched through the threads for this answer and I can't get it to work right. My issue: I've created a form that I want to be 5" wide (or so) and 6" tall (or so). I do not want the form to open maximized, in fact I don't even want the user to be able to change the size. The problem...
  9. C

    Primary Keys and Indexes

    So a quick, upfront "Thank you" for anyone who can offer advice on this! I have a db to handle theatre lighting gel stock that I am working on. I have two tables, one for manufacturers and one for the gel inventory. tblManufacturers ManufID (autoIncrement PK) ManufName (text) tblGelStock...
  10. C

    Troubles with Combo Boxes and Arrow Keys

    Hi. So a brief explanation of the project: A Gel database which holds an inventory of our company's current gel stock by manufacturer, including counts of different size gels and a description of the gel with primary keys being "Color Number" for each manufacturer's table. I have built a...
  11. C

    Hello!

    Hello everyone! I'm a bit of a novice programmer in general, though more novice in VBA than some other languages. I am currently employed at a performing arts center and due to the fact that I have the most computer skills and programming knowledge, I've been tasked with updating some of their...
Top Bottom