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!
Access 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 advanceACCDE 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
Tengo 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?
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.Number 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 you
Distinct 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. -Joe
