Search results

I Have removed the spaces and still no louck. Does my code look OK to you guys?

OK, things have changed a little on this project so I have only just been given the new spec. Basically though I need to do the same. I need to send data bound to a form to a seperate table. Thanks to C smithwick I have made a start: This is what I have so far: Private Sub...

Hi, thanks for the code. I have just given it a go and It only updates the selected record again. Were you meant to declare nIndex?. Its not used in the code. Should I have added something? :confused: I will check my form name and treak brackets see if I can get it working. Cheers D

I have tried doing something a little different but again, my loops wrong as only the one selected on the form is added... Private Sub cmdExitandUpdate_Click() Dim rst As Recordset Set rst = CurrentDb.OpenRecordset("select * from tblWorkRequests") Do While Not rst.EOF For nIndex = 0 To...

Firstly thank you Wayne and c smithwick for your speedy replys The following in post 2 is correct: "Your current query is only adding one record because it is only running for the currently selected record on the form." My code (Post 1) does work for the selected record on the form. I...

Its pointing to this bit as the problem: Private Sub Form_Open(Cancel As Integer) ' --- On Error GoTo Errors Dim QRY_Clear_Temp_Schedule As String Dim DaysToMove As Integer Dim SelectedScheduleStart As Date DaysToMove = 1 - Format(Now(), "w") SelectedScheduleStart = DateAdd("d", DaysToMove...

I tried to open your database but also got a series of Parameter prompts for Monday through to Fridays dates. I tried accessing in design view but got the same effect. I have both DAO 3.6 and the Calendar control in my vba references. I agree with HiTechCoach it does look good. Please can...

Good afternoon all,:rolleyes: I have a query which picks up completed work requests from a work request table (which is linked to Sharepoint) I would like to add some of the information from that query to a previously created work request table where work requests were entered manually (I...

Sorry for the delay in the reply guys! Ezfriend, thanks for your reply, I couldnt manage to open the file on my PC though? :confused: ----------------------------------------------------------------------- DCrake, that worked perfectly for incrementing numbers, thank you very much :) I guess...

Good afternoon all, I hope everyone is well? I was wondering If anyone could help with the following problem I am having. I need to export the results of a query in the following format, each row having a line number... 1,61545001,,21/04/2009 08:00,21/04/2009 17:00,16/04/2009 17:00...