Search results

Hi, kinda really new to access and not familiar with VBA. I've managed to duplicate a query, and use the unique "customer control number (p-key)" to print off the page that I want. Problem now is that after I'm done entering all the data to be entered into the database, and the control number...

Sorry if I made my first post unclear. I am printing a report. However I'm trying to print a report based on the data entered on a form. So when I hit print "demand" it will save the data onto the table and print the report using the data table as the record source. Kinda have to look at it I...

Hey all. I currently have a database that we have to enter any stock ordered and received. Problem is, is when we have to enter the data into the database, we also have to hand write out a form for acquisition of that item. Is it possible to enter your data into a form, and once all you info...

You did it again. I guess I'm use to work and having to "enable" macros. Mr B your my access hero for the last few days. can't give rep untill i give someone else rep, noted though and will be granted in the future.

Ah forgot about the rep. Not use to VB, I'm phpBB guy. Thanks for the help, +rep

Hi all, I've been fiddling around with this database all night trying to get it work. I'm using Access 2007, and I believe the problem happened when I converted to 2003, as work only has a license to use 2003. Or when I tried to create another button on the "Supply Query Switchboard" form(> 14...

Thanks B. Just so anyone ever has this easy oversight. Pop Up - Yes Modal - No All I have to worry about now is that my print function works as I hope. No printer at home :( Wise me luck. I'll probally be back with some minor question. Once again thanks Mr. B

Hello all, tried searching in the help file but no luck. Same with the sites search function. Novice question here, that I'm obviously missing. When I open up a form, the form opens up behind the current form, thus making me minimize the other screens to get to the form I want. Where is the...

Yes Marco, with OpenReport with the view set to "Print" Does this link work? http://www.mediafire.com/?ljmmgvd4zgw

I'm not trying to call up a form with certain criteria. Just trying to print the current requisition that I/we enter into the database. So we don't have to create another form by hand. I guess you gotta have to look at the DB to see.

Basically. When I try to create a "New Demand" and hit "Print, save and close" It tries to print off every demand available (60+ pages). And I only want to print off one. I've tried everything I could think of, but no luck. Hence why I'm here. Link to program...

is there a way to get away from the conventional looking command buttonsand creat my own, or does that go in depth if vba code

That sums it up. I fiddled around with it and got it working. Well okay for now. Still working on making it flow right. Thanks Kathy.

Sorry being unclear, I abandoned my first idea and went with a more "simple" method. So here is my new method, but I would like to combine the 2 screens (3&4)/Parameter Values into one. Step one, select "search vidmars" Info box Appears Then you enter a NSN, or if you only have a PN...

Okay so I got it to query the vidmar table. So I have the following. My main page "splash screen" I have a command button. When clicked, calls up a Macro, to open the "Vidmar Search" form. The vidmar form's record source, is a query. Now for the query I have included all of the values in the...

Only one Nato Stock Number and one Part Number can be in a location. I right clicked on the submit button (design mode) and clicked build event, and pasted your code, but nothing happened. Am I missing a step? Also, how does the location get displayed in the "location" text box once it...

Hello all. Been scratching my head for awhile now at this. I got most of what I need to do completed, just this search function is giving me a headache. I'm relatively new to M$ Access, and I have the majority of my project done thus far I believe. Can you guys please help me our with the...

The "parts rxd.gif" is the form that gets generated when you click on any buttons from the "search demands.gif" I'm assuming that each button will perfom a search from the overall data "supply data" table and spit out a report based on the criteria "130-333" Which is the aircraft.

Hello fellow access users. I'm new to the access world but have already realized its potential, and so I took a course to learn the basics of access, and I've been tasked to try and create/modify a database for work. In which the user that created it did not make it edit friendly. And guess who...