Recent content by EthanHunt007

I have got a customer form that has a sub form in it, and when i click on a button in the sub form it opens the agreement form and leaves the customer form open, but i want it to close it, any suggestions Thanks Ethan

I have the following command as code for a button on a form to export a query to an csv file, DoCmd.TransferText acExportDelim, , "Bacs", "C:\" & Format(Now(), "DD-MM-YY") & "_Bacs.csv", False but if you open it with note pad it has "" around each field, how do i make it so they are not...

At work i have a newtwork of computers each with a frontend of my database on it and 1 computer with the backend on it, once there's about 8-10 computers using it, it wont let anymore in it saying something like unable to open, exculsively opened etc. How to i get round this?

Sorry to be a pain wayne, but how do i do that?

how would i get it so that when i click the button a box pops up and says enter start date and then enter end date, so i can put different ones in. the field they look at are paidviadate and it filters all record sets between start and end.

This is the coding i have for a button, but its saying 2 few parameters expected 2. Private Sub Command40_Click() On Error GoTo Err_Command40_Click Dim rst As DAO.Recordset Dim varArray As Variant Open "C:\BacsQuery.Txt" For Output As #1 Set rst = CurrentDb.OpenRecordset("Select * From Bacs...

do i put all the fieldnames in the line ie varArray = Split(rst!sortcode,accountno,name,amount) or just 1

I've tried using the above code but it error's at the split command?

I need to export a query as below Mark, Smith, 10 Garden Street, London, LN1 4RF Fred, Spencer, 12 Red Street, Luton, LU7 5TF AS Mark Smith 10 Garden Street London LN1 4RF Fred Spencer 12 Red Street Luton LU7 5TF any blank fields need to be spaced aswell can any one please help. Mark:confused: