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: *

  • Users: blaine011
  • Order by date
  1. blaine011

    Is there anyway to trace an outgoing email

    I'm sending an email out to this one customer and although I don't receive an error message, it doesn't get to the intended recipient. Is there any way for me to track the email to make sure that it's reaching the server, or does anyone know what may be causing this?
  2. blaine011

    Ambiguous Join nightmare

    I thought I tried that before but I guess not, at any rate it is working now. You are a godsend, thanks alot!
  3. blaine011

    Ambiguous Join nightmare

    I have a database that takes a main [order information] table, and two customers. I create a form with an underlying querie that pulls all information from the [Order Information] Table, and two separate customers tables. Both customer tables, cust1 and cust2, are related to a city, province...
  4. blaine011

    Cannot send to specifig domain

    I have had the Reverse lookup table entry on my ISP DNS record updated, still nothing, I also have a PIX firewall, could that be causing the problem?
  5. blaine011

    rule forward to blackberry stops

    I have setup a server side rule on a users email account to forward all messages to his blackberry account. It works for a day or two then stops all of a sudden. I have to recreate the rule to get it going again. Am I doing this the wrong way?
  6. blaine011

    form is duplicating table records

    Thanks for the help it worked out great, although the condescending comments are not necessary.
  7. blaine011

    visual Basic code

    I did that, and I looked for the command INSERT, which would definitely be in the code, as it is inserting into the wrong field, and it comes up with nothing.
  8. blaine011

    Information in a combo box

    Have you set up relationships between the lookup table and the main table that you want to update? That's the first step, however I can't help you after this step, as I am having a problem with it duplicating the record in the lookup table.
  9. blaine011

    form is duplicating table records

    Does anyone know how to fix this? I just want the lookup table to be used for just that, looking up. But I want the unique identifier field in the lookup table (an autonumber), to be used to update the foreign key in the main table. So. Aside from the other fields, the user will use a pull...
  10. blaine011

    visual Basic code

    That won't search the code though. There has to be a way I can see where the code is doing an insert.
  11. blaine011

    visual Basic code

    In that case, how would I do a search in all of the code. Basically, my problem is that in my form, when I press the next record button, it is doing an insert into a lookup table that I did not intend. So I want to find all cases of the insert command in the code to eliminate this problem.
  12. blaine011

    visual Basic code

    how do I view ALL of the visual basic code at once?
  13. blaine011

    form is duplicating table records

    unfortunately that didn't work. even with the relationships deleted, when I ran the form it still tried to duplicate the field, and returned the same error. Also, without the relationship, it won't update the foreign key fields in the main database as they are not liked to the lookup tables...
  14. blaine011

    form is duplicating table records

    MelissaL, how did you setup your combo boxes, because I did the same thing you did, and when I pointed the combo box to access the lookup tables it gave me an error message. The error message said "The changes you requested could not be made because they would create duplicate values in the...
  15. blaine011

    update query question

    I have a database which I wish to normalize. One of the attributes is province. I created a provnum attribute which will store the reference numbers for the province. I created a separate province lookup table, with reference numbers and province name. I want to create a query that will go...
  16. blaine011

    print out tables

    Is there anyway to print out the a diagram of all of the tables and the attribute names? I have a linked table that I need to normalize and it would make it easier if I didn't have to write out the tables by hand.
  17. blaine011

    looking up table values in a form

    I have a table which is linked to 4 smaller tables. The main table is an invoice table, and it contains 4 sections, salesperson, authorizing person, ticket types, and customer, which I've set the name fields to not allow duplicates. I want to create form that allows me to create new...
  18. blaine011

    form is duplicating table records

    but wouldn't it only add things if I typed in something that wasn't in the pull down list? Or am I way off here?
  19. blaine011

    form is duplicating table records

    The nice thing about the combo box is the pull down menu, or can I do that with the list box?
  20. blaine011

    form is duplicating table records

    for example, I create a new ticket, and one of the combo boxes looks up the names of the owners, joe and bob, so for this example I pick Bob, now I want it to simply add the ref key for bob into the invoice number, which it does, but it also creates another record under the owner table so now...

Part and Inventory Search

Back
Top