Search results

Nevermind...I just added a where clause to my SQL statement and all my problems are resolved.

O.K., new problem. I have a qry which pulls all of the hours recorded by user, by task, by project. It processes extremely fast (6 seconds) considering how much data it pilfers through. That's because I'm doing the sums on the report (by user, by task, by project). Now, here is the dilemma...

1. Order has to be on hours, not name -- project requirement. Plus, that still wouldn't alleviate the problem of having the hours for the second person disappear, i.e.: Anderson 2 Butler 3 Curtis 1 Ericson Harris 4 I thought this had promise, but it...

[RESOLVED] Toughie? I have a report, which shows the following Projects and Tasks from my company's time reporting system. There is a grouping on each TaskID within a grouping on each ProjectID. Here is the problem, some of the tasks have several workers logging hours against that task (which...

Here ya go... Ran into a very similar issue. This should do the trick. http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q302/4/92.asp&NoWebContent=1

Nevermind I'm retarded. I won't ellaborate...I just found out that I am retarded. I must go cry for a few hours.

I have a form, with a linked-table as its data source. When the user clicks a button, an ADODB.Command is built for the appropriate stored procedure (add/update/delete). I am using ADO and the command object so that I can get the autonum primary key field after an add. Here's the problem...

[field1] has to be qualified, since there are multiple tables being joined in the query.

On a related topic I have a query for a report, as well. I decided to build the where clause as has been noted here. Now, when I attempt to open the report, I get a prompt asking me for the value for the criterion I just set up! It's like this: stWhere = "[tbl].[field1] = " & lstThis.value...

A stab I don't think that will work. The problem is going to be, that when the database is opened, it is opened locally on whatever machine the user is on. As such, the .dll that is required, will have to be registered on their machine for the reference to work. I would be open to hearing if...

Takes a lot of intelligence to say 'ditto' Pat, 1. I don't know why you would say I still don't get it (as though I didn't get it before). Maybe you should have read my response and Doc's response back before writing this article. 2. If his p.o.v. was what you actually felt, you would have...

Means to an end... I think we're both on the same page. I was only griping about putting logic into the SQL on my query that feeds the datasheet, versus us being in the nth iteration of this software, and our lives don't seem to be getting incrementally easier with each version. But, yes, it...

Not as long-winded O.K., you said a key word in all of that..."assume". You assumed that I am working with subforms in continuous mode, and directed at least 50-60% of your technical lecture on that subject. I am not dealing with a subform in this instance whatsoever. I understand the...

In the future Try doing some searches on the forum with different combinations of keywords that uniquely describe your problem. If you don't get any results, then use more general descriptions. If you think you have too many results, try to be more specific. Inevitably, it seems we always...

Here ya go... http://users.impulse.net.au/predator/Downloads/ComboSamples.zip The site that is from is: http://users.impulse.net.au/predator/accessdownloads.htm

Thanks! I'm not completely sold on the clicking into the record, and then having it enable/disable (graedus' question)...if a user wanted to be able to visually see enabled/disabled without clicking the record, problems arise. But, I digress, the fact remains that you have shown Access to be a...

Impressive O.K., so I should be able to see this working as well, but like I said, my db doesn't work. Yours works smoothly. Here is the same db that I attached before (I converted to prior version). See if you can open it now and make heads or tails of it. Thanks!

Sorry for confusion, When I previously said it worked, I only tested with a textbox, and I changed the control source (like you suggested), and I saw the value come up appropriately (-1 or 0). I forgot to check it on a checkbox, to see if the checkbox was enabled and disabled accordingly...

Back to previous... Your last post is true, but on the previous subject: I just tried it, and it doesn't work. I will attach the database for your viewing.

You're reply should have said "CAN" I stand corrected. That worked...but back to Graedus' post, is there in effect a way to enable or disable a bound or unbound field (on each line in a tabular form), based upon a value in the record...the answer is still: VB: Yes Web: Yes Access: NO...