Search not working

[Infinite]

I have a navigation form, and in that navigation form I have 2 tables that have search boxes in them. But when I look at them from the navigation form, the search doesnt work. Any reason it would not be working?

 

[Infinite]

Or not....

 

[Infinite]

Does any one have a idea why this is not working? Do you want me to post my data base for you to look at?

 

[JHB]

Do that + a description of what and where to search.

 

[GinaWhipp]

Infinite...

Ummm, *doesn't work* doesn't tell us anything. You need to provide more information.

 

[Infinite]

I have a navigation form (I believe you guys know how to build that) and If I was to add my forms named frmItems and frmEvents, the search text box I have, that uses the code here, http://www.access-programmers.co.uk/forums/showthread.php?t=188663, If I add those 2 forms to the navigation, the search does not work. I can type, but it doesnt do anything, unlike if I was to just open them up as a form.

 

[GinaWhipp]

That is correct, it will not work because adding any Form to another Form makes it a Subform and the syntax used in your Query is not correct as it is looking for frmItems and frmEvents to be a Main Form not a Subform.

To get around this constraint you would need to switch to VBA and not use any syntax in the Query.

 

[Infinite]

To get around this constraint you would need to switch to VBA and not use any syntax in the Query.

Not quite sure what you mean by that. Sorry, still a beginner at this...Didn't think it would take me a year to just learn the basics of MS access.

 

[GinaWhipp]

Hmm, okay let me explain like this...

Navigation Form
frmEventss

frmEvents is referenced...

Forms!frmEvents!txtYourFieldName

However, once you put frmEvents on your Navigation Form it is now referenced...

Forms![YourNavigationForm]![frmEvents].Form![txtYourFieldName]

This is the down side of putting your Criteria in the Query as opposed to using VBA.

As for *learning the basics*, not sure where you started to know the answer to that question.

 

[Infinite]

As for *learning the basics*, not sure where you started to know the answer to that question.

Not understanding that.

as opposed to using VBA.

And, how would I use VBA for it? That would make things a lot easier.

 

[GinaWhipp]

1. I was not knowing how to answer your statement...

Sorry, still a beginner at this...Didn't think it would take me a year to just learn the basics of MS access.

2. Here's a sample (has a download) for searching using VBA...
http://allenbrowne.com/ser-62.html

 

[Gasman]

PMFJI in here...

Infinite,

I'm sorry I was not able to help you further and can now see you have an expert helping you.

I appreciate you might be getting a little frustrated with what you are trying to do and your 'considered' lack of help in doing it from this forum, but you do not exactly endear yourself to anyone wanting to help, when your initial questions are so obtuse as not to mean anything to anyone.

An example is below for this thread.

I have a navigation form, and in that navigation form I have 2 tables that have search boxes in them. But when I look at them from the navigation form, the search doesnt work. Any reason it would not be working?

I would suggest you take a breath and sit back and read what you write.?
The way I always approach this is....If I read what I have writtern for help, would I understand it when knowing nothing about the posters situation?

Everyone here gives their time of their own free will. They are not obliged to help anyone.

So I would ask that you review your attitude a little, and that way you might get more help. ?

Something like below is not going to get you many responses to help

I have a navigation form (I believe you guys know how to build that)

There is wealth of information here if you are prepared to listen and learn.

FWIW I leaned the basics of Access in well less than a year, but as mentioned I presumably started from position well ahead of you, due to my knowing other languages, even if it was COBOL as one of them.

Food for thought perhaps?

 

[Infinite]

1. I was not knowing how to answer your statement...

statement, not question

Food for thought perhaps?

Yes, I agree with everyone thing you said, and I dont want to come out demanding, pushy, etc, etc. And I would very much so like to continue learning on this site, which, by the way, has had the most amount of helpful people ive seen ever. You, CJ, Gina, and a lot more I cant think of the top of my head.

An example is below for this thread.

Yes, I really should of worded that differently. Not my best moment Like CJ once said, I might as well have said I have a problem, can some one fix it?

Thank you once again!

 

[Gasman]

Infinite,

I'm glad you took my post in the manner it was intended.

 

[Infinite]

2. Here's a sample (has a download) for searching using VBA...
http://allenbrowne.com/ser-62.html

Just looked at that (really looked at it) and im not sure it is what I want...Would it be possible to have....Maybe another query duplicate? I know that would be a waste and I probably shouldn't do that, cause any changes to the main query I would have to change on the 2nd query also....just thinking, because im not sure. Im sure you would probably (and most likely do) have this figured out, but, im thinking a duplicated query might do for now...