Recent content by Rod C

Reply, thanks Thank you very much, I used the second method and after a little manipulation got it to work. Thanks again.

I searched the history and read all the posts on this subject but still don’t get it. I want to make visible a label with “continued” in it if my group spans more than one page. Where do I put the code to test if HasContinued is true or false so that it will change the visible property?

I have a table with two fields, Number and Text. The number is duplicated multiple times. I want to concatenate the text associated with each number field so that the number shows up only once and the text is concatenated into one record. Is this possible in a query?

I am using the “FileSearch Object” to determine if a specific file exists. The files are 1.xxx, 2.xxx, 10,xxx, 101.xxx and soforth. The problem is that if I am searching for file 1.xxx is returns 1.xxx, 10.xxx, 101.xxx, and anything with a 1 in it basically because I am asking for that. I tried...

Yes, actually a small blank square drops down.

I seem to have lost the ActiveX controls in the More Controls button in the Toolbox Toolbar. Any idea where it went and how to get it back?

I looked at the navigation buttons property and the record number box in help but don’t see how to reference just the record number portion of this control to set it to visible no. Can you point me in the right direction?

I have a form that displays one record at a time. The user can scroll through the records with the canned navigation buttons. I have a key field on the form that is simply a number. It looks just like the record number but obviously doesn’t match the record number. It confuses users. Please...

How do I remove the first and last characters from a string? If it helps the character is “#”.

I have a table with a hyperlink field. The field contains links to Edocuments like Word, Excel, and JPGs. I have a form with a text box who’s control source is the hyperlink field. When you click on the link in the text box the appropriate software boots and the document is displayed. I would...

Can I use a string as criteria in a query grid? And if so what’s the trick? For example I have a public string strXYZ that I set equal to a value “Smith”. Can I use the string in the query grid to represent “Smith”?

I am using a “Enter Parameter Value” popup to enter query criteria. It doesn’t seem to work with more than one parameter no matter how I type it. For example if it works with “A”, “B”, or “C” individually it doesn’t work with “A” Or “C” in combination. It also doesn’t work with an asterisk for...

OK, you did so well on the last one, how do I get the name of my database and print it in a report footer other than simply hard coding the name? Like =[Report].[Name] for the report name.

How do you refer to a reports name and have it print in the report footer?

I know this is long but please bear with me, I need some help. I am having difficulty updating a value in a table via a series of queries. I am getting the following error: Operation must use an updatable query. (Error 3073) I have three tables involved, the main table “tblMasterNeeds”...