Search results

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.

You are lucky that you have first 3 characters as alpha(string). It is easy to select first 3 as 1 field, and rest of it as numbers then you sort field by alpha and numbers. But if you have inconsistant data you would need to write 2 functions to purge all alpha characters and then purge...

Built another field as a last field in your table with text data type. Import all data manually or using VBA, and then just add update statement something like this DoCmd.RunSql "Update YourExistingTableName Set NewFieldWithTextDataType=ExistingFieldWithNumberDataType" Use your new field for...

1) Set up System DSN- works just fine!! 2)You have probably dbo or dba account on SQL Server side. You have to create on every computer the same DSN with dbo or dba Login and password with TCP/IP client configuration setting. 3) Link once all tables using your new DSN with save password checked...

1) Create a new field in your table with name "TotalCalc" 2) On close button place code Docmd.RunSql "Update YourTableName Set TotalCalc=Forms!YourFormName.YourCalculatedTextboxname where YourVisaUniqueField=Forms!YourFormName.YourVisaUniqueTextboxname" Another word you are forceing to update...

If it stored as memo then I think it could be kind of binary method to keep image in the field. There is no simple way to view binary stored image in the report.