Access 2007 Queries

DME43 · 06-04-2009, 02:06 PM

not sure if this is in the correct forum, but ill give it a go.

I am quite a beginner in access btw

what I want is this to happen:

I click on the query. A box comes up saying 'enter first range' then ok. Another box comes up saying 'enter second range' then ok and it shows me values between the first range and second range. I don't want it to be predefined, but for the user to search when they click on the query

Hope that explains all

**jamiemac2005** · 06-04-2009, 02:19 PM

Hey, where you've written "[between] x and x" you need something like:

Code:

> [Enter First Range] AND < [Enter Second Range]

Sorry, haven't used access in a while myself but give that a go, if it doesn't work post back and i'll fire it back up (useless software tbh) and give it a proper in depth go.

Cheers,
Jamey

DME43 · 06-04-2009, 02:20 PM

Quote:

Originally Posted by jamiemac2005

Hey, where you've written "[between] x and x" you need something like:

Code:

> [Enter First Range] AND < [Enter Second Range]

Sorry, haven't used access in a while myself but give that a go, if it doesn't work post back and i'll fire it back up (useless software tbh) and give it a proper in depth go.

Cheers,
Jamey

thats it; thanks very much! :D

**jamiemac2005** · 06-04-2009, 02:22 PM

Haha glad i got it first time.

Cheers,
Jamey

DME43 · 06-05-2009, 04:06 PM

I've encountered another headache; Is there any way we can insert a background picture into a form? I'm using office 2007 and have tried this method, but picture doesnt show up

**jamiemac2005** · 06-05-2009, 04:11 PM

If it doesn't show the image then there's something else going wrong, You could always just add an image to the form, then send it backwards (click the image in the toolbox).

Cheers,
Jamey

DME43 · 06-05-2009, 04:12 PM

Quote:

Originally Posted by jamiemac2005

If it doesn't show the image then there's something else going wrong, You could always just add an image to the form, then send it backwards (click the image in the toolbox).

Cheers,
Jamey

I did that, but I cannot select the text boxes in the front

**jamiemac2005** · 06-05-2009, 04:14 PM

Okay, then go back to working out why the image doesn't show, are you sure the image exists? is the path full? have you tried encasing the path in quotes(")? etc. =] And are you sure you had the form selected when you were in the properties box?

DME43 · 06-05-2009, 04:15 PM

Yes; when I go back to form view the image shows and the text boxes also show, but when I go back to design view I cannot select the text boxes and instead the background is selected

**jamiemac2005** · 06-05-2009, 04:16 PM

Oh, okay, then shift the image until you're done working on the text boxes, i've had the same problem. It's just Access' shocking design. MSjunk. That's all you can really do.

DME43 · 06-05-2009, 04:17 PM

Ok, thanks anyway :]

**jamiemac2005** · 06-05-2009, 04:18 PM

That's ok =]

06-04-2009, 02:06 PM	#1 (permalink)
DME43 Registered User Join Date: Aug 2007 Posts: 117 OS: Windows 7 Beta 64bit	Access 2007 Queries not sure if this is in the correct forum, but ill give it a go. I am quite a beginner in access btw what I want is this to happen: I click on the query. A box comes up saying 'enter first range' then ok. Another box comes up saying 'enter second range' then ok and it shows me values between the first range and second range. I don't want it to be predefined, but for the user to search when they click on the query Hope that explains all

06-04-2009, 02:19 PM	#2 (permalink)
jamiemac2005 Design Team Member Join Date: Jul 2007 Location: Coventry, UK Posts: 1,862 OS: Vista, various linux distros	Re: Access 2007 Queries Hey, where you've written "[between] x and x" you need something like: Code: > [Enter First Range] AND < [Enter Second Range] Sorry, haven't used access in a while myself but give that a go, if it doesn't work post back and i'll fire it back up (useless software tbh) and give it a proper in depth go. Cheers, Jamey __________________ Myspace

06-04-2009, 02:22 PM	#4 (permalink)
jamiemac2005 Design Team Member Join Date: Jul 2007 Location: Coventry, UK Posts: 1,862 OS: Vista, various linux distros	Re: Access 2007 Queries Haha glad i got it first time. Cheers, Jamey __________________ Myspace

06-05-2009, 04:06 PM	#5 (permalink)
DME43 Registered User Join Date: Aug 2007 Posts: 117 OS: Windows 7 Beta 64bit	Re: Access 2007 Queries I've encountered another headache; Is there any way we can insert a background picture into a form? I'm using office 2007 and have tried this method, but picture doesnt show up

06-05-2009, 04:11 PM	#6 (permalink)
jamiemac2005 Design Team Member Join Date: Jul 2007 Location: Coventry, UK Posts: 1,862 OS: Vista, various linux distros	Re: Access 2007 Queries If it doesn't show the image then there's something else going wrong, You could always just add an image to the form, then send it backwards (click the image in the toolbox). Cheers, Jamey __________________ Myspace

06-05-2009, 04:14 PM	#8 (permalink)
jamiemac2005 Design Team Member Join Date: Jul 2007 Location: Coventry, UK Posts: 1,862 OS: Vista, various linux distros	Re: Access 2007 Queries Okay, then go back to working out why the image doesn't show, are you sure the image exists? is the path full? have you tried encasing the path in quotes(")? etc. =] And are you sure you had the form selected when you were in the properties box? __________________ Myspace

06-05-2009, 04:15 PM	#9 (permalink)
DME43 Registered User Join Date: Aug 2007 Posts: 117 OS: Windows 7 Beta 64bit	Re: Access 2007 Queries Yes; when I go back to form view the image shows and the text boxes also show, but when I go back to design view I cannot select the text boxes and instead the background is selected

06-05-2009, 04:16 PM	#10 (permalink)
jamiemac2005 Design Team Member Join Date: Jul 2007 Location: Coventry, UK Posts: 1,862 OS: Vista, various linux distros	Re: Access 2007 Queries Oh, okay, then shift the image until you're done working on the text boxes, i've had the same problem. It's just Access' shocking design. MSjunk. That's all you can really do. __________________ Myspace

06-05-2009, 04:17 PM	#11 (permalink)
DME43 Registered User Join Date: Aug 2007 Posts: 117 OS: Windows 7 Beta 64bit	Re: Access 2007 Queries Ok, thanks anyway :]

06-05-2009, 04:18 PM	#12 (permalink)
jamiemac2005 Design Team Member Join Date: Jul 2007 Location: Coventry, UK Posts: 1,862 OS: Vista, various linux distros	Re: Access 2007 Queries That's ok =] __________________ Myspace