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!

Recent content by vols77

  1. vols77

    database not working

    Macro security level.... good thought.... I really do not know what the security level is on his PC..... If I remember correctly, he needs to go to:Tools / Macro / security. Am I correct in saying that he needs to make his the same that I have mine? - especially since I am able to run the db...
  2. vols77

    database not working

    Yes. they have access. The same version as I have on my PC. - I probabaly should have mentioned that before.... sorry.
  3. vols77

    database not working

    I have sent a database via e-mail and the end user is able to open the database but nothing works. It is as if the vba coding has become disabled. I do know that his computer does not have a printer and I have heard that if there is not a default printer that access may not work correctly. Is...
  4. vols77

    Recordcount

    What is wrong with the below? If RecordCount < 2 Then Me.Command44.Enabled = False Else DoCmd.GoToRecord , , acPrevious End If Basically I am wanting to disable the button if there are fewer than 1 record (to avoid the "debug" error if there are no records and someone clicks the button) I...
  5. vols77

    Open report with criteria

    Forgive me if this is the wrong forum but this does deal with reports so I thought I would give it a shot here. The below code opens the report fine, however, how would I incorporate text22 and text24, which are two fields that the user can use to enter a date range. Also, if possible, how...
  6. vols77

    Yes / No Msgbox

    Thank you to all! The code is working and in multiple areas! Not easy getting back in the grove when I have not written any code in over 2 years.
  7. vols77

    Yes / No Msgbox

    Thank you! Think I am almost there but have one slight problem... If Len(Me.BOL & vbNullString) = 0 Then Select Case MsgBox("Do you want to exit? If so, your record will not be saved.", vbExclamation + vbYesNo, "No BOL # - Record can not be saved") Case vbYes Cancel =...
  8. vols77

    Yes / No Msgbox

    I really could use some help. I need a yes/no msgbox to appear if the field "BOL" is either blank or they have entered then erased the value. Yes/no because if they go to the next record or exit the form, the record will not be savedf. It has been an extremely long time and I will admit my...
  9. vols77

    Saving records

    I am lost in the translation from the posted code to what I would need to change to work....
  10. vols77

    Saving records

    On the form, there is a button "add record" that when clicked, the new record automatically fills in the field "Job", what I am tring to do is to prevent the user from saving the record unless the field "BOL" is filled in. I have tried several things but can not seem to figure it out...
  11. vols77

    Open form to certian record

    A problem has arised..... one of the issues is that I would like the list to expand as jobs are added. That is why there is a make table query named "mkjoblist" that creates the table JobID. What I would like to do is that once the user clicks the button "button1" on the switchboard, the...
  12. vols77

    Open form to certian record

    Thank you! Took some time but figured out it was acformds for "datasheet".
  13. vols77

    Open form to certian record

    Going great but it will not open in the datasheet view.... tried changing code but no luck.... Really need it to open in datasheet to prevent "complaints". Thank you again to all for the help!
  14. vols77

    Open form to certian record

    Almost there.... not the only thing is that a pop up comes up that says "enter Parameter Value" and has the job I want listed. If I type in the job again, the form opens but that really defeats the purpose.... Any ideas?
  15. vols77

    Open form to certian record

    On the form "Switchboard", there is a field "List15" that is a list box linked back to Table "JobID" field "Job". What I need is that once the user selects the job from the list box (essentially the onclick of the listbox), the form "Jobs" will open with only the selected job from the list box...
See more

Part and Inventory Search

Back
Top