Search results

cj London The data it exports is not important and doesn't matter about the order just want it to update the worksheet even if it does not delete a b c d just overwrites new employee and important data is held in a separate table Good night Cheers Shane

Hi cj london e column not to be deleted I only want to delete a,b,c,d columns Cheers Shane

hi all hope this is possible right I have Query call "export to excel" these are columns in my query employee id total ex date of ex first name surname which I would like to export to excel file name "access data" columns in excel A employee id b total ex c date of ex d first name e...

thanks JHB yeah that worked lol I feel like a right bloody Idoit now think i was having a bit of a moment... cheers again shane

hi , all can someone point me in the right direction why this code below is not working as I'm banging my head how it works right I'm working on a report I have a text box that contains directory path for a picture which is showed in a image box on my report which works...

thanks mh123 got working a treat legend !! my code for any one else who struggling Private Sub cmdEmail2_Click() Dim appOutLook As Outlook.Application Dim MailOutLook As Outlook.MailItem Dim OutlookAttach As Outlook.Attachment Set appOutLook = CreateObject("Outlook.Application") Set...

no worries bob thanks anyway Shane

sorry for the late reply thanks bob couldn't get it to work but doesn't matter just put a sign next to the text boxes stating what 0 or -1 mean thanks for the help if get change I have another thread I m stuck on if you have min http://www.access-programmers.co.uk/forums/showthread.php?t=263084

hi all I have some code that attaches any files that are in my attachment field on the current record in to a email this is great but I m starting to realise that this is take up way to much space as it hold a copy in the database and can t afford to go down the sql sever route so what I have...

hi bob right tried what you suggested only one problem if the new value text box does not receive -1 or 0 I get a error for example if the new value text box receives a text value not check box value it then shows #error because its look for -1 or 0 I wonder is there any way of capturing it in...

hi bob yeah just hope it stay's it was lovely to day few beers in garden here is the code I have on the main form on before update event Private Sub Form_BeforeUpdate(Cancel As Integer) On Error GoTo Form_BeforeUpdate_Err Call Audit_Trail(Me, "ID", ID.Value)...

hi all right I have auditing system in my database that tracks any changes made to any records. it logs it on a separate table and i show it on a continuous form. right my problem is that I have loads of check boxes and text boxes on my main form on the form that records the main form...

you were right Plog legend i had the field set as a text field not date/time also i found that using now() give me the exact value e.g -15.3646577 so i have change this to date() give me -15 thank for you time plog cheer shane

hi all I have goggled the hell out of this can't find a solution. right I have a query call courses and field name expiry date I have add additional field within the query to show how many day left and how many days over the expiry date I have had a good go myself with no joy here what I...

thanks Dave Work a treat Legend!! cheers shane

hi all I have combo box call "supervisor" and check box call "supervisorchange" basically want to make supervisor change to true if combo box is change which I have made code you can see below it work's Private Sub Supervisor_Change() If Me.Supervisor = "" Then Me.SupervisorChange = False...

hi all I have some code below I run on a form in access that can delete calendar appointment in outlook I just wonder how can I adapt this to send cancelation before deleting appointment for my outlook here's my code so far: Dim goldLocation As String Dim...

Dim outApp As Object Dim outMail As Object Set outApp = CreateObject("Outlook.Application") Set outMail = outApp.CreateItem(olAppointmentItem) hi paul thanks I had tried the code above before posting on here I couldn't get it to work but for some reason I copied yours and it works you must...

hi , all i have some code that creates appointment that i can send to collegues when i run the code first time it work all ok but the second time i run it i get a run time error see pic below but i dont get any error's if i leave outlook open have also try the code on 2 pc's but...

thanks Paul see some nice touches you add thanks again you *******Legend**** shane