Search results

Hi Thanks for your reply. I agree, I shouldn't have current address in tblPerson, so I can get rid of the property fields in tblPerson. The problem still exists though, that most people have previous addresses (therefore there is a one-to-many rel for tblPerson-tblPropertyHistory, and for...

Hi All I would like a bit of functionailty within my database, but i'm not sure where to start. I have main table called tblPerson. Within this (amongst other fields) is ID (unique), CurrentAddressLine1, CurrentAddressLine2, CurrentAddressLine3. I have another table called...

Actually, I have now looked at the wizard nav buttons, I didn't know that was so easy! Thanks again for your help

Wow, that was quick!!! Ok, so im testing this code and getting problems. I cant seem to compile it. I get a syntax error on this line: DoCmd GoToControl SubControlName what is the correct syntax for this? Thanks for your help so far

Hi I'm not liking the built in nav button placement on the screen so want to put my own in. MS advise how to do it here: http://support.microsoft.com/kb/104683 Option Compare Database '******************************************* ' MODULE DECLARATION SECTION...

Hi I've been playing about with this today, and it appears the above problem is the least of my worries. I now keep getting cannot read file errors when I try to update the financial statement template. It is a known error: http://support.microsoft.com/kb/824172 my code opens the...

Hi Bob, thanks for your reponse. I am pretty new to VBA, so please excuse my ignorance. When you say put that line to the end, it that the very end or within that bit of code, this is what i have now: Sub OpenSpecific_xlFile() ' Late Binding (Needs no reference set) Dim...

Hi sorry to post again, but you are all very helpful and ive almost finished by DB. I have a button that has to export 4 queries into excel spreadsheets, and then open an excel spreadsheet that has links to the 4 exports and does some nuber crunching and produces a report. the button code...

ok, I added the tblPerson to the query, put the fields i needed in the report and its working. thanks!!!

Ok, i can see how you did that, and the report returns the correct casenote entry, however I need this report to be part of a bigger report, which also has the clients details. So, I took your report and made it a sub report of a Rpt based on the tblPerson, however I now get all the records...

sorry, this time with attachment

Thanks for spending time to look at this, i attach a stripped out version of the DB. you will see in frmMain there is a button which says print full report, this one works fine, what i want to do is press the button in the casenotes subform and just print off the client details and the...

Hi Yes the form is open at the time, the button that calls the macro is on the sformCasenote form and the CaseID field is on there too but not visible.

Thanks for your quick reponse, I have just put that in and it comes up with an enter parameter value box for Reports!rptCasenoteEntry!srptCasenotes.CaseID i put a value in and click ok, then it asks for the value for Forms!frmMain!sformCasenotes.CaseID the report it gives then has every...

Please help, I have a form called frmMain, containing a Subform called sformCasenotes. SubformCasenotes is a datasheet form with a button which I want to use to print the individual entry in the datasheet. The unique identifier on this subform is called CaseID. The field that binds these 2...

Its ok, I think I have it working now, I recreated it all as I noticed a strange relationship in the tables created by the lookup. Thanks for your help Kev

Hi again I have tried this also: =DLookUp("Multiplier","tblFreq","FreqID = " & [Forms]![frmIE]![RentFreq]) and get #Error could the problem be something to do with the criteria being a lookup combo box on the form?

Thanks for your quick response. I should have said, i have tried this also: =DLookUp("Multiplier","tblFreq","FreqID = '" & Forms!frmIE!RentFreq & "'") and get #Error Thanks again

Hi all I have been researching this problem for a while now but still cant sort it out despite trying lots of ideas i've found on this site and others. As background, i'm fairly new to access, only done a couple of basic (really basic!) courses through work, so please treat me like an...