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!

  • Congratulations SkipVought 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. jlindquist

    Saving a form using code

    I have one form which you enter data into and you can then create a form using a template and I coded it to put all the text boxes and everything in place and it just needs to be saved. Is there any way to save this form from the code to a certain filename without having to prompt for a...
  2. jlindquist

    Sum of values on a subform

    Email me at Jon-Paul_Lindquist@cdh.org
  3. jlindquist

    Sum of values on a subform

    I have a form with a bunch of preliminary order information. I then have a continuous subform on this form. Part of that data is "Amount". Part of the original form is the "Total". I want the "Total" on the main form to be equal to the sum of all the...
  4. jlindquist

    Getting the date that the database was last modified

    I have an about box where I put the version number, creator, and the date it was last updated. Is there any way to retrieve the date that the database was last modified through code or retrieving the database properties?
  5. jlindquist

    Opening a hyperlink

    I have a main form which acts like the switchboard, and I have a help button on it which I need to launch an HTML help file which I created. I want it to open without the locationbar,statusbar,menubar, and toolbar...basically a blank html page. Is this something you can specify when you open...
  6. jlindquist

    Centering text in MsgBox

    Any easy way to center text when you call MsgBox "Something",vbButtons,"Whatever"...blah blah blah
  7. jlindquist

    Returning error if filter returns no records

    I'm not trying to open a report so that won't work. I'm just filtering by form, then allowing the user to edit the record or open other attached records. I want the user to be able to either research or close the form if no record is found when doing FilterByForm.
  8. jlindquist

    Set value of a control based on where the call came from

    Works like a charm. Thank you!
  9. jlindquist

    Returning error if filter returns no records

    I have a form that immediately goes to the FilterByForm screen when opened. Upon applying the filter, if no records exist for the criteria, I want to pop up a form reporting that no records have been found, and then ask to either research or close the form.
  10. jlindquist

    Set value of a control based on where the call came from

    I have a form that holds a date submitted and a due date value on it. Next to each I have a button to pop up the same little calendar. Upon selection of a date I would like to set the value of the control where the original call came from. Form Project Date Submitted: (BUTTON)--> Pop...
  11. jlindquist

    Getting a 2 digit year

    Thank you for your help...worked like a charm
  12. jlindquist

    Getting a 2 digit year

    I have a text box which holds a project number. There's an autonumber on the field and I need to attach some more info to make it a correct project number. I know the format of attaching text on something & "whatever", etc. but I just want to get the 2 digit year to attach on the...
  13. jlindquist

    Opening a form based on a choice in a combo box

    Thanks for your help everybody. I think I got it to work...
  14. jlindquist

    Opening a form based on a choice in a combo box

    I have a form to search and filter out records, on that form I have a button to open up one of several forms which needs to be decided by the value in the combo box. This is sort of the same idea as the switchboard, but I can't get it to work... Any ideas?

Part and Inventory Search

Back
Top