Search results

So the most reliable way for me to round up always is to call up a function?

Of course, if I was thinking at all. I would realize CInt(1.3+0.5)=2 and CInt(1.6+0.5)=2. OK, I think I'm all better now.

No, that doesn't work. Where Int drops the fractional part, CInt returns the low whole number below 0.5 and the high whole number above 0.5. So, CInt(1.3) = 1 and CInt(1.6) = 2. Seems kind of screwy there isn't a simple term to round up.

That's good to know. Thanks, Mile.

How about if I want to round up to the next whole number I put: Int([MyField]+1) This will return 2 if MyField is 1.2 or 1.7. Any disadvantage to this?

Hayley, your bypass key works great. My boss is the worst for going in the back and reformatting my tables. Got him! One question though. If some one else has this same trick, could they come behind me and enable the shift key?

Thanks again, Neil. And yes I meant 10Jul. What you have here I like and will get started on that. This is very helpful and appreciated. Cheers

OK. I put a field in the main table called RecurringItem. It's a yes/no field. I made an append query for the main table looking for RecurringItem = yes, Where Date () is within 30 days from DueDate. The problem is every time this query opens, I add a new record for each recurring item in...

Maybe try from scratch. Put an unbound combo box on your form. In the Row Source Type, select table/query and in Row Source, type: SELECT [tblYourTable].[SSAN] FROM tblYourTable; Then, in the AfterUpdate event, I hace this code: Private Sub cboSSAN_AfterUpdate() ' Find the record...

After SelectCase should be the name of the option group. If it is WhichDiv, no need for 'Dim WhichDiv as Integer'. SelectCase Me!YourGroupName Case1... Case2... End Select

Mr. Wizard put this code behind a form I use to do the same thing. Private Sub cboSocialID_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[SocialID] = " & Str(Me![cboSocialID]) Me.Bookmark =...

What about after the DoCmd you set the focus to the next text box. Then put a message on the GotFocus property of that text box. Might not be the best way, but you would get a message when it started and another when it finished. Was just reading samehkh's response and that would do it too.

Put your message box before the DoCmd. Just have warn the user that there will be a wait. When they hit the OK button, the DoCmd will execute.

Thanks, pal. I'll give at a whirl.

I have a form that when it opens runs an append query. I would like it to skip this step if the query is empty, which it will be most of the time. What do I key on? Search hints? Taunts?

I haven't had any problems with it either. And like you say you can easily change information. Thanks J, I was just wondering if it was that big a no-no. I don't think the more experienced kids on here use them that much. We're at least a crowd of two.

And some with a little 8Meg Visor. I read a lot of good stuff about Dragon Forms, but haven't used it yet.

I tried doing something like that with totals, but each time you have different criteria, you need a different query. I also tried combining queries but had tons of trouble with it. I wound up doing what Rich suggested and made subreports for each query and put them in the main. Played around...

I wonder if anyone knows of the Access library would be associated with the unino query. I hate to arbitrarily add libraries, but I noticed I don't have the DAO 3.6 (is that right?) installed. Should I install and see if that helps?

Niel, thanks. That helped a ton with the structure. Kreff and I have PMed each other and figured out we're pretty much after the same thing. Say you have maintenance due on 10Jan and 10Jun every year. If 10Jan was not completed, I still want 10Jun to be added to the registry 30 days prior...