NeoPa, if my F-E database weren't 75+Mb I'd gladly upload it and have you look at it lol What did you mean by the FROM clause? Is it possible to DSUM from two separate tables/queries? If so, that solves my problem right there : )
Are there any examples of this? I looked on thescripts.com before I posted this plea for help but I wasn't able to find anything that was similar or somehow related....
BinaryGirl23
Last Activity: Jan 10 '08, 11:08 PM
Joined: Oct 11 '07
Location:
-
I guess I was being a bit unclear with my last post : ( I do use NZ to prevent null values in all of my reporting. The problem that I'm having is that if an employee works doing only those "extra jobs" and none of the "regular jobs" then the report won't find it.
So here's how the report is reading the code: 1) Report opens up and OnOpen it changes the recordsource to one of several queries (all relatively similar)...Last edited by BinaryGirl23; Dec 12 '07, 05:09 PM. Reason: Forgot that TS.com omits redundant spacesLeave a comment:
-
Report to pull data from different tables
Hi Everyone : )
I hope that this question is actually something easy in disguise. Re: Access 2003 I have a report that displays information about which of our employees worked at a given job over a period of 2 weeks, and displays how much we paid them for their work at that job (using DSUM to calc all those records within that 2 week period). This works just fine.
The problem is that sometimes our guys work at these... -
Ack! Don't tell me things like that. lol What my 'fix' so far has been was to create a new db with a new table and populate all my necessary fields, then import that into my current BE DB - now that actually worked okay but it seems like a roundabout way to deal with this and if my DB really is corrupt, then I just have a bigger problem. I'm going to copy all the new table entries then revert back to my last archived DB and put all those entries...Leave a comment:
-
Can't compact BE database due to 'exclusive' error
Hello,
I'm having a bit of a problem regarding my back-end database for Access 2003. The db is set for shared mode, has no programming code at all, only back-end tables that is shared on our server, that everyone accesses. Everything has been working fine up until today.
So today I need to add about 20 fields to one of our tables (making the total about 40 fields in all for this one table). When I go to save the table,... -
I appreciate your help NeoPa : ) I personally have been doing a lot of other access related coding and I've just neglected this item for now. Anyone else who wants to look at this as well is more than welcome to share their input : D...Leave a comment:
-
B-B-Bump!!
B-B-Bump!!Leave a comment:
-
Hi NeoPa,
Well I couldn't upload my database because even the front-end is almost 20Mb right now but I was able to at least re-create my problem (I added some comments so you get an idea). It's a very simple re-enactment of what I'm trying to do. I'm hoping that by doing this, it will make this problem resolve itself via becoming self-evident lol
Thanks for taking the time to help me out : )
http://w...Leave a comment:
-
I think this is the right direction (using the setfocus maybe) but when I run this it tells me "Runtime Error: 7777 You've used the ListIndex Property Incorrectly".
The debug process highlights "SelectionLst.L istIndex = intCounter" as the problem. The ListIndex count was at 19 and the intCounter was at 20 if that will help. I'm really curious now about this. NeoPa you've been a big help so far - you have any suggestions??...Leave a comment:
-
Well I tried both of the suggestions but I still can't get this to work : (
The "InputGoodi es" function that I'm referencing looks like this:
..and it goes on for another hundred lines asking questions,...Code:Public Sub InputGoodies() If Price1.Value = "0" Then Price1.Value = SelectionLst.Column(5) SqFt1.Value = SelectionLst.Column(4) ...
Leave a comment:
-
Running function for each item in listbox
Hello,
I'm sure this is such a simple question I didn't even want to bother posting but for the life of me I just can't get it to work : (
I have a button that toggles "Select All" and "Select None". Whenever the user clicks "None" it runs a function that clears a series of data and likewise when they click "All" it inputs a long series of data. The function works as long as the... -
Thanks Nico!
It took me a while to get this all to work with the code I was using but I couldn't have done it without you! You guys on here are really smart - I really had to wrap my brain around this for a while lol
-CatherineLeave a comment:
-
Finding a value NOT selected in a listbox?
Hello everyone,
I'm having a bit of a problem regarding Access 2003 which I really hope is an easy one to solve! I'm using a multiple-selection listbox control to look up values of one table and then it takes the selected values and puts them into a memobox (the values are delineated by a comma) that we can print on a report.
What I would like to have happen is that the user be presented with this same list of possible...
No activity results to display
Leave a comment: