Search results
-
A
no Report avaiable message box
Thanks Bob, it's working GREAT now!!! But there's still an error (just as you said in your 1st post), the 2501. Is there a way to make this vanish? I've looked around and searched but it isn't at all clear to me where I have to put the code (and what code). Everything I found was for the case... -
A
no Report avaiable message box
Well, another error now... See the attachment -
A
no Report avaiable message box
Thank you Bob. I insert it in the NoData event of my report but it gives me a Compile Error. It says "Variable not defined", and when I click on help, it explains... "You use the Option Explicit statement to protect your modules from having undeclared variables and to eliminate the possibility... -
A
no Report avaiable message box
Similar case here... Hi Bob, hi habbabub I have a very similar case here. I have a button in a form (let's call it frm_SEARCH_FORM) that takes parameters from the form, passes them to a query (qry_SEARCH), so that a report (rpt_SEARCH_RESULTS) opens accordingly. Currently the report opens even... -
A
Button from subform opens wrong record on other form
Snow? I'm jealous, RG... Anyway, I managed to do it, it works well, but don't ask me how... Being disappointed as I was, I tried the other solution (you know, the "switching boats in mid stream") just for the fun of it. And it bloody worked! So I don't think I'll be a pain in the... head for... -
A
Button from subform opens wrong record on other form
Sorry RG, you are right (well, again...). I'll stick to the previous version and try to resolve it. As you said, I need to get the Charges form working properly first. The generic query to which you refered before should include what records? The client's records, the products records, the... -
A
Button from subform opens wrong record on other form
Look, I think we can solve this another way. The only reason for this form's (CHARGES) existence is to store some charges (well, obviously...) in a table. What I could live with happily is to create a simple form that would store multiple purchases of the same client for the same date. That's... -
A
Button from subform opens wrong record on other form
No, I don't have SP3 installed. And thanks for your patience, I can only imagine how difficult it must be to troubleshoot something in a foreign language... -
A
Button from subform opens wrong record on other form
It's Access 2003 but the file is Access 2000. Here's a link of the same DB converted to 2003 version: http://www.iliasfragiskatos.gr/irene2003.zip -
A
Button from subform opens wrong record on other form
It does compile, but you can download it from: http://www.iliasfragiskatos.gr/irene.zip It's a regular ZIP file, no need to rename it -
A
Button from subform opens wrong record on other form
Sure RG, no problem at all... In the meantime though, I removed the query to which the CHARGES form was bound... But as far as I remember, it WAS updateable Please ignore the initial menu, it is far from completed yet and it is there just to remind me to fix it when done... Thank you P.S. 1... -
A
Button from subform opens wrong record on other form
OK, I did what you said, I changed all the lookup fields in all my tables. I also rebuild from scratch the CHARGES form. I did this through the access wizard, took only two fields (CLIENT_ID and DATE), and then I inserted a subform and bound the two (form & subform) via the CHARGE_ID field. You... -
A
Button from subform opens wrong record on other form
I am using lookup fields in most tables. But as I read in what you sent me it's rather bad... I'll just remake everything without lookup fields (obviously this needn't be changed in all my forms, right?). I'll try and revert to you as soon as possible... When I changed my macro to what you... -
A
Button from subform opens wrong record on other form
The RecordSource of the CHARGES from is a query named qryDATES. This query has only 2 fields, CLIENT_ID and DATE, and it finds these records from an APPOINTMENTS table. Let me also mention that I have set it up so that it shows only excluive records (if that is useful to you). So, at first the... -
A
Button from subform opens wrong record on other form
Report? What report? I only want the CHARGES form to have the CLIENTID and today's date automaically inserted by the SearchResultsSecondary form and the query. I don't understand your question, RuralGuy, should I have a report? What for? -
A
Button from subform opens wrong record on other form
It's bound to a query that takes the CLIENT_ID from the subform SearchResultsSecondary and the today's day (through the Date() function) and is supposed to find the appropriate record (from the CHARGES form). Isn't that correct? Shouldn't it be returning the correct result? -
A
Button from subform opens wrong record on other form
Thanks for your reply, RuralGuy. Well, here's the code... Option Compare Database '------------------------------------------------------------ ' PASS_FORM_ID_AND_TODAY_S_DATE ' '------------------------------------------------------------ Function PASS_FORM_ID_AND_TODAY_S_DATE() On Error GoTo... -
A
Button from subform opens wrong record on other form
Hello everyone, I have a form named SearchResults and a subform named SearchResultsSecondary. Inside the SearchResultsSecondary, I have a button that, when clicked, runs a macro named pass2form. This macro, is supposed to open a form named CHARGES in edit mode, filtered by a query named... -
A
Which way should I go?
Thanks Ken for your prompt reply. If that's not too much, can you please suggest which fields the order table should include? Furthermore, can I have multiple purchases for a single date this way?