Recent content by blaine011

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?

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

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

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?

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?

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

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.

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.

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

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

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.

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

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

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

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