Search results

Thanks everyone! I finaly got it, if you are interested this is how the open report code looks now: If bProcOK Then DoCmd.OpenReport "CloseOutRep", acPreview, , _ "[Estimator]='" & Me![txtEstimator] & "' AND [SalesYear]='" & _ Me![txtYear] & "'" End If

How do I get the vbOK and vbCancel into this msgbox so that my code will run as the user wants. I think all that I have to do is add vbOK and vbCancel to the message box but I can't figure out where and help was no help other then alerting me to the fact that Access has a vbYesNo that would of...

Cynthia_D, Probably the easiest thing to do would be do put it in the On_Click event that opens up your secondary switch board. The way it is written here you would need to put it behind each button that opens up a sub switchboard. It may be a little redundant but it will give you the...

If you don't want to go through the thread, here is the code: Dim strPasswd strPasswd = InputBox("Enter Password", "Restricted Form") If strPasswd = "YourPassWord" Then ' Open specific form here. Else Exit Sub End If

Check this thread for my quick and dirty way of doing this and some comments from others about this method. binding a password to a cmd button I am not working with a bunch of hackers/crackers so this method works very well. If your users are at the beginner to intermedite level it should work...

Thank you for the help, I think I have it now.

I am almost ready to give up! I can not believe how complicated this is. I wonder if there may be something else wrong the way I have it all set up. Here is the error I am getting

I can not get any of the above to work but can some one help me with this. It should work if I can get the syntax correct. Private Sub cmdReport_Click() Dim bProcOK As Boolean bProcOK = True If IsNull(Me.txtEstimator) Then MsgBox "You must select an estimator", vbExclamation, _...

This is a Visual Basic question but I was hoping that there is somebody here who can help me with it. I can open and write to a .dat file with VB by using this code. How can I bring it back into my text boxes so that I can edit the data? Open "c:\record.dat" For Append As #1 Write #1...

Chris RR, no luck yet but I am still trying. I am going to print your response out on paper and see if I can make some sense of it. No fault of yours, I am just a little slow when it comes to new concepts. Thanks!!!

pdx_man, I am missing something! Here is the code as I have it. By the way, I found out I only need Estimator and Year so I am only dealing with two pieces of criteria instead of three. Private Sub cmdReport_Click() Dim whereStmt As String whereStmt = "" If Not IsNull(Me.txtEstimator) Then...

daninter, Check this thread: Topic: ok....how about emaililing someone based on field contents? =] Is that what you are after?

elektrik, don't worry about it. Helping others is half the reason I keep coming back to AWF. I spent so much time begging help from others in the begining that I enjoy being able to share my knowledge when ever I get the chance to now! Keep them posts and questions coming!

It will put the code in a class module and tie it directly to the controls event. I am a little confused now, are you doing all your code from the module section?

Are you using the code builder behind an event to trigger this code?

Go to Tools\Options\View and check show hidden objects. That should do it for you.

All three combo box's are based on a queries and the choices are limmited to the list. None of the fields are required, if none are selected I want the whole list to show. Is it possible to open the report based on my multiple criteria?

elektrik I am with you there! I started my obsession with computers when the Vic20 was new. It had 3k of memory and could do some amazing things with it. I programmed some simple loop statements back then or typed code from Run Magazine but I never did much more then play games with computers...

Are you using the greater then and equal to in your query? BeginDate [date]>= EndDate [date]<=

I have a report that opens based on a drop down box. Basicaly you select the name in the box and press a button and it will open the report with the related data. DoCmd.OpenReport "CloseOutRep", acViewPreview, , "[Estimator]= '" & Me.txtEstimator & "'" The user wants to narrow the reports down...