Search results for query: *

Thankyou - obvious when you know how - but can't find it in the help for love or money. I do need to run the test on each record - so it is perfect thanks again

My only reticence is that I don't know the code I have a test as follows: If test then variable = 1 Else variable = 0 I have a tabcontrol with two pages ( call them page0 and page1) If variable = 1 I want to see page1 and page0 be inaccessible If variable = 0 I want to see page0 and page1 be...

Michael - I did understand your way - but thought that mine would be a little easier to action from the starting point I'm at. Are you saying my way (overlaying the tab controls and just switching certain ones to visible) won't work ?

Thanks - looks good - can overlay one tab control over another and put all the buttons on them - then just turning the control invisible does the same for all the buttons (essentially)

I have a from which displays 20 buttons if a certain criteria is met, and 20 different buttons if it isn't. At the moment I'm doing this via the OnCurrent Property and an if statement followed by lines and line of code setting the visible property of each button to True or False. Is there a way...

If I want to merge two files in Unix, I can type cat file1 file2 > file3 How can I do this in NT ??

Tne path is def the same - will look into the references - I have managed to get round of it by making my final query a query of two tables rather than a query of two queries (if that makes any sense to you) Thanks for all assistance

Thankyou - it all seems to work nicely !

I am running the same database from two different Access Programs (both same version - 97). I have a query that uses two other joined queries to pull back data. In one version rows are returned, and not in the other. THIS MAKES NO SENSE TO ME !!!! The SQL for the joining query is as follows...

I seem to be finally getting somewhere with this using the QueryDefs hence: Dim dbs As Database, qdf As QueryDef Set dbs = CurrentDb Set qdf = dbs.CreateQueryDef("StatQ1", txtSQL) I just need the code to delete my querydef before I regenerate it - I'd be very grateful if someone...

kctaylordotcodotuk That is great !. I now have a function in a module run from a button in my form that produces the string txtSQL which looks like the SQL I need - but I can't work out how to actually run it. I tried adding DoCmd RunSQl "txtSQL" at the end of the module, but it...

Thanks Michael - how am I going to be able to change the SQL statement according to what is chosen in the form ?

I'm planning to create an access database with a table in it that may have 20 million lines in it. Does anyone know if Access will be able to deal with it, or will I need to use another DB ??

I have a feeling this will be difficult to explain... I have a table with structure as follows: Server Text Date Date Stat1 Value Stat2 Value Stat3 Value I have a form with combo boxes for Server and Stat Thus the user chooses a particular server and a...

I have a feeling this will be difficult to explain... I have a table with structure as follows: Server Text Date Date Stat1 Value Stat2 Value Stat3 Value I have a form with combo boxes for Server and Stat Thus the user chooses a particular server and a...