Search results

I have a search screen(form) that seems to do what you want with combo boxes. It works off of a query with several IIF statements in the criteria. I am not real strong in vba. And you'll see that this form is pretty basic. However, my company loves it and it has saved them tons of manual...

I am trying to update several records on a form at one time. My form shows in continuous view so that you can see all of the records on the screen at once. I am trying to update all of the PCODE fields at once with a control button. Can't I use some kind of loop? I've tried several ways but...

I got it to work. I just used the field name in the last part of my IIF so that it would show all the records in that field. Thank you!

I tried the criteria you gave me Pat, and it still didn't work. It doesn't show anything. If my field [ComboBUILDTYPE] on my form is empty then I don't want any criteria to be used in my query (I want to show all the BUILDTYPEs). But if someone looks up a BUILDTYPE in my combo box then I want...

My query has multiple and/or criteria. The first row in my query has several fields based on fields on a form. The second line has all of the same except the last 2 fields. I want the last 2 fields to check if the field on the form is Null. If the field is Null then I don't want Criteria in...

Of Course, parentheses, now it works perfectly. It seems so obvious now. Sometimes it helps to have someone else look at it too. Thank You!

I have a report with a lot of criteria and shading. I have 3 fields (INSTALLER, SJSCITYSTATE, and DELIVERYDATE)on one line that can shrink. The shrinking part is working fine. But I have 2 lines on the side that are visible or not depending on whether all 3 fields have something in them...

I read about in in help and found out how to do it in a book. I can make it work until I try to use it on a subform. For some reason the on current doesn't work the same for the subform.

I am trying to open a form based on what is entered in another form. There are 3 forms involved: main form (draftingschedule), sub form(subdrafting), another subform(subdrafting-id). I want subdrafting-id to open based on what is chosen in subdrafting. Drafting Schedule and subdrafting are...

I tried that and it kept giving me an error. I put my field name from the table in there, not the activeX field name, and I didn't know what to put in the abbreviate part. What should I be using?

Thanks it's working now, especiall;y the year idea. But I was wondering what is an easy way to have it say the month name instead of the number?

Specifically I have a form with AcriveX0 and ActiveX12. These are the criteria for my report. One date on each will be chosen (these are the criteria for another report that goes with this one-subform/mainform). I would like for this new subform's to select the whole month for that ActiveX0...

If I have a form so that the user selects a date for the criteria, how can I use that one date to select the whole month?

That is kind of what I thought and told my boss. Then someone else told him it could be done. I wanted to see what people on this site said. Thank you!

I have a report with date criteria. The beginning and ending date will usually be in the middle of a month, probably covering2 seperate months. I have weekly and monthly totals. The weekly totals will occur in the middle of a week if the month ends in the middle of the week and then at the...

I totally forgot about those reserved words. I made that corrections and everything seems normal again. Thanks!

That's what I thought. I have places of code on the subform. Up until yesterday, I did not have error handling on there. Thiss is what it looks like. Are there any visible problems: Private Sub Form_Current() On Error GoTo Err_Event 'IF ACCTINI HAS INITIALS, SHIP TO AMT CANNOT BE...

I have a form with a subform and when users enter information into the subform sometimes they get an error message when they go from one line of the subform to the one below. It seems that after getting this message some of the information from one jobs has gone to another job and some of the...

Unchecking autocorrect really made a big difference. Thanks!

THANK YOU- It is working well now. I am trying to make the ActiveXCtl12 go to exactly 4 weeks after the Monday of the current week and not having much luck with it. Can I add more cases or should I add on to Cases 1-7?