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!
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
