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

Search results for query: *

  1. Lhuffst

    question

    ...are 2 subforms on this form: frmPermitInfoUpdate has field depositAmt on lost focus: ConspChrg = txtDepositAmt * 0.1 '10% frmMeterInfoUpdate No issues Only on the depositamt field does the message "can't find frmPermitInfoUpdateParent 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...
  16. Lhuffst

    not understanding something....

    Hi Majp Sorry it took so long to get back I have been making the changes you suggested and it seems to be working in some places but not others. I am in the process of moving old databases to newer versions and wanted to try the navigation options which started me down this path. I am still...
  17. Lhuffst

    not understanding something....

    I have a navigation form that I want to requery the recordset of a subform when returning from a different form. I'm having a difficult time getting the syntax correctly and need something to help. Mainform with navigation buttons: ShopOpNavigation Errors button on Mainform: Opens...
  18. Lhuffst

    problem passing dates

    Finally (after days) of trying different things, I got it to work. changed the following. On Report 1 txtStart Control Source is now =[Forms]![ShopOpNavigation]![NavigationSubform].[Form]![txtfromdate] txtEnd control source is now...
  19. Lhuffst

    problem passing dates

    redid the reports for the umpteenth time :) Form frmReports, you fill in txtfromdate and txttodate. Report1 Added 2 text boxes TxtStart control source =[Forms]![frmReports]![txtfromdate] txtEnd control source =[Forms]![frmReports]![txtToDate] Recordsource is now: SELECT...
  20. Lhuffst

    problem passing dates

    I need help on how to correctly identify dates from a form in queries. I have MainForm: ShopOpNavigation (used the wizard) Subform: frmReports where the user enters txtFromDate and txtToDate That is fine. Reports: Main Report: Report1 which has only titles for the report, no...

Part and Inventory Search

Back
Top