Search results

I want to have a seperate search form using unbound text boxes. I'm currently using Combo boxes as my search and the following code. docmd.openform "Members",,,"[MemberID]= "&Me![combo2].column(0). I would perfer to use txtboxes so that if a user enters something like MICRO the database...

Yes I'm saving the total amount paid on the main member table. I do not have a amount due table. I wanted the total amount paid to be easily seen on the main form without using a pop-up cmd button or a subform.

I have a main form with a synchronized pop up form named Payments. On the main form I have a unbound text box that shows amount due. When I enter new payment info in the payment pop-up form for the first record for 100 dollars and the dues payment = 100 dollars the main form will show amount due...

Fornation, Thanks a bunch Works like a charm.

Hey fornation, Here is my exact code: Dim objWord As Word.Document Set objWord = GetObject("G:\MSAPPS\Share\Dueshor2.doc", "Word.Document") ' Make Word visible. objWord.Application.Visible = True ' Set the mail merge data source as the Northwind database...

I tried it and still doesn't work. Either I get a runtime error or the document asks to be saved and I have to manually close word. Dim objWord As Word.Document Set objWord = GetObject("G:\MSAPPS\Share\Dueshor2.doc", "Word.Document") ' Make Word visible...

Thanks guys I will give both of the suggestions a shot sometime today. Thanks for your help.

I have a mail merge button with the following code. Dim objWord As Word.Document Set objWord = GetObject("G:\MSAPPS\Share\Dueshor2.doc", "Word.Document") ' Make Word visible. objWord.Application.Visible = True ' Set the mail merge data source as the Northwind...

I have a main form with a synchronized pop up form named Payments. On the main form I have a unbound text box that shows amount due. When I enter new payment info for the first record payment for 100 dollars and the dues payment is 100 dollars the main form will show amount due 0 (good). For...

create a new moduel and put in the following code. Rename the code or your buttons to fit the function. Public Function DisableEnable(frm As Form) 'To call the function set the form's OnCurrent 'property to =DisableEndable(Form) Dim rstClone As Recordset 'Create a clone of the form's...

Lawson can you email me a copy too, it sounds like something I would like to try for my database. aguzman@nespapool.org

How can you have your table clear some fields exacly one year from now.

Thanks David R. I will look into your first suggestion. Thanks again.

I have a main form with a payments form attached by member number and a order form also joined by member number. The payments form has amount of product, deposit, payment1 payment2 and amount due. All these feilds are in the payments table. On the payment form in the control "amount due" I...

Thanks to both replies.

Bascially what I want to do is this. On a Membership form I have a drop down list that puts companies in their membership catagory. If you select the catagory of Former Member the form changes color to lets say red but all the other member records stay the same. Any Help???

I hope I'm not too late, I would love to have a sample of that code. This is currently an issue that I'v been trying to deal with for the past two months. My email is aguzman@nespapool.org.

I have a Main form with a couple of pop-up forms on it, one being a payments form. On the main form I have a field total amount paid that reads off the payments form field amount paid. This works great for one payment but if I add another payment for that person the main form is still reading...

Pat Hartman you are right. My tables resemble your second example. I had to make one table within the qry a one-to-one relationship. The tables make up is exhibitorID, address, city, st,zip, the other table is PaymentID (autonumber, Keyfield) exhibitorID, payments and the last table is...

I have a databse with one main table and other link tables all one- to- many relationships. I made a qry using three tables the main and two of the many side tables. I would like to make some data entry to the qry that will update the main table. When I enter in a new date into the qry it...