Search results

Hello, I'm looking to sum restaurant covers from a day - based upon the date on my form which is formatted dd/mm/yyyy I'm trying to use: =DSUM("Covers", "tbl_Net_RestaurantBookings", "#" & Format([CheckIn], "dd/mm/yyyy") & "#" = [Forms]![frmBackGround]![txtLocalSystemDate]) LocalSystemDate =...

Hello, I have created a grid using a table Fields are DinnerTable, 18:00, 18:15, 18:30, 18:45 etc On a form I have a textbox named txtGrid1 and a button I'm looking to run a query where if the textbox value was 18:30 then my query fields would be 'DinnerTable' and '18:30' - however I cannot...

Hello, I am trying to build an automated task scheduler for my system where every day it will run a report at the selected time each day, or run some process. Currently I have a few small access databases running in windows task scheduler that open, run whatever then close - works well...

Hello, I am trying to update a field in a table, the field to update is variable based upon what the user selects on a form, but the field to update is created in a textbox - its a mixture of the day of the week selected and the name of the field to update, so at the moment I am trying to...

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