Search results

Thanks for the reply. I suppose that would be one way of doing it, however I am trying to create an "integrated" program, and so I hate the idea of them having to have a separate window open with Excel running. I'm starting to think I might just have to re-create the Sheet in a Form in Access...

So I have this lovely, pretty Excel sheet full of conditional formatting that is used as a vehicle assignment board where I work. I know I can embed the file into an Access form using an unbound object, and therefore "integrate" it into Access, however this creates a copy of the file, and...

I... love... you!

Simple question guys. If I have a Query, and I want to list the sum of one of the columns of that query in another text box on a form, is this the correct way of doing it? In this case, "Drivers Other Shifts" is the name of the Query, and "Duration" is the column header. When I try this I get...

So does anyone else have any other suggestions, or am I SOL at this point? I just can't picture the equation I have being "too complicated" considering some of the other stuff I've seen on these boards...

Thank you for your reply. I did what you suggested, however I am still receiving the same error message! As I said, I don't think that's the issue, as Frame11 is always on the active form,and if it isn't then the program just prompts me for the value of Frame11. It's better practice to do it the...

Small Change = Error Message Hey guys, I've got a bit of a mystery that I can't seem to solve :banghead: I am getting an error message for one of my queries (the code for the query is shown above. The error is shown below. The query was working fine and I never had any issues until I tweaked...

Hey guys. I'm printing out reports that require a lot of information to be squeezed on to one page. The result is very narrow rows of information. Because these have to be read by all sorts of people, the text needs to be as large as possible within these rows. I've run across an issue where...

Well, thank you for confirming that I am in fact a complete idiot, lol. This is the first time I've done anything with Access... which is funny because this has turned into a beast of a program. I've been learning as I go, through trial and error, and never messed with Forms, so I thought a...

Just a really stupid question, as I must be doing something blatantly wrong. I have a Report that displays as a pop-up which is the 'front end' to my program. Basically a whole bunch of buttons to open various other reports and/or external links, etc... I have this report set to open as a...

Unfortunately, this is an awkward scenario. I cannot change the structure of our database, as we NEED to have the various, SEPARATE tables for a variety of reasons. I appreciate your replies. I ended up creating, essentially, several reports that are each linked to an individual table. Makes...

Hey guys. I'll start by saying I know next-to-nothing about Access, but I've managed to build myself a decent little program by muddling along. I've gotten to a point where I need some help! I currently have this as a query in my file: SELECT * FROM [Shift List] LEFT JOIN RUNSHEET ON...