Search results

Hi Minty, Just added them, but no dice. It takes 9 seconds to open the form first time. Less than a second the next time I open it. It is only on the Windows 11 machine. I use it on Windows 10, perfect..... ~Matt

Hi all, I have just upgraded to Windows 11 at work and now my forms are really slow when I open them. If I close them, and reopen, they are fast. Has anyone else experienced this at all? ~Matt

Hello coding wizards, Is anyone out there able to add seconds to the below code? Public Function CalcHoursOrMinutes(CalcType As String, Hours, Minutes) ' This procedure calculates the values for the CalcType, "Hours" or "Minutes". ' If either Hours or Minutes is Null, the function returns...

I just did something like this yesterday. I used the code from here. https://www.fmsinc.com/microsoftaccess/modules/code/Access/Environment/AccessWindow.htm I added the below to the top of my form module Private Declare Sub Sleep Lib "kernel32" (ByVal lngMilliSeconds As Long) Then just Sleep...

Hi Arne, The code is all good. Every time it will be used will be a unique file name, so it wouldn't have an issue. Once the import is done into the 3rd party software, the file is deleted. ~Matt

I love you. Marry me. ~Matt

Why not? They can if I edit the name manually. Why can I not export to there with spaces? ~Matt

Hi all, I am exporting 3 queries to a spreadsheet for import into another program. Export works fine, but 1 tab is giving me issues. The tab needs to be named Bill of Material Records. But when exported it replaces the space with an underscore, Bill_of_Material_Records. Does anyone know how I...

Thanks Maj

Hi All, Is there any way I can get a query to create a sequence number based on the first column, but start again when the data in the first column changes? I have a query that has 511 rows. Column1 is BomReference and this has a total of 30 different BomRefences. What I am after is the query...

Just to throw more brown smelly spanners into working fans please see below for more information. If I take a copy of the form and save it "Copy of frmBarcodeProductionManagement" and edit this form I do not get the save issue. If I then rename the corrupted form to...

I am still stuck in the save mode, and I finish at 1pm, so I am going to revisit this on Monday. I am going to take a backup of the form, then delete all controls. If the save speeds up, I will add them back, 1 by 1, to see which one has ruined my Friday. In all my time using Access, this is...

Hi Gasman, That is what I did to create the new form, which is why the codes are all the same. The only difference between the 2 would be the source query to the main listbox used on both. If I use the old version of the form and use the new query source, it still saves fast. It has really...

Hi Minty, I mean saving a design change. I shall update the main post. ~Matt

Hi All, I have a database that works fine. Apart from 1 form which now takes over an hour to save. Every other form is fine. Instant saves. But this one just locks all office apps on my PC while it saves. I have recreated the form from scratch, and it stays the same. There is a near identical...

It's not, no. But it is easy enough to understand and edit. I have managed to modify it and add my own parts without anything breaking, so far.... ~Matt

I used this guy, and edited the layout for our use. http://testolek.xaa.pl/portfolio2/index.php It cost €100 for the full code, but was well worth it. ~Matt

Hi all, The 3 tables I am using are from an external source, CIM50. I cannot change the field types at all. Please see below dbo.WorksOrderOperation Column Name Data Type Allow Nulls WorksOrderOperationID bigint False dbo.WorksOrderOperationBooking Column Name Data Type Allow Nulls...

Can you shed any light on why this will not work without the Like in front? The SQL fields are both the same data type and this is the only query that does not work without the Like. But it was working this morning. I changed nothing, but it just stopped working..... ~Matt

SELECT dbo_WorksOrderOperationBooking.EnteredBy AS Employee, dbo_WorksOrderOperationBooking.StartTime AS Start, dbo_WorksOrderOperationBooking.FinishTime AS [End], dbo_WorksOrderOperationBooking.QtyCompleted AS Quantity FROM dbo_WorksOrderOperationBooking GROUP BY...