Search results

Hi, I want to block editing certain fields after a date (+ 7 days) This date exist on the form in the txtDatumFix field Now I have this: If Forms![Inschrijving].[txtDatumFix] < Now() Then Me.AllowEdits = False Me.AllowAdditions = False End If I want 7 days on top of the existing date...

Thanks Jack, Ill have a look to this solution..

Hi all, I'do a Transfertext to a commadelimited csv file. Decimal values that are exported in this file, are rounded to two decimals and have a comma i.e. Original value : 81,2222222 Value in csv : 81,22 Value needed for import in Mysql : 81.2222222 Is it possible to change this with VBA code...

Hi all, I've got a downloaded (through php) file with xls extension, but in fact it's not a real xls file. When I open manually (in Excel) and click 'Save as' it's offering to save as a textfile. When I save it as xls, the file grows in size and then I can run VBA code on it which edit some...

Hi, I'm importing four colums form an Excel sheet into a table. One of the columns has dates in it in this format :d-m-yyyy u:mm This Ecxel file is a download from an MySQl db. The props of the table date field are default date/time. It 's no option to change this, because the MS db is used by...

Thanks for you reply RV You don't happen to have a sample of how to accomplish the things I want ? Would be very helpfull...

Hi all, I use an Excel import to update tabel 'deelnemer'. This works oke BUT when user 'x' has a linked field in tabel 'B' the import fails due to RI (I think..) How can I make it so in this code that the user record is updated and can I restore the RI (otherwise my forms won't work..) This is...