Recent content by flemmo

That's great DCrake, thank you. It does take around 3 seconds to show up in the text box. Is there any way to speed it up a little? EDIT: Its okay - putting the code into VBScript onopen (form) is much faster.

Hi, I have a query the counts rows from another query. I would like to put the result of the count in a text box in a form. The form itself has a different record source to the count query doesn't show in the 'Add Existing Fields' window. I tried clicking in the text box, then Control Source...

Think I've found a solution - just to select a new list item in the combo as follows: SELECT [Categories].[CategoryID], [Categories].[CategoryName] FROM [Categories] ORDER BY [CategoryName] ASC; UNION Select "0", "All Categories" FROM [Categories] ORDER BY [CategoryName] ASC;

Oh no! Now I've saved the database and reopened, "Any" has gone again :( It looks like its going to the 0cm column. I've created a new textfield and set it to equal the value of the combo and it says "Any", so I know the value of the combo is being set, but I cant see it because the column is...

Got it working. I changed the width of the id column from 0cm to 1cm, viewed the form and it displayed "Any". Then changed that column back to 0cm and "Any" is still showing :) Thanks again Trevor ;)

Thanks Trevor. Comparing your example to mine, I cant see why mine isn't playing ball... I'll keep trying.

Thanks for the suggestions. Trevor, I tried your suggestion. It works on a text field but not on my combobox. Perhaps I need to change the settings of the combo?

Hi I have a combobox with a list of values fed from a table. Simply ID and Name, ID hidden and Name visible. I need to add the word "Any" as the first option, before the list of values from the table. Access usually has the 1st row as an empty/null field with no value. I could either add the...

Thanks for that. This is good news as it means I can carry on with my current database without any headaches :)

Does this apply to just Excel 2003 and older? Perhaps the poster on the link I provided meant Excel rather than Access? I think my client is using Office 2000. The database is Access 97.

Phew that's good to know. I thought 65k was a bit strange. The slowdowns I was experiencing have gone since limiting the records returned automatically when the search form is loaded. Basically the list was thousands of records long, whereas in reality I only need a couple of hundred max...

As the database has grown in the 3 years, it has slowed down at certain points. The main reason for this is the search pages automatically showed all records when unfiltered. I changed this to records in the last year. To see older records, users have to enter 'from' and 'to' dates. The main...

Hi all, I have a 3 year old Access 97 database that contains 16 tables, the largest of which (purchase order details) contains 13000 records. The file comes to 36MB. given that the file is 36MB after 3 years, and one table is already 13000 records long, is there anything I need to do to...

thanks for your help ;)

Think I've cracked it? Dim db As Database Dim qdf As QueryDef Dim strSQL As String Set db = CurrentDb strSQL = "SELECT * FROM CUSTOMERS;" db.QueryDefs("MyQuery").SQL = strSQL