Search results

So, stupid question, tech services reminded me of SQL Express and I’m thinking of transitioning over to it. However, they were trying to tell me that the basic setup would be the same as what I have now, BE file on a storage server and FE on each individual computer, and that it wouldn’t need...

Well that was a quick response. Tech services from the district said that they have an SQL server but they do not provide end users access to it, which I understand generally, and it would be about $1.5k-$2k for them to add anything to it due to licensing. The suggestion was to “unsplit” the...

Thanks guys. I have been toying with switching to an SQL but was hesitant because I have never worked with one and I’m pretty clueless on it. Also, this would require access to something that I don’t currently have. I would assume that the district has some sort of an SQL server for something...

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

The first step is going to be splitting the DB to have a front end and a backend. The backend will have to be stored on a network drive that all the users have access to. That’s kinda the easy part. The harder part is the fact that each user will have to have a copy of the front end on their...

Never mind. I had a typo in the code and I wasn’t running the form as acDialog Got it working. Sent from my iPhone using Tapatalk

So here’s what I tried and I still can’t get it. Form1 private sub Searchtch_click() Docmd.openform “search_for_staff” Me.test = GetTeacherID() Form “search_for_staff” CODE]public sub AssignStaff_click() Dim strTeacherID As Long strTeacherID = me.TchList Docmd.close [/CODE] Obviously I...

I have been able to use screen.activecontrol.parent.name to get main form name and screen.activecontrol.parent.parent.name to get sub form name. However I am having a hard time putting them into a variable and then using the variable to reference the appropriate control on the correct...

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

Yeah it was just 1 record. It was an easy fix. I would like to think I would of come to that procedure myself but it would of taken a heck of a lot more time... yeah don’t know why I said Japanese. It was a toss up for me lol Sent from my iPhone using Tapatalk

Just what I needed Ridders!... thanks guys. Sent from my iPhone using Tapatalk

Yeah already tried that. I’ve tried every way I can think of... through a form, directly through the table, and through a delete query. No luck. Sent from my iPhone using Tapatalk

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

How do you even figure that out? I’m a speech therapist not a software designer or anything like that. I often look at things in regards to the cost of materials but everything needed for this was already in house. The true cost here has been time. To get where I am today I’ve been working on...

Well considering this woman that’s doing the audit is being paid to find problems and offer solutions I feel like you might be right. She might be coming at it with the mindset of “if I say something is working well then I haven’t done my job”. My coworkers, don’t get me started. This is my...

Thanks Guys. She caught me so off guard that is was kinda speechless and pissed off. Tomorrow should be interesting. My department has a focus group meeting with her. I honestly wouldn’t be surprised if she asks the 60 something year old woman on my team, the one that has seriously asked me what...