Search results

Hi ken ChqRecNo is set as a number in the table...cheers Fi

Hi I have tried using this in the before update event of ChqRecNo on a form, it is getting stuck at [Forms]![frm_DataForm_ChqRec]![ChqRecNo] = "" giving the error message Runtime error 2115 The macro or function set to the BeforeUpdate or ValidationRule property for this field is...

I have been looking thru the forum to find a way to password protect a form using a table holding the User ID and Password the solution by Supercharge works brilliantly if anyone else is looking for a similar solution, i adapted it slightly so it works from a button on the switchboard...cheers...

oops ...i would never have worked that one out !!:D

ahhh...will see how I get on with this looks daunting but a challenge..thanks again for your help will let you know how I get on ..thanks for your patience..cheers Fi

Hi...all i can get from help is one topic 'Access 2007 reserved words and symbols' when you go into this it list all the reserved words but not any examples...what did you type into 'Help' to see examples....:o cheers Fi

Hi Namliam..looked at this in access help but due to being a novice really dont get it :confused: sorry will keep at it and perhaps the penny will drop ! cheers Fi

Hi Again...to have the list show only one table, in this case tbl_Contacts is it possible to exclude all but this one from the list ?? cheers Fi

Hi Namliam...and thanks to you also.. M$ may have not reached Gibraltar yet :p

Hi Bob...that worked a treat thank you very very much..i can feel this may lead to another question when i try to do the next part of what I am trying to do !!! cheers really appreciated Fi

Hi NAMLIAM apologies but what is 'M$' ?? I am using MS Office 97 and a novice !! will look at what you suggested to see if that gets me there I changed Type -32764 to Type 1 and did get the tables to show but it also listed what looked like some system tables also, so it was pretty close but I...

hi.. what i tried to do was put this code in the row source of the list box I would like to use to view the tables in my DB, I have it working (from another good thread ...) where it shows the reports on my db which I can double click on to open them up, that code is SELECT MsysObjects.Name...

Hi Im trying to make the tables visible from a list box and found a thread with this, which looks like it is what I need unfortunately I get a syntax error, I have tried amending the code but my knowledge is fairly limited, could anyone hlp me ?? thanks in advance cheers Fi SELECT...

Hi I read your WkNo solution which was just what I was looking for thanks you very much, would you know if this can them be converted to the weekending date of that week number eg wk1 would be 06/01/2008 ?? thanks in advance Fi

Hi..I managed to sort out the problem I mentioned above and will post how I did this for anyone else who may come across the same prob..however I now want to summarise the data by supplier ie show the list of suppliers with their total liability rather than the liability against each order, I am...

Hi Bob thanks again for looking at this I look forward to your solution...cheers Fi

Hi Rich thanks for replying, I agree it does look like that but the field on the DetailFooter on the subreport is SubTotal and that seems to be what I am referencing to on the Main Report. I tried putting a GrandTotal on the SubReport, Report Footer and referenced that on the Main Report and...

Hi Not sure if I explained the problem well enough in my last post as to what I am still having probs with, I have followed Pats advice and am now able to show the total from each record on the subform on the main form but still cannot work out how to make the Grand Total of the subreport show...

Hi Mithiani, sorry not sure how to upload a report only ? Pat, I have done as you said above but am still not getting it to sum correctly, when i put the sum in the report footer of the subreport it worked fine, but on the main report the Report Footer shows on the subreport as the sum of each...

Hi Pat, this seems to be almost working I'm using =[Report].[rpt_sr_DlvdDetail]![InvoiceValue] as the control source for the text box on the main form that picks up the Invoice Value from the subreport but it is showing the first invoice value of the whole selection only, through the whole...