Search results

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

That’s part of what I’m envisioning. The problem is that I’m using this for a school system and will, in the end, be linking items to both students, which would be easy by their district ID#, and staff, which would be much harder since We dint have easy access to employee #. What I would ice to...

I have been able to implement what arnelgp shared above but was wondering if anyone knows of a way, or if its possible, to add a button on the form to somehow bring up the Windows built in scanner and have it automatically direct the document to be scanned into the appropriate folder so it can...

I guess my issue, as dumb as it might be, is knowing where to put the code. At first I read it that all of the code needed to be entered into a module. However, that doesn’t make since because I would think I would need something to trigger the code. So, I guess the question is, the module...

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

Finally getting a chance to look at this. That is exactly what I was picturing. Thanks for the help Sent from my iPad using Tapatalk

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

That was exactly what I was looking for. Thanks. Sent from my iPhone using Tapatalk

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

Yeah I don’t even know because I posted that and then went back and looked at the DB you posted and that made no difference. All I know is that my computer as a whole is being buggy at the second. I just did a full reset hoping that fixes some things... for some reason I was suddenly unable to...

Now I feel stupid. Not sure why I was getting the errors at first but then the second problem is that it’s case sensitive and I didn’t realize that. Thanks. Sent from my iPhone using Tapatalk

It throws an error. When I select debug it has the “like” highlighted. If I change it back to a = it doesn’t error but it makes everything fall into the else category if I say “*what*” Sent from my iPhone using Tapatalk

I can get my idea of the code to work if it references a text box and not a combo box. There’s something about using “like” and not = with a combo box that it is not liking when doing a “if then else” Sent from my iPhone using Tapatalk

I can get it to work with... If Me.combo = "Whatever" Then Me.OtherControlName.Visible = True Else Me.OtherControlName.Visible = False End If What I’m wanting is something like If Me.combo like "*What*" Then Me.OtherControlName.Visible = True Else...

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

This makes SOOO much sense seeing this. Thank you!

I agree that would make it easier from a data point of view but how would I then be able to know what accessories go to a particular device? My end goal, and what brought up this original posts/question is to be able to print out a receipt, more or less, of all the items that a kid has and then...

By child you mean only related to the device table? Already fixed that. If you mean a child in the sense of another field on the device table that wouldn’t work as it wouldn’t let me pull a report of how many I have being used/unused since it would be a list of things in that field. Sent from...

Ok charger was a poor example. I’m talking things like an auxiliary cable, usb cord, case, or a carry bag. That specifically will be used with other equipment and wouldn’t be placed on their own and can then be associated with a device as a package and can be easily identified as needing to be...

I could see narrowing it down to student / teacher / campus / equipment. However, I am having to track accessories with the equipment and need to be able to give numbers of chargers ect that I have so I really need the accessory table. What all do you picture being in the "booking" table? I...