Search results for query: *

Hi Derek, If you run the query on its own can you see if any of the values are null or have a space in them? For using the code version i would use the isnull() property rather than checking for an empty string. So your code would look something like: Private Sub Detail_Format(Cancel As...

Hi Derek, Have a look at the properties of the text box if you set the can shrink and can grow properties to yes it should make the text box disappear automatically if there is no value in it. Let me know if it works for you. Rob

It works fine for numbering the records in the individual sub-reports using your method. I tried using it on the main report itself and it only numbered the first sub-report but didn't number the records in it or any of the other sub-reports. I'm going to try and use a global variable and...

Cheers Paul, The Main report doesn't hold any records as such it just combines the three sub-reports to display the records, if that is any clearer. What I would like is that all records will be numbered, but would be possible to have the number increment over the three sub-reports? Cheers, Rob

Hi all, Wondering if anybody has done this or knows if\how it can be done. I have a report that has 3 sub-reports on it. I want to give each record that comes up in the report a number, like the first record in the report is 1 etc. til the last. The sub-reports get their info from parameter...

Hi all, Wondering if anybody has done this or knows if\how it can be done. I have a report that has 3 sub-reports on it. I want to give each record that comes up in the report a number, like the first record in the report is 1 etc. til the last. The sub-reports get their info from parameter...

Hi all, Would anybody be interested in having a look at my form and its VBA code because I can't for the life of me figure out why its doing what its doing. It seems to me that the form reads the VBA code and decides itself what lines of it it will follow at the time. I'm only a novice at VBA...

Hi all, Would anybody be interested in having a look at my form and its VBA code because I can't for the life of me figure out why its doing what its doing. It seems to me that the form reads the VBA code and decides itself what lines of it it will follow at the time. I'm only a novice at VBA...

If you run the query with a specific date rather than as a parameter are you getting a count? Because all I can think of if you are getting a 0 count value is that your query isn't recognising a date value in the qeuried table,maybe??? It could be just the date format of the field or you might...

How does the selection variable work??? I'm presuming this won't put the format of the reports I've designed into Word. I'm just wondering if it made a difference that the form is opening the report directly and the query criteria is being passed this way?????

Cheers Craig, but it's still asking me for the query criteria that are passed to it by the form.

Hi all, I was wondering if anybody can help me with this. I'm trying to export a report to Word. I've looked through the posts and found a few ideas and tried them but.....I can't seem to get them to work for me. Basically I've a report that contains 4 sub-reports which are generated from...

Hi all, Could anyone give me a hand here. I have a form that has an unbound textbox to enter search criteria for a table. I'm using the code below to search the table and open an another form to view the details and it brings up a blank record if the criteria isn't found. Is it possible to bring...

Thanks aswell PaulF, looks a little complicated but I'll try it along with Wah's contribution. Is there much difference between the two in what they do???IS one method more\less error prone??? Rob

Cheers Wah it works like a charm. I'd never thought about using the events for the form. Cheers again, Rob

Hi all, I was wondering could anybody help me out here. I've a checkbox that I want to use to disable two textboxes on a form, but only for the current record. I can get the checkbox to disable the textboxes but it does so for all records on that form which I don't want. Also if I close and...

Hi all, I was wondering could anybody help me out here. I've a checkbox that I want to use to disable two textboxes on a form, but only for the current record. I can get the checkbox to disable the textboxes but it does so for all records on that form which I don't want. Also if I close and...

Hi all, Anybody know why the code below causes MS Office 97 on NT4 to crash after a few iterations?? Or is just one of those microsoft things???Anybody any ideas?? Public Sub Filter_List() With Worksheets("CriteriaValues").Range("Criteria") .Cells(2, 1).Value =...

Thanks a mil tsuji, it works like a charm. Thanks again to Dale and Abi for your help too.

Cheers you guys. Abi: I'm gonna play about with it for a while and see how I get on with checking the blank cell in multiple columns. I'll let you know how I get on before I throw the PC out the window!?!?!?! Dale: Cheers for that, I was having problems with the syntax before cos the help file...