Search results

Hi All, Just in case anyone is interested I have now fixed this issue. I was doing a TRIM on the mouse down event of the combo box. This seemed to be causing the problem. I have now amended the RowSource code to... issue_no.RowSource = Trim("Select Q_BoM_Issues.[new iss] " & _...

Er, not sure about that website, I got some security warning about running code on my PC, think I'll avoid that one Thanks

Hi Daz, Thanks anyway, my code is a simple 'RowSouce' code which updates the combo box on lost focus event of text box issue_no.RowSource = "Select Q_Issues.[new iss] " & _ "From Q_Issues " & _ "Where Q_Issues.doc_ref = '" & assy_no.Value & "'" MP

Hi Daz, Thanks for your reply. I had already tried this, I can make the list display 25 items, but again when the list is longer than this the same problem occurs. I would prefer to keep the list at around 16 ish. The list changes per part number entered. The one I am using at the moment is...

Hi All, I have a working combo box on a form that displays issue numbers for part number typed into a text box. This all works fine when the list of issue numbers is below the displayed list (16), but when the list is longer than 16 you cannot seem to select anything after item 16. When the...

Hi All, Is there a way of adding a bookmark to a report, in access 2010, so that users can jump to the top? I have a long report grouped by customer. I can add a button to each group to click on, but how to I reference the top of the report or jump to a field at the top. All I have found...

Thanks for the links, I will take a look. further info, I forgot a bit of the code.. Set fs = CreateObject("Scripting.FileSystemObject") Set readContent = fs.OpenTextFile(pathLong, 1, 0) lineRead = Mid(readContent.ReadLine, 77, 40) Where pathLong is the path and file name and lineRead is...

HI All, I am trying to read the first line of a file in access 2010, but it is not returning the correct text. I am using code Set readContent = fs.OpenTextFile(pathLong, 1, 0) lineRead = Mid(readContent.ReadLine, 77, 40) the result of lineRead in access is - ?A ???? ?????
@ ???A...

So sorry for the delay in responding, I have been completely side tracked recently. The names are coming from a separate table and will be manually assigned. The query result is a list of jobs and I want to allocate a name to each one and then run report for each name. I now have a working...

Hi, I am running a query on a linked table. With the result I want to add a column of info (persons name), so I can run a report based on theat name. I did and update query to a table, added the 'name', but when I re-run the update query to get new info, it just added all the same info...

OMG.... I was using DISTINCT as the query was returning duplicate results and 'Group by' would not work, but DISTINCT did. I removed distinct but the query failed to return the correct results. So I wondered about the 'unique identifier' that I picked when importing the table.... so I...

'wbom' and 'cst' are both linked tables

Ok Thanks, code for query is quite simple [I think] SELECT DISTINCT wbom.pstk, wbom.issue, wbom.sstk, cst.u1, cst.u2, cst.desc2, cst.desc1, cst.desc3, cst.source, wbom.[no], wbom.desc FROM wbom INNER JOIN cst ON wbom.sstk = cst.pstk ORDER BY wbom.issue, wbom.sstk; The Report has two sub...

If I put the 2 parameters (937-1402B and 3.2/E2054/04) direct into the query and save it. Then just use DoCmd.OpenReport "BoM", acViewReport for the form button click, it only takes around 6 secs to produce the report. Martin

Ok, so in this configuration, when I click the button it takes around 19 secs for the status bar to say 'running query', and then around 4secs for the report to appear. Total around 23secs. :confused: Martin

There's an idea, I will need to try this tomorrow. Cheers

pstk would be in format = "937-1402B" and issue would be in format = "3.2/E2054/04" Thanks

Ok, finaly got around to re-creating this form, but with no luck. I have also tried passing the info using a double click from another report, using the same code, but it still runs slow. Thanks Martin

Thanks, but these are linked tables that I cannot change. However, pstk is indexed 'Yes (No Duplicates)' and issue is indexed 'Yes (Duplicate OK)' Thanks

Thanks, but not sure I understand.....