Search results

Hi, I have used the code below to export my table to a specific range and worksheet in excel which works fine. However I would like to export another table to a different range in the same worksheet in excel in the same code. Could somebody help me update this code in order to do this I...

I wonder If anybody can help. I am creating a db to hold the results for my local Cricket Club and calculate the averages. To calculate the average you need to total the runs scored and divide by the number of innings. However if a player is 'Not Out' then you add the runs but don't include...

I use the code below for emailing attachments My trouble is that I need to automate this process and therefore want to remove the EmailSend.Display line of code. However when I do this outlook will not send the e-mail (I get no error messages, but I never receive the mail) but the code works...

Could somebody please help me? I am using the following code (from MS Knowledge Base) in a query which works well when I have only 2 variables. However I have tried to adapt the code to use 3 variables as I have 3 Primary keys in my table but the result I get is always a 0. Does anybody have...

Could somebody please help me? I am using the following code (from MS Knowledge Base) in a query which works well when I have only 2 variables. However I have tried to adapt the code to use 3 variables as I have 3 Primary keys in my table but the result I get is always a 0. Does anybody have...

Could somebody please help. I have written the following code Dim db As Database Dim rst As Recordset Set db = CurrentDb() Set rst = db.OpenRecordset("qryFindDuplicate") If rst.RecordCount >= 1 Then DoCmd.OpenQuery "qryUpdateMill" Else MsgBox...

Could somebody please check my code I keep getting the error message "Loop without Do" but I just can't seem to resolve it and it's driving me mad. Dim dbs As Database Dim rst As Recordset Set dbs = CurrentDb() Set rst = dbs.OpenRecordset("qryMill") Do While rst.EOF If [Mill Cycle] > [Weeks...

Can anybody tell me if there is a way of pausing code for say 5 seconds without using the onTimer Event. Thanks

Could anybody tell me how I can list my tables in a list box or combo box, Thanks in advance Mat

I have a query that returns a number of clients (ID, Name, Address) This works fine. What I want to do is create another query that returns every client except for the one's returned in my first query. Can anybody help me with this Thanks in Advance Matthew

I have a text box on my main form which sums a column from my subform. This all works fine except when there is no data in the subform the text box shows #Error. Can anybody help me with this as it is driving me nuts Thanks

Could anybody tell me if it is possible to sort by a text box in a report and if so how can I do it ? I have a text box which calculates totals within a group but I would like to sort by the total. Thanks