Search results

strange... when i change to commas i get an error... says there's a misplaced comma sowhere or something

here's the exact line i used positions: IIF([Compression_Position]<>0;[Compression_Position];IIF([durabilité_position]<>0;[durabilité_position];IIF([MV-Absorption_position]<>0;[MV-Absorption_position];IIF([Entrée échantillonnage_Position]<>0;[Entrée échantillonnage_Position];null)))) if I...

I have tried commas,, then a get a parse error... but with semicolons i dont get a parse error... but the error i get is that all the values of the new field are all #error

actually there are 4 right parens... one of them combined with a semicolon to do a smily

nope I did that and it caused an immediate syntax error... its not it ... the semi-colon is what should be used. Anyone else has ideas ?

Hi, I have 4 fields in a query that can have a alphanumerical value, 0 or null but when there is a value, they are the same for one ID : example 0 0 1 0 2 2 2 0 0 0 3 3 0 3 0 8 0 0 0 0 0 0 I want to add a 5th field that would show the value if anyone of the fields has...

ok thx but how do i create a batch file with that command ??

Is there a way to make automatic backups on a daily basis... from code... ? thx

nope i tried running the suggested line but I get the same syntax error... and the form is not liked to the table... i double checked by running the command in a new form...

I get a syntaxe error

In a field I want to change all the value that are o to 1. I have the folowing code wich gives me an error... can anyone tell me why ? code Dim sqlStr1 As String sqlStr1 = "UPDATE tablename SET [field name] = 1 WHERE [field name] = 0;" DoCmd.RunSQL sqlStr1 thx

a state is also called a report i think..

not it Its not a table but a state

I accidently deleted a state in my DB !! an important ans complicated one... I have a backup but it was made a while ago so i cant just replace the DB with its backup... I tried to export the state from the backup and save it in the DB but after that when i open my DB.. it tell me there's a...

of course :) I have access 2000,,, i'll try to see if there is any difference un syntax for that line.

the folliwing line gives me an error: Set rs = CurrentDb.OpenRecordset("SELECT * FROM MSysObjects WHERE Name = 'YourTableNameHere';") says incompatible type

would that be effective with modified reccords ?? would the now value change when a field in the reccord was changed »?

Hi ! I have a access program that transfers tables from a Handheld PC to some access tables... but the transfer sometimes fails so I need an easy way of confirming that the transfer went well. Anyone have any idea how i would do this ? like is there a way to see when a table was last modified ?

Help files dont talk about using variables to declare arrays... :(

sorry i meant Dim array(0 To lines, 1 To 10) As String