Search results

Thank you, job done!

Hi All, I am writting a report and would like to cut and paste clips of code from the VBA window into the word document. Cut & paste works obviously but what would be nice is if it kept its formatting for layout and also the way it colours the code. I dont really want to do a screen grab if I...

Hi Folks, I would like to know if there is a way of testing for values using an IF statment. I know there is but my knowledge of IF statments does not extend to this senario. So what I want to do is basically test for the following: OrderPlaced = -1 AND FromStock = 0 AND Arrived = -1 AND...

Hi Folks, I have one table with say 4 fields, Name, Address, Size, Order and InStock. Order and InStock are checkboxes. I want a query that displays records that have a -1 status in 'Order' OR 'InStock'. Any help would be apreciated. Thanks

I have a solution, are you still looking or did you find an answer? Cheers

Yes! Sorted it!!! So simple. Ditch the brackets... Private Sub MasterLbl_Click() If Me.OrderBy = "MastRef, SubRef, DiffRef" Then Me.OrderBy = "MastRef DESC, SubRef DESC, DiffRef DESC" Else Me.OrderBy = "MastRef, SubRef, DiffRef" Me.OrderByOn = True End If End Sub Why this would...

I have tried this but the SQL is different to the VBA code. The differences are subtle but non the less they are different. Cheers

Almost worked, I used this as you suggested: Private Sub MasterLbl_Click() If Me.OrderBy = "[MastRef] AND [SubRef] AND [DiffRef]" Then Me.OrderBy = "[MastRef] DESC AND [SubRef] DESC AND [DiffRef] DESC" Else Me.OrderBy = "[MastRef] AND [SubRef] AND [DiffRef]" Me.OrderByOn = True End If End...

Can anyone help me please. This was my code that basically sorted records displayed in a form by assending order then by descending order if you clicked the header MasterLbl. Private Sub MasterLbl_Click() If Me.OrderBy = "[MastRef]" Then Me.OrderBy = "[MastRef] DESC" Else Me.OrderBy =...

Bob I have tried this but it only sorting in ascending order and not descending. Any ideas? Thanks Private Sub MasterLbl_Click() If Me.OrderBy = "[MastRef],[SubRef],[DiffRef]" Then Me.OrderBy = "[MastRef] DESC,[SubRef] DESC,[DiffRef] DESC" Else Me.OrderBy = "[MastRef],[SubRef],[DiffRef]"...

Hi Bob, Yes I am actually bringing them together on a form but I want to sort the field with this code: Private Sub lblDescription_Click() If Me.OrderBy = "[chrDescription]" Then Me.OrderBy = "[chrDescription] DESC" Else Me.OrderBy = "[chrDescription]" Me.OrderByOn = True End If End Sub...

I use this code to sort aphabetically on a field. Double clicking the header (DeptLbl) simply sorts it fine. But I want it to sort it on this field first but then on a sub field called 'Room'. In other words I want it in Department order first followed by Room order next. Any ideas ...

My problem is simple. I want to join field1 and field2 and store the result in field3. The fields are text fields and I would also not want to perform the action every time the query or form or whatever opens as this could slow things possibly in the future. It would be fine to do the join...

Sadly not, the export is as it comes from the very basic logging software. It seems such a silly thing to try and overcome, however famous last words I feel. ta

Sorry no the table grows verticaly and then branches out to the right via column expansion. Any thoughts ta

Hi Ken, Thanks for the replys. Yep its consistant and I dont mind importing it as this is what I have done. Well just a direct import into Access. But the thing is once its there, can I use Access to manipulate or rehandle it in to columns? Cheers

Here is the sample of the data. I have obviously deleted many of the rows below to reduce the file size. The rows went upto around 8100 or so ! Cheers

I have an access table that contains an exported file from another application, its electrical consumption data actually. My problem is that the export function on the metering equipment will export it in only one way. It exports it in a vertical fashion down to a set number of rows but then...