Search results

Chris, Very Grateful, thank you !! Diem

Hi Chris, Thank you so much!!. It's working great but what if the memo field has only one instance of this: xx/xx/xx - nnnnnnnnn etc. The function doesn't return it(?) Dm

Hello All, I know there are some threads that cover similar scenarios to what I'm about to ask but I still can't get my head around it. Hope someone can help. Basically, I've got a memo field that has this standard structure. xx/xx/xx - nnnnnnnnn etc. (two carriage returns) xx/xx/xx -...

Hi there, No need to reply to this one. I actually found out why it can't be done. Apparently, once the refresh has started it will take all the processor time, so the scrolling text won't be able to operate at the same time. Thanks Wayne! Dm

Wayne, There's no problem with the code. As I said, I've got another form in which I've got a button to execute the Refresh function. But I'd also like to have the scrolling text running at the same time (while the Refreshing function runs) so that the user gets an idea than the db is...

Hi Wayne, Thanks for the prompt reply. Here's my SCROLLING TEXT form: Public txtScrollStatus As String Private Sub Form_Load() Me.lblScrollingLabel.Caption = "Patience is a Virtue ........................." End Sub Private Sub Form_Timer() Me.lblScrollingLabel.Caption =...

Hi, Hope someone can help me with this one... I've got a form used as a scrolling text. On another form, I've got a button to activate a refresh of the database (by calling a function). How do I have the scrolling text run while the refresh is being executed (this might take a while) and...

Hi Jon, Thanks for your reply. I actually had a report created for that particular query. Unfortunately, it's exactly the same as in the crosstab query (I've also used the "Can Grow" property of the report field). Any idea? Diem

Hi all, Its my first time using this forum! I'd appreciate some help with an issue with crosstab query. I have created a crosstab query based on another query. One of the expression in the crosstab query doesn't return the full size of the original field (ie. half of the text has been cut...