Search results for query: *

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

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

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

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

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

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.

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

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

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

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

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

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

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!

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?

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

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

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

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

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.

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