Forum Widgets
Latest Discussions
Access Issues with Windows 11 24H2
I am starting to experience issues with using Access (Microsoft® Access® for Microsoft 365 MSO (Version 2501 Build 16.0.18429.20132) 64-bit), that I have never encountered before. My windows version is Windows 11 24H2. I created a brand new database (to see if my problems occurred on a brand new database and not my existing databases) with two tables, each with 3 records - so a very useful database to have, but anyway... I tried to create a query to join the two tables and saw that: Large areas of the query editor was unavailable for me to drop a table onto - a red circle with a line through it came up Once I dropped the table to an acceptable area (middle of screen), I couldn't create the join by dragging from field to field. I could only create the join by going into SQL mode and writing the join myself I couldn't drag a column to the selection pane to the position i want. I had to double click to put at end of select, then physically move the field to position i wanted. This is definitely not how it should work I have worked with access on and off for 30 years, and haven't come across this. I had totally uninstalled office 365 and reinstalled from the microsoft website. I came across this on reddit but nothing else. Does anyone have any idea on what could be causing this? Many thanks Les
Cant Create form Using 2 x Sharepoint Linked Tables
Hi I have 2 x tables Plant Orders and Plant Orders Details that are linked from Sharepoint. I have a user input Form whereby the Plant Orders Form is the Main Form and Plant Order Details is the Subform. I want to combine the records in these tables as an editable form in a datasheet view. If i use the wizard to create a form between these tables i get the message "one or more of these tables is not related". If i check the relationships on Access it is true there are no links between these tables. However the Master Child Relationship in the database is working correctly as the common field between the two tables - Order Number - updates in the Order Details table on Sharepoint but is not entered in the Subform. Ultimately what i am trying to achieve is a datasheet that can be edited that contains all the records for a particular job without having to scroll through each order number. Any suggestions?
TRYING TO BUILD A LOGIN BUTTON/PASSWORD
Hi there, I hope you will be able to help me. I am very new to access and managed to build a small database for my work, mainly from watching you tube videos and reading google information however, I want to start upping the anti a little more by adding a level of security so users need to input a user name and password to gain access to the database. My first stumbling block is the 'build event'. Whenever I right click on my login button, it takes me to the macro screen yet when I watch videos online, you get the option to select code builder, I cannot for the life of me see how to change this, any advise please would be greatly received. Many thanks, AndyUpdate Query - 3 criteria
Hello Experts, I need to update 3 fields in a table Import_ExcelPC but I am not getting anywhere with it. Let me explain what I need in simple plain english Update: Import_ExcelPC.Notes to the value show in [Import_ExcelPC_Copy].[Notes], Import_ExcelPC.OKToPayYN to the value show in [Import_ExcelPC_Copy].[OKToPayYN], Import_ExcelPC.DABYN to the value show in [Import_ExcelPC_Copy].[DABYN] but its for records where [Import_ExcelPC].[Invoice amount] = [Import_ExcelPC_Copy].[Invoice amount] AND [Import_ExcelPC].[Invoice No Stripped] = Import_ExcelPC_Copy.[Invoice No Stripped] here is my sql: UPDATE Import_ExcelPC INNER JOIN Import_ExcelPC_Copy ON (Import_ExcelPC.[Invoice amount] = Import_ExcelPC_Copy.[Invoice amount]) AND (Import_ExcelPC.[Invoice No Stripped] = Import_ExcelPC_Copy.[Invoice No Stripped]) SET Import_ExcelPC.Notes = [Import_ExcelPC_Copy].[Notes], Import_ExcelPC.OKToPayYN = [Import_ExcelPC_Copy].[OKToPayYN], Import_ExcelPC.DABYN = [Import_ExcelPC_Copy].[DABYN] WHERE (((Import_ExcelPC.Notes) Is Not Null)) OR (((Import_ExcelPC.OKToPayYN)<>0)) OR (((Import_ExcelPC.DABYN)<>0)); DABYN, OKToPayYN are Yes No fields. NOTES is long text. in picture: the ouput is 0 records to update. There should be 198 records being updated though. I run this select query and it shows 198 records based on the criteria SELECT Import_ExcelPC_Copy.Notes, Import_ExcelPC_Copy.OKToPayYN, Import_ExcelPC_Copy.DABYN FROM Import_ExcelPC_Copy WHERE (((Import_ExcelPC_Copy.Notes) Is Not Null)) OR (((Import_ExcelPC_Copy.OKToPayYN)<>0)) OR (((Import_ExcelPC_Copy.DABYN)<>0)); here is a screen shot. Its 198 records. Why wont those 198 records update in Import_ExcelPC instead of showing 0 records to update? I am not sure what I am doing wrong? thank you for the help.
Asset Tracking Template - depreciation
I'm looking for a free/low cost Asset Register app to record a few hundred fixed assets for a NFP. The Asset Tracking Template for MS Access looks OK but doesn't do anything for depreciation. I've had a look at a few spreadsheets but they look even more rudimentary. Can anyone suggest an appropriate tool or updated template? Thanks Steve
Filter Form with Like and Or
Hello Experts, I am having a tough time adding a condition to a filter on a form. It works with 1 condition but not sure about the OR part (sq, dq) Maybe it is correct. The error I get is "Type Mismatch" see pic below. The row highlighted is the Remarks line. It seems odd because the fields are "short text" in the underlying table. Do you see an issue with the OR statement? If not, any ideas why I would be getting that error knowing that the fields are text? Private Sub txtEndUser_AfterUpdate() 'http://allenbrowne.com/ser-28.html If IsNull(Me.txtEndUser) Then Me.FilterOn = False Else Me.Filter = "[Remarks 1] Like '*" & [txtEndUser] & "*'" Or "[Remarks 2] Like '*" & [txtEndUser] & "*'" Me.FilterOn = True End If End Sub here is the table showing they are short text. the table is imported. as a reminder, I have no issues with 1 condition meaning it filters fine.
