Search results for query: *

Hello: I would like to open different forms, based on dates in an unbound combo box on a different form. So, open a form to specify dates and then click to open a form with that date range of records. It is called from the form that is to open. I currently used something I came across online...

Thanks for the reassurance that that was not possible. I finally found a "me.visible=false" value on opening the new form. Sophia

I think it was because the data was not saved on the main form. If anyone knows otherwise, please let me know. Thanks, Sophia

Hi Everyone: I am stumped by this issue. I have a form with a button to click . When that button is clicked, another information pop up form opens. But the original form closes and I don't understand why it is closing. I have the same type of form in other areas of the database that does...

Thanks for the advise. :) Sophia

I want to open a form with a button, to save space on the main form. There are too many subforms showing in the Page Tabs across the screen, with the subforms on the page tabs. I am just trying to make it visually better to look at. Sophia

Thanks again Duane. It is working now. Is there an easier way to have a button open a linked subform? It is so easy to have subform linked to a main form the traditional way by having both forms on screen. Sophia

Thank you Duane. That was the issue for the error. But now when the subform opens and I fill in the data, the [Pound_Sheet_No] does not transfer to the subform automatically. I thought that that code would do it? Sophia

Hello Everyone: I have a main form with many subforms placed on tabbed pages, all linked to the main form. I would like to change some the subforms to be opened by a button instead. But the problem is that some of the subforms have not yet been populated, so I will need to pass the main...

Hi Everyone: I need advice on a form and a field with a drop down list. I have a form where the user chooses a item from a drop down list. The list is based on a query which has two fields. One field is a "medication" and the second field is a check box named "disable". So, any item that...

Ok, I understand now. Or I could just name it "Customer copy", etc, right? Sophia

Thank you very much Duane! I had the table, but for some reason could not get the desired result . I changed =[Copy] & " copy" to just the [copy], since it would not work otherwise. I appreciate your help! Sophia

Hello Everyone: I have been searching, but cannot find an answer for this. How can I print one report, many times but with a different footer . Each footer would have a different word, such as "customer copy", "office copy", "admin copy", etc? Thank you, Sophia

Hi Andy: That's a good idea, since there is a PK in the table. But how would I go about using it? Sophia

Hi Duane: Thanks for the reply. •Are all of the records new? Yes •Are these done in a batch or one at a time? One at a time. Is there any field or fields that determine the order/sequence of the records? No. We just want to alternate the employee who looks after the record. The employees...

Hello Everyone: I have a form to enter data into a table. I want alternate new records to populate the form with an alternate name...either A or B. I assume the A and B will have to be in a new table. Example: New Record Populate A into field Next Record Populate B into field Next Record...

Hello PWise: That worked great!! Thank you very much for your help! I just don't understand how it could be open in the background. I checked everywhere part of that code and form over and over, but I guess it doesn't matter now. Sophia

Hello: I have a 2003 Access database that I updated to 2013. It contains a form that has a button that opens another form. But for some reason, it will only run once, until I close and reopen the database. The first form is based on a query. Then the button opens another form. Can anyone...

Hi Andy: I understand now. I just meant that the user would choose one or more of the email addresses on file to send the email to. I will try what you suggested, tonight, and let you know. Thank you for you help. Sophia

Hello Andy: Thank you for your reply. What do you mean by your statement: Loop thru "email addresses on file" and for every address send an e-mail. How would I accomplish that and why would I do that for every address on file? Sophia