Search results

  1. T

    AutoPopulate a field & formatting a field question pls!

    Hmmm...it sounds like I'm sort of there. I did create a new table to track and record each customer and its related shortform. But I have to admit, I'm a little lost when you start saying recordset and looping! Is it something I could learn so I could add this in or would it be easier to...
  2. T

    AutoPopulate a field & formatting a field question pls!

    Hello there! I'm updating our db here for the next FY and we've incorporated a new naming system into our contracts. For example: Alysheba Incorporated submits a contract for a project called Kentucky Derby Win Planning. Internally, we will know it as: ALYS001 - Kentucky Derby Win...
  3. T

    Enter Parameter Value??

    Hi there, I re-vamped an old form and now am ready to enter my data, but when I opened up the form today (after working on it yesterday), it is giving me the message Enter Parameter Value, then says Label556 with a field for entry below that. My form doesn't have a Label556. It did, but I...
  4. T

    Stop number field from rounding up

    "Umm, your problem is that you have it set to Long INTEGER (an integer does not accept decimals - it is a WHOLE number)." Do I not need these fields to be set as Long Integer so the contents can be added up in another field? If not, and I can change it without affecting the addition, should...
  5. T

    Stop number field from rounding up

    Hello, Anyone know how to format a particular field in my db so that it does not round up the number that is entered into it? The related data will be entered into the form and it will be to record the number of hours...ie: Project Manager Rate Hours What it's doing now is if...
  6. T

    Help getting a calculated field query info into my form

    Allrighty, I've put in the Nz function just to be on the safe side as yes...way too many idiotic users out there! Speaking of, is there a way to write down a "how to use this db" document of sort? I am not able to sit down and train the person who will be using it for our data entry as she's...
  7. T

    Help getting a calculated field query info into my form

    LOL uh oh, what did I get myself into :rolleyes: That problem has been making me mental for a week that's why I was so happy. I knew it would be easier for someone with experience, but not that easy...I'm slightly embarassed haha! No wedding for anyone until this db is up and running :)
  8. T

    Help getting a calculated field query info into my form

    OMG I love you!! How is it that easy?? LOL! I went back and updated the fields so that they default to zero and they are required...would this be okay or should I still us the Nz? Don't go far...I made need more help lol! Thanks SO much!!! Lynne
  9. T

    Help getting a calculated field query info into my form

    Hello all! I'm new and need help lol! I haven't used Access in about 12 years, but have a new role where the person before me made a db. I've re-vamped it and made it more user friendly, but I'm stuck on this one thing and it's making me mental. I imagine it's pretty simple for those with...
Back
Top Bottom