Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CarolOB

    Print Button Question

    Adding the object library solved my problem - thank you CarolOB
  2. CarolOB

    Print Button Question

    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...
  3. CarolOB

    Print Button Question

    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...
  4. CarolOB

    Search form help

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

    Date Calculation question.

    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...
  6. CarolOB

    Can anyone answer a question about Quicken?

    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
  7. CarolOB

    Can anyone answer a question about Quicken?

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

    Can anyone answer a question about Quicken?

    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...
  9. CarolOB

    Problem with Option Group

    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
  10. CarolOB

    Problem with Option Group

    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...
  11. CarolOB

    Problem with Option Group

    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...
  12. CarolOB

    Calculation on form with subform

    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...
  13. CarolOB

    Calculation on form with subform

    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
  14. CarolOB

    Calculation on form with subform

    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...
  15. CarolOB

    Calculation on form with subform

    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...
  16. CarolOB

    Calculation on form with subform

    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...
  17. CarolOB

    Calculation on form with subform

    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...
  18. CarolOB

    Calculation on form with subform

    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
  19. CarolOB

    Problems with a calculated control on a subform

    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
  20. CarolOB

    Calculation on form with subform

    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...

Part and Inventory Search

Back
Top