Search results

Have you tried stepping through the code line by line to see where the error crops up? Once you have identified the line it generally (?!?) gets a bit easier. HTH

Hi Just got Access 2007 and playing. On surface looks good even if re-learning needed but suspect familiarity will come fast. I was surprised (and a bit daunted) to find when I put a button on a form it wants to do a macro but if I force an event then I get the VBA pane but just get Private Sub...

Thanks guys I can almost follow the logic and will probably continue to do so until I need to use it again! THanks especially for between you providing both the "this is how it works" answer and the "this is what it is" answer. That actually helped a lot because I could work through the line and...

Hi Hope someone can help since I have got an error in my code. I know it lies in the middle part around Me.cboSupplier since when I break and hover over all the other bits they give me the right values but when I hover over Me.cboSupplier I get zilch. The line of code is lngQuote =...

Hi I have cobbled some code from the MSDN site to send a series of personalised emails each with individual attachments. The issue I have is that I have to repeatedly click on security messages and also to jump back and forward between my Outlook pane and my Access pane. I can fathom this but I...

Hi again Sorted the yellow myself by moving the code down the sequence and then changing to .Sheet.Column Only trouble is 44 is a horrid muddy orangy yellow not the nice pale one I wanted but I am sure I can now sort this Thanks again for the help!

Wow Roy You da man! Thanks! Worked a treat and I can even understand why just couldn't see it/didn't know it before. For anyone's future reference I have put the revised code in below. PS You don't know how to fix the yellow background to column G do you, wizard that you are!?! Revised code '...

Hi I have an application that generates Excel spreadsheets to be emailed to outside parties so they can enter pricing information and return it. The application then picks up the spreadsheets and imports the data back into Access. This is done since the recipients will almost certainly not have...

Hi Sorry so long to get back - too many different projects all competing for too little time. Me.Undo worked a treat. It is obvious really but I never thought of it! Thanks for the help Best wishes

Try using <Tools> <Startup> and then enter the name for your switchboard?

Hi I have a form with avout 4 fields based upon a query to allow user to edit an entry if needed. I want to put a cancel button on so that if they change their mind after having changed a field it reverts to its original value - so for instance they decide to change a land line phone number to a...

Not too sure of the SQL. You are getting #Name since the fields are not in tblCallLog. I would be tempted to build a query to pull all the data you need for the combo then call if cboCallLog and redo the combo to take data from the query. I think this would probably be more efficient

Glad it worked. I think the Dim for strScrNo was a bit of a red herring - sorry. Do not know how it cropped up!! Anyway good luck

Hi I have played around with your database and so far as I can see it seems to be working but you know what you want it to do. Several things 1. The file is the same name so make sure you open it to a different location to avoid overwriting yours (sorry - I rushed) 2. I have applied naming...

Hi I tried looking at links but cannot read them. I think you can attach jpg files directly, otherwise try zipping your db and attaching. I have a bit of time at the moment so may be able to help although I may have to head off for a bit

I would have said that having one table per product was asking for a nightmare scenario. You can always have fields left null in your table so you can have fields for dtmInstallDate, lngInstallStatus, dtmCreditCheck, lngNetwork (create a separate table for networks since much more efficient to...

Hi Sorry haven't looked at your attachment since short of time but you need to logically work out the processing steps and then build a sequential structure of queries which you call on order, either using a macro or more constructively using VBA. You can refer to textboxes on the form whilst...

Just a guess but it looks to me as if Jet is looking for a table called tblPrinters/Laptops/Desktops which suggest you have a bit of coding wrong. Hope this isn't a red herring for you but think it would be worth looking at it since from what you suggest it should be looking in tblCallLog - or...

Been there. Done the jigsaw. Don't worry since the process never ends. I now struggle and puzzle over things that are a bit more complex, but can still remember struggling over that one a few years back. It is all part of the learning curve!

Hi I have just pulled an example from one of my databases to give you an idea. What I use is Private Sub txtDrug_DblClick(Cancel As Integer) On Error GoTo Err_txtDrug_DblClick Dim stDocName As String Dim stLinkCriteria As String Dim strScrNo As String stDocName =...