Help!! Search Form (1 Viewer)

[vbaInet]

I'm not sure if that can be circumvented. I don't really use subforms so I hardly ever play around with them. I think it's a default setting, it has to fill up the rest of space to fit your screen. Post your db let me have a look.

 

[lee_gti]

thanks again

 

[vbaInet]

I've just had a quick look and tried to adjust it. That handles the overspill from your controls. It's either you increase the width of your subform or write some code to adjust the widths of all controls before loading. However, even with that once your increase the width of any field, it will show if it overspills. Have a quick search on google for setting the widths of datasheet columns using vba.

 

[rob.low]

Hi there,

I have read this thread and have made the form and it works great.

but im stuck on how to send the results on the sub form to a report?

lets say the sub form displays 2 results from my search, i want to send the results to a report.

any help or push in the right direction will be appreshiated

Rob

 

[vbaInet]

Hello rob. I'm glad you found the information you got here quite useful.

There are ways of doing it what you ask. Have a look at the following to see what you can come up with. Although, the first link relates to forms it is the same principle:
http://baldyweb.com/wherecondition.htm
http://baldyweb.com/OpenArgs.htm

Another way is to follow my suggestion in this thread:
http://www.access-programmers.co.uk/forums/showthread.php?t=189442&highlight=open+report+form

If you still have further questions regarding this, since what you're asking isn't related, create a new thread and someone will be able to guide you.

 

[rob.low]

Hi thanks for your help with opening the reports i have sorted that bit now with your help

I have another question now

I have a field in my table "clients" with a date in it called "installdate"

how could i search for a start and end date in that field?

I have placed 2 textboxes on the form one named "startdate" and the other "enddate" but that is how far i have got

I cant work out the vba code to carry out the date search
any help or direction with this would be verry appreshiated

thanks again
Rob

 

[vbaInet]

Glad you got that sorted.

We're going off tangent on this thread and like I mentioned in my last post, if you had any further questions, create a new thread so this thread stays focussed on the OP.

I may even see your new post