Search results

Thanks Jack, that seemed to work. Thanks!

Ok, when I tried to open a new module and then save it (following advice of 1st replier), it told me 'You tried to cancel the previous operation' four times before the little message box stopped popping up. It doesn't save any new modules or anything. As to the second post, I have no idea what...

HELP! When I went into one of my databases this morning, I got an error 'Module not Found.' When i hit 'OK' it opened up the VBA window and was obviously running something, because it said it was in [Break] mode. None of my modules seem to be missing and when i opened up an earlier version of...

I feel idiotic, but I've been messing around with a Data Access page for a few days now and i can't get my option group to work. I added a frame, bound it to a boolean field, and added the radio buttons, setting the values of them to 0 and -1. I thought it would be fine. Yet, when I go into...

I had to mess with that quite a bit to suit my needs, but it worked! Thanks so much!

UCase won't work for this particular thing (its a date, you can't really upper-case a date), and I thought about the separate fields thing, but I don't think that will work either because it needs to flow and the [line5] or [line6] fields might vary in size, so I can't preset the field sizes...

Does anyone know any way to say, bold only one word of a text or memo field? I currently have a report which makes paragraphs from combining multiple text fields, and I need to make one part of it bold. Is there a way to do this in VB? If not, I have another option. The part I needed bolded...

OK that sounds great, but where do i put this code? i've never had to do anything like this before, so please go slow!

I have a bunch of forms that when opened they each pop up a dialog box which requests report info. I want the user to be able to cancel (via a command button) if they wish. When I pull up the report from the database window, this works perfectly. HOWEVER, when I try to do this via a...

Ok I see what you mean. I had a message box popping up, but I'll do a modal box instead that will allow me to close the forms. Thanks!

Anyone besides me could know this. I am trying to run a test to see if information matches up. If it doesn't, the user needs to go fix the problem, thus close the form "matching form" and go elsewhere. My problem is that I am BRAND SPANKING NEW to VBA (i'm trying to wean myself out of macros)...

Hi. I have a form which tracks courses and instructors and students enrolled. The student subform is based on a query which is based on two tables: one with basic student info, and the other with course/credit info. When i type in an ID number, it pulls up student info. However, when the...

I have a similar problem to other ones mentioned on here: i have a combo box and i'd like to be able to type in a name not in the list and have the control re-query so that the new name will appear int he list. The problem is that i do NOT know how to code, i've been doing everything from...

I have a macro set to the oncurrent property of a form that does a whole bunch of crap, including opening a pop-up form. For some reason, this macro is running twice. I don't know why and its driving me crazy.

You could try using conditions in your macro. [forms]![name of form]![name of field]="A" would run that particular action (like open a popupform) only if that condition is true. You could do a separate condition for each answer you want, and then attach it to something like the 'after update'...