Search results

not working, its prob me. i labeled the button in the other tab as focus_page1 and just doesn't change a thing. any ideas? Private Sub Page1_Click() Forms!subfrm_pickups!focus_page1.SetFocus Me.SetFocus End Sub

ok, i will try to clarify what i was saying this is when it hides itself then this is when it is normal before i switch tabs

yup, it scrolls down to show the header of the form within the tab and hides the tabs. i then have to scroll up a slight amount to see the tabs.

I have 2 tabs with forms dragged and dropped in each. Every time I switch tabs, access scrolls down to the form header and hides the tabs. I can scroll up to see them but it's kind of annoying as i switch between them a lot. Any fix for this?

thanks SOS!

bummer. im still pretty new. would there be another easy way to display two queries/form from those queries on one page or tabbed possibly. i got two queries that have a strong relationship that it'd be nice to see them in the same window...

alright i got two queries i unioned through sql. they query separate tables that are similar enough. my results are shown together but I can't edit the table data from the query even if i convert to form and add text boxes etc. Is this just a byproduct of union queries?

yeah the macro builder had been sufficient for me till now so makes sense. well now i know how to add vba to forms so cheers!

Thanks guys. It's all becoming more clear. Yeah that has module property was defaulting to "No" somehow. Making it "Yes" makes it show up in my VBA explorer. Thanks SOS and dk, very helpful!

all you guys say makes good sense now, except the only form i see is my AMST_Home form when I have way more forms, reports, queries than just that one form. How do I see all objects in my database to attach macros to them?

how do i navigate to the Form_Activate() event within the VBA editor. here's a pic of what I'm seeing. I keep adding a module which I'm not sure if that's what I'm supposed to do???????

i have a form that has a link to add a record. Upon returning from adding the record, the combo boxes that should now have that new record in their list don't. I've been doing some googling where they say I need to call a requery of the form possibly on the trigger of the form getting access...

Is there an option in the page setup when printing a form or report to scale the page by a percentage. I found that handy to just bump that percentage down to 80-90% to fit everything i wanted to see on one page but I don't see this option anywhere in access:eek:.

Thanks guys! I got it figured out with your help. I added the table twice deleted and created a new join. Both joins had to be type 3 (not exactly sure why) or else it would not pull up the records if the delivery or pickup driver fields were blank for the order. Thanks again, I now can move...

Ok, here's my query. What would I use for the alias name in the query to pull say the delivery driver name into the query or the pickup driver name. I'm sorry, I'm still not getting it. This is my major hangup keeping me from moving forward.

ok, but we usually have different pickup and delivery drivers. and i don't want to have two tables with the same driver info for "pickup driver" and "delivery driver" lookup fields in the "order" table. but when i want to run a query, can i drag the details from the "driver" table into the...

Ok, I'm new to Access. I am designing a access database for a trucking company to track all orders from ordering to delivering. I have created a "Customers" table which I want to pull from in the "Orders" table as "Who to Bill," "Delivery Location," and "Pickup Location". I created...