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. jsrothaus

    Reserved Error(-1104)

    oops! left a part out on building the recordset set rs = db.openrecordset("SELECT tblEmployeeInfo.* FROM tblEmployeeInfo WHERE tblEmployeeInfo.EmployeeID = " & Me.EmployeeID, db.opensnapshot)
  2. jsrothaus

    Reserved Error(-1104)

    docmd.openform "YearInfo", acNormal,,,acFormEdit,acHidden Set TestDB2 = Forms!YearInfo.recordset testdb2.findfirst "EmployeeID = " & EmployeeID hmmm. Why are you opening a form? is it to get a record? why don't you go right to the recordset and not open the form? dim db as...
  3. jsrothaus

    Command Button

    They're right. do like this: private sub cmdButton_Click() txtWhatever = theValue end sub option groups are bettern suited for this. private sub optionGroup_Click() SELECT CASE optionGroup.value case is = 1 txtWhatever = firstThing case is = 2 txtWhatever = secondThing case else...
  4. jsrothaus

    Visible Property

    Try this: function statusIs() If status = "Working" Then Forms!frm_PAF!frm_Products_Subform.Form.Add.Visible = False Forms!frm_PAF!frm_Products_Subform.Form.Date.Visible = False End If If status = "Submitted" Then Forms!frm_PAF!frm_Products_Subform.Form!Add.Visible = True...
  5. jsrothaus

    Is This Possible in Access?

    Barcodes are fonts. You can purchase and download them from the web, and use them just like a regular font. You can also purchase libraries and call them as objects, like from Wasp, but the former is easier to me. -Jerry
  6. jsrothaus

    Update Query Criteria using Form

    Here's what I think you are looking for, one at a time. First, if you want to have a dynamic source (pulling from a table or query) but you want to have an "all" choice, try using an option group, 1 button "all", one button "Individual" with a combo box of choices...
  7. jsrothaus

    Faxing from Access

    I figured out the fax thing. the docmd.sendobject is for both email & fax. It requires outlook, or outlook express. It also requires a MAPI program like MS Exchange or Microsoft fax. this is the object: DoCmd.SendObject acSendNoObject, , acFormatTXT, recipient1, recipient2, recipient3, subject...

Part and Inventory Search

Back
Top