Search results

PLease can anyone help. I have a subform in which I display a load of records in datasheet view. I have a check box on the sub form but I can't for the life of me hide this. I've tried opening the form in form view and then selecting Format->Hide Column, but then as soon as I close and...

I am trying to use the backcolor or forecolor property in a field in a form that displays in datasheet but it won't work. It's fine in form view. Does anyone have any ideas as to how I can get the field to show a backcolour AND display it in datasheet view? Thanks

SQL (within VB) above. I have found now why it doesn't like it: In my SQL I say "SELECT * FROM qry1 WHERE TextField1 <> 'Tracy'" but I need an nz, so it should read: "SELECT * FROM qry1 WHERE Nz(TextField1) <> 'Tracy'" so it can't compare null 'not equal' to 'Tracy', but it can compare null...

I am trying to do the simplest thing adn I think I must be doing something v v v silly. Dim rs as new AdoDB.recordset rs.open "SELECT * FROM qry1 WHERE TextField1 <> 'Tracy'", currentproject.connection Unfortunately it return EOF. It seems it doesn't like the <> operator, nor !=, nor 'NOT'...

Hi, Please can someone explain how to redim a dynamic array. I declare my array as follows: Dim MyArray() as Variant The brackets are empty so that it is a dynamic array. I want the array to have three columns and unsure of how many rows as yet (hence it's dynamic). So I used the following...

Hi,. I am trying to use a criteria in a query as follows: Description like "*" I want to retrieve all records where the Description contains an asterisk, but at the moment (as expected) everything is returned, because asterisk is the wildcard. There should be a charcter I can precede the...

Yeah, sorry, I'm being a div, it works fine. Thanks

Still no luck. Can't set the format to 0.00. I tried setting it to fixed with 2 decimal spaces but it just won't display them. I'm completely out of ideas here. Sure there must be a way.

Thanks for the tip, but if the last decimal place is a 0 this doesn't work. So, for example, 15.00 will still display as 15, 15.30 will display as 15.3 Any other ideas?

Does anyone know how to specify how many decimal places are displayed for a decimal in a field on a form. I am currently using the round function So Round(x / y, 2) This displays x / y rounded to 2 decimal places. Muy problem is that if x divided by y is an integer (i.e. no decimal places...

Nope, neither of these change anything. You don't need square brackets round the field name unless it contains a space, plus I never put the semi-colon at the end of SQL unless it's in a query grid. My first statement works fine without the semi-colon. It just seems to be the * wildcards it...

Please can someone tell me why the first statement works fine, but as soon as I introduce a wildecard - * -, it won't work. Any ideas would be very much appreciated. rs.Open "SELECT * FROM Query1 WHERE Code = 'GR1'", CurrentProject.Connection rs.Open "SELECT * FROM Query1 WHERE Code like...

Thanks that does help. I'm using Access 2000 si I will forget the whole idea! Easy life....

Any ideas on how to get the reports saved in .pdf format? Thanks

I want to send the reports electronically, but allow the recipients to copy and paste. At the moment I send them using snapshot viewer but they can't cut and paste from that. I've tried outputting to word but too much of the formatting is lost. I think we have Acrobat reader which I...

I want to send the reports electronically, but allow the recipients to copy and paste. At the moment I send them using snapshot viewer but they can't cut and paste from that. I've tried outputting to word but too much of the formatting is lost. I think we have Acrobat reader which I...

Does anyone know how to save a report to a .pdf format or any other format from where you can copy and paste. Currently I am using snapshot viewer but it is not possible to copy and paste from this format Thanks

Use Instr to find the position of the first space: PositionOfSpace = Instr(1,namefield," ") Then use Instr again to find the position of the second space, but start searching the field one character after the first space: PositionOfSpace = Instr(PositionOfSpace+1, namefield," "). Keep...

Hi, I am trying to send some reports electronically, which is fine using snapshot viewer. However you can't copy and paste from snapshot viewer, which is a pain. Does anyone have any ideas for what I can save the report as in order to be able to copy and paste from it? Thanks Tracy

Thank you very much.