Search results for query: *

That worked. THANKS!

Thanks for the reply! I don't see that option in Access 97 - maybe that's my problem. For an autonumber, there are two Field Properties tabs - General and Lookup. General has 5 rows, 1.) Field Size, 2.) New Values, 3.) Format, 4.) Caption, and 5.) Indexed. The lookup tab is blank. So I...

Hey everyone - great to be here! I'm trying to do something that seems relatively easy. I have a bound form that is tied to a record set. I have a primary key of Order ID and I'd like each time you click the "new record" button a new Order ID is automatically populated with the current order...

Good afternoon everyone! I love this site...it's helped me soo much with my Access coding! My problem (well, not really a problem): I have a dropdown which is populated through a query on the main form in my access database. Unfortunetly, the mouse wheel will NOT scroll through the dropdown...

Good afternoon all, At my company, we are having problems with our users going into the access database and changing things without telling anyone. My question is, there anyway to version an access database? Or, I know there is a way to force a login/password. But is there a way to record...

Thanks! I'll try that! -Tim

Good morning! I have a field that I'd like to suppress if it contains certains text values. The problem is it may contain one text value or many text values seperated by commas. What is the syntax for doing a "Like" command (like in SQL) in Visual Basic?? I can't simply do an "=". THANKS! -Tim

Hmm...maybe you didn't understand my question. I'm using VB code for on "On Open" option for the report. The footer name is [Defect Impacted Center]. There's a field called "Impacted Center" in the footer body. How do I reference the "Visible" option for the FOOTER (NOT the field) in VB...

Good morning all! It's good to be back on this site! Here's my question. I have a report footer with only ONE field in it. I need to set the 'Visible' property of the Report Footer to 'No' if any 1 of a certain 5 values appears in the field in the footer. What is the VB code to reference...

Ahh....that works.....just take of the [qry] part. Thanks! -Tim

Hey CosmoKramer...thanks for the reply. Yes, [qry]![Test_Cond_Cycle_1_Plan_eBAT_REG_CLA] is the correct name. They are each individual fields in the tables. Any ideas??? I'm stuck! Thanks! -Tim

Actually guys: When I insert ONLY this I still get an #Error. Sum([qry]![Test_Cond_Cycle_1_Plan_eBAT_REG_CLA]+[qry]![Test_Cond_Cycle_1_Plan_eBAT]+[qry]![Test_Cond_Cycle_1_Plan_eBAT_REG_ENT]+[qry]![Test_Cond_Cycle_1_Plan_eBAT_REG_FUNC]) Why does this cause an error??? Why can't it sum those...

Hey everyone...good morning! Anyone know why this control source gives me an "#Error"...doesn't make sense...I checked all the "("s and ")"s and it looks right. The fields are all perfectly accurate - the query is correct. I added the spaces to make it easy to read for ya. =IIf(...

How about a follow up question for a star (or two)? Ok, for the same database. I have to do seperate queries for each pass since there is a report for each pass. So, ALL the PMT_No's are in Project but they MAY OR MAY NOT be in "Project_Test_CB" Table or "Project_Test_BDR&quot...

It worked!! Thanks a million! -Tim

Sorry about the topic! It won't let me edit my post after I sent it!

Good afternoon all! Ok, I need one query to do something rather complicated. Break out your SQL skills! I have 3 tables. Table 1 = Project Table 2 = Project_Test_CB Table 3 = Project_Test_BDR The 'Project' table has a primary key named "PMT_No". Tables 2 and 3 have further...

Good morning all! Here's my question, hopefully it's easy: I have a Report with 6 subreports. They are all located in the Details section and are placed 1 at the very top of the details section then the remaining 5 beneath one other. Now, some reports will have data and some won't. If one...

Okay, but how does that help me? If rs.BOF is TRUE and rs.EOF is TRUE then there is no current record and the same error occurs saying "There is on Current Record". There will NEVER be a current record until the user clicks out of the subform. So what can I do? Many thanks! -Tim

Thanks so much for the e-mail Rolliee...your code worked great (after tweaking it a bit) except for one small problem. When there is no "Current Record" then it gets an error. (saying there is no Current Record). I added a button that once clicked fills in the Pass 2 and Pass 3 stuff...