Search results

Hi everyone, I am very new to VBA and I am wanting to increase my knowledge in this area as I see that the potential within VBA is quite vast. I'm looking for something that is self paced either within a book or a website. Any suggestions?

That did it, I can't thank you enough, if you're ever in souther indiana I will have to buy you a drink. Thank you once again.:D

That is exactly what I was looking for, I guess I couldn't accomplish what I was wanting to do with an embedded macro. There is no way I could of done that without your help. I need to start looking into vba, now all I have to do is fiddle with it a little so it can accept wildcard values...

There is only 1 form, that is one that loads automatically, 1 table labeled training database and the reports that I have are brought up by clicking on either of the 2 buttons. They are labeled surface training and underground training. So if you click on surface training it will bring up the...

Here you go, should be everything you need. Let me know what you think. Thanks

The following is the code that I have behind my Button to pull up the records by the last name. Any thoughts? One thing I forgot to mention is that on click I am running an embedded macro. Report Name Surface Training View Report Filter Name <This is blank> Where Condition =[last name?]=[Last...

Sorry about that, what I have is a button on my form that pulls a report after it has been filtered thru a text box. The Button brings up a text box and I input the last name and it spits out everyone who has that last name, lets say their last name is smith. And it shows me a report of...

Hi everyone, Here is my delima, I have a report that I am able to type in a keyword and it will pull up that report exactly as I type the keyword, however, let's say that I want to pull up someone else's report I cannot. I have to exit out of my report and then go back into it and resubmit the...

Found it, Thanks a bunch. I guess I just over looked that. Thank you once again.

Sorry, I don't think I explained myself very well. Lets say that if I have a John Smith that comes back on my report and then I put in John Smith again later on it shows John Smith and it has the other one blank. I would like to "hide" the duplicate. I looked into what you suggested but I...

I have a report that spits out several names of individuals, I have it in ascending order and if there happens to be a duplicate the second, third etc. are all left blank on the report, is there anyway to prevent this from happening. Any help would be appreciated.

I am having a little trouble with my report spitting out exactly what I want, using access 2010. I have a text box that pops up when I select a button and unless I input the text exactly how it is stored in my table it will not give me anything back. I believe it has someting to do with...

Still doesn't work. I've tried several different variations of the phrase. I'm opening a report and what I want to see is the information that I input into my text box. I have a problem in my argument of the where condition is and it is: Where Condition = [Last Name?]=[Last Name] this...

Matching Text box with table Hi all, I'm having this problem, it's probably very simple to fix, but I'm new to Access. I have a box that prompts me for a last name and I want to be able to return all last names that start with what I type. EX. I want to return all names that start with Appl...

Hello everyone, New to this but figured I would give it a try, I'm definately a novice to Access, however trying to increase my knowledge of it. I am from U.S. In the midwest. Southern Indian to be more precise. Any help would be appreciated and my apologies in advance being I know that I...