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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Lhuffst

  1. Lhuffst

    question

    I have a system (fe and be) on a shared drive. It works fine for 2 out of 3 people. the third person, when they try to make a change (bound form), will get a message that the form can't be found. If it was everyone, I would say it is how it was named in code but it's only one person. I...
  2. Lhuffst

    Keep getting errors saving a null (blank) date

    Andy and Duane, Adding the quotes to Andy's suggestion did the trick. Thanks
  3. Lhuffst

    Keep getting errors saving a null (blank) date

    Hi Andy, at the table level I have Format: Short Date Input Mask: 99/99/00;0;_ Required: No I had removed the input mask and tried it but still wasn't able to save. How do you mark a datetime as being able to accept a null? When I make your change, it still gives me an syntax error. The...
  4. Lhuffst

    Keep getting errors saving a null (blank) date

    I am using access 2010I have a sql statement to insert information into a table. If I have dates in date fields, it works fine. If I don't fill one it, I get errors. I've read the posts and tried what was suggested but still no success. Can someone see what I'm doing wrong? My default...
  5. Lhuffst

    add user manual to menu bar

    Duane, I created a user manual that I would like to have on a tab on the menu bar. Right now the menu bar has File, Home, create, external data ... I'd like to add "User Manual" and when they click that tab, have the ability to open the word document. I looked at the Quick Access Toolbar...
  6. Lhuffst

    add user manual to menu bar

    How can you add a key User Manual (word document ) to an access 2016 database Thanks lhuffst
  7. Lhuffst

    combobox for multiple fields

    sorry it's been so long responding - I'm yanked from project to project it seems. I was hoping to use as much original code as possible from the original coder. Based on your forms I'm restructuring this one to be normalized. Thanks for the help
  8. Lhuffst

    combobox for multiple fields

    DHookom My apologies. I thought that for so few lines it wouldn't be hard to read. I'll correct that in the future. Yes I have done combo boxes and can use the wizard but this is slightly different so I wasn't sure. TblFees Fields: fld2wk3inSvcChrg fld6mo3inSvcChrg fld2wk75inSvcChrg...
  9. Lhuffst

    combobox for multiple fields

    If I have a table that has these fields: SrvChrgSize SrvChrgAmt fld3-2wk 30.00 fld3-6mo 120.00 fld75-2wk 60.00 fld75-6mo 140.00 How would I do the combo box that lets them select the field and corresponding charge? Currently I have 4 columns horizontal but that's...
  10. Lhuffst

    how do I

    my mistake. Thank you guys
  11. Lhuffst

    access 2010 vs 2016

    Hi. Our company is deploying office 2016 to take advantage of office 365. My question/concern is that I have not finished changing all the access databases to the newer versions. Will databases that are version 2003 but running under 2010 still work when 2016 is deployed. Since this is a...
  12. Lhuffst

    how do I

    I moved the formula to the form on current I changed the text box decimal places: 0 format : 0000 This looks now Thanks
  13. Lhuffst

    how do I

    dHookom. That's what I tried originally Total Gals: 132580 puts thousands as 132.58 I only want the 132
  14. Lhuffst

    how do I

    I have an odd request from the customer. One of the fields is total gallons which can be hundreds, thousands or more This is not a problem. Now they want to add another field that shows only the thousands of gallons based on the first field. How do I do that? for example Total Gal: 181700...
  15. Lhuffst

    not understanding something....

    MajP Thank you very much for all the help. Still struggling somewhat but your explanation was great! Definitely helped me...
See more

Part and Inventory Search

Back
Top