Search results

Hello I'm trying to sort the columns on a crosstab query by date where the date is grouped using a function such as format([apptdate],"mmmm/yyyy") I've looked in the other posts and the suggestions seem to say more or less the same thing i.e try yyyy/mmmm etc. The problem is no matter which...

In answer to my own question Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) DrawLine End Sub Sub DrawLine() Dim rpt As Report, lngColor As Long Dim sngTop As Single, sngLeft As Single Dim sngWidth As Single, sngHeight As Single Set rpt = Reports(Me.Name)...

Hello Fool that i am i'm trying to develop a dynamic cross tab report. I've nearly finished but i need to resize some lines on the report as the report width varies depending on how many columns i've got. Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) dim Objcontrol as...

Well i'm glad something works, if you have any more questions dont ask me!! only joking. Chris

Hello I'm happy about the make table part, it's more the creation of the report. Now i know ( thanks loony22) that you can set the controlsource of an object at run time it's a question of creating multiple instances of the object ( is this possible??) to assign the control sources to and then...

Hello Sorry if i'm not getting the right end of the stick here is my test example. On the form if you click the check box and enter 3 in the text box you get 1 record back. If you then uncheck it and click the button you get all records back. I'll promise to give up if this is wrong!!

Doh, It's weird how you can know stuff like setting the controlsource for a textbox in a form etc but when you see it in code you (I) have a total blank. Anyway that actually really helps me with a problem i've been having. Cheers Chris

no worries

Hello try putting this in a blank column in the query nameleftchar: Left([First Name],1) Chris

Hello No just put in an extra column in the query and write this in the top where the field usually goes FINDALLENTRIES: IIf(IsNull([Your field])=False,2,2) then stick this in the or section. Like (IIf([criteria.notesactive]=0,2) Chris

Hello Just wondering what the difference between controlsource and recordsource?? Chris

Hello Think i've solved it first under the field [your field] stick in the criteria Like (IIf([criteria.notesactive]=-1,"*" & [criteria.notes] & "*") this will select all records containing anydata like the entry in the textbox because of the wild cards at each end, just lose them if you...

Hello What about Like IIf([criteria.notesactive]=-1,[criteria.notes],"*" or isnull([criteria.notes]) = true) Chris

Hello Are you using the query builder or code in VBA?

Hello Could be completley wrong here (nothing new!) but should the statement read ??? IIf([criteria.notesactive]=-1,like([criteria.notes]),"*") Chris

Hello I just posted this to the forum http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=33540 and it got me thinking. In VB v5/6 you can create an array of objects such as text boxes and postion them on a form during run time. Do you think it is possible to do a make...

Hello This sub will return all of the fields in a table to an array. You need to put it in a module. ' put this at the top of the module ' it will allow you to access the fieldnames from another sub public Fieldnamed() As String Public Sub gettablecolnames() Dim db As DAO.Database Dim tb As...

Hello Thanks for the suggestions. I've tried every combination i can think of and whilst i can open the DB no problem nothing will run the macro. Back to the drawing board! Cheers Chris

Hello Thanks for the suggestion, but there appears to be a problem with the arguments. Some work some don't. I suspect there may be some options unchecked or maybe there are network permissions for opening DB's which i haven't got, who knows!! Chris

Hello I am trying to run a .bat file to open a data base and then run a macro. From what i looked at in the forums and the help file this should be the correct syntax: "M:\Information\procedures\OURLOG.mdb" /x EMAILREPORT with /x as the switch to trigger the macro. I have mananged to get other...