Recent content by DiveKennene

Okay, I have tried to set up the relationship with a ONE -- ID (Primary Key in Customers table (Autonumber Field)) TO MANY ID (Number Field - no "key"). When I leave the main customers form (just using DoCmd.OpenForm) to enter rig information, the ID # from the main form is not populating...

I would like to put "Rigs 4,5,6" in a seperate table on a seperate form, but how do I do that and keep them linked to the person on the main form? Anytime I go from the main form to the second form to add more "Rigs" for the customer, it keeps wanting to start a new record.

Sorry, was having some issues with my webhost...apparently they like getting paid:). The link is working now.

It is a database for parachute riggers. Some riggers have customers, i.e. dropzone owners, that will have 16-20 rigs that they own. So, all of dropzone owner A's rigs, which consists of several different pieces of equipment and serial numbers to go with it, will be unique to that person only...

No, each user has a large set of equipment, each with different serial numbers. So, each user's equipment is specific (and unique) to each user.

I have heard about using tabbed pages on the same form...not finding any info on how to do it exactly in Access 2007. My table consists of the following fields: ID, First Name, Last Name, Address, Zip, Email, Main1, Reserve1, AAD1, Harness1, etc. (where I have Main1, etc., there will actually...

Hello All, I have a table called "Customers". I have a very large form that I can't fit all of the input text boxes on...I actually will need to create about 6 more forms that all link to the same record in my one table. My table has about 100-150 fields in it, problem is there isn't enough...

Got It! Thanks for all your help...I finally got it to work. For being a newbie, I am impressed with what I have accomplished with everyones help. In case anyone is interested, here is my final product, it's called "Riggers Friend Database": http://www.packing-made-simple.com/rigger.html...

Hello, I have a form with one of the text boxes value is set to: =DateAdd("d",[Days],[LastRpk1]) where [Days] is a field in a table that is bound to a text box on the form with a default value of 120. The form is set to automatically open in a new record. Before I begin adding data to...

Again, I'm real new to this...How do I set the value to the underlying table?

Please excuse my ignorance, I am a rookie when it comes to code. What second code and where would I put it?

Okay, new update...I got the Forms!Customers.Check107=True to kinda work. I send out 2 emails and it ticked the checkbox for the first customer but not the second one. Now I am really confused. Here is my code at this point. Private Sub Form_Load() Dim db As DAO.Database Dim rs As...

Okay...I put in the code: Forms!Customers.Check107 = True and I keep getting the error message that it can't find the form. The form is there in my project, I am sure of that. What am I missing?

That's the right direction. Unfortunately the code in my example is on the form "Email Reminder" and the check box is on a form called "Customers". I am not sure what the syntax would be for setting the check box to true as my form loops through the emails to send.

OK. I am actually making progress on my project. I have a database set up to automatically send emails to certain customers when a certain time frame comes up (set up through a query that "gathers" all customer emails that fall within a certain time frame). My code goes through the list and...