Coleman984
Registered User.
- Local time
- Today, 10:01
- Joined
- Jul 28, 2011
- Messages
- 89
I have a query that keeps opening wider than that looks nice how do I reduce the width of a query via VBA code?
Open query in windowed mode
- Thread starter Coleman984
- Start date
John Big Booty
AWF VIP
- Local time
- Tomorrow, 03:01
- Joined
- Aug 29, 2005
- Messages
- 8,262
If you use the query as Record Source for a form you can then easily control it's size and position on the screen.
Coleman984
Registered User.
- Local time
- Today, 10:01
- Joined
- Jul 28, 2011
- Messages
- 89
That would be true I suppose. Ultimately I will being using forms instead of the queries themselves. But I'm having trouble getting the forms to behave the way they should. Once I get that sorted out then I will use forms.
Basically what the forms are supposed to do are show employees without jobs assigned (this is what the query does). Then I have tried adding a combo box with the available jobs to add job that is missing for the employee. I got the jobs to show up, and only employees without jobs to show up. The part I couldn't get was having the data be added to the table in question. So I deleted the form in frustration now I'm even worse off than before. anywho.
Basically what the forms are supposed to do are show employees without jobs assigned (this is what the query does). Then I have tried adding a combo box with the available jobs to add job that is missing for the employee. I got the jobs to show up, and only employees without jobs to show up. The part I couldn't get was having the data be added to the table in question. So I deleted the form in frustration now I'm even worse off than before. anywho.
