Search results for query: *

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...

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...

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 =...

Hi all, I have some code that transfers a range of data but it copies and pastes all the formatting from the original range which I don't want. I've tinkered around a bit with it but can't seem to fit the PasteSpecial function xlPasteValues into the code.Any suggestions???? Here is what I'm...

Hi all, I'm try to automate the transfer of a large list of data from a report to an archive. I've a basic macro that will move it across but you have to select the data to move and then you have to make sure that the cells it'll be transferred to haven't got data from the previous weeks or...

I'm trying to get each cell in a column to give the user a list to choose from when they click in it. But I also want them to be able to add to the list if the item isn't there. I'm using a data validation list at the moment so is there any way of adding to the data validation list through the...

I'm trying to get each cell in a column to give the user a list to choose from when they click in it. But I also want them to be able to add to the list if the item isn't there. I'm using a data validation list at the moment so is there any way of adding to the data validation list through the...

Hi all, Is there any way to enter data into a combobox and create a list that way instead of having to pre-prepare a list to use?? I trying to create a list like the "Autofilter" and the "pick from list" shortcut. Can any body give me some suggestions. Cheers, rob9740