Search results

  1. A

    Moving objects on form via code

    thanx Mike, i was doing it in mm, which was why it never worked yes mike, i've hidden some buttons for user with low level access. But he buttons are grouped by category. do they are not arragned in any order. But it works now thanx [This message has been edited by Anauz (edited 03-02-2001).]
  2. A

    Moving objects on form via code

    I'e used the left and top properties....but it seems to put the objects on the top left of the form
  3. A

    Moving objects on form via code

    Hi I have some buttons on a form which i want to move to differnet positions depending on who is logged on. ie some buttons will be hidden....some not. so i want to fill in the gaps of hidden butons. Any help will be appreciated Thanx in advance
  4. A

    Deleting records

    I have a form which loads/saves data to 3 differnet tables via tab forms. I have a button which deletes the selected record from these tables. The problem is that when i click on the delete button, it only deletes the record from the tab that has the focus....where i want to delete fromall the...
  5. A

    Not Saving Certain fields in a form

    I have a form which saves/loads data from 3/4 differnet tables....via tabs. However I do not want to save some fields...is this possible? Thanx in advance
  6. A

    Requerying Listboxes

    try "On Change"
  7. A

    Print current record ONLY

    how do you select which record to print? ie do you select a memberid in a drop down box or something?
  8. A

    auto fit to screen forms

    dalgliesh....i think your mail box is full, email bounced back dagliesh@hotmail.com' on 2/26/01 10:37 AM The content length of the message is too long for the recipient to take delivery The MTS-ID of the original message is: c=NL;a=400NET;p=SHELL;l=LONSC0S0066-
  9. A

    Timed Event

    never mind.....found it
  10. A

    Timed Event

    Does anyone know of a function that will say count to 10 seconds before performing a command
  11. A

    Error Message!!!

    have you uninstalled any components of active X recently....or since you last usd your access db?
  12. A

    Form Saving Problems

    how do you open the form in the first place? Access has differnet methods for you application of the form. The following will open the form in add mode. Dim stDocName As String Dim stLinkCriteria As String stDocName = "Company_Details" DoCmd.OpenForm stDocName, , , acAdd...
  13. A

    auto fit to screen forms

    Theman.....your email address did not work
  14. A

    Current User Based upon a Y/N box

    check you email
  15. A

    Current User Based upon a Y/N box

    On the clicked event of the tickbox enter the code for showing thier userid in another field fieldx.text = currentuser 'then refesh the form Me.Refresh
  16. A

    Prevent main form from closing when field not updated in subform

    have a boolean called required if "Me.requiredfield.text" = "" then required = true End if on the click event of button to close the form put the following code in If required = true then msgBox("required field is empty") Else 'code to close the button End if [This message has...
  17. A

    MsgBox

    Does anyone know if it is possible to have multiple line msgbox's? ie line one line two line three thanx in advance
  18. A

    How to Requery

    I had a similar problem....but access seemed to have sorted the table out itself....but then i never used autonumber. What do you want to refresh? the form? or subform?
  19. A

    Inserting results of coded query into a query

    It's not in a query...the code is in VBA in the click event of a button...there is embedded SQL in it. But i think you have given me the right idea, using insert. Thanx
  20. A

    Only display data for logged in user

    I presume you want to access the windows current user...via the windows logon?
Back
Top Bottom