Search results

I have a database that tracks students and their test scores. I am trying to figure out a way to where it will pull the student's latest test score and compare it to see if they fall within standards. So far I have 3 tables. tblStudents studentID studentName studentEmail tblResults resultID...

When I distributed my accde file to the people in my office it went straight to the MS Access welcome screen instead of opening the database. Anyone have any ideas?

I know there is VBA to load a ribbon in to the database but is there actual code to set the ribbon or code that corresponds to Access Options --> Current Database --->Ribbon and Toolbar Options --> Ribbon Name?

Does anyone know where I can find the XML for the default ribbon bar on Access? I think it would be be easier to take away certain buttons than to start from scratch.

I have a table with the fields userName and dbPermissions. the username in the database is the same one that is displayed when calling the Environ$("username") function. I want to build a script that will find record where the function matches the userName in the table and then looks up that...

I am trying to use conditional formatting on a report and fill color only changes if I click in the field on the report. Nothing happens in preview mode. It works if I change the condition to change font color only but I want the field to fill. This field is date format if that makes a...

I'm trying to append a query that calculates percentages append that query to a table. When I open the table the percentages either show up as 0% or 100%. I have set the field in the query to percentage and the corresponding field in the table to long integer/percentage and still can't get it to...

I have a button(cmd1) on a form(Form1) that I want to have open a different form(Form2) to add more detailed information, add a new record, and set a field in Form2 equal to the primary key of Form1 without having to add Form2 as a subform. Anyone know of any ideas or have code for that?

I am trying to create a field in access that will store multiple fields form a lookup table. When I go to select the options a "0" shows up at the end of the list and "No" shows up in the other field of the same type. Does anyone know why this is and how I can get rid of it? I have looked at the...

Does anyone know of a way to compare the data between a current version of your database to a backup of that same database?

Is there a function that will return a boolean value to check to see if one record exists in a joined table? For example: In one table you have a list of customers and their respective customer IDs: customerID - PK customerName customerAddress etc.... In another table you have: orderID - PK...