Search results

I am having to start using ACC2007 since it is getting harder to buy ACC2003 for new clients so I thought I had best explore using the 2007 format. Wish I hadn't! There have to be some benefits somewhere down the line surely - please ... Anyway I cannot see merit in macros since most of my stuff...

Thanks Yes the reference to Outlook is OK - first thing I checked I will try adding New to the dim statement. It is a pain since I cannot really test it till I get back into the client! Still I suppose if I have it working seamlessly here it has to work there!!!

Hi Getting an odd one here that I think may be network/security based rather than VBA but would like to check first. I have a bit of Outlook automation code that I have re-used from a previous application. It worked fine there, and it works fine in the new app from my office but when I tried it...

Hi You have to put a condition in the third part of the DLookup, or else leave it out altogether. If you leave it out then the look will test the value of SNum. But you might be better to dim a variable rather than using a textbox - lngTest = DLookup(“[SNum]”, “[Table1]”) If lngTest =>2 Then...

Hi An application I am building sends out a detailed information report to volunteers giving them background on cases. I felt using snapshot would be useful for this to build in confidence. However there is also a report that the volunteer needs to complete and send back to H/O so it can be...

Hi Paul I was just about to post a note to the effect that I had done exactly as you suggested and it has worked nicely. Now trying to get some of my other DLookup functions to work. I think it is getting too late since I have fallen over with a joint text and date field criteria set about ten...

Well I thought I had got it with this intYear = DLookup("[lngCurYear]", "tblCurrentYear", """ & Format(Me.txtRecD, 'yyyymmdd') & Between & Format(CDate([dtmCurYearStart]), 'yyyymmdd') & And & Format(CDate([dtmCurYearEnd]), 'yyyymmdd') & """) since it compiled and ran OK with the first test I...

Thanks guys Well I had thought of using "between x and y" but was not sure how to SQL it What I now have is intYear = DLookup("[lngCurYear]", "tblCurrentYear", """" & Format(Me.txtRecD, 'yyyymmdd') & " Between " & Format(CDate([dtmCurYearStart]), "yyyymmdd") & " And " &...

Hi I am trying to identify the financial year within which a transaction occurs. I have tried to use a format to circumvent confusion between US and UK dates but I have clearly got something wrong in the SQL. I wonder if any of you wizards can spot my mistake? intYear = DLookup("lngCurYear"...

Magic Roy I used oSheet.Columns("H").Numberformat = "0000000" and it worked a treat. Help much appreciated. Thanks again

Hi I am struggling with an exported Excel sheet that is used to allow suppliers to enter information that is then uploaded back into my db app. The problem is with one field in Column H. In Access it is a text format in that it contains a 7 digit number where the first digit may be a zero. This...

Thanks for the thoughts MicroE. On reflection I suspect you are right about IP ownership. The puzzle is I don't think there is anything remotely clever within the password protected VBA and the bl**dy thing does not work!!! Looking at the data structures I suspect someone fresh out of a not...

Thanks MicroE I will check that. If IP has not been raised as a specific issue I vaguely recall it lies with the person commissioning the database. I know that my T&Cs specifically retain the IP with me but without T&Cs then it would be vague. If IP is not with the client then it looks a bit...

Hi RuralGuy I tried that and it came up with -- on the next line in the Immediate Window. I did try -- as the password just in case but it didn't work - which wasn't a huge surprise. As the code suggested I put it in a module in a new database and typed the following into the Immediate Window ...

Hi John I am pretty sure that it is simply a VBA password I am needing but without it I cannot get anywhere. You are right in that I have mdb of both the FE and the BE. Looking at the data structures I do not think it is even properly normalised so I doubt they have done much more than lock down...

Hi RuralGuy Thanks for your efforts. Yes I know costs are not high just I am a suspicious sod at heart I suppose and being a Scot would resent $35 if it didn't work (rather like that code which looked as if it might) - I guess we all have crosses to bear! I am still exploring options but reckon...

Thanks RuralGuy for that one. I have had a look at it and tried to debug but not successful yet - might need a bit of help later on but will try harder first. Meanwhile I did try to open a new module in a copy of the database and I cannot even open a new module without the password. Do you think...

Thanks Keith I have had a look and they all have the feel of snake oil about them. The trial versions inevitably will not "prove" that they can do the job - easy to see why!!! Does anyone have experience of one that works? Thanks and best wishes

Hi I have been called in by a client who had a db app put together (not very well). The original developers simply are doing nothing and the client is in despair. They have asked me to see if I can both correct the original bugs and also develop the database on. The history is one of many...

Thanks for suggestions. Just finally back in and too kna**ered to have a bash tonight but will hopefully get a chance to explore further tomorrow. Will let you know how I get on.