Search results

Hi DJN, Thanks it works but maybe like neileg is writing: the printer was waiting for an end or file marker from the first report

Hi, I don't know if this is an access problem but since I am only encountering this problem in access, it could be. In access, when I am printing a report from within a form with the code : " DoCmd.OpenReport" , the printer begins to print immediately the first report but when I am trying to...

Thanks it works Daniel

Hi, I have a *.csv file with 7 fields delimited by 6 commas . The code to import the file in a table should be : DoCmd.TransferText acImportDelim, , "abc", "c:\abc.csv". The problem is that I can import my *.csv file but in my new table , I have only one field "F1" with all my data (with...

Hi Fizzio, Thanks for the answer but in the mean time I have found the solution. It was a problem of date format and now it works. Daniel

Hi, I was using Access 2000 and WindowsMe. I have installed it with WindowsXp and I have encountered the following error : In a form, I have a date field with date() as default. When I was pressing the minus key or the + key, the date was changing with one day. Now it doesn't work anymore ...

Hi, I have a password protected database. Is there a way to use the code "makeReplica" with a password protected database? I know the code "PWD=" but it doesn't work with "MakeReplica" Thanks for help Daniel

I have a textbox with short date as format and today as default date. I would like, when the focus is on this textbox using the plus sign (+) to increase the date by one or using the minus sign (-) to decrease the date by one. Thanks for help Daniel

It doesn't work for me : When I try to use the code : Me![YourFieldName] = YourVariable I am receiving the error message : You can't assign a value to this object.

I have a continuous form based on a query; I would like,when clicking on a record in this form, that it opens a new form- with default view single form- with the "clicked" record in the form. I have tried DoCmd.GoToRecord acDataForm, stDocName, acGoTo, me.CurrentRecord but sometimes it...

Is there any function allowing a sort in a form? Instead of going to the toolbar, records, sort,I would like to have when clicking on commands buttons that my form is sorted on a certain way. So I could have- on a click- many ways of sorting my fields. Found the solution : Private Sub...

Hi Travis, Thanks very much, it is working (I just had to change ".Field(0)" in ".Fields(0)" Thanks again, I will now perform all my calculations in my reports with this method. Daniel

In a text box - in the report footer -I have put the following code for my control source : =Max([mytable]![myfield]) but when i am previewing the report, I am receiving the message :"enter parameter value for mytable!myfield. Thanks for help Daniel

In a continuous form , to go to the current record( for example editing this record in another form) you have to write : DoCmd.GoToRecord acDataForm, stDocName, acGoTo, Me.CurrentRecord; This works fine BUT I have applied a filter in my form and then when trying to go to a new record,it...

Hi Travis, I have tried already before the change that you wrote but then I am receiving the error message: Runtime eror 3077, wrong number of arguments used with function in expression. I have tried : rst.Findfirst "left$([Name],1)=" & chr(KeyAscii) but then I am receiving the first error...

BUT : I have written the code but when I am pressing a key I am receiving the following eerror message :Runtime error 3070, the microsoft jet database engine does not recognize "(the pressed letter)" as a valid field name or expression. I have received many times this error message with the...

Hi, I have tried and set the AUTO RESIZE from YES to NO but when I open the form it is still maximized even if I have the "DoCmd.Movesize" in the Private Sub Form_Resize() Daniel

Thank you very much

When adding a record in a form, with Data entry set to "YES", it is impossible to switch to another form. Is this normal, or is it possible to change this? Daniel

I have a continuous form with a field based on customers names sorted in descending order. I would like when pressing a letter key that the cursor goes to the first record with this letter as first letter. For example when pressing "T" , the cursor has to go to the first customers name beginning...