Search results

Hi everybody, I did a search on the error but non of the answers are solving it. Anyway, I've got a form and subform. A combo box cmbFrm on the form filters subform to a value it displays. A combo box cmbSub on the subform has onLostFocus event. Now if I do following: cmbSub looses focus...

Hi guys! This question isn’t great importance compare to others but more from tuning point of view. If I delete unnecessary fields (not calculated and not displayed) from a query would it make a difference in performance? Originally they played debugging purpose. Thank you

...I should've tried that.. Thank you

Hi guys! It's unknown for me why Access hasn't got MINUS implemented and Unmatched Query Wizard doesn't help me much. So I'm wondered if anyone had to confront the following task: Table1 Book Agent ---------- b1 a1 b2 a2 b3 a3 Table2 Book Agent ---------- b1 a1 b3 a3 The...

...damn, you good!

For example you had selected Al and Henry: John Smith 123 A Row Selected --> Al Jones 134 X Row Selected --> Henry Ward 323 C Change to sort on this column -+ I need Al and Henry to be selected again: |...

Hi everybody! I’m wondering if anyone had similar problem? I have a listbox with 4 columns, which is refreshed by a query. Every column has a corresponding button, which can change the order of that column. The problem is every time I change the order of any column I loose the rows I selected...

...you're right: the moral of the story is don't try to be smart ass - or you'll get yourself in trouble. ;) now I don't have a break at all

It does the job in flash! P.S. But it disappointing when you try to make one query instead of 3 and it does a bad job.

You're champion! But still, my solution was pretty logical,.... oh well. Thank you.

Hi again, Can anyone point me where the error is? Let’s say I have two queries. q1 gives me these two columns: ID name 1 mouse 2 cat 3 dog 4 bird q2 gives me the following columns: ID name 2 cat 3 dog What I need is to get all names from q1 that don’t exist in q2, so here is: SELECT q1.ID...

Hi Pat, did I understand you correctly: The structure of the SQL query would be like: SELECT DISTINCT BookID FROM query_1 LEFT JOIN query_2 ON query_1.ID = query_2.ID WHERE query_1.BookID <> query_2.BookID Thank you

Hi Pat, Thank you for taking time, but I think a few things won’t make this query work correctly: Firs of all: WeekID and AgentID belong to tbl_AgentWeeklyStockSale, which is not included in the query right now. I tried to include it and got the following error: “The SQL statement could not...

Hi Rich! I didn’t risk to show the query before, because there is would be a big chance that nobody would read it. Anyway, I’ll try to explain what’s going on: There are following tables: tbl_Books BookID (primary) CategoryID DiscPrice Quantity tbl_Categories CategoryID (primary)...

Hi everyone! I wrote not a small query and as my database growing it takes more and more time to get a result out of it. Right now it takes about 3 minutes, some people may say - it's cool...you've got a good reason for a coffee break, but I'm afraid that in a few month I'll be able to take a...

Ok… Sounds like I panicked too early. The awful thing about this sort of bugs is if, for example, I have 5 fields in the Form Footer, where all of them represent totals of its columns respectively and one of them contains a bug, than all 5 of them would show the #ERROR message, not just the...

What's going on? Hi Fizzio, I can’t believe what my Access 2000 is doing with me. Once I thought I’d fixed the problem and the next second it comes back again. I renamed my text box to txtSold and the field where the text box gets its data from called [Sold]. So, to get total of the txtSold...

Thank you Hi Fizzio! You’re champion! I’ve never noticed that the control’s name suppose to be called different from the field name it’s bounded to. Why is that? Cheers.

Hi guys! I have a continuous Form, which displays a few columns of numbers. All I’m trying to get is the sum of each column in the Form Footer. For example one of the columns Named: [Sold] and bound to [Sold] field of a table. So in the Form Footer I created control with Control Source: =...

The same problem! Hi buddy! I've got absolutely the same thing happening with my code, it displays all the forms and reports, but when it comes for execution then nothing happens. Have you resolved the problem, please reply if so. Thank you