Access | Microsoft Community Hub

Forum Widgets

Latest Discussions

Sort in Query not Displaying
I have no clue how to word this. Basically, in a form I have a field called Members. This field is a drop down menu that lists all of the Members for a meeting via check boxes. I can then tick the checkboxes for the people who attended the meeting, click 'ok', and then when when I run the report, their names will appear. I don't need this information saved; just to display on the report so I can print it. Here's my problem. Not all of the members can vote, so I want the members who can vote listed first, and the rest of the members listed next. I've put in my custom sort formula in the Members query. When I open my Members dropdown box, they are listed exactly the way I want. However, as soon as I tick on the names and then click 'ok,' it's displayed in order of the primary key. When I run the report, the names are still sorted by the primary key. I've gone to every query and table I can find to create my custom sort, but it keeps defaulting to sorting by the primary key. It's driving me INSANE. Any idea why it's doing this? I've dug through google and haven't had luck finding an answer that works. Thanks in advance!
Solved
nicoleethier
Copper Contributor
Jun 24, 2025
access
FOD
Query
Sort
Sorting
173Views
0likes
16Comments
ACCDE File - Hide Everything
Hello I have a database for which I want to hide the navigation pane and the menu ribbon (everything) in a ACCDE file. I just want my Home Page Form to open when the link to the app is selected and nothing else is visible. DoCmd.ShowToolbar "Ribbon", acToolbarNo does not work. I have tried a link on one of the previous answers and error 404 came up. Help would be greatly appreciated. Kindest regards Adrian
Solved
adriankuchta
Copper Contributor
Jun 04, 2025
access
office 365
178Views
0likes
16Comments
Read or convert Access 97 DB
Hello I have multiple random Access 97 databases that I need to be able to read or convert. I have scoured the web and not being real successful. Does anyone know of any tools to do this? I don't have an older version of Office / Access to try to pull it in like Office 2007. If there is a legal way to get an older copy of Office I am willing to purchase it. Any help would be appreciated.
Solved
Don_Inst_Support
Copper Contributor
May 24, 2025
access
136Views
0likes
4Comments
Criteria for a query
I have a database containing multiple records, and I want to create a query that allows the user to specify how many times the records should be displayed. This should be done without duplicating the original data preferably using a criteria. Sample: 1 Row Date: 02/16/2025 Code: 123456789 Description: Test But if the user types 2 will show a duplicate row. 2 Rows Date: 02/16/2025 Code: 123456789 Description: Test Date: 02/16/2025 Code: 123456789 Description: Test
Solved
FJMSalgueiro
Copper Contributor
Apr 15, 2025
access
58Views
0likes
3Comments
Round the shortcut of Access 365 to be consistent with other apps.
Like the title says.
Solved
asmobilevlog
Copper Contributor
Apr 04, 2025
office 365
99Views
2likes
3Comments
Trouble identifying 'Primary' phone number
Hi - I'm new...ish to Access. I've used it to cleanup raw data before importing into main SQL db, but have not really 'developed' in it. My SQL is rusty and I've only dabbled with VBA. I'm building a db that has a separate table for 'phonenumber', I'm using a Y/N checkbox with the intent that if the checkbox is checked, then that is the primary phonenumber to use (this is on a continuous form). Since a record can have more than one phonenumber, how do I code it so when someone goes to check an additional checkbox, that it 1)warns them that another phonenumber has already been marked as the primary number (if another one has indeed been checked...if not, then allow the checkbox to be checked), and then 2)if the user wants to change which is the primary phonenumber, then have the update clear the other checkbox and check the current checkbox. Just so you understand, I'm not talking about making the phonenumber the primarykey - I have the primarykey as PhoneID. Thanks in advance for your help! I thought I posted this yesterday but now I can't find it at all so forgive me if this ends up being a duplicate post.
Solved
ns61
Copper Contributor
Mar 07, 2025
access
162Views
0likes
5Comments
Primary Phone Number
Newish to 'developing' in Access...previous experience w/Access has been importing raw data, using SQL and Macros to process data to put into format to import into SQL db. I'm racking my brain on how to resolve to have only one phone number out of multiple to be the 'primary' phone number (NOT the primary key as most searches take me to. I have 3 tables...CustomerT, PhoneT, and PhoneTypeT - each have their own ID's (CustID, PhoneID, PhoneTypeID). Phone Types could be Cell, Home, Office, Fax, Spouse....and so on. Each customer can have multiple phone numbers...I want one of them to be the 'primary' number (because I'll need to pull in the primary number into another form at some point - same thing can be done with email as well). I've added a Y/N checkbox - when checked, indicates primary...but I can't wrap my head around to allow only one checkbox to be checked (in other words, checkbox for 'Cell' is checked...then later, 'Home' is checked - I'd want to 1) msg user asking if they want to mark 'Home' as the "Primary" number - if yes, then 2) mark 'Home' as primary (checkbox is true) and then make sure all other checkboxes are unchecked (false). I know SQL and somewhat familiar with VBA...just am pretty rusty with both so syntax would be helpful. Thanks!!
Solved
ns61
Copper Contributor
Mar 07, 2025
access
132Views
0likes
3Comments
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
Solved
les_lockett
Copper Contributor
Feb 13, 2025
access
2KViews
0likes
22Comments
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?
Solved
HenryD
Copper Contributor
Feb 11, 2025
access
sharepoint
175Views
0likes
7Comments
Update 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.
Solved
Tony2021
Steel Contributor
Feb 06, 2025
access
105Views
0likes
3Comments

Resources

Tags

access1,653 Topics
office 365368 Topics
2016197 Topics
developer191 Topics
Access Web Database100 Topics
Access Web App57 Topics
sharepoint52 Topics
201351 Topics
201042 Topics
admin41 Topics