Search results

Hi all, I have been looking and trying and cannot find the right syntax to open a form and apply a filter to the subform. Main form is frmProductionManagement, subform is sfrmProductionManagement is in Continuous Form view. If I set the filter in the subform in design mode to [Outstanding] >...

Hi all, I have looked but cannot find a method for this. I want to delete all files and folders from a main folder, apart from anything *.zip. I can find code to delete everything, or all of a certain file type, but nothing to only leave a certain file type. ~Matt

Hi All, I have generated a query that filters from options of a form. When I open the form, the list box posts the below error. But if I open the query itself, it shows the data and no error. Just won't display it in the list box. I have 3 check boxes for the dates Created Date, Sent Date...

Hello forum brains, I am hoping someone might have an idea on a solution here. We have a 3rd party application to for our production people to log their times on jobs. It works, almost, how we want it to. Where it falls down is when people log onto multiple operations at the same time (which is...

Hi All, Does anyone have a snippet somewhere on how to separate a minute field into each hour, minutes, seconds? IE 75.5 would be 1 hour 15 minutes 30 seconds ~Matt

Hi all, If I have repeated Dim Strings, can I declare them as public once on a form then just refer back to them anywhere else on the form code? Example as the below code. This is used on a few different command buttons. Dim strLoggedUser As String strLoggedUser =...

Hi All, I have a query to delete certain records from a link SQL table, but there are a lot (over 300k). Is there any way of creating a query to loop delete 100 records at a time so it doesn't get hung up trying to delete them all in one go? ~Matt

Hi All, Is there a way of making a form with a fixed position but not allowing any other forms to over/underlap it? I wanted to have a left sided menu for my modules, and when one is selected a custom ribbon is then loaded. I know a fixed position can be done, but wasn't sure if I could then...

Hi all, I have always used a method of creating an insert query and then calling this with VBA when I need to add data to a table. DoCmd.SetWarnings False DoCmd.OpenQuery "qryInsertReturnAction", acViewNormal, acEdit DoCmd.SetWarnings True Is there any benefit to changing this to have the SQL...

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...

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 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...

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 =...

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...

Hi all, I have just started receiving an error message with a linked table. It has only appeared today and the related FE still works fine using this table. I am still able to open and access the table and all queries and code related to it work. Has anyone ever had anything similar? ~Matt

Hi forumers, I have a modified drag and drop planner we use at work that places new activities on the screen with an X and Y coordinate to place it when added. I am trying to figure out how to work out the next X and Y values based on the last values in the table. X starts at 10 and increases...

Hi All, I am working on a quantity price break query and wondered if there is a an easy way for the below. I will have 8 breaks of 1, 2, 5, 10, 25, 50, 100, 250. I would like the expression to take the QuoteQuantity (IE 32) and quickly find where that sits in the price breaks. As in >25 AND <...

Hi all, I have a strange error on a query and wondered if anyone else had ever seen anything like it. I am getting the below error. The field it mentions is only in a single table on the query, so the message is incorrect. This only happens when I edit the related form on a Windows 11...

Hi All, Is there a way of exporting to PDF and then merging another PDF file to my report? I have a code that exports my report to PDF then attaches it to an email. What I would like to do now is export it, merge it, then email the combined file. Is this possible? ~Matt