Search results

I'm not sure I totally understand what you mean by "few files, few columns, and many rows" I'm assuming files is tables?... A masterlookup table sounds exactly like what I need. In my Googleing all I'm quickly seeing about lookup tables is basically exactly what I'm already doing :( If you have...

Yeah I saw it and based on the responses realized that this was something I wasn’t even going to attempt. I’ve got a hat enough time getting the relationships and what not working that I don’t need to even think about going there. Also, coworker, even though we are the “assistive technology”...

Ok got ya. In this case the main would be devices I guess... sorry for all the dumb questions. Sent from my iPhone using Tapatalk

I realize I have several tables that don’t seem needed but I did it in an effort to minimize the chance for my colleges, who are almost computer illiterate from entering some things in wrong. For example, device category will be used to identify devices used as writing...

plog Ok I am trying to start a square 1 with the relationships and the first issue I'm running into is picking the main table. I want to say that the main table would actually be the teacher/student junction table since everything is then matched up to a teacher/student combo. However, I cant...

by schema I'm assuming you mean a snipping of the relationship screen? if so here it is. Its a bit of a mess I feel with all the different tables being so interconnected. Part of the mess is that I am trying to set it up to force the users to have uniformed naming of devices since right now...

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

Finally got it. Figured out. The problem was unrelated to this and I feel dumb. Thanks guys Sent from my iPhone using Tapatalk

Checkbox is on B. This is what I currently have but it’s not working Private sub assign_click() if me.assign=true then Me.student=forms!ipads!studentID ELSE me.student= 11 End if End sub Form iPads= form A Form B= add_apps Sent from my iPhone using Tapatalk

I think I should’ve mentioned that form B is a data sheet. Not sure if that makes a difference. Sent from my iPhone using Tapatalk

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

Did you ever figure this out? I’m trying to do pretty much the same thing and I am stumped. Sent from my iPad using Tapatalk

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

You’re not kidding! And, then when you make something the heads explode as you try to explain what it is, how to use it, and why it’s better than post it notes Sent from my iPhone using Tapatalk

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