Search results

bob thanks but i mean more i want to return the text that currently is in the label

WHat i am trying to do is return whatever i have currently in a label as a string field Any ideas would be great

bob nevermind solved it read up a link pbaldy sent a while back and used it to help with this one http://www.access-programmers.co.uk/forums/showthread.php?t=148020

nevermind guys figured it out stupid filters lol

when i run the following code i am getting a bad DLL calling convention can anyone help cause it was working now its not :( Call Report_filters(strrpt, Datewhere, dateto, datefrom, opt) Public Sub Report_filters(strrpt As String, Datewhere As String, _ dateto As...

bob what i think my problem is im trying to apply the filters before opening the report but i dont know how to pass the filters to the report with openarg like i can to a form. The reason i need to filter instead of criteria options as you would prob know is using the pdf output option doesnt...

the today part bob sorry is part of an early code to format the date field to a 6 character number.

what i am trying to do is enable or disable report filters on a report depending on a check box i choose on a form everytime i do this with the following code i get an error messgage Error 2451 the report name doesnt exist when i know its there i dont get what i am doing wrong can some1 help...

Bob thanks again mate that is exactly what i was wanting. All working great :) Hope someday I get capable enough to repay the favour with all the help everyone on here has given me.

Thanks Bob that is what i am looking for now to figure out how to use it :)

bob sorry i mean its more that the report isnt an option or control on that other form i mean to say if form1 opens frmREPORTOPTIONS set strrpt to rptFORM1 etc

ok guys i am having a mind blank moment here. What i want to do is i have a form that has an option box to give various options on how i want to view the form e.g (pdf, email etc) this form is called "frmREPORTOPTIONS" this side of it i am fine with. However my problem is i want to store which...

dcrake i more mean to open, openoffice and view a graph that was based on one of my queries in access.

is there a way to export a spread sheet to open office rather than excel? the reason is not all users have access to excel and since open office is free if i could export my graphs to that it would work much nicer for me. Thanks

thanks mate knew i must have been missing something silly

ok i am trying to get a query in vba to change its header some of its fields depending on an integer i have set (p) valp = "VALUE" & P qtyp = "QTY" & P sql = "SELECT (DateDiff('d', [Forms]![frmCOMPARISON]![txtDATEFROM1],(HTRXTBL.HTRX_TRX_DATE))) AS DAY, " & _...

just query designer in access bob

bob still no luck on that one:(

ok guys i know this is really stupid and silly but i cant see for the life of me what i am doing wrong i have a query where i want to only show records between to dates (including first and last) when i do both or less than one date nothing shows using the code below SELECT...

adam are you saying store the filters in a table or are you saying store each set of results in a table???