Search results

Bob, I hate being an idiot but I don't know what a breakpoint is. As far as posting the db, it's my clients business and that would violate our contract. I would have to take the tables out and such. I'll try to find out about this breakpoint. Thanks.

Sorry Bob I tried as If([payterm] = "X" then Me.expiredate = Forms![orderfrm]!orderdate Else Me.expiredate = DateAdd([payterm], 1, Forms![orderfrm]!orderdate) End If and like Me.expiredate.Value = If([payterm] = "X" then Me.expiredate = Forms![orderfrm]!orderdate Else...

Thanks for the reply. I fill it in and I get a compile error: Expected: Expression I have it written like this Me.expiredate.Value = If([payterm] = "X" then expiredate = Forms![orderfrm]!orderdate Else expiredate = DateAdd([payterm], 1, Forms![orderfrm]!orderdate) End If I'm trying a couple...

Phantom, I'm not sure if it helps or means anything but I use SQL on our companies server everyday In that enviroment I would have to use Not Like '%ENGINEERING%')) instead of "*ENGINEERING*")) I'm not sure if it makes a difference just thought i'd put it out there.

Thanks Bob worked like a champ. Knowing very little about code I couldn't tell you what DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 does just seeing it by itself. However DoCmd.RunCommand acCmdSaveRecord You do know. Again Thanks for your help.

I'm not experienced in code at all. I can't figure out what is wrong with this code Me.expiredate.Value = IIf([payterm] = "X", Forms![orderfrm]!orderdate, DateAdd([payterm], 1, Forms![orderfrm]!orderdate)) the whole thing is Private Sub cboproductid_AfterUpdate() Me.txtamount.Value =...

Thanks for the reply. Yes payterm is yyyy, d, m, q, or X Order date is a date/time. I took out the "" from the expression and replaced it with [order date] and it sorts right. I also tried a any date such as #01/01/1975# and that worked. But I kept it as [orderdate]. I had to change some...

Bob, Thanks for the advice. Do you mean this DoCmd.RunCommand acFormBar, acRecordsMenu, 5, , acMenuVer70 instead of this DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 ??

Adam, The Refreshed data is coming from product form. The user can set the values of the combo boxes of the order form from the product form. There are about 4 different values set in the product table. What happens is the info is set but when the user closes product form the information does...

I have an expression in a query Expire: IIf([payterm]="X","",DateAdd([payterm],1,[orderdate])) However when I sort it it does not sort in correct manner it's goes like 1/11/2007 1/15/2008 10/10/2006 10/16/2007 10/31/2007 10/5/2006 I have the field properties set to Short Date. What do I...

Thanks for your comments Trumpet. I tried to attach the refresh cmd in the close of the other form and came up with an error. So this fresh macro on the On Activate event was the easiest and it worked. However I found later that unless the form was filtered it would refresh and go back to...

In a few of my forms I have command buttons to go to other forms. Normally they go to the other forms to add or update info to use in the form they just left. When they leave the other forms they use a command button to close it. I have set the Activate event on the main form to refresh. This...

Thanks I will search that out. What method would you recommend?

I have been designing a database for a friend of mine and yesterday he said that he was planning on having someone else do his inputting for him and wanted to sync up his with hers and hers with his. I'm fairly certain this can be done however I have never attempted it and not sure, with my...

I have that fixed. Thank you. It's funny I tried that before and I got an error. Run time error 2564 or 2540? Hmm, it's working now thank you.

I get a compile error: syntax error Private Sub actionid_AfterUpdate() is in yellow

After the user selects and enters one value I want the values for two other fields set. If I run these they seperately they both work Private Sub actionid_AfterUpdate() Me.Action.Value = DLookup("[actionname]", "actiontbl", "[actionid] = Forms![cstfrm]!commentfrm.form!actionid") End Sub...

Sorry Got it Left([Fullname],InStrRev([Fullname]," "))

Last name removed I searched the forum and looked at the example db. I could not find an instance to satisfy my need to omit the last and save the remainder Examples Alan Albert Wayne Chris J Newman Mr. Milton Allen Mr. & Mrs. G. Borden Paul McDonald William B. Jones Results: Alan Albert...

Oh so get get rid if the navigation buttons. Create my own. In the code of that button have it refresh. If I must. It seems like alot of work for a novice. I'm just trying to make a few $$.