Search results

Could you provide me with a link that will show me how this is done? I tried a search on custom labels but the results focused more on custom labels with respect to reports instead of forms.

I have a few forms with tab controls on them and I would like to make it easier for users to be able to see which tab they have selected. I tried adding code to the OnChange event of the tab control so that the caption for a particular tab would use all caps if the corresponding tab was...

Worked like a charm. You're the man. Thanks.

Keith, Thats actually the first thing I tried but it generates a run time error # 438 "Object doesn't support this property on method." because of the Ctl.Enabled = False line of code.

I appreciate your suggestion but I need to do it the way I described. There's actually more to disabling the form than just doing it for users of a certain type but I was trying to simplify the problem when I posted the question. Long story short, I need a for loop of some kind to place in the...

I have a form with many, many controls and subforms on it that need to be disabled if users of a certain type enter the form. Basically, of the 30+ controls and subforms these users should only have access to 3-4 of them. Now I could go though each control and disable it like this...

Wow, sorry it took so long to respond. You guys are correct, I didn't have an else statement. I thought the property would automatically reset itself for each group of records. After I used the else it worked. Thanks for all your help.

Yup, those worked. Thanks!!! This was driving me nuts.

?? I'm trying to make some forms and reports but the arrow keys aren't moving things around when I use them. The objects that I select just sit there. I recently installed Access 2000 on a machine. I've only used 2002 in the past. Was this feature not available in Access 2000? Anyone know...

Thanks Wayne. I ended up having to place the code in the DetailFormat event. But I'm still having a problem. A list of classes is being generated for each student which is what I want... but the bolding is the same for all of the students. So if student1 took algebra only and student2 took...

I have some labels on a report. I would like to bold some of these labels inside of the Report_Open event if certain records that correspond to the lables contain a specific value. How would I go about doing this? I know how to open a recordset. My question is, what is the VB code to change...

I figured it out, and yes, I DO NEED to store a blank row sometimes....like when the data is changed from something to nothing. Here is what I used: SELECT tableA.field1, tableA.field2 FROM tableA UNION SELECT "", "" FROM table A ORDER BY tableA.field1 tableA.field2;

I mean nothing at all is selected. The combo box would have/store no value. Is there a way to say... SELECT (a blank row) and * FROM table?

I have a combo box that gets its data from a select statement. It works fine. When the form loads the combo box automatically sets its value based on the value of a variable stored in a record of the database. When the combo box changes so does the value stored in that record. What I would...

Here is what I'm trying to do.... I have a form. The form contains a subform with records in it. For the sake of argument lets assume the records consist of first and last names. The form also has a text box for the last name field and a text box for the first name field. I want to make it...

NM, got it.

No luck Ken, but I do appreciate your help. I tried putting my original SQL string all on the same line and it worked!! I have no idea why splitting it up was causing a problem unless I wasn't splitting it up properly somehow. Again, Thanks.

I can't seem to get this create table query to work within a form. Meanwhile, if I take the exact same code and place it into a query all by itself it works!! Here is the code from the query that works (table names and variables were changed to be more generic): SELECT TableA.VariableA...

I am populating the combo boxes with a simple SQL select statement. Something like "SELECT table.var1, table.var2, table.var3 FROM table ORDER BY table.var3". I am using Access 2002 and I have exclusive access. What's weird is that every other aspect of the form that was changed (like the...

Wow. You're way is much simpler. I'd definitely go with that instead. Hey, ghudson, since you're so smart would you mind taking a look at my thread entitled "Form import woes" a few topics down?