Search results

Thanks for this looks like an interesting solution which I will try

It appears from all my web searching that this is a relatively common problem (trying to use the enter key to trigger an event without effecting cursor position) and I have now solved it as follows: Private Sub txtSiteName_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = 13 Then...

Hi, I have a form which shows a list of records. To help the user find the record they want I have a text box txtSiteName which the user types into. On the OnChange event of this there is the following code: Private Sub txtSiteName_Change() Me.txtSiteNameX = Me.txtSiteName.Text...

Ok thanks, yes this is something that is used potentially daily by the users

Thanks for this, interesting approach. So, just thinking it through would I; 1) Create a temp table and copy across al the data sheet file information 2) Using select case update that table with the destination folder name info 3) Query that temp table and perform the file copying 4) Erase...

Hi, I have been toying with this module for a while and wonder if anyone can help. I have the following code which looks up some files relevant to a project record and then copies them to various directories so they are correctly catalogued for distribution to a client. As it stand the module...

Thankyou, all sorted

Sorry I don't follow?

Thanks, tried this as follows: SELECT T.Year, T.OrderNumber, T.SumOfQuoteValue, DCount("*","qryMaintOrderContractYearTotals","Year < " & T.Year) AS Sequence FROM qryMaintOrderContractYearTotals AS T WHERE (((T.OrderNumber)="MJ0092762")); But get the following results which aren't right...

Hi Sorry, probably being stupid but I cannot get this to work. Here is the SQL from my current query that I want to add another field to called [Sequence], how do I add your script into this query? Thanks SELECT qryMaintOrderContractYear.Year, qryMaintOrderContractYear.OrderNumber...

Hi, I have a totals query that returns any number of results sorted in date order. What I need is to then create a column called [Sequence] that then shows the row/record sequence number as per below: Year OrderNumber SumOfQuoteValue Sequence 2023 MJ0092763 5987.76 1 2024 MJ0092763...

Hi Pat, Thanks very much for your comprehensive reply to my post. So to give you a little more background whilst I am far from an expert I've been building by DB within our business now for 20 years + and obviously learnt an enormous amount in the time. Historically I had forms that opened with...

Thanks for this Pat, I have direct messaged you

Hi, I have a split DB with the BE (0.5GB) residing on a network drive. All users have an FE file on their local machine. All machines are at least i5's, mostly i7's with plenty of RAM running on a gigabit network. There are usually around 12 users using the DB simultaneously. I have been...

Thanks so much works perfectly

Hi, I have a module that within it I have to use the same CASE argument several times as it loops through a number of different processes as per below: Select Case rstDetail.Fields("CategoryID") Case 20, 32, 33, 34, 35, 36, 37, 56, 58, 59, 60, 125 There is the...

I've changed my tack just slightly but in essence if the value in [txtQuoteDateOption] =1 I want to filter the records retuned using the values between [txtStartDate] and [txtEndDate]. If the the vlaue in [txtQuoteDateOption] is anything else I just want it to return ALL records and not filter...

Hi, I have a query I am filtering dates with criteria as follows which works perfectly: Between [Forms]![SalesAnalysisQuotes]![txtStartDate] And [Forms]![SalesAnalysisQuotes]![txtEndDate] However I want to introduce an IIf into this as follows...

Perfect - thanks for this, all sorted! That's 30+ forms I no longer have to resize!