Recent content by Chisamba

Solved the problem. The 'Square box" is the line feed character, so instead of using vbCrLf and then vbLf I used vbCrLf a second time, no box. It beats trying to write code to hunt down the boxes and replace them - I have seen that suggested elsewhere. Dave

Hello, Assume your form has 3 fields Field1, Field2 and Field3. Field3 calculates the values of Field1 less Field2, enter the following formula in Field3 =IIF([Field1]-[Field2]<0,0,[Field1]-[Field2]). The previous example using AfterUpdate does not work because the AfterUpdate event is not...

Thanks a lot.

I would like to use code to change the connection string for linked tables in my front end database. I have tried using the connection property of the TableDefs collection, this seems to work while I step through the code but does not change the existing connection property. Any suggestions?

Problem Solved Took a while but problem is solved. Finally formated the Hard drive of offending machine and re-installed. It appeared to be a problem with Windows 2000 installation which was carried over when machine was upgraded to Win Xp. After doing a clean install of Win Xp all was well

Hi Keith, I use the following code and it works fine for me, returning to the switchboard. Private Sub Report_NoData(Cancel As Integer) MsgBox "There is no data to print. Please check selection criteria.", , Me.Caption Cancel = True End Sub Obviously you can change the message text to suit...

Hi, I have attached a report that may work for you. I have added code to your on click event on the report preview button on the issue form. The code adds blank records to your tempmergepermit table when you view the report, I have not been able to prevent the carton quantity field from...

Hi, Instead of using the page footer use the report footer, and set the page footer visible property to no. Obviously if your report is more than 1 page long the info in the footer will only appear on the last page, also if the last page only has one record on it the footer will come halfway...

Hi, How do I prevent the printing of carriage return and line feed characters in a memo field on a report? They appear as a small box. Thanks

Can anybody help with code to extend vertical lines at the right and left of a report detail section when a memo field in that section increases in size to show more data. The can grow property for all fields is set to yes. Thanks

After checking on the validity of data entered in a contol on a sub form using the beforeupdate event focus is moved to a password field on the main form. After entering a valid password I would like the focus to be returned to the control on the subform. How would I do this. There are a number...

I have developed an MS Access application that is deployed on a number of machines, one running 98 the others running 2000 and XP. On all the machines the application runs fine except on one of the XP machines. I keep getting the message "The expression you entered has a function name that XXX...