Recent content by JohnGio56

I'm sorry about that I can barely keep my eyes open. :) I did implement your ideas into the final copy but I don't have time to do it in the dummy. It does make sense to establish those protocols bc I'm sure it makes queries easier down the road so thanks for your help! This is my first database...

Got it!! :)

It keeps telling me upload failed

k i removed the data but for some reason it wont post? Is it bc its pass protected?

Can I message it to you for confidentiality reasons?

OKay so I got it to auto fill but now I get an error message that states The field 'Client_Survey.Client_rec_Num ' cannot contain a Nulll value because the required property for this field is set to True. Enter a value in this field. Any ideas? I mean the number shows up in the field bu...

Okay so i get this error message "Main Menu can't find the macro' End Sub.' " But after I click okay it does update the field!!!! AHHHHH sooooo close!!!! Any ideas?

Okay I'm getting an error that states Main Menu can't find the macro 'Private Sub Combo32_AfterUpdate() Any ideas?

Thanks Doc! I'll let you know how it goes! Will you be up for a while? I have another pretty easy question that I'm concerned about. But in order to get there I need to finish this part first. Sorry I'm a newbie but I'm really enjoying this learning process!

so do i put this in the control source for the field on the form? would it be typed like so? me.Combo32.Column(1)

How can I update 2 fields from one combo box? I used the combo to update my customer_id but I also want to attach the order_id to the form since it is one of the fields also. I already created the combo box using the wizard and the customer_id updates just fine. I'm just struggling on trying to...

Okay that didn't work... I get ?Name# in the field and nothing shows up. For example I have a combo box with shows multiple clients and their account number along with their purchase num and when I select them from the box to update info i want to update both fields in the form at once. Any ideas?

Essentially what I want to do is not only update the normalized tables but also the large table. If I normalized the database will I still be able to run queries for reports?

Hey guys, So I'm having a little trouble setting up my tables. Here's a brief background: I got a huge excel file in which there was multiple tables combined into one. My boss wanted me to break the sheet down logically all with the same unique identifier. Then I also need to import the entire...

Thank you! I will try that and let you know how it turns out.