Recent content by IgorB

Use syntax in your report source query something like this: "Select .......,Trim([risk]) & " " & Trim([auction]) As My NewRiskAuction from ...." This will merge 2 fields in one, hope this solve your problem.

Are you talking about average of 4 last records or fields????

Your update expression: SET [Upload Trades].Client = [uploadaccts].[client], [Upload Trades].Account = [uploadaccts].[account] looks wrong. You tried to update Client filed and Account at the same time(it is impossible, do each update one at a time). Also "not updatetable" indicated that your...

Just use buit-in function Round(yourexpression,2) This example will round up your number to 2 decimal points.

I have this code somewhere, but when I used it I had big problem. There is the loop hiding all toolbars and menu which has effect to existing databases, another word it has impact on the whole MS Access enviroment. It took me efforts and time to restore everything back, so be CAREFULL with that...

Added to column in the table? Like you have already stored 1111 1112 1113 etc.?? Igor.

Why do you use File Dialog box, prompting user for selection .pdf file. Then pass parameter to the string. Search forum for File Dialog box.

Make sure your query does not have 3 sources which could cause not updateble problem

What I would od is 1) create label1 on form 2) place VBA code on ComboBox_AfterUpdate() like this label1.Caption=ComboBox.Column(1) 3) Use expression in your query like Forms!FromName!Label1.Caption

To open table in run time DoCmd.OpenTable "Labels",acViewNormal or To open table in design time DoCmd.OpenTable "Labels",acViewDesign

There is no control over this problem as far as I know

=Format(Date(),"dddd")

Set dbs = CurrentDb MyTextBoxName= dbs.Properties!AppTitle

I usually relink tables involved and it always helps.

This syntax gave me "overflow" error message dtmStartTime = "01/01/2006 14:30:00" dtmEndTime = "02/01/2006 14:31:00" I replaced it with dtmStartTime = #01/01/2006 2:30:00 PM# dtmEndTime = #02/01/2006 2:31:00 PM# and it work fine now.