Search results

Need Help with Summing Query (SOLVED!) Hello again! Another question, since you were so helpful with the last one: I have four columns: Employee, Discipline, AvailableHours, TotalHours. I want to summarize these by Discipline, so that for a list of employees, I wind up with a list of the...

Okay. I see what you're driving at. I'll try that and see what happens! Thanks! EDIT: Yup! That was what I needed to do. Thanks again!

That's more or less what it is. However, the engineers table isn't linked because they add/remove them at will, so that information is copied into the assignments table for each entry. See the attached screenshot.

Thanks for the reply. It is possible to have multiple design leads for a project. The way the database is set up now, users complete a form for the project, and then there is a subform (continuous form) where they can enter a bunch of engineers who will be working on the project, along with...

Hello everyone. I'll try to explain this intelligently. I need to generate a report that uses a Left Join query. The tables being joined are a "Projects" table and an "Assignments" table. The Projects table, as one might expect, has one entry for each project being worked on. The Assignments...

Thanks for all the help guys. I did end up removing the .Value property from all of my code. I did, however, discover one instance where I did need to keep it. Setting a TempVar to the value of a control, I have to use the .Value property, or it tells me "you cannot store a CONTROL in a...

Sounds good. I'll stick with Me. for the time being, but quit using the .Value property like a n00b. Thanks guys!

Oh wow. That's neat to know. Never even thought to eliminate the 'Me.' Though I do like that 'Me.' sets off IntelliSense which helps me ensure I'm typing the correct things. To clarify. I have "ModifiedTimestamp" as a column in many, many tables, but I can just use the name without the 'Me.'...

Question guys: When is it appropriate to use the '.Value' property in your code? I'm OCD about keeping code as neat as possible, and I started wondering if I was doing things properly. For example, when referring not to a control, but a field in a linked table, which is the "correct" form to...

Hello all. I'll cut to the chase. I have an Access front end and SQL Server back end. I use DSN-less connections to link up all the tables. If the user doesn't have the rights, then I get this error: and then it displays a small login window with the server info, etc... I want to avoid all...

Crap, I'm sorry guys. Forgot to state that it was indeed solved. Turns out the other subforum was indeed the place to post it. Thanks for the help though! I'm slowly learning!

I literally just figured this out! It seems to work now. The reason I didn't figure it out sooner is exactly what you said - it shouldn't have worked before, either. There are several bugs that have appeared ever since the conversion that SHOULD have been bugs beforehand, but worked fine, which...

Hey guys. I recently converted my back end to SQL, and since then I've been trying to track down things that broke, and fix them. I posted this in the SQL subforum, but I think it's actually a VBA issue, so I'm putting it here too (this subforum is also much more active.) I'm having trouble...

Hey guys. I'm new to SQL, and I can't seem to resolve this problem (and neither could my SQL friend.) I recently converted my back end to SQL, and since then I've been trying to track down things that broke, and fix them. I'm having trouble getting timestamps to communicate properly between...

Understood. There is definitely a lot of cleaning up of things that needs to be done. In the meantime, does anyone have a solution for how to use a 'greater than' statement with a value that might potentially be null?

Hi guys. Did what everyone here suggested I do and converted my back end to SQL Server. I'm still learning SQL, so I'm tracking down all the things that broke during the migration and am trying to fix them one at a time. Here is a bit of code that worked fine when the back end was in Access, but...

From what I understand, I could use SQL Server as the back end, but there are two problems with that solution: 1.) I've been told that converting an Access Database to use SQL Server tables, while not impossible, does require quite a few changes to a lot of code - especially if you use VBA...

Thanks for the reply. Currently some satellite locations do experience significant lag, however all of these locations are being upgraded to fiber, so the network speed issue should hopefully be resolved. As far as updating, I'm actually not too terribly concerned with that at the moment. For...

Hello All, I've done a little bit of Googling and some searching here, but still feel as though I don't have a firm grasp on this subject. This is my first "real" database that I have built. It is going to be deployed to many users, at many satellite locations across the city. Prior experience...

Heh, yeah I gathered that. I was looking here: http://www.utteraccess.com/wiki/index.php/RunSQL_vs_Execute