Search results

I have a form with some controls that are bound to the database, a Save button, and a subform. If the user makes any changes to the controls on the form, I don't want them to be able to save those changes without clicking on the Save button. Since the controls are bound, I have a BeforeUpdate...

I found the best way is to replace the ' (or a ") with a `. You can use this example, where Details is the name of the field: Dim snglchr, replchr, dblchr snglchr = Chr(39) dblchr = Chr(34) replchr = Chr(96) ' *** IMPORTANT ' The following code removes any ' or "...

Finally got it to work: Here's the code for anyone who has to do this in the future: Dim DummyRS As DAO.Recordset Set DummyRS = PubMonthlyProgressRS.Clone txtRecordCurrent.Value = PubMonthlyProgressRS.AbsolutePosition + 1 DummyRS.MoveLast txtRecordTotal.Value =...

I did, but with the same results. This may or may not be due to each time the user clicks a button, I call the Form_Load event. Could this be the problem?

Rich: I replaced my code with yours, and now it says "1 out of 1", regardless of the number of records or placement in the rs. Any ideas? Thanks, Steve Geller

I have a form that displays search results. The user can click First, Next, Previous, and Last to go through the records. This works fine, and the correct data is shown in the correct order. I am having a problem with displaying the count of the current record in a "1 out of 6" format. Here...

Did you give it focus (SetFocus)?

shiner: I'm not sure, but your menu is 6 tabs and you want to know how to refer to the tabs? To answer your other question, you would put the code in the event that would trigger the referral to the subform. For example if you wanted to give a subfom focus after you clicked a button...

Thank you both for your help. The problem was that the original designer (I'm doing maintenance) called the subform something different in the Name field than the Source Object field. When I called it what it was looking for, everything was fine. Thanks again, Steve Geller

Thank you to everyone for all your help. I had the master and child linked, and I was using the Forms![frmMain]![YourKey] syntax. What was causing the problem was that I had the Filter code (and code for populating a drop down box) in both the Load and Open event for the subform. When I...

Mile-O-Phile: No, each subform is on its own tab.

I have a form that has a page control on it. The page control has three tabs, and on each tab is a separate subform. I'm using VBA, and I can refer to the first subform (the one on the left with default focus) with: Forms![Form Name]![Subform name] , but I can't refer to the other two...

Wayne: Thank you. I added the code, but it's still not working right. Could you tell me under what event on the subform I have to put the filter information? Thanks, Steve Geller

I have a form which has a subform and buttons to move through the recordset displayed by the main form (First, Next, etc.). I tie the subform's data to the form's data by setting a public variable equal to an ID from the form, then the subform is filtered off of that public variable. When I...

Thanks, IMO. I wasn't allowed to, but our tech people did pretty much what you suggested.

Thanks, IMO. I'll try it and let you know.

I'm working on a series of reports in an Access db that was created on another machine. It's been copied to my machine, but when I either try to run a report (the VBA code opens it in acPreview) or design mode, I get this message: "You must install a printer before you design, print, or...

I'm working on a series of reports in an Access db that was created on another machine. It's been copied to my machine, but when I either try to run a report (the VBA code opens it in acPreview) or design mode, I get this message: "You must install a printer before you design, print, or...

Thanks, Mario! I did wind up using a similar setup.

This may not be the correct forum for this question. If not, I apologize. I have a database on a drive that is available to multiple users. I want to do this: A user selects options on a form and clicks Submit. This creates an SQL Query (via VBScript) that varies in length depending on the...