Search results

Hi Gasman, There was another column I didn't show. There is also a setup time for each operation which is a fixed time over the job no matter the quantity. If an operation takes an hour to setup, this is shared over the qty of the build, not the operations qty. Not every operation has a setup...

Perfect. I now get 81:18:20 for this job. Thank you. ~Matt

Hi Mike, This would be 30 seconds per operation, 300 operations for 150 minutes which makes 2 hours 30 minutes 0 seconds. Anything that is under 24 works perfectly. ~Matt

Hi all, Does anyone know of a way to mimic the Excel [h]:mm:ss in an Access query? This is for our capacity planner to show how much time has been allocated to a job. I have the below from Access, and in Excel it sums to a total of 80:58:20 if I format as [h]:mm:ss, but I cannot get access to...

cDate() worked perfectly. I wish I had known this before. I had thought about doing and import to a new table and setting the field data type, but the query runs in a fraction of a second linking direct to the Sage data, so I didn't see the value in doing an import to local, then running the...

I did this in the end. The issue I had was the Date field imported from Sage50 was not sorting by date, rather by number. It meant 01/08/23 was followed by 01/09/23 and so on. I had to break the date down into the parts of the field then sort (but not show) those on the query before exporting...

Hi all, Does anyone know the code to sort by a column in excel after exporting? At the moment I have the below code, which works perfect and formats it how I need, but I cannot get it to sort by Column G, asc. Dim xlApp As Object Dim xlSheet As Object Set xlApp =...

Thanks Pat, I need to learn the OpenArgs now then. Do you have any useful guides to this? I am very intrigued now. ~Matt

I have tried to reduce the number of potential records someone could edit in error. Sadly idiot's will always find a way to idiot. At least this way they can only idot 1 record by mistake. My next step is to lock the record to the person whoe created it, and anyone trying to edit it would need...

Hi Mike, All the quotes are displayed in a list depending on which form they have open. They double click the one they want to view/edit, and that is the one it opens. ~Matt

Hi Mike My form does not move between records. You can add a new one, or view an existing one selected from a list box. I did once have forms allowing movement between records, but the number of people that changed the wrong quotes was astounding. As Pat has now confirmed I already have the...

Hi June, Could you let me know the difference between your code and the DoCmd.OpenForm "frmQuote", , , , acAdd I am currently using? Whenever I create a new record on any form, I use the DoCmd.OpenForm acAdd method. Should I be changing this? ~Matt

Thanks Pat, That explains it perfectly for me. My next question then would be, is it better to have the form Record Source based on a query or a table with a filter in the DoCmd.OpenForm code? ~Matt

Hi Forumers, I have been reading many posts and viewing much code on here and notice the Recordset is mentioned alot. If I have a form that cannot move between records, is there any benefit in declaring the recordset? My frmQuote is based only on the tblQuote, and cannot move next/previous...

I have found the issue. The original programmer had a module called RefreshTableLinks that ran when every form is opened. I have removed the call for this and all forms now open fine. If I never change the details or location of the linked tables, hopefully this will not cause an issue? Public...

Further Update If I remove the option from Display Form, the error does not happen. But if I select a Display Form (any form), the error appears. ~Matt

Hi Gasman, It is yes. And the table works fine in other FEs. Despite the error message, the table still opens and works fine, as does the code I am using the table for (User Access Rights) ~Matt

Update. I have this FE linked to 2 BEs and the error is linked to the only table from the secondary BE. All the others tables are from the main BE and they all work fine. ~Matt

As soon as I open the FE. The database opens a main form and then this error appears. There are lots of linked tables and this is the only one that has an issue. ~Matt