Search results

I figured it out - forms!frmMain!frmSub1!frmsub1A.form!cmbcontactID EB

I have a tab control as my main form and then I have a subform which itself has a subform to pull another level of information. I am having trouble figuring out how to refer to a control on the nested subform. I have this so far: Names of forms/controls: frmMain, frmSub1, frmSub1A (control on...

Use Access Help and look up "Navigate Between Form Pages." You can use either macros or VBA (GoToPage action) to move between pages.

In the form properties, set the Cycle to "current record."

I hope I can explain this problem in such a way that someone can give me advice: I am developing an insurance claims administration app (for an insurance brokerage). I have main form, frmClaimsEntry, which is a tab control. On the first tab, the user selects the client fromm a combo box ...

Here is the code that I used to use a query as the datasource for a mail merge document. DoCmd.OpenQuery "qryProspectMerge", acViewNormal intAnswer = MsgBox("Is this the correct information?", vbYesNo, "Confirm Results of Query") If intAnswer = vbYes Then DoCmd.Close...

The IsLoaded Function is found in the Utility Functions module in the Northwind sample database. You can copy it to your database using "get external data" from your File menu. [This message has been edited by Elana (edited 03-08-2002).]

Are you getting an error message or is nothing happening?

Is the Data Entry property of the form set to Yes or No? If "yes", then it won't show all the records in the recordset.

Thanks Pat! You're my hero!

I have a form that displays location information that the users can edit. Users can open this form from either one of 2 different forms (search forms). I want the current record of the search form to be the record that shows up on the edit form. The Unique Identifier for each location is the...

I have a form (frmAPRP) that can only be opened if another form (frmChanges) is open. My "on Load" event for frmAPRP states: "If IsNull(Me.OpenArgs) Then MsgBox "This form must be opened from within another form", vbCritical, "Cannot Open Form" DoCmd.Close acForm, Me.Name End If"...

That was it! Thanks for the prompt response!

For this purpose, I usually place a command on the "On Activate" event for the form: me.yourcombobox.requery Hope this helps!

I have a procedure where my error handler simply states msgbox err.number & " " & err.description. On running the particular procedure today, I received the msgbox stating only "0". No description of the error. Obviously something is wrong, but I don't know what. Any suggestions?

Thanks so much! I had tried Format previously, but I didn't have the syntax right.

I need to determine a pro-rata factor using the following code: Dim intNodays as Integer Dim Factor As Single intNoDays = DateDiff("d", Me.CovEffDate, Me.ExpDate) Factor = intNoDays / 365 My problem is that I need field Factor to be limited to 3 decimal places. I've tried several things, but...

Thanks, but I've already completed that step. My concern is with the header showing the name of the salesperson...Currently it prints over both columns...I want it to print over just the first column. Any ideas?

I have a 2 column report that lists clients by Salesperson. I want the salesperson's name to only show on the left-hand column, not over both columns. Any suggestions? Thanks

That got me on the right track. With a few revisions, it works great. Thanks for taking the time to help me out!