Search results for query: *

Adding the object library solved my problem - thank you CarolOB

I copied and pasted the code from the e-mail portion of the reply into my code, and I changed the field names to match mine. When I click on the button to e-mail the report, I get a message: "User-defined type not defined" and it points to the lines that say: Dim objOutlook As...

I've created a form and a report to generate invoices. I added a command button to the form which is to be used to print the invoice, however, when I click on it, I only want the invoice for the currently displayed customer to print not all the invoices in the table. Could someone please tell...

Tezdread, Would you please e-mail me a copy of your sample database too? carolob@attbi.com Thanks CarolOB

wwbryan, I recently had a similar problem with calculating a person's age correctly and found that the following code worked just fine when used as the control source: =Int(DateDiff("d",[DOB],Date()/365.25) By using the Int function, the calculation drops the fractions and dividing...

Thank you for your reply. I had already asked him whether he did a copy or a backup and he said he had done a backup and restore. I should be hearing back from him late this afternoon and hopefully the answer will be what slammer14 suggested. Thanks again. CarolOB

Thank you. I'll pass that information along to him. CarolOB

I have never used Quicken, but a friend of mine has asked me for help with a problem. He made a backup copy of his data and tried to load it on a new computer that he bought. He gets a message saying that the data installed successfully, but he says his data isn't there......has anyone...

I finally got it to work! I had to change my code to the following: =DLookUp("[FirstPymnt]","[InitFees]","[MemberType]=" & [TypeNumber].[Value] & " And [TERM]=" & [TERM].[Value] & "") Thanks for your help. CarolOB

Hi Starsky51, Thank you for your response to my question. I have tried what you suggested, but the result I get is #Error. The following is the code I used as the control source for the text box where I want to display the appropriate first payment...

I have a form named Initiation which contains two Option Groups. One Option Group is named Member Type and has 4 option buttons: H/W Junior Single and Student and their option values are 1 2 3 and 4 respectively. The other Option Group is named TERM and contains 3 option buttons: oneyear...

Thanks for the follow-up message. I pretty much had proceeded with the way you said EXCEPT, I had changed the Yes/No data type to return True or False instead of -1 and 0, thus, I didn't need to use the ABS portion. Thank you CosmoKramer and LittleSmudge. I really appreciate the assistance...

Good Morning, CosmoKramer, I kept "fiddling" with my select statement and finally got the syntax down right. I guess I was having a "BRAIN CRAMP" or something. It's working AWESOME now! Thanks a million!!!!!!! CarolOB

Hi CosmoKramer, I apologize, I thought I had replied to you. I've tried to modify your code to match what I need, but keep running into syntax errors and/or compile errors. The following is the latest copy of the code I've tried: Private Sub Form_Current() Dim rst As ADODB.Recordset Set...

Good Morning, Thanks for getting back to me. I put the break point in like you suggested, but it did not produce a yellow box with a tool tip in it when I hovered the mouse over the memberID term. Instead, the whole line was highlighted in yellow and there weren't any tool tips. I'm...

Sorry I took so long to respond, but it was a hectic day at work today. I've made some progress. I seem to have the ADODB code working ok now, but I'm having trouble with the rst.Open statement. I've tried it several ways and have gotten everything from syntax errors to a message saying that...

Good Morning, I'm still not having any luck with this. I get a compile error: user defined type not defined on the line where it says Dim rst As ADODB.Recordset. After researching the help again, I changed ADODB to DAO and that seemed to remedy that problem. I then changed the next line...

Sorry I didn't respond sooner, but I've been trying both of your suggestions and I haven't had any luck yet. Thank you for your suggestions - I'll keep fumbling around and see if I can get it to work. CarolOB

Sorry I didn't respond sooner, but I've been trying both suggestions and I'm not getting anywhere at all. Thanks for your suggestions - I'll keep fumbling through it and see if I can get it. CarolOB

I have a main form named new_mem (based on a table named members) and a subform named family1sub (based on a table named family1). There is a field called ID in the family1 table that joins with a field called MemberID in the members table. One of the fields on the subform is called locker and...