Search results

Ok here is the list that I have. SearchVB VB Help VB Explorer VB Explorer seems to be the most active of the three I listed.

Jman I am faced with the same thing but for different reasons. Here is a tutorial I found that will walk you through using an Access database with Visual Basic. Hope it helps! Visual Basic Database Tutorial - Part 1 Without knowing much about it yet, it seems like you get the best of both...

arage, did you get this figured out?

Very Cool!! I had no idea there was a command to run a spell checker inside Access. Thanks for the tip.

You could use a DCount to check for the value in the index which would then allow you to control the event without Access getting involved. I am not sure what you are doing but here is a quick example of what I am talking about. Dim strMsg As String, strTitle As String Dim intStyle As Integer...

You didn't ask but here is the thread that I started when I was trying to get this all figured out. The very last post will show you how to do it with one command. By the way I only posted the open report code so if you want to see the whole thing I will get it for you. <A...

ryker, I am not sure if this will work in your situation but you can open reports with criteria without using a parenter query. For instance, on one of my forms I have two combo boxes. One shows all the estimators and the other show available sales years. The user can select from each box, hit...

You need to tell Access what do to with the cancel like this: If Answer = vbCancel Then Exit Sub Cancel = True Here is the whole Sub if you want to see how I did it in my app. I have been told that the way I do this is not efficient but it works well for me and I have never had any errors with...

Here is how to open a report with criteria using a combobox and a command button. Open report based on multiple criteria I also modified the code to check to see if there is relevent data in a report before opening it up. So for instance if a estimator did not have any time posted in the...

No problem, did it work out for you? I notice that you are going to use it with a command button. I did something similar where it would bring up a input box for a password. If the password was entered correctly the database window would show up.

Try it like this: (Control source of the Grand total) =Sum([Monthly Revenue]) I am not sure if the space in the controls names are going to give you trouble or not but try it and let us know!

Here is the article mentioned above. I did not read through it but I found a way to do this by calculating in the group footer and setting the the visible property to no. Then I can go to the page footer and call the total of the invisible control that has my sum in it. Hope this helps!

Mark, Isn't your question answered here? Refer to database window in VB

Anyone?

It is set that way and it does do it on the form load and open but I want it to do it every time the control gets focus.

I am trying to get the text in a control to be selected when the user enters the box so that the user can enter a new number without deleting the text allready in the box. Here is the code: Private Sub txtEmployeeNumber_GotFocus() txtEmployeeNumber.SelStart = 0 txtEmployeeNumber.SelLength...

mark, I stole this from a post that R. Hicks made on another board but I think this will answer your first question anyway. I used this with an input box and a If Then Statement. If the right Password was entered in the input box the database window and other options would switch from hidden...

Here is the post RunnApp Macro Madness!!!

Just insert a line in your macro and choose set warnings to No/False before the command is run and then set them back to Yes/True after the command is run.

Thanks, it worked great!