Search results

Ok. I've got this almost working, but I still have one problem. To start with, here is the code I am using: SELECT SrvcRest.*, ReRoutes.[Bulletin #], ConcatRelated("[Bulletin #]", "SrvcRestandBulletins", "SrvcRest.ID = " & SrvcRest.[ID]) FROM SrvcRest LEFT JOIN ReRoutes ON (SrvcRest.EventDate...

Alright guys, I appreciate the help. I have separated things so that there aren't multiple values in one field and everything is working splendidly! However, I have one last foible to work out: If a route event matches more than one bulletin, then the query generates two records for that event...

Actually, I do have one more question. The ROUTE field in Table 1 will always be one number ("120", for example) whereas the AFFECTED ROUTES field could be just "120", or it could be "32, 72, 120, 128". How can I configure the query to match those two fields and find the route in the list?

Ok. That definitely helps to point me in the right direction. I'm sure I'll be back with more questions about this, but this is a good start. Thanks for the quick reply! And don't worry, the column headers above were simplified for the explanation. I've already learned my lesson about using...

Hello all! I'm trying to design a query to perform a certain task, and I'm having trouble figuring out how to approach this (I'm not terribly savvy with Access.) Here is a simple example: Table 1: DATE | ROUTE | OTHER FIELDS... Table 2: BULLETIN # | START DATE | END DATE | AFFECTED ROUTES |...

Okay. It seems I am back to square 1 now. I can't use a Macro in the workbook, as it turns out, because other users do not have the appropriate permissions to run Macros in Excel. Therefore the macro does not run and the file does not hide and/or exit on its own. I have therefore gone back to...

Thanks. This was a simple solution that seemed to work perfectly! If I need to edit that workbook, is there a way to stop the Workbook_Open event from running if I want to open the workbook to edit it? I thought holding down the Shift key was supposed to do that (as it does in Access) but it...

Hey guys. I have a question. I need Access to open an Excel file prior to pulling information from it, because the Excel file itself only updates when it is opened. I was able to achieve this with the code below: This works fine if NO Excel window is already open, but if the user happens to...

Well I have managed to link each field to an individual column. However, the problem is that I end up with one record with 100 columns (one for each route assignment.) This too wouldn't necessarily be a problem but I need some way of flipping the table so that I end up with two columns, rather...

The board is more of a GUI setup for the dispatcher. In the case of Excel, they have a "front end" worksheet (a screenshot of which is attached below) and then there is a hidden worksheet which is just two columns as I described above, linked to the various cells. That hidden worksheet is what...

I'll try to do this as briefly as possible, but I would really appreciate anyone who has the patience to understand this and help me come up with a solution, if there is one. Currently, I have a "Vehicle Assignment Board" in Excel, which allows a dispatcher to assign different vehicles to...

So it turns out I'm a MASSIVE idiot. After two months of various versions of this setup, I just now realized that all these individual lists of shifts that I have that need to be ignored at different times all have one thing in common in the description, meaning that I can just universally...

You asked for it, lol, so here is what I have. Feel free to laugh at my stupidity, as I am a complete n00b. First, the code that is run when the user clicks "print": Then, we have the code for the union query that the "ShiftChange" report uses: That's everything. Would you like me to...

Would you be able to elaborate on that for me to get me pointed in the right direction? I'm very new to SQL, VBA and Access (as you've no doubt figured out) so I could use a bit of a head start, as I'm not sure what you mean (I know what a function is, but I don't know what you mean by using one...

I'm attempting to avoid having a crap-load of queries, because this software is eventually going to be maintained by people who are NOT IT people, lol. Using TempVars allows me to have one query that can cover a range of potential applications (for example, there are shifts from A to F, and I...

So I have the following statement: Those TempVars (in bold) are defined using the following code before being referenced, and there is no issue with anything. It all works fine. However, I also have this statement: In this case, those two TempVars are defined using the following piece of...

Hey guys. I've got some code here that seems to present a bit of an issue. It basically joins two tables together, but ONLY includes records that are unique to either side (so basically joining two tables and not including records where the employee number shows up in both tables.) It works fine...

Simple question. I originally designed my database on a computer running Access 2010. This caused a lot of headaches when using it on computers running 2007 (as in, it wouldn't work) so I spent the evening at work on a computer with 2007, figured out what features weren't compatible, and then...

I just wanted to follow-up on this thread. I ended up "solving" the problem by adding some VBA code such that Access opens the Excel document in a new hidden Excel window prior to calling anything that references it. It then closes the window when it's done. Problem solved. That way whether they...

I see what you mean. By the way, I attempted to create a blank Access Database on one of the workplace computers themselves, and then link the spreadsheet, and I have the same odd issue. If I don't have the spreadsheet actively open in Excel (and at this late hour, there is nobody actively...