Search results for query: *

Hello folks, I have figured out that the problem is associated with the date field. Whenever I include it in the list of fields it messes up the query. I dont know why or how to fix it. I am connecting to a pervasive b-trieve database which stores its date format in a unique manner...

Thanks for the response Leslie. I can do a loop like that: Do While Not OrderSet.EOF and it works. I also tried using the recordcount after going to the last record. The problem is that the actual data being returned is not correct. The system tells me there are ten records when I use...

PH, Thanks for the response. Does that mean that you first have to go to the end of the ADO record set to get the correct count? It seems to work fine when I select just one field rather than multiple fields in the first example. In the second ne it works fine with multiple fields but not...

Hello experts. I am having a problem with my queries producing inconsistent results. They are part of a button on an Access form. When I change the first select line to: SELECT ORHDR.Ordno FROM ORHDR WHERE It works fine but when I select wildcard or multiple fields it gives me incorrect...

Thanks for the response Paul. That makes sense but I am not clear on how to put a pagebreak in the detail section. I have tried this, PageBreak = True Is that correct? Thanks again Callum

Hi Experts, I am trying to create a report using code and have it begin a new page after printing out 15 records. It appears the system can not move to a new page unless the size of the section or group is larger than the page. When this happens it does not format properly. Is there a way to...