Search results

Hi Arnelgp, I haven't used the splitter control before- is the idea that in form view you are able to drag the subform's to increase their size? like changing the size of a text box? Please see the image I have attached... I am assuming I will need to change something in the settings in the...

Thank you Ridders, I think you could be right... No quick fix here. I will set about rebuilding it in the morning. I will check the widths to make sure they're the same, if they are different will the auto scaling not work? Simone.

The form is part of a larger database, I do have individual search forms as well. However the purpose of this form is to bring up all the documents related to one product and it works a treat... Apart from the scaling!:banghead: haha

Hi Guys, Having some auto sizing issues. See attached pics. My original form (RC13) was all good then I added to it and now its not resizing (RC14). I have checked the settings and they all look the same. Any tips? Thanks! Simone.

Awesome that's good to know...now to find it :D I'm using 2016 Thanks, Simone UPDATE: I found it haha

https://www.techonthenet.com/access/queries/max_query2_2007.php This is for older versions of Access the version I am on doesn't have a 'total' column otherwise this would have worked.

Yes I was thinking a query was the way forward, I haven't had much practice with queries- if I make a query with the two fields drawing number how do I display the highest issue for each drawing? In criteria (data sheet view) I tried max(Issue) but get the error of having an aggregate in a where...

If [LatestIssTxt] = "Latest Issue" Then DoCmd.SetWarnings False DoCmd.RunSQL "UPDATE DWGIssueControl SET DWGIssueControl.LatestRev ='Old Issue'" & "WHERE (((DWGIssueControl.DrawingNumber) = '" & Me.DwgNoCbo & "')) AND((DWGIssueControl.Issue<'" & Me.Issue & "')) " '"...

Hi Minty, My column headings are ID, Drawing Number, Drawing Title, Issue and Issue Date. There are multiple records with the same drawing number and title but they have different issue numbers and dates. The reason there are multiple drawings of the same name/number is as the drawing are...

Hi Minty, Great suggestion, I have an issue date already in my form/table. As I have lots of different drawing numbers each with lots of different issues/dates how do I set the max Issue date for each set of drawing numbers. I have a separate continuous form to search through all the...

Hi Guys, I have this code behind a save button, I'm trying to automatically update my table from a form when a user up issues a drawing to a new rev. If [LatestIssTxt] = "Latest Issue" Then DoCmd.SetWarnings False DoCmd.RunSQL "UPDATE DWGIssueControl SET DWGIssueControl.LatestRev...

Your advice to divide, simplify and conquer definitely helped me get to a solution and look at the problem from a different angle! Thanks.

Thank you all for your help, annoyingly I didn't manage to get my search form working with the union query I gave up when I realised Hyperlink fields built from the query were no longer active. I did get a working form I just went about it a different way. My solution was... rather than having...

Thanks for the tip! Will definitely try this :)

Hi, Thank you for your response, I just tried your suggestion and while I got no errors the results are records are not displaying. Just blank when you click. Will go back to trying individual WHERE statements. Thanks :)

Hi Minty, I have attached a screen print of the error I get when I remove the quotes and space's. I have never used Debug.Print before, I have added it into my code like you said and opened the immediate window but nothing happens. I'm not sure how it works. Thanks for your advice! :)

Thanks, Great advice!

Errrrrmmm... This is what I came up with but on click no values are shown even when the keywords text box is empty. Private Sub SearchBtn_Click() Dim SQL As String SQL = "SELECT [DDP Issue Control].[DDP Ref] AS [Document Number], [DDP Issue Control].Description, [DDP Issue Control].Part...

I tried the exact same thing first Minty! I'm running access 2016 and keep getting errors when I remove the spaces and quote marks .

Hi, Thanks for the speedy reply, I had figured the WHERE clause was only working for the last one. Do I place the individual WHERE clause's before the UNION's? I thought someone might pick up on the table structure...The Data in the query isn't the only data in each table, I have only picked...