Search results

I'm an absolute idiot, guys. I linked the table through the import wizard, and I'm just realizing that it saved the DSN file in my personal Documents folder. Moving it to a network folder fixed the issue. I'm sorry.

When I access the permissions of the database in SSMS, the users are listed and they can access everything in SSMS (sorry; not sure if that's what you're asking)

hmm interesting. Yes, I did use the wizard to import the table. I'll look into importing it via VBA (hopefully others know more as well). Thanks!!

Hello. Apologies in advance...this is the first time I'm linking a MS SQL table to Access so maybe I'm doing something stupid. I moved my Access data to my IT's SQL server and then linked it to my Access DB. It works flawlessly for me. When our other user tries to open the table in Access...

Ah that did the trick. It was hidden well. Thank you!

I inherited a DB and on startup, one of the tables is automatically opening. I do not want users even seeing the table, let alone tinkering with it. But I have no idea how to turn this off. The only way I know auto opening something on startup is listing in the startup form in Options, and obv...

Do you know how I could get the address for the location to pop up on the main form when that location gets selected? I've tried to add it as another column and have a text box based on that but I can't seem to figure out the exact steps

And when adding employees, what if there was a form that had you input the name of the employee, select the locations from a list box, and lastly, all the appt types are listed out with a text box next to each one where you would type the preference?

Thank you so much! While users will be using the forms, I will be the one managing the database. While I'd like to make all changes using forms, what's your thoughts on just manually adding / deleting employees (and their subsequent appt types) in the tables themselves for now?

Attached! Thanks!

Got it!! Sweet!! You're legit teaching me so much lol Now that I have a workable junc table and the naming conventions are accurate, how do I go about creating that glorious main form with sub forms from a few replies back? That way I can start manually adding in the preferences

So I guess my question is, if I already have that junction table with the employees at their respective locations, how do I Cartesian that with every appt type? Because you're right, that's definitely ideal in this scenario. I just don't know how to do that

Yea, so its only one preference per appt type per employee per location so essentially its when "Employee 1" works at "Location 1" with "appt type 1", he/she prefers "preference 1"

No its actually the opposite; pretty much all the employees work from a single location. There's only a handful (maybe 10) that cross over into another location I listed these out in the junction table. You'll see there's a few that work at 2-3 locations, but for the most part each employee...

Omg that would be so perfect. The only thing I'd change is switch the locations to the main and form. Because there's roughly 17 locations but 120 employees. So it'd be much easier to choose the location and then see the employees that fall under that. I attached a dummy database with the three...

Perfect! Its building very necessary. Just gotta do data entry now. One more question. What if we receive new employees? What would be the method for adding them into the database? I guess I could have a form separate form that adds new employees, and then you go to the junction form to setup...

Okay so here is another question: Lets say I made tables for employees, locations, and appointment types. And then I link those up via a junction table, and then make a form to begin data entry. Ideally, I'd like to have three drop down selections, one for each category (employee, location...

Perfect! Thank you so much! This is what I was looking for! Last question, with it being implemented like that, is there a way to set up a form that nails down on all three? For instance, the user would select - the location, - then the employee, - then appointment type, and it populates...

Yea you're definitely right, I'm using it similar to a spreadsheet. Maybe you (or someone else) can give me some advice on a redesign to help streamline this process. Basically its a table that has appointment types as field names. Roughly 25 of them. Then in the first column are employee...

I have a massive table and am looking to create a form that helps to easily locate info I'd like to make a form that has two drop down menus in this order - the field name columns - the first columns data This would essentially triangulate a specific cell's data and that's what I'd like shown...