Search results

Hang on...I'm gonna try scrapping the whole thing first and starting over. this is NOT that dang hard.

No workie! This is about to drive me CRAZY! I have 3 other forms that this works A-Ok on but for some reason..this one is givng me fits! Still not working. That's when it's something really simple isn't it?

It works and I even modified it to include Bereavement! WOHOO!!! Ya like to answer questions do ya? How about this one? I have a form with a combo box and a button to preview a report based on the selection in the combo box. This is for customer sales reports. The combo box is Combo0...

Trust me, I would if I could. I am totally new to this with no background whatsoever and I can't find anywhere online with examples of long expressions like that. Is there a list of those sorts of things somewhere that I just didn't find? I have no clue where to put the brackets, commas...

Now it's telling me there is a command without an operator. Uugh!

I tried to copy/paste that and it told me it contained an invalid syntax.

K - I tried.. =IIf([Text29]>0 or [Text31]>0,[Text19], [Text91]>40,40,[Text91]) But it didn't work. It said I had the wrong number of arguments in it.

Thanks, I'll go give that a TRY!

My new db up and running but I have a couple of issues that have come up as well as a new report I am trying to program. I was wondering if anyone can help. The db was built in Access 2000 on a Win2000 machine. Three of the machines here are running XP with Access 2003. I asked one of these...

It is SOOOOO YOU!

I didn't specify anything...at least not knowingly. Does it do that automatically?

I checked it on another pc and the reference was there but it said Microsoft Word 11.0....I'm assuming we all need the same one. Where do I get them & install them?

Got it....it has VB for Applications MS Access 10.0 Object OLE Auto ActiveX Data Word 10.0 Object and Office 10.0 Object These are on my PC, the one that works fine. I went to one of the machines with the problems and it said MISSING: Word 10.0 Object Library. How do I fix that?

I am a total newbie to access and I have no idea how to check that. Where do I go? I checked the link in the onclick event and it is correct but it is linked to a word file on the network. It is f:\DatabaseFiles\GATXInspectionform.doc Should it have the server specified instead? Like...

Thanks! I'll see what I can find out!!!! How to I check the references for the word file?

1) When XP users open the database it gives them some security warning because of the macros. Does anyone know how to fix that? 2) When merging w/word it works great for me but on some machines, it simply opens word and nothing happens. YIPES!

Ya know what? I got home and realized I forgot all about vacation/holiday pay which would mean it NOT split those amounts. How do you put 2 parameters like that in? In other words, if vacation pay (Text29) and Holiday pay (text31) are <0 then [text91]>40,40,[Text91] But if vacation pay...

WOHOO! GOT IT! THANKS SO MUCH for your help!!!!! Do you have time for one more question? I need it to total Text97 for the whole report. I have a box on the bottom of the report that says =Sum([Text97]) but now it when I view it, it asks me what Text97 is? Wierd!

Yup, I tried that but it's still not showing up. It is included in the total hours calculation and the overtime pay is calculating off of it which also calculates into the net check. If they have 48 hours for example, it's working great but they guy who only has 10 hours for the week is...

GOT IT BUT....if the value is 0 it's not showing anything and messing up other things calculating off that field, for example total hours. If have... =IIf([Text97]<0,0,[Text97]) How do I make it display 0.00 if the value is less than zero? Now it is just blank.