Search results

Spot on, thanks gents.

Should have been clearer :) The end " Q45BB6LPQ5" part.

Hi guys, Hope you're all well. Any ideas on the most efficient way to isolate the last characters in the below string: "HW $161.14 Q45BB6LPQ5" The number of spaces between the dollar value and code might change fwiw. Thanks.

I presume Modal = Continuous? That's a good idea :) I presume you can't create a model subform?

Hi Ken, it certainly can.

Hi guys, hope you're all well. I have an unbound main form that users can search/filter etc. for company names. The sites then fill another list box. I need a decent way to display notes against the customer/sites. I'm playing around with a subform but it doesn't have the look I am after (the...

Excellent, thanks for the advice guys.

Morning all, another forms-based question. I have a listbox containing customers, once one is selected a second listbox containing contract is populated. When only one contract is found against a customer I am trying to then use the PK from the contract table to retrieve the action(s) ID and...

Excellent, thanks B. I assume the form stores the value when it opens even though the code isn't running? Cheers.

Hi guys, Been a while since I worked with forms. I have a list of customers that are monitored by the team. They need to add actions to each customer against a specific contract (one to many). At the moment a customer name is selected, a list box shows the different contract, they click...

Is registerANA declared as the same data type as the values in [PROC Reg/Tag]? Also, I would remove the spaces and forward slash in that field name - it'll only cause you headaches!

Is the field you are searching on spelt correctly?

I've figured it out in a recordset but I'm not sure if this is over-complicated :) Public Sub CalculateDates() Dim db As DAO.Database Dim dtCurrent As Date Dim dtPrevious As Date Dim iRecord As Integer Dim sSql As String Dim rs As DAO.Recordset Set db = CurrentDb sSql = "SELECT * FROM...

Hi ML, I'd open the series of data in a recordset. To calculate the difference as specified you'd need to evaluate each weekday in the gap between the date of the current record and the date-1 day in the next record. I'd use a counter to count days that don't equal Saturday/Sunday between...

Glad you sorted it Jal. I do something similar when I need to run analysis on a subset of a lot of records. Just make sure you compact at the end :)

Thanks darbid, excellent. I formatted the Now() part as DD_MM_YYYY_HHMMSS in the end as it didn't like it first time round :) Thanks again.

Hi all, hope you're all well. Hopefully a quicky, not sure what I'm missing. I am creating a workbook a outputting an array after some of its values have been run through some parameters. My code for creating the and naming the workbook: Set wbOutput = xlApp.Workbooks.Add With wbOutput...

Morning all, Jal, I tried the first suggestion inserting into a new table - that worked reasonably well/fast (it's not too many columns), so thanks. Might be the easiest way for me to aggregate the data. I am going to look at the dictionary suggestion today so thanks again :)

Hi Trevor, It's an array of analysed data - it's not stored in the database (i.e. in a table) so no.

Hi all, hope you're well. I have the following data (assume each item is a column in the array) set of about 120K records: Customer1 A B 120 Customer1 A B 100 Customer1 A C 200 Customer2 A D 150 Customer2 A D 100 Customer2 A E 100 I need to aggregate this up into the following...