Search results for query: *

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

ok started down the long road of making all the sub forms thanks for the advice so far. Does anyone know of how many sub forms i can include i dont want it to say i have used up to many controls halfway through making it ?

Are you still looking for a solution? Yes Did you try some solutions? Yes I tried making a query but all the information doubles up. . . How do you make a report with sub reports ? (The sub reports would have to be conditional if there is any data in the conisponding tables) Did you consider...

Tried making a report but looking at the query it is not what i wanted to do anyway

I would like to list my tables in an alphabetical format but only show this if a member has the information in this table, also. My main table is called BPD and the only table where a member will have details. Hence the BPD table always at the top then any other information in from the relevant...

I have just tried this with two of the thirty tables and it crashes and said that there is too many fields ?! Thanks for the reply tho