Search results

Wow, I got a lot of replies really quick and didn't even realize it. :D Cosmos: Thanks for the links! I can't get the first one to work, but the second was quite helpful. :) RichM: I was planning to use a lookup to the other tables, so that tblPosition showed the actual data instead of an...

Thanks, Graham. I thought I was going in the right direction, I just wanted to be sure. If I want to return other values, could I just use the lookup wizard when designing my table? --Sara

Hi! I am about to start up a new database for HR tracking their positions, vacancies, applications, etc. It's a bit more complex than my first database, so I'll probably be poking around a lot. (You all have been so great so far, and my first database went over quite well!) Anyway, my...

Thanks! I don't know what I was tweaking before, but it wasn't coming up with anything, but this time it worked! Thank you so much for your help. :) --Sara

Thanks for your response! I'm not sure it's what I'm looking for, however. I don't know much about SQL (I do all my stuff the point and click way...) but it looks like you're asking it to find a null value in the Employee table... The thing is, every employee has a position number, but not...

Hi, Everyone! I was just asked a question by someone in HR about her database, and thought y'all might be able to help me figure it out... There are two tables: Employees and Positions. She wants to run a query that will show her all the vacant positions. Is there a way to check to see...

Thanks, Pat. I'll definitely look into those.

P.S. Doc Man, Yes, I am backing up my database, dually, daily. I've learned *that* lesson, thank you very much! :p --Sara

dp, Funny about that Map thing. I'd like to say we were here first, but I don't think that's true. I like New England a lot. I'm moving to Chicago for a few years, but I plan on having a family in New England, probably New Hampshire. Nice that you're close to Boston and Providence. I'm...

Thanks, Doc Man! That's quite a brain full! (Especially when you whipped out the Calculus. Woah.) Nobody access the db remotely, so we're at least safe there. Also, the network administrator has only given access to the people in this office, who each have network passwords and the db...

Thanks Thanks Hayley, Alex, and Neighbor! I'll look into all of that and see what I can finagle. Hopefully we can work something out... I was just so excited because my database was all done, and then he hits me with that... Lawyers... :rolleyes: bodhran1 - Where in Mass is Uxbridge? I'm...

Does that take up a lot of space? Do you think I should try it, but recommend a limitation? If each case has five one-page word documents, that's about 20 kb each, for 100 total per file, making it well over 120,000 kb, and as the database continues to grow, that will also expand. And we're...

I was just approached by one of our attorneys about adding something to my database which I think is borderline ridiculous. I basically just want affirmation... Or contradiction is fine, too, I suppose... Anyway, my database tracks all of the files we have in the office. It shows whose case...

Well, I hate to be the one who disagrees... but what the heck. I like Audrey's first one the best. Though I think they're all great. But the first is definitely my favorite. I enjoy symmetry. :) --Sara

Thanks, Jack. That does help a bit. But I'd still be willing to look at anything anyone else can find, too! :D --Sara

Hi! Does anyone know of a place where I can find a comprehensive list of different operators for queries as well as a good description of where, when, and how to use them in context? I am trying to create a sort of manual that the people using my database can refer to that will help them do...

Go to Tools -> Start-up, and under "Display Form" select your menu form. --Sara

Have you tried working with the switchboard manager? It's pretty easy to use and sets the whole thing up according to your specifications. It can be found in Tools -> Add-Ins -> Switchboard Manager. You can edit the look of the switchboard the way you edit the look of any other form. I...

Thanks, Pat, for helping me understand. I thought that was what was going on, but I wasn't sure why or what to change. thanks, cpod for showing me what to change.

uh oh... Okay, so the search form works fine on most records. However, on some records it gives me a Run-time error (#3075). I've looked at the records it does this for... they seem to be the ones with an apostrophe in their title. (ie "Ernie's Gas") Syntax error (missing operator) in query...