Recent content by karl05

You could try SELECT Count(*) AS Expr1 FROM tablename.table_date WHERE (((IsNull([tablename].[table_date]))<>False)); hth

If you name the queries numerically (AppendQuery1, AppendQuery2.....) then use a String for the query name and update the string as the For loop runs. Something like this Dim queryName As String queryName = "AppendQuery" Dim num As Integer num = 1 For num = 1 To 9 Step 1...

Eikenhorst, Your a genius! Thank you very very much. It worked perfectly

Thanks Thanks, I hadn't thought of it that way. I was looking for a property or something to change but will try that, it make sense. Cheers Karl

Hi, I have a form in Add mode that keeps entering records in my table whenever something is typed in any field. I would like to stop the automatic creation of the record until all fields are completed or when a Save button is pressed. Any ideas?

Hi, I am trying to use the following code to open a folder in Windows Explorer and show the user the contents Application.FollowHyperlink folderName, , True It works but when used in Citrix session it opens two instances of Windows Explorer. Any ideas how to fix this?

Fixed it but am not happy with the fix. The Column Count property of the Name field on the form needed to be 2 for the email address to be picked up. Now when the user selects the drop down box on the name field it shows both name and number columns. Not great but at least I can move on

reply Thanks workmad3 but that didnt fix the problem. I rearranged my vba code a little to get the column count returned by the query (as below). The column count query returns 1?? But when I run the query normally in access it returns all 3! This is very weird

Hi In a form, I want to autopopulate two fields of contact details after the user selects a contact name from the another field using a lookup query. For example, the user selects the contact name in field A. Using the afterUpdate feature of this field I want to automatically populate two other...

Is it possible to ask a user to select which fields they wish to appear in the report and then generate the report based on these selections? For example, some users only want (item code, pack size, cost price) while others would need similar fields and maybe a few extra. cheers