Search results

pcs:- Yes there is a simpler way to do it. I was trying to over complicate things where all I actually needed to do was use user rights to prevent access to the underlying tables. Therefore allowing the super user to have access to tables direct. I thank you for your comments All the Best Toni

Hi Chris No I did not list it like that. However I did end up doing it like this and all is now well. Thanks for the intetrest in the problem though SQL = "SELECT Last(tbl_system_check.Cypher_C) AS 0, Last(tbl_system_check.Cypher_D) AS 1," SQL = SQL + "Last(tbl_system_check.Cypher_E) AS 2...

I assume that the text box feeds into a field in a table. If it does you could also change the field properties to Number, Type Decimal with a scale of 2 and a decimal places of 2 That is what I had to do this morning All the Best Toni

This is the line I want to break up as I have another 10 query selections to add Set rs = db.OpenRecordset("SELECT Last(tbl_system_check.Cypher_C) AS 0, Last(tbl_system_check.Cypher_D) AS 1, Last(tbl_system_check.Cypher_E) AS 2, Last(tbl_system_check.ECS_C) AS 3, Last(tbl_system_check.ECS_D) AS...

I have quite a long line of code in VB and I wanted to break it down into a number of lines. Normally I would use the _ in the code but for some reason as soon as I do that the auto syntax is not happy and says that the first word of the second line is Complie Error: Expected List seperator or...

With a few changes and deletions from your example it works great. Thanks Toni

Thanks Everblue, I will try that now All the Best Toni

I have a textbox that contains a Now() date and time value which is saved into the table. I want to convert this field to a CheckSum. I know this is possible although I dont know how. Also, I want a specific user to be able to enter the checksum value and be able to decode it to its original...

I have just noticed that even though I spaced the example correctly in the message when created, it has trashed the spacing completely. Basically there are three columns, Drive Name, Todays value and Previous Value All the Best Toni

I am designing a form that is used daily to check the status of various different servers. This kind of info includes hard disk usage, connectivity etc etc. The form is text & check box based. I have 15 fields that the user is to type in the values of the current hard disk space remaining on...

Pat or whoever feels they can answer this I have a primary key in a table that is based on multiple field basis 'tbl_flags' has primary key of 'cr_no' and 'flag_code' combined. I have another table, d2Kflags that contains imported data containing 'CR no' and 'flag code' I want to sucessfully...

I will look that up in the help file right now. Many Thanks Toni

If I were to use variables, is there a way to specify a variable at the top of a module and then call it from anywhere within the module? I have 2 dozen Sub that will call this variable. IR

I have a constant string value set at the top of a module. This constant is the path to a specific file on my hard disk. Is there anyway, through the use of a Open File dialog box or whatever that I can change the value of this constant to the selected path? I have a set of procedures that run...

Cancel thread, Problem sorted

For those of you who know anything about VBA and Excel, may I point you to http://www.access-programmers.co.uk/ubb/Forum11/HTML/000362.html THe is a problem there that requires urgent solution if you would be so kind IR

Anybody?

Sorry, this is not a solution to your problem, but when you find out by this forum or other, I would very much like to know also Many Thanks and sorry if you thought I was gonna give you the answer to your problems Toni

For those of you who were dying to respond to this, please do not worry about it. The code works great in Access & Excel 2000, it just does not work on my Access XP developer machine. Toni

I have a chunk of code that creates and runs a number of dynamic SQL statements. There have been occassions where the machine has not finished writing the information to the new query structure, and as a result the old query has been run instead. Is the a way to delay each query run operation...