Forum Widgets
Latest Discussions
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.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!!
Creating an Inventory System with Bills of Materials
Hi there, I'm new to Access and I'm developing a database for a small business that includes an Inventory table, where all parts are listed. I am hoping to create bills of materials for assembled products (finished goods), which would include some parts from the Inventory table (parts included depend on the finished good). I want to have a front end form where the user simply selects which finished good has been ordered, with a "complete work order" function that will automatically remove the specified part quantities from the current stock in the main Inventory table. I am unsure on how I should approach this, through tables, update queries, etc. Please let me know if anyone has developed a similar system, or any ideas on how I can move forward. All suggestions and expertise are welcome! Thanks in advance.
How to Create Tile-Style Buttons on MS Access Forms?
Hello everyone, I have come across a user interface in MS Access that features tile-style buttons, as shown in the attached image. These buttons have icons, labels, and a modern appearance, which makes the form look more professional and user-friendly. I would like to implement a similar button style in my MS Access application. However, I am unsure about the best approach to achieve this. Could anyone please share their insights or experience on the following: What control type should be used to create these buttons? How can I add icons or images to the buttons while keeping them responsive? Is there a way to apply custom styling, such as rounded corners and background colors? Are there any VBA techniques or third-party tools that can help with designing such buttons? Any guidance, sample code, or references to tutorials would be greatly appreciated! Thanks in advance.Query re: OLE Object
I need to write a query to update an OLEObject field on a form (Forms!ScheduleFormCont!ColorTextBox), based on a table with the same OLEObject field (SCHEDULE.ColorTextBox). I am updating the form field from another table also with an OLEObject field (ColorsTable!Color). The OLEObject fields are: SCHEDULE!ColorTextBox ColorsTable!Color And [Forms]![ScheduleFormCont]![ColorTextBox] listed on the form as a Bound Object Frame I then need the form to update with the new OLE Object information. I am using code: DoCmd.SetWarnings False DoCmd.OpenQuery "AddColor2" DoCmd.SetWarnings True The AddColor2 query is not working: UPDATE SCHEDULE INNER JOIN ColorsTable ON SCHEDULE.ColorText = ColorsTable.ColorName SET SCHEDULE.ColorTextBox = [ColorsTable]![Color], [Forms]![ScheduleFormCont]![ColorTextBox] = [ColorsTable]![Color] WHERE (((SCHEDULE.SONo)=[Forms]![ScheduleFormCont]![SONo])); SCHEDULE!ColorText and ColorsTable!ColorName are ShortText fields containing the same value. Can you help??
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.
