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...

Thanks Cheers MattS Works a treat - very much appreciated

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...

File Attachment Sounds to me that the path to open Word is incorrect. Do you have a shortcut to open word on your desktop ? If so make sure it is working then right click and check it's properties. The path that you can see there is the one that you should be using in your code.

File Attachment The path c:\Steve\Test 1 must include the .doc file extension i.e c:\Steve\Test 1.doc Are you getting any error messages when you click the button?

File Attachment Make sure that the path is correct to open word and secondly the title field must contain the full path of the document to be opened e.g C:\Procedures\Document1.doc apart from that I can't see much wrong with it

File Attachment try inserting a button and on the on click event use the following code: Dim stAppName As String stAppName = "C:\Program Files\Microsoft Office\Office\WINWORD.EXE " & [Test] Call Shell(stAppName, 1) Substitute Test for the name of the field that holds the path to...

Your best bet would be to create a new field in your table and set it as a Hyperlink. To create the link simply right click your mouse on the field (either in form or datasheet view) select edit hyperlink and then select browse to find your document.

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...

Thankyou very much Cheers b jackson that worked a treat Thanks very much

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...

Check Code Thanks Mile that workks fine

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...

Thanks guys got both of these to work - very much appreciated

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

Cheers Pat, it worked a treat

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

Try selecting options from the menu then select the keyboard tab and choose 'Go to Start of Field' in the Behaviour entering field option. this should do the trick