Forum Widgets
Latest Discussions
Form Combo Box Doesn’t Store Selected Value (Foreign Key Issue)
Hi all, I'm building a data entry form for the Peserta_Workshop table in Microsoft Access. This table includes a field called ID_Unit_Kerja, which is a foreign key referencing the Unit_Kerja table. In the form, I'm using a Combo Box to select a unit from Unit_Kerja, and I've set the Row Source to SELECT ID_Unit_Kerja, Nama_Unit_Kerja FROM Unit_Kerja. The Control Source is already set to ID_Unit_Kerja. However, when I select a unit from the combo box, the value does not get saved to the Peserta_Workshop table, and sometimes an SQL or NULL error appears. I’ve set Bound Column to 1 and Column Widths to 0cm;5cm. What could be the issue? Appreciate your help!AnitaaJun 15, 2025Occasional Reader64Views0likes3CommentsAccess Help
I am trying to create a rather simple dbase and need a bit of guidance. I have two tables, and in the first table I have a column titled component #. The 2nd table houses all the data associated with the Component #s. When keying data in the component # field on the first table, I would like access to look at the 2nd (Component #s) Table, and if that # doesn't already exist I want a box to pop up (a form, I imagine) that will allow the component # and associated data to be added to Component Table. Also, if the # doesn't exist in the component table the record cannot be saved. Can anyone provide guidance on how I might accomplish that. Thanks in advancedavismichele11Jun 08, 2025Copper Contributor72Views0likes4CommentsACCDE 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 AdrianSolvedadriankuchtaJun 06, 2025Copper Contributor143Views0likes16CommentsRead 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.SolvedDon_Inst_SupportJun 03, 2025Copper Contributor118Views0likes4CommentsTengo una base de datos e Access que contiene una serie de documentos Word y PDF.
Tengo una base de datos e Access que contiene una serie de documentos Word y PDF. Me ha funcionado perfectamente hasta el día 14 del 05 de 2025 que ha habido una actualización, desde entonces no puedo abrir ninguno de los documentos Word, me aparece el siguiente mensaje: Microsoft Word Word detectó un error al intentar abrir el archivo, Pruebe Io siguiente: * Compruebe los permisos del documento o la unidad. *Asegúrese de que hay suficiente memoria y espacio de disco. Abra el archivo con el convertidor de recuperación de texto. y cortar un Jamon.docx) Sin embargo, los documentos PDF los sigue abriendo perfectamente. Pero me sorprende que tengo instalada una copia de esta misma base de datos en otro portátil que no ha sido actualizado y me abre estos mismos documentos Word perfectamente, sin ningún problema. ¿Qué puedo hacer para solucionar esta situación?MiguelAngel1May 26, 2025Copper Contributor65Views0likes2CommentsCreating 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.CDuestMay 24, 2025Copper Contributor6KViews0likes14CommentsNumber Format - Dark Green if Positive and Red if negative
Experts, how can i shade a positive number a darker green than what shows below? this is what I am using [Green]€#,##0.00;[Red](€#,##0.00);[Green]€#,##0.00 I have tried replacing "Green" with Dark Green and Color5 but those names dont seem to be in the list of available colors. thank youSolvedTony2021May 24, 2025Steel Contributor37KViews0likes3CommentsDistinct Count Subquery, MS Access
Need some help in getting a Distinct Count result in this query. For context, i work in healthcare and of course an not share the actual data behind the query. My goal is to modify the current quiery - which returns total charges by account financial class (medicaid, commercial, medicare, sellf pay) and account date within a given month (post date, in the query), but add on a distinct count of hospital accounts in the grouping. Current SQL below, all data lives in the ez_hosp_chg_v. table. End goal is to return a distinct count of the bold/red data point: "HOSP_ACCT_ID" SELECT ez_hosp_chg_v.POST_DATE, ez_hosp_chg_v.TX_FIN_CLASS, ez_hosp_chg_v.ACCT_CLASS, Sum(ez_hosp_chg_v.ORIG_AMT) AS SumOfORIG_AMT, ez_hosp_chg_v.PRIMARY_PLAN_NAME, ez_hosp_chg_v.HOSP_ACCT_ID FROM ez_hosp_chg_v GROUP BY ez_hosp_chg_v.POST_DATE, ez_hosp_chg_v.TX_FIN_CLASS, ez_hosp_chg_v.ACCT_CLASS, ez_hosp_chg_v.PRIMARY_PLAN_NAME, ez_hosp_chg_v.HOSP_ACCT_ID HAVING (((ez_hosp_chg_v.POST_DATE) Between [enter start date] And [enter end date])); I've attempted incorporating a subquery like this distinct count example, but can't get the syntax correct in my version: source: https://www.access-programmers.co.uk/forums/threads/count-unique-values-in-a-query.327614/ Any help or pointers are appreciated. -JoeJoeCavasinMay 21, 2025Copper Contributor127Views0likes4Comments
Resources
Tags
- access1,651 Topics
- office 365367 Topics
- 2016197 Topics
- developer191 Topics
- Access Web Database100 Topics
- Access Web App57 Topics
- sharepoint52 Topics
- 201351 Topics
- 201042 Topics
- admin41 Topics