Search results

OK. You win. (I thought hash was what I had for dinner last night) All kidding aside, it's really interesting taking part in a forum with an international scope and being exposed to cultural differences.

I've never had to refer to one of those squiggly things the British use. But if I did have to, I would probably call it one of those squiggly things the British use.

Thanks Igor! And to us Yanks, they are pound signs.

I posed this in a reply to a thread a ways down, but I am asking again to help it to be viewed by more forum visitors. I've built a form that lists hyperlinks in a text box The source field in the table is defined as hyperlink. All data in the text box is displayed as hyperlink. If a file...

Have you had any luck with this? I'm trying to do the same thing. I can get the hyperlink to display in the text box, but I cannot get the address to go along with it. So I have a link that doesn't open anything. Any help would be appreciated.

Set dbs = CurrentDb Set rst = dbs.OpenRecordset("table1") With rst For I = 0 To ListBox.ListCount - 1 x = !Field1= ListBox.Column(0, I) !Field2= ListBox.Column(1, I) !Field3= ListBox.Column(2, I) !Field4=...

I'm not sure where hyperlink2 came from. It seems to me that Hyperlink1 should be in the assignment statement where Hyperlink2 is. Also, is it defined as a hyperlink in the table?

I don't know if this will help, but we just have a text box on a form whose source is a field defined as a hyperlink. We then depend on the user to type in the approprate path. A more progmamatic approach may be to build a string variable and set the hyperlink equal to that. For example...

Another way to do it would be to set up a hidden list box that uses this query as its rowsource. You can then set up a loop from 0 to ListCount - 1 to read each line of the quey.

I don't understand.

We have an Access 2000 database that sends emails with a report attached to each, from several buttons using DoCmd.Sendobject acReport, etc.... The send fails after the first one is sent, but no error message occurs. If we close the database and go back in, we can send another one, but it...

Currently we're in migration from ACCESS 97 to 2000. We're having a lot of fun(not) with all the new idiosyncracies we have to learn. One of them has to do with multiple users in development. 97 allows two users to make changes to objects in a database at the same time. When one developer...

Thanks for the response Thanks for the quick response, but I found my answer with a little more digging in the Help file. One of the new properties in 2000 is AllowDesignChange. Default for new forms is All Views, but default for converted forms seems to be Design View Only. This is the...

We recently began using ACCESS 2000 at our installation. Most of our work right now is converting 97 to 2000. A few of my new forms in 2000 have a quirk I can't seem to remedy. When they are opened in form view, the property sheet is displayed. How can I stop this?

I am developing some reports that must print Landscape on Legal size paper. But everytime we open the database they are set back to Letter size. Does anyone no why the page size is saved only as long as the database is open? Iam using ACCESS 97 and Windows 2000.

I am developing a db for capital budget requests. I have several pop up forms that I use as requestor woksheets. Most are continuous forms that use the Sum() function in the footer. I have one form, though, that I cannot get to work. It displays #Name? in the totals boxes (I have one for...

This should be an easy one (at least it sounded easy when I was given the task). I have a combo box in which I would like to display a list of budget years ie 2004;2003;2002;2001. In my RowSource I entered Year(Date())+1;Year(Date());Year(Date())-2. That is exactly what displayed - my...

I have a form with two uneditable continuous subforms. The records on the subforms can be added, edited and deleted through a pop up detail form. When I click the delete button on the detail form, I run a delete query, close the detail form and requery both subforms. The problem is when the...

I have an unbound form that I use to gather information to use as query criteria to populate another form. This form has a combo box that I would like to open with the default value of "All Tests" which is the first value in the query behind the combo box. I have tried setting the combo box...

Here's one for the techies out there: Below is the error message that we get in the Cardiology Database when the file gets locked. Once the file is locked, any user that attempts to launch the database will get this message prior to the login screen(our security splash screen). Microsoft...