Search results

Ranman256, I have the form in datasheet mode and can set the column widths with the mouse. Setting the row height using the properties box only changes the row height for the records not the column headers, which is what I am looking to change.

I have a sub-form which opens in datasheet view. Is it possible to increase the height of the column headers and wrap the text, so that I can reduce the column width and still not lose any text. Also each column header has an arrow to allow sorting. Is it possible to turn this off within the...

All thanks for your help, I have got the following to work; [Text1]<=[Text2] And [Text1]<=[Text3] And [Text1]<=[Text4]

snueberg, thanks for your reply. I have this formatting to repeat 16 time on the one form, so was hoping that one expression for each text box would work, but never mind once its done its done! Thanks for your help

Gents, thanks for your help. Unfortunately I don't yet understand VB, so was trying to use conditional formatting. What I'm after is along the lines of IF "Text box1" <= "Text box2" OR "Text box3" or "Text box4", then text in Text box1 changes colour to red. All text boxes have a numerical...

I am trying to conditional format a text box to make text turn red if the number in the box is less than or equal to the number in 3 other text boxes in the same report, is this possible?

Paul, Thanks for your help, found DFirst was what I needed, =DFirst(" [110-1]![axle serial] ","[110-1]") worked just fine

The DLookup() seems it may work, but how do I select axle position 4 from the query 09ts data by even130. I have =DLookUp([09ts data by even110-1 last turn],[serial number]=4) but this returns #Name? in the text box in the report

I am a novice to MS Access and not familiar with VB, so is it possible to copy and paste a value in a cell in a query to a text box in a report? I have managed to create a macro that goes to the value I require in the query but haven't found a way of for a better word "pasting" it into a text...

plog, as you can gather I'm not that familiar with access. but in the hope someone can help, I attach an updated spreadsheet. the result of the required query I would expect to be row 2 on 3rd tab. If I've pushed your patience too far I understand. Thanks, Ben

I appreciate you patience. I have a query "all turn data" that adds the turn description, column H. what I need from the second tab is the serial number so I can add it to a report, see attachment, 3rd tab, the unit number is taken from another query and is selected using a combo box on the...

find attached another spreadsheet. Hope this helps some. Unfortunately my access file is 16Mb and source excel file is 6Mb otherwise I would upload them

sorry, give me a few minutes

attached is an excel spreadsheet with a sample of the data I use. below is the data filtered down to even number and axle position, I need to filter further to the last date for the specific data. Thanks

Hi all, I have a query that I need to filter results from 2 fields. I have one field that filters data of 1,2,3 or 4 to return a 1. but I need to filter that further to return the last entry by date. I have used DMax("[date]","09ts data") in the date field, but the query returns empty fields...

Ken, thanks for your patience. I have created the button, when I right click and select build event I am faced with a VBA page, where do I put my piece of code. Below is the code I am faced with; Private Sub Command61_Click() On Error GoTo Err_Command61_Click...

The code I have is; Sub Copy_One_File() FileCopy "A:\USB2.0FlashDisk_sda1\LATHE_DATA.xls", "F:\Victoria Line\Bombardier\Maintenance\Lifting Rd and Wheel Lathe Team Documents\Wheel Lathe Documents\Wheel Lathe backup\LATHE_DATA.xls" End Sub This code works when I run the module but I don't...

Thanks for your reply Ken. I have created a module using the copyfile command. How do I run this module from a command button on a form. please keep as simple as poss as I'm a novice to Access. Thanks

I need to copy an excel spreadsheet from my memory stick, E:\, onto my hard drive. I will have a command button in a form that will run this code. Would be grateful for any help as I have no idea where to start.

Sorry, I wasnt aware it was password protected