Search results

I have a Database I’ve made for my school district that is being accessed across multiple campuses for some reason we are having what appear to be inconsistent connection issues. These issues are not isolated to when we are using wireless but it does seem to make it worse. When we are having...

I have a form that is used to search for Teacher_ID I want to be able to open the form from any other form and then use the selected Teacher_ID to update the one on the sending form. On occasion the sending form will be a sub form which is what’s really throwing me off. Any advice? Sent from...

I have a detailed report of staff, the campuses they cover, and the students on those campuses. How would I set it up to where a command button press would open the report but only show the information requested at that time I.e. list of staff, list of staff and their campuses? Sent from my...

I have figured out how to open a report and filter it in reference to a list box and I have figured out how to automatically save a PDF by clicking a command box. However, I can’t figure out how to made a command box automatically filter a report and then save it. Suggestions? Sent from my...

Something went haywire and I have a record in a table that has various fields swapped out to be written in crazy symbols (like Japanese). Any time I try to write over the cells or delete the record I get a message saying “Search key was not found in any record.” Suggestions? Sent from my...

I am working on a report and need it to show the current school year on it. So “2017-18” if it was printed between Aug 2017 and June 2018. Any suggestions on how I would accomplish this? Sent from my iPhone using Tapatalk

this might be a little dumb but... is there anyway to have spell check auto run whenever focus changes between controls, without having to code it into each control? I got this code that works great and set it up on an OnExit event but wondering if there's a way to make it work for all items on...

My school district is having all of its special education audited. I recently made, and I’m continuously tweaking an building upon it, an Access DB to track/document everything for my department. I had to meet with the woman doing the audit today and the 2 things that she had to say to me...

I'm trying to setup a DB on the network drive at work and I would like for each individual's local copy of the FE to automatically update to the newest version upon opening. I found this thread... https://access-programmers.co.uk/forums/showthread.php?t=265491 it seems to be what I need but I...

I would like to attach several different PDFs to a main record. From what I’ve read it’s always best to link as opposed to truly attach. Although I keep reading “link don’t attach” I’m not sure how you do it. My goal is to have a sub form that has a way of opening a file browser to locate a...

I’ve got a query that I want to be ran after a report is generated and emailed to indicate that all the records on the report have been submitted. I have an update query that does the job great but i can’t figure out how to keep all the pop up confirmations showing before the query will run. Any...

I want to show/hide controls if the answer chosen from a combo box is like “*x*” I can’t seem to get it to work with “like” but can easily make it work if I say = “x” but that’s not ideal because leads to me having to go back in and edit the code as I add items to the combo box list that fit the...

I have multiple tables that connect back to 2 main tables, they themselves, are connected as many to many. My goal is to get them all into a query so I can then run a report to be able to show that a teacher has the following students (or a student has the following teachers as well as the...

I have a button on form A that brings up form B for me to choose items to assign to the student represented in form A. Form B references a query to show only unassigned items. I have a checkbox and want to set it so that the foreign key in form B will be set to match the primary key of form A on...

I’m setting up an inventory database. Some/most of the items will have barcodes but others do not, and it’s not practical to barcode them. Is there a way to generally not allow duplicates in a field but allow a small handful of things to be entered multiple times in the field with multiple...

I have a report that is grouped by student (page break setup so every student has its own page) and then all the equipment that is assigned to them. There’s a few students that this list spans more than 1 page. I would like to have the pages numbered so I can easily see in a print out that I...

Hi everyone. I’ve played around with access here and there but did the most work in building things when I was in highschool (pushing 15 years ago). I now work for a school district and I’m in charge of all the assistive technology equipment (communication devices for nonverbal students, adapted...