Search results

If someone can help me gray out one field if another field is filled in on the form. Example: If textbox containing Mass is filled in then gray out Volume and if Mass is not filled in then gray out Mass and allow to fill in Volume.

This almost works for my case too. Except that it just grays the boxes out completely. So that I cannot update either one... If someone can help me gray out one field if another field is filled in on the form. Example: If textbox containing Mass is filled in then gray out Volume and if Mass...

Thank you this works and thanks for your persistence!!

Bob thank you so much for your input. I couldn't figure a way either and I've been working on this one project for 14 plus hours straight. I guess I have to give in but how to do it gracefully and save face. Thanks again!!

I have attached the file. This is what I was trying to accomplish. 1. 15 random items chosen from the Category CHEESE and DOUGH 2. 15 random item chosen from the Category SAUCE MEAT TOPPINGS and FZPIZ 3. 5 random from BAKERY, COND, ITAL, CP, MISC and POTATO 4. 5...

I've added the code to the detail section of my report and no errors. However, it does not select a random number of records???? All records come up?

first of all thank you for your help! Secondly, it didn't work once again same error 3709 If I wasn't worried about my job I've paid someone else to do it at this point. Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer) Dim objConn As ADODB.Connection Dim objRS As...

No dice still same runtime error. Please advise???? Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer) Dim objConn As ADODB.Connection Dim objRS As ADODB.Recordset Set objConn = New ADODB.Connection Set objRS = New ADODB.Recordset objConn = CurrentProject.Connection...

Thank you but I've added it and still come up with: compiled it and ran it and now I get runtime erro 3709- The connection cannot be used to perform this operation. It is either closed or invalid in this context. What am I doing wrong? Here's the code once again. I don't have to add a...

Not sure I understand then. Isn't this setting the connection and if not how can I do it? Dim objConn As ADODB.Connection Dim objRS As ADODB.RecordSet Set objConn = New ADODB.Connection Set objRS = New ADODB.RecordSet

I am so missing something... I added the Dim objConn As ADODB.Connection Dim objRS As ADODB.RecordSet Set objConn = New ADODB.Connection Set objRS = New ADODB.RecordSet compiled it and ran it and now I get runtime erro 3709- The connection cannot be used to perform this operation. It is...

Thank you Bytemyzer! Okay. I corrected MY mistake but now I am back to the original runtime error '424' object required. Please help?

Thank you for your reply. When I go to compile the code that you have provided (which I really appreciate) it comes up with error on: Randomize -Now I have added this as an event on my catagory header. Should I be doing it some other way? Thanks!!

Hi All - I need some direction. I don't know to much about programing or adding code to MS Access. I need to create a report containing a specific number of randomized records from each catagory. However I do not know which way to go with this. I have tried vb coding within the report but it...

forgot to add that I recieve a runtime error '424' object required. all help is appreciated.

Hi All - I need some direction. I haven't programmed in years. I need to create a report containing a specific number of randomized records from each catagory. However I do not know which way to go with this. I have tried vb coding within the report but it doesn't run. I tried top records...