Search results

I just set the SelStart property to 10 OnEnter which should cover all possibilities. Works fine. Thanks, just what I needed. Paul

After some playing around further to my question below I have found the problem seems to be that I'm using a string variable as the criteria for the Dlookup function. I assume its a matter of syntax, but how do I use a string variable as criteria in a Dlookup function? Thanks, Paul

Hi, Is it possible to set the focus to a text box without highlighting the text already there? I have a text box which has a default value, and I set the focus to this when a new record is entered. I want users to be able to just type the rest of the field value, with the first part being the...

Hi, I have a simple, unbound form which has a combo box containing manufacturers, and a text box which I want to display the relevant country when a user selects a manufacturer. I have tried the following code in the combo box's afterupdate event: Dim c As String c = DLookup("[Country]"...

Hi, I have a calculated textbox in a report footer and am trying to get it to display its value to 2 decimal places. I have set the properties-format-demical place of the text box to 2, but I still get loads of decimal places on my report. Why? Thanks in advance for any help, Paul.

Is it a property of the hyperlink field in the table, or the hyperlink control in the form, or do I have to set it for each entry?

Hello, I have a form in my database that has a hyperlink field. When I click the hyperlink Internet Explorer opens up at the relevant site. However if I go back to Access, then to a new record and click the new hyperlink a new IE window opens up. Is there a way to make hyperlinks all open up in...

Hi, I think I understand what you are trying to do. In the drop down combo box are you selecting audit reports by the audit report number, or some other field e.g. report name? What is happening in your subform at the moment, is it simply blank or does it diplay all audit issues instead of the...

I've sorted it now, after a chance flick through the Office 97 Bible. I used: Forms![form]![subform].Form![control].Requery Thanks for your help, Paul.

That works fine for one of my combo boxes, but I also have the same situation for a combo box in a subform. I've seen other answers on this site that deal with subform requery, but I can't get it to work. I've a feeling I'm just not getting the syntax right. Any ideas?

Thanks guys, that look like just what I need, I'll let you know if it works.

Hi, I'm not sure if I'll be able to explain this problem clearly, but here goes anyway. I have a combo box in a form, and the combo box has a lookup row source like "Select DISTINCT [fieldX] From [tableY]". I have a button on the form to bring up a popup form to add a new record to tableY. The...

Im having difficulty in using check boxes in a custom dialog box, to set up the parameters in a query. I then want to produce a report from this query. Can this be done, and if so does anybody have any advice?

I have created a database with a form which has a button to bring up a popup form. In an earlier version of the database this worked fine. Now I have made a few changes and I get an error message saying the table (on which the popup is based) is open through the user interface, and cannot be...