Search results

Thank you both for the responses. ajetrumpet thanks for the link. I was able to finally get it to work. I was using the wrong control the whole time and have finally got it to work great. I just added one line to each of these sections in my main form and thats it, seems to work. Private...

Wondering since there are a lot of people on here from UK did anyone go? I am a big Giants fan, its just too bad that the weather wasnt better. The game was more or less like backyard football, with better weather it would have been more exciting. Plus the grass was more or less soccer grass...

Hello, I have looked at numerous threads here and have some confusion with subform requery. I know thats what I need because when I change the search selections in my combo boxes the subforms do not update, only after hitting design and then preview. Does the requery code go into the subforms...

Oh I see. I am pretty new to this so I really appreciate the help. Thanks alot.

I have attached a database I am working on in which I am trying to get the results to show in the bottom of the form, instead of a new window or popup. In the customer search form I want to have the results show up in the sub form below it named "Child48". If anyone can be of assitance that...

Thanks. I have been trying to solve something on my own but have not been able to. With this above I get this: Compile Error : Method or data member not found. This is what I have: Private Sub Command12_Click() If (IsNull(cboType)) Or (IsNull(txtCriteria)) Then MsgBox "Please select...

Ok so like this for each one replacing the form name: me.frmShortAccountTitle.visible="true" Do I have to do anything for the subform area? This is the code for the search button, but does the subform need anything? Thanks alot you have been great help.

I think that is what I am trying to do. I think I am trying to find a way to do it like this: If search criteria "ShortAccountTitle" is used then show subform "frmShortAccountTitle", etc. for each of the search criteria. However I am not sure how I could make that happen. This way when I try...

Thanks for the response and nice setup btw. See when I use the search function in the "before" picture it opens each form as the code says in a new pop up or tiled window. I would like the form to actually show up below the search form. I am not sure how I would make the sub form box below...

Hello, I have a search function for my database. I put in the search criteria and matching criterian open in a new window. I would like to add a sub form to this and have the results open in the same form...if that makes sense. Here is the search form: Private Sub Command12_Click() If...

This is strange but not sure why this is happening. This link will not open in excel worksheet. However if I save the worksheet as a .htm page it will open. Is there a way to force a hyperlink to open with Adobe Reader? To see what I mean try the following. Put this link in a worksheet and...

Hello, I was wondering if anyone know why this may be happening or a way to prevent from happening. Every so often the shortcut that all my users use for the database will change location. It recently happened when we upgraded to IE 7. Is there a way to fix this so it doesnt happen anymore...

Hello, I am having this error when I use a form on a database I am building. What it is this. I have a search form that search's a table for specific information that I put in the search criteria field on the form. Like name, dates, account number or whatever type of data I query. Now it...

Hello, I was wondering is it possible to have a link that somehow will email a password to a user if that user forgets their password. More a less something that looks like this as seen in many programs. Forgot Password? Searched but didnt find anything but didnt know.

Yeah I don't think Validator will pick up on the mulitiple use of h tags. Google "<h1> tags" or something like that. Like "how to use <h> tags". Also you may want to change the text that is in your h tags. Meaning in your <h1> tags you have, "Menu 1". This will only help you if people...

Well one thing I notice is your multiple use oh <H1> Tags. You are going to get your site either flagged or penalized for mulitpe uses of that tag. I am pretty sure google will pick up on this. Even though for SEO H1 tags are the most important this is bad do to and the SE will see this. You...

Hello, Well I was trying to make this as easy as possible for the person inputting this data and for the credits between the officers be exact everytime. I did try what you suggested but did not work. I didnt understand your response at first but now reading it again thoroughly see what you...

pBaldy thanks for the response. Ok. I have this so far but I know its far from correct but hoping I can get it down. =IF(AND(Officer1 Not IsNull,SUM(SUM(Officer2 Not IsNull,Officer3 Not IsNull,Officer4 Not IsNull,1),SUM(Officer2 IsNull,Officer3 IsNull,Officer4 IsNull))...

Hello, =IF(AND(I6>1,SUM(SUM(I$7>1,I$8>1,I$9>1,1),SUM(I$7=1,I$8=1,I$9=1))=4),F$6/(SUM(I$7>1,I$8>1,I$9>1,1)),"0") I have the following for Excel and was wondering if I could use it for an Access form. What this does is the following. There is a text box for a dollar amount. There are 4...

So Col I can add this to all my fields and each one will be requried, does this work on all fields...combos, text? This is exactly what I need.