Search results

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...

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 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”...

I am using “DoCmd.RunCommand acCmdInsertHyperlink” from a form button to run the Insert Hyperlink pop-up. The problem is that if the user clicks the Cancel button on the pop-up rather that entering a link and/or clicking the OK button the code errors. Any ideas on eliminating this error?

I need the "Insert Hyperlink" button picture. Any ideas on that or other button pictures?

First, does anyone know where I can get the “Insert Hyperlink” button picture? Second, I have a continuous subform, multiple records associated with a main record, to enter hyperlinks to associated Word documents. Rather than have the data entry person click on the “Insert Hyperlink” button in...

I posted a message and subsequently researched this forum and received a lot of great information which I am now researching. Someone named Anauz posted a response and then Emailed a sample database to several members. I am looking for this sample shrinker-stretcher database or Anauz. Thanks

I have a test database with an open table. I want to run an update query and then see the results in the open table. What code or method do I use to refresh the table. I can use the menu item “Records & Refresh” but I can’t figure out how to run that in code. I may need to set focus to the form...

I have a form that looks fine on my screen but when opened on a smaller screen in a lower resolution is way to big for the screen. What is the general approach when designing forms for general use?

When designing a report you can use a “Sorting and Grouping” pop-up to sort and group records. Does anyone know how to use code to determine what sorting and grouping was used on a report? I want to put the sorting and grouping information in a text box on the report so report readers will...

When designing a report you can use a “Sorting and Grouping” pop-up to sort and group records. Does anyone know how to use code to determine what sorting and grouping was used on a report? I want to put the sorting and grouping information in a text box on the report so report readers will...