Recent content by neil_turner

dam, window dosen't support tab.... doh what I was getting at is: if strName = "bob" then msgbox "hello Bob" else msgbox "your not bob" end if I hope this makes some sense now and that I've not completely confused you..

No worries, I'm having problems with linking 2 tables together for an update statement and what Microsoft is telling me dosen't work, so quite happy to help instead bashing my head against the wall.. The problem your getting is that you have not closed the 'if' statment. An if statement has...

yeah thats right it appears your column WEIGHT is of type text. The problem with your code is that your missing a leading ' change the code so that it is exactly Set rst = Db.OpenRecordset("SELECT * FROM tblESTIMATE WHERE tblESTIMATE.WEIGHT='" & strFileName & "'") This should now work...

doh... that should be if not (rst.eof and rst.bof) then sorry about that wasn't thinking at the time of typing...

Thinking about it a bit more, you may want to add the following lines into your code. The error you were getting was because the query was looking in the tblESTIMATE for an entry in the WEIGHT column that was = strFileName instead of what the value of the variable strFileName was. To stop this...

All you need to change is the way in which your code creates the query. What you need to do is seperate the text of the query from the variable you do this with "your query here " & your_Variable_here & " remainder of your query" so hence the code you want to make this work is: Set rst =...

Søren, Not sure if I'm a 100% with you on this! You don't have to create a QueryDef every time you want to open a query, instead just create a new recordset, then call currentdb.openrecordset(your_query_here) then check the recordset returned to make sure it has results i.e. while not...

Hi All.. Quick question.. I'm creating a project where all the major database tables are on Oracle with only a few application tables within Access (although they don't really need to be - they can be located in Oracle should I need to). At present so that I can update some of the oracle...

Hi All, I've just a quick question with making an application client server. So far all the code I've written is for the front end application, which from what I have read is waht gets relesed to the user. However I want to write some marshelling code that will check the status of a table at...

Hi All, I have an extremely strange problem with a recordset. I have a recordset declared in a module as a public recordset. I then use this recordset to query a external databse (which is oracle) using ODBC and DAO. This returns the query fine, I envoke the 'edit' method on the recordset...

Hi All, Yet another question. Im trying to lock a row of data in a linked table into an Oracle database. At present im trying to use Pessimistic Locking. I use a function to open a recordset for the row that I want to lock, I then test to see if the rocord is already locked if not I carry...

Thanks for your help, but no there are no OLE columns within the tables, infact apart from the tables and queries theres nothing else in them oh and a macro to run them in order. Unfortunatly its just such a size due to the amount of rows of data and then temp tables being created from querys...

I've tried everything in that article already to no effect, for some reason Access 2000 really dosen't want to play ball. I know SQL server would be a great option unfortunatly the work is there as a proof of concept which will only be used occasionly where the full solution will be much larger...

Hi All, I hope someone has the answer for me here as I have been asked to save some space on our server which has about 12 large mdb files upon them all of which are in Access 2000. I went through the first one and changed all the feild sizes to suit the data which hardly made any difference...

Problem solved, the module I was using had a sneaky error within it. The user defined function would not work even though the function with the error was not the RowSourceType function that I was wanting to use. After working this out I have managed to get it all working. Nothing is ever simple..