Recent content by maverickmonster

Have found this think this is what i need to do http://support.microsoft.com/?kbid=208541

I am nearing completion of my reports Everything is going well but the only thing that looks bad is that when a report gets splits over two pages it there anyway to keep the report together on next page rather than splitting it up ? Cheers

Thanks all for response's I have used xlbo's code, i would do use the excel code normally but as i have to right a huge chunk of code i may as well include this so the whole sheet is with out formula Cheers Maverickmonster

Hi I have some date data that is stored backwards and am correcting it as part of a process. I have written something (below) which should do this. The current date is held as "19860317" under the general format. I can not format in excel as a date. When i run the program it seams to work...

I have a sony laptop and wish to output what is on my screen exactly ( not dual monitor ) . I have a work mate who it works for so the projector is good . The setup is the same , refresh rate, 32 bit of colour and resolution. Is there anything i am missing. On the sony normally you have to...

Thanks very much I would have your children (Thats how happy i am ) Cheers Have a beer on me Maverick Monster

But how can i interchange this (from straight null in the insert and to the user input varible) depending on whether the user inputs are bad or not ! If the user wants to enter information in any of the fields this is fine it will be input and inserted , if they wish to leave it blank then...

Here is what i currently have : If Not IsNumeric(txtAHD(0)) Then ahd0 = Null Else ahd0 = "'" & txtAHD(0) & "'" End If If Not IsNumeric(txtAHD(1)) Then ahd1 = Null Else ahd1 = "'" & txtAHD(1) & "'" End If If Not IsNumeric(txtAHD(2)) Then ahd2 = Null Else ahd2 = "'" & txtAHD(2) & "'"...

bjd4jc - I see this zero length field for text field in the database but not numerical fields. If IsNumeric(txtAHD(0)) = False Then txtAHD(0) = Null If IsNumeric(txtAHD(1)) = False Then txtAHD(1) = Null If IsNumeric(txtAHD(2)) = False Then txtAHD(2) = Null If txtAHD(3) = "" Then...

When inserting null's or blank into a table via VB6 front end into access using ADODB the vb code bombs out and says field'ad.name cannot be a zero length string I have this problem on inserting blank or null into dates, numbers and the above mentioned strings fields in databases. Is this a...

one of my sub reports is called "AD Query" is that the subreport control (see example below) as it asks for the information ? =IIf([AD Query].Report.HasData,"","Sub Report One is Empty")

Spot on thanks mate :-)

Yeah thats good but if i try to add more fields then the error comes of "you tried to execute a query that does not include the specified express "Name" as part of an aggregate function" How can i add extra fields ?

I have a table with lots of information but importantly with a URN (Unique reference number) and a date. I want to take the latest date for each member how can i do this via a query ?

I have a question i have made some of the sub reports on the main report , How can i make a conditional statement at the end of the report to show which tables were not included because of no data