Search results

  1. N

    Startup Help

    hey guys. i have a switchboard that appears automatically in my database via the startup options from tools in the menu bar. ive seen that if you have something startup, then exit it, another form will appear. how can i do this? my switchboards name is just switchboard and the form i want to...
  2. N

    switchboard trouble

    hey guys, im having a bit of switchboard trouble. i cant seem to make it appear when i want it to appear. i go into database utilities and then into switchboard manager and it says i already have a default switchboard. and when i go in to edit all the commands and stuff, the switchboard doesnt...
  3. N

    having a tad of trouble

    im having a bit of trouble generating a field in one of my queries. i think its fairly simple, all i want to do is have the field in my query to show a date, that is just calculated by subtracting 5 days from the current day. i have something that looks like =Now()-5 but that doesnt work...
  4. N

    H E L P

    hey guys, i need to know if i can do something like this: i want to in my query, create a new calculated field. this field, is calculated by taking the "quantity" field in my table, multiplied by the "status" field in my table. but the problem is, some of the entries in my status field have a...
  5. N

    Weird Date Calculation

    im absolutely terrible at vba and module developing and stuff like that. so im asking if someone could write a code for me that does the following: Takes a date from a field in a table, then if that date is a Monday or a Tuesday, it will subtract 11 days from it. And if that date is a...
  6. N

    Report Format Preset?

    im asking around to see if theres a way i can set default formatting for reports made from the wizard. because when i make reports from scratch, i can change the spacings between entries and what not. i wanna know if i can preset the format for reports generated froma wizard so that i dont have...
  7. N

    Entries Sum

    is there a way to total up the number of rows i have in a table/query and have that number show up on a new seperate row kinda like the way sums are shown in msexcel. using access2003 btw, thanks
  8. N

    Deriving Default Values from Table

    i was wondering if there was a away to set a default value for one of the fields in a form that is taken from a table. for example, i have a form w/ 3 fields: plate#, logoname, and prints. i want it so that when i type in a plate#, the logoname automatically pops out whenever a corresponding...
  9. N

    Help! Business Day Calculation

    hey everybody, im new to access and im wondering if there is a way to perform date calculation based on business days not just regular days. i want to have a field show up on my report titled "Requisition Date" that is calculated by subtracting 7 business days from another field i already have...
Back
Top Bottom