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 derfloh 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: *

  • Users: VivP
  • Order by date
  1. VivP

    Trigger MsgBox when user tries to change data in a read-only recordset

    I wouldn't bother, if I were you. Just set the Enabled property to False and the Locked property to True on the boxes displaying the data or on the whole sub-form. Then they will quickly get the idea. Viv Paton Access Developer
  2. VivP

    Email reports in message body using Access

    Quick and dirty: Export as an .rtf into Word and then copy and paste the text into the body of the message. The same method could be coded, but I'm afraid I don't have examples to send you. Viv Paton Access Developer
  3. VivP

    Hi, This should be a simple one, b

    I don't think you can enter anything in a parameter prompt to get all records on a 'yes/no'. You would need to use a pop-up form with something like a tri-state 'tick box' (or a more user-friendly combo box) to vary the criteria in the query and preserve the possibilty of including all records...
  4. VivP

    Setting a Table to Hidden via Code

    Arse. Had actually fixed that, but forgot to paste the right bit. Hey ho. Have fun. Viv Viv Paton Access Developer
  5. VivP

    I have a form that gets user inform

    I would suggest that you paste the SQL (minus the criteria statement) into the form's record source and then set up a line of text boxes in the detail section of the new form. Bind these to the fields you wish to display, and then change the Form's 'Default View' property to 'Continuous Forms'...
  6. VivP

    I have a form that gets user inform

    A data sheet or continous form I would suggest. You can use the 'on double-click' property to do an actions you need when the user decides to do anything. I that what you mean't? Viv Viv Paton Access Developer
  7. VivP

    Setting a Table to Hidden via Code

    Yeah, I think this will do it: Public Sub SetHiddenTableAttribute(tblName As String) Dim tbl As TableDef Const cSYSTEM_OBJ = &H80000000 Const cSYSTEM_OBJ_ALT = 2 Set tbl = CurrentDb.TableDefs(tblName) If ((tbl.Attributes And cSYSTEM_OBJ) <> cSYSTEM_OBJ) And _ ((tbl.Attributes...
  8. VivP

    ticking a box on click of a button

    Just stick this in after the print command: me.CheckBoxName = True That should do it. VP
  9. VivP

    Subform not accessing next record unless I go into design view??!

    Is the Combo box in the subform or in the parent?

Part and Inventory Search

Back
Top