Forum Widgets
Latest Discussions
Populating Comb Box With Multiple Values
I have an Access table with a Regions field and a States Field. The States Field is populated with one to twenty state abbreviations depending on the region. Using VBA, I'd like to populate the Regions combo box with the appropriate regions depending on what state is chosen in the State combo box. The problem I have is that some states are included in more than one region. For example, 'WY' is part of the Great Basin, Northern Rockies, and Rocky Mountain regions. 'NV' is part of the Great Basin and Northern California regions. In order for multiple regions to be populated in my Regions combo box (ie. Great Basin, Northern Rockies, and Rocky Mountain if a user selects 'WY' in the States combo box), is there some sort of VBA dictionary I could set up (much like in Python) to iterate through and select out the appropriate regions? Or if that's not possible, would I have to set up some sort of array and use a For Loop to select out the appropriate regions? Region_Name States Alaska AK Eastern Area ME, NH, VT, MA, CT, RI, NY, NJ, DE, PA, MD, WV, OH, MI, IN, IL, WI, MN, IA, MO Great Basin AZ, ID, NV, UT, WY Northern Rockies ID, MT, ND, SD, WY Northwest WA, OR, HI Northern California CA, NV Southern California CA Rocky Mountain CO, KS, NE, SD, WY Southern Area TX, OK, AR, LA, MS, AL, TN, KY, VA, NC, SC, GA, FL, PR Southwest AZ, NM Any advice would be greatly appreciated.
Reciprocate Relationship - how to setup
I think I almost have this...and then I don't. I'm creating a db that has a single 'Contact' table (ContactTbl - think 'Customer' table or 'Entity' table...). The table has both Organizations and Individuals - I do have a 'ContactType' field (Organization/Individual). I've created a form (ContactF) that brings in the OrgName, FName, LName....(the OrgName or F/LName fields are populated pending ContactType) - that's not the problem. I have a SubForm (RelationF) that...when an Org record is displayed on the Main/Parent form (ContactF), the SubForm (RelationF) shows all the Ind (employees) and their titles (titles in a free-form txt field for now). When an Ind record is displayed on the Main/Parent form (ContactF), the SubForm (RelationF) shows the Orgs that the Ind works for (has relationships with) and their title with that org (an Ind could work for multiple Orgs). I actually have this working but all the input in manual...in other words, if on XYZ Corp record and I add an Ind as a relationship, I have to go to the Ind record and create the relationship - that's the issue that I'm having...how can I have Access create the relationship automatically. In other words, when I'm creating the relationship from the Org record, I want Access to create the relationship on the Ind record (since I'm making that relationship through the SubForm. Same thing the other way around - if on the Ind Record and a relationship is created with an Org record, then have Access automatically create the relationship on the Org record. That way when viewing the records through the form, I can see the proper relationships: How can I have Access automatically create the relationship.
I would like help writing a query to determine when people should follow up on a late shipment
Basically, I have a table that is a log for when issues of different magazines are received. Here are the fields: Title of the magazine Frequency (Monthly, bimonthly, annual, etc) Issue date (the date printed on the magazine) Received Date (The date the item was received) Expected Next Issue Date (Calculated field that figures out when the next issue should come in based on the Received Date and the Frequency) I want a query that, for each title, returns the record for the last issue that was received, but ONLY if it is after the "Expected Next Issue Date" for that record. For example, Time is Biweekly. So If they receive it January 1, and it is now January 15 and the next issue was not received, I want the query to return the record for the issue that was received on January 1, but not any of the issues that were returned before that (so not any issues that were received in December of the previous year). Right now I have a query that does that, but it requires the user to check off old issues as they receive things, which is not ideal. Any ideas on how to write a query that will do what I want?
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, AndyAsset 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
