Search results

Thanks sonic8, For my system they will always be pdf and Adobe reader will always be present. Understand the others may be different, hoping that mine will be easier. The printer is shared and the same name on all clients, all clients have Adobe Reader present. The main issue with this would...

Hi arnelgp, I have found your old code below, but need to find a way of setting the printer this needs to output to. Public Sub PrintAnyDocument(ByVal strPathFile As String) Dim TargetFolder Dim FileName Dim ObjShell As Object Dim ObjFolder As Object Dim ObjItem As Object...

Hi Arnelgp, Sorry, I think I worded it wrong. I don't want to open the print dialog. I want the VBA code to decide on the printer. I want the user to be able to double click the list box and it will print the selected PDF to the printer set in the VBA. Please note, this is an external file...

Hi All, I have just finished a form the allows me to open saved pdf files and it works great. Is there simple code to direct print these to a specific printer? I have looked but lost the link that I found that I thought would do it and cannot find it anymore. ~Matt

Hi All, I have what should be a simple query, but I cannot get it to work right. I have a table with a DrawingRevisionID (PK, AutoNumber) and DrawingRevisionDate. I want to be able to only show the latest date, but also need to show the PK which may not be the latest number. As an example I...

Perfect. Dim f As Object Dim strDocumentFileName As String Dim varItem As Variant Dim strStartFolder As String strStartFolder = "\\sc-nas-01\XP-Share\Production & Shop Floor\Drawing Register\Cable Assemblys\" & Forms!frmProductBOM!ProductCode Set f =...

Hi all, I have the below code to select a file and save the location to a table. Dim f As Object Dim strDocumentFileName As String Dim varItem As Variant Set f = Application.FileDialog(3) f.AllowMultiSelect = False If f.Show Then For Each varItem In...

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