Recent content by Nitibob

Hi all Got a perplexing problem which I'm sure some of you can shed some light on Developing a piece of code to open and run reports and had got part way throught when i decided to test it...the code so far: Sub RunReport() Dim buso As busobj.Application Dim DP As busobj.DataProvider Dim...

Hi, Went on their Universe Designer course a few years ago and found it very good. They teach from the offical guide but they apply good working examples They would get my vote

Do you want seperate PDF files or one single one split out? If its the former, you need some code to filter on your criteria and save the snapshot. If its the latter, just set up some seperate tabs...based with filters or sorts... then when you save the pdf file it will be seperated out...

I think what you need here is an alias table. If you want to access the same table twice - then you rename it as another name. If you are doing this in the query grid, then add the table colors to the query twice - linking them to the relevant fields on person . Let me know if you are...

Hi all, I continued to play with this and got it to work at last!!! Its a bit bizzare...but it now works... thanks to both bill and centurion for all their help!! strMonthSQL = "SELECT tblSettledAudit.* INTO tblSettledReporter " & _ "FROM tblSettledAudit LEFT...

Thanks Bill, Will do...can't actually send it til later on today!!! Thanks

Hi Bill, Its still giving the run time error - its expecting parameters where there is none???? I'm confused!!

Hi there, the field dtmDate is of type date/time - does this have any bearing on the way the code needs to be written?

thanks CajunCenturion for your quick response, I have checked the field and table names, these are all fine - any other ideas? Thanks

Hi all, I think I'm making a schoolboy error here but I can't see it. It is giving me a 'Run-time error: 3061' - Too Few parameters. Expecting 1' Can someone give me any advice please? Private Sub cmdMonth_Click() Dim wks As Workspace Dim dbs As Database Dim strMonthSQL As String Set wks...

Had some use of this tool on Excel97. In my experience, i thas been very good. An exsisting form with cica.50 fields has been converted into a good data entry form. I had problems with different types of filed type - so i used the wizard to import as txt and then exported to another table with...

Hi all, I have asked this question on the office forum but been told you guys might be able to help I have an excel form that has various calculations and subsequent percentage formats that I would like to export to a table in an Access Db. Using the template wizard seemed the best way - BUT...

nope, i have tried to specify all the cells in the excel s/s with the correct format: number, percentage, text, date BUT it is turning it all to text

Hi all, I have an excel form that has various calculations and subsequent percentage formats that I would like to export to a table in an Access Db. Using the template wizard seemed the best way - BUT it imports all the fields as text...is there a way around this..... or do i need to do...

Hi, You could also use Application.WorksheetFunction.Even(value)