Recent content by mahmudich

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...