Search results

And finally.... Any ideas on how to create a second column in the same field (poss using chr(??)). Thanks Tracy

Hello (again), Does anyone know how to check in VBA if a form is open? Thanks

Thank you bot for your help. Works a treat! Tracy

Hello, can anyone please help as I've completely run out of ideas! I have a text box in a report footer, and in that single text box, I need to display all the records in a table. The table has around 5 records in it. I can create a string concatenating all the records. That's no problem...

Thank you Tay. Works a treat.

Thanks, this works, but I wanted to change the font color. Any ideas...husband?

Can anyone please tell me how to set a colour of a text box on a report in visual basic. I've tried Me!TextBox = RGB(255,0,0) but it just sets it to a weird number. I think there is a format function but I can't find it. Any help would save me! Thanks

Hi, I have a table with about 20 values which I need to get into a field at the bottom of a report. The values in the table act as a key, so I need each of the records in the table to go together into one field. Does anyone know how I can do this? I tried to concatenate into one big string...

Hi, I have a memo field in a table, and when set this table to the record source of a report, and set the memo field as the control source of a text box on the report, the memo field gets truncated. I've even tried to use two separate text boxes and set their control sources to...

Thanks. vandewi: I am not printing the report, just previewing on screen and it still truncates. 3699wat. I am using a memo field in the table, then I create a query from that table, then use the field in the report. It still truncates. Is there any way I can force a txtbox to be a memo...

Hi, I am trying to run a report with a field in it which contains a fair bit of text. On many occasions, the text is truncated. I have set Can Shrink and CanGrow properties to yes, and tried making the field bigger. Does anyone know if there is a limit on how much text can fit in a text box...

Please can someone tell me how I can check which page is selected on a tab control. I've checked the help, but cannot work it out. Must be a super simple thing. Thanks Tracy

Ta Thanks Tim, this is a great help. Tracy

Hi there, In Access 97 you could put @ at the end of one sentence in a Msgbox and then @@1@@1 at the end of the next, and it would make the first sentence bold and put a new line between the two sentences when the msgbox displayed. Does anyone know how to do this in Access 2000? Thanks for...

What is the exact code on your button that calls the query to run?

I got as far as nstalling the package and Deployment facility, but it's after that that I get stuck. I don't know which files to run to set up my application. Thanks Tracy

Hello, Can someone please tell me where the 2000 run time wizard can be found. In Access 97 this was on the Microsoft Office Developer Edition Tools CD. However I can't find the equivalent for 2000. I have the Developer edition CD for Office 2000, but when I download the option I need, and...

The problem is you can't do a message box for the value of TestDate when you use rs.FindFirst "TestDate = " & Me!txtFormDate. When I use If rs!testDate = Me!txtForm Date it's fine. I can get round the problem by not using the FindFirst method, but it is such an efficient method that I really...

Nope, still no luck. Time wasn't included in my dates. The starnge thing is that when I use the FindFirst method i.e. rs.FindFirst "TestDate = " & Me!txtFormDate it doesn't work, but when I use If rs!TestDate = Me!txtFormDate it does work. Haven't used Now() or Date() either. I am totally...

Please anyone, can anyone please explain to me how to compare dates. I've been coding in Access for a couple of years and every development I do I always have problems with dates!!! ANd nowhere in the help has an adequate explanation. Dates in a recordset, vs dates in a text box on a form...