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

  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...
  16. vols77

    Open form to certian record

    Okay, A table has been created to have JobIDs. Table: JobID Field: Job Now the list box is linked to this table and the following code used on the On Click of the list box: DoCmd.OpenForm "Jobs", , , "Job=" & Me.Job Form Name: Jobs Field on Form: Job The problem is that by using the...
  17. vols77

    Open form to certian record

    How do I have the list only show the jobs once? I.E. I have the list box linked back to the main table where all the records reside. The problem is that since there can be multiple entries for one job, the list box lists the job as many times as there are entries. If I have the list box...
  18. vols77

    Open form to certian record

    Just to make sure I explain this I like to use a list - sorry if it seems "elementary" to some... 1) The form to enter / update data [form name = Jobs] is set up as a datasheet to best resemble Excel. 2) Switchboard has a button that says to Update / Add to existing job 3) I need a list box to...
  19. vols77

    Filling in blanks

    I have to say I did but did not find that one. Thank you all again so very much! Guess, I need to work on my searching skills.
  20. vols77

    Filling in blanks

    The formula works great if there is only one line under the main line, however for those who have 3 or more, starting with the 3rd line the part number does not carry across. I.E. from the example in the first post, the line with dept 9 and qty 6 for part A, when using the formula does not have...

Part and Inventory Search

Back
Top