Search results

Hello, I have created a query from 7 other queries; each one sums the data from a day by product and then it shows it on a 8th query where all the products are displayed with the daily\weekly\date periods selected from a form. - Not really explaining it well I know, its like a Crosstab query...

Hey All, I am trying to link to my data in a very old system (Total Control Till System) to my accdb database. I used to be able to use Windows 7 and MS Access 2007, however I am looking to use MS Access on Office 365 as I use for other databases as my old computer has died. I can probably...

Hello, Please can you help, I feel like I am missing something simple here. I am trying to click a button on a main form and then the subform is made visible and a combobox gets the focus on the subform to type in for a search. I'm using the following code, but what am I missing please...

Hi, I have a continuous form that I use to filter out checklist items, I am looking to change my category number for each category\heading when I update one of the textboxes on my form, so all other textboxes with the same heading will be the same, I am using the following code however I then...

Hello, I'm trying to populate the first\default value of a Combo Box when I make a form visible with the value of a Textbox on another form. The Textbox value will be same as one of the 6 in the Combo Box. The Combo Box is just to allow the user to change the department and will be picked...

Hello, I'm trying to filter and print a report using a button on a form, I can get it to work, however I seem to be a little bit short for my ideal filter. I can get the following to work (with 15 criteria): DoCmd.OpenReport "rptBuyingList", acViewReport, , "STOCK_CAT =...

Hey All, I'm trying to use an insert into statement to log an action in my system, I am looking to show the record with Printed on MMMM YYYY, however the date format is the issue at the end (I always seem to have an issue with date format, I just cannot get it. Please can you tell me what my...

Hey All, I'm trying to filter a from using a few different combo boxes, one of them is to filter records for a date, I'm using the following code but I keep getting the error "Run Time Error 3709. The search key was not found for any record." If Nz(Me.cbxSystemDate, "") <> "" Then...

Hello, I have a form and a subform which has a textbox called tctManagerDiary, when I click on a button to hide the subform then click on a button to show the subform the data will not append to the textbox. The code I am trying is Me!subfrmDiary.Form.txtManagerDiary = DLookup("ManagerDiary"...

Hello, I am looking to use DLookup to put values in to textboxes using VBA, can I do something like this please: Me!subfrmDiary.txtManagerDiary.Value = DLookup("ManagerDiary", "tbl_Net_Diary", "TheDate = Forms.frmBackground.txtLocalSystemDate") I have also tried...

Hey All, Can Environ('ComputerName') go in to a SQL Statement? I'm looking to do: DoCmd.RunSQL "INSERT INTO tbl_Net_UserLog(UserName, Action, Computer) SELECT Forms!frmBackground!txtUserName, 'User Logged Off', Environ('ComputerName')" Thanks, Malcolm

Hey All, I've created 2 crosstab queries and I need to combine them in to one query to give me correct values Eg: Table 1 record 1 total is 100.00 and Table 2 record total is -25.00, I need to sum them together to give me a query which shows 75.00. I am looking at a Union Query to do this, but...

Hello, I have a table that logs all my users activities\changes etc and I would like to be able to filter by Employee or Action but I cannot quite get this right. I have my combobox grouped so I can see all my users but when I filter by a user I cannot see the whole table unfiltered - how can...

Hello, I'm trying to update my table with a button on a form after a procedure has run to show the next date due. So it could be Weekly, Monthly, Quarterly etc. I have used the following which works On Update but not with Run SQL: If [Frequency] = "Monthly" Then NextDate = Null [NextDate] =...

Hi, I am trying to use RunSQL update and I want to use 2 lines for 2 sentences to store. I am trying to use vbCrLf, can I use this in the SQL Line? (eg & vbCrLf &) This works fine is MgsBox etc. If not is there another way I can do this please? Thank you DoCmd.RunSQL "UPDATE...

Hello, Part of my database is for tracking testing of devices, we test one device each week and record the test date. I am looking to do 2 things, but I cannot think how to do them: Device 1 16/04/2022 Device 2 23/04/2022 Device 3 Device 4 1. I want to show on my form the next device...

Hello, I'm looking to re-do my Error Handling as it seems to be quite messy, at the moment I use the same code in each VBA entry; On Load, Click etc. I have a large system with lots of forms etc so I was looking to call a module that would hold the error handling in it for all area's. I use...

Hello, I'm having issues updating a record for a diary database. I have the following code which should update the record where the date selected in the form textbox called txtLocalSystemDate and in a column in the table selected from a list on the form called txtDiaryFeed. Its complicated...

Hello, I'm not sure if what I am trying to do here is simple or not and my brain hasn't really came up with a way to do it so here goes: :) I have a table which holds my data like this: Booking Arrival (D/M/YYYY) Departure (D/M/YYYY) Nights Cost 1 1/1/2021 3/1/2021 2 100 2 2/1/2021...

Hi, I am trying to run an Update Sql code line where the destination in the table is variable, however I just cannot quite get there. The line of code that I am using is: DoCmd.RunSQL "UPDATE tbl_Net_Diary SET & [Forms]![frmBackground]![subfrmHome]![txtDiaryFeed] & =...