Search results

Thanks for the pointers ...Any chance you could give me some code to do this as I'm having problems understanding how RecordSetClone works. What I need is something like : If cboChoiceSelect = Table1 then RecordsetClone = "Table1" else etc... .. but I'm not sure of the syntax.

I make a selection on a form to choose the source of the data (ie I set the form's Record Source depending on the selection combo)- to one of three tables. I select this source then go to a combobox to choose a particular record. I use the recordsetclone structure to pull through a particular...

Job Done Thanks for your help. Works a treat now.

Row Source I see where you're going. But I still need to give row source somewhere to fetch its combo list from, ie the Fullname list from the selected (one of the three) tables. I was hoping to refer to the table name in the sql code by referencing cboSourceChoice contents? my problem is how...

I have a 'dynamic' form which can be linked to 1 of 3 tables, the active one being chosen from a combo cboSourceChoice. The tables are called NPD,NPDy,NPDz. On the form I have another combo Called Combo2, which I use to select the record to display in the form. In the Row Source I am trying to...

Loading up of Row Source property Thanks llkhoutx for the helpful suggestion. I have used this idea to help me progress my problem, but am still having difficulties. It is the Row Source property of Combo2 that I need to dynamically change , synchronized with the (source table) selection made...

I've been wanting to use the same form to query three similar tables. I have managed to achieve the Record Source part... (see link http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=59283) Now, I need to select records from the chosen source table. Basically I need to...

Bang on the button.. Yep. It sure did, thanks very much. Apologies for my failure to follow your excellent instructions, the first time! :o Many thanks, again, Brad. PS. VB maestro drinks VB Bitter? Surely no coincidence. Perhaps I ought to try some!

Sample attached Brad, Thanks for the suggestion. I see where you're going with that. Its not quite what i want. When I search using using first combo, I retrieve all the data in the form, but I also want the second combo box to show the matching data in the box window. At present, it remains...

OK the first part i can do (ie Bring up data via either combo box).. For example i want to be able to select a person by their name or by their code number. I am using recordsetclone statement to pull up the data at present.... But how do I get the second combo box to display the 'matching'...

NOT cacscading my combo boxes Yeah, I thought of that, thanks. but I'm not trying to cascade my combo boxes....... I want to search by 2 (or more) alternative methods and have the non-searching box(es) show the matching data correctly. I'll have a look through the cascading posts anyway, just...

NOT Cascaded - Bring up data via either of 2 combo boxes OK the first part i can do (ie Bring up data via either combo box).. For example i want to be able to select a person by their name or by their code number. I am using recordsetclone statement to pull up the data at present.... But how...

I know the feeling This seems about right: Balance: IIf(((([MonthlyRent]+[Prev Balance]-[Rent Paid])>0) Or ([Date Rent Paid] Not Between DateSerial(Year(Date()),Month(Date()),1) And DateSerial(Year(Date()),Month(Date()),5))),([Prev Balance]+[MonthlyRent]+[Late Fee]-[Rent Paid]),([Prev...

Set Warnings Set Warnings refers to the dialog that you normally get when you run a query. Usually says something like 'You are about to run a query that will ....'. This is handy to have on when testing you design, but if you switch them off in a macro, then the macro can do its job - ie run...

Make a temp table You could make a new temp table with a MakeTable query and then export the newly made table. eg SELECT * INTO test0 FROM testjunk Where id=[x]; Create a macro to run the queries as follows: Set Warnings OFF Run your new MakeTable query now, making a new table Do the export...

Half full, half empty Or ... A (probably, very) long story kept (sensibly) short... Either way, thanks for your help. :)

All luck - no design! ..Namlian Thanks for your reply, most interesting. I've never (knowingly!) used DAO (or ADO). What are they all about and why would I need to use them? (The reason I removed this line was pure 'luck', as I had been getting a ' Compile error: User defined type not defined'...

I think i've sussed it See attached db1plus.mdb The trick seems to be that the date range over which you are going to count the referrals, needs to be filtered out first see q0 in the db1plus.mdb Then do the grouping in q1, and finally use q2 to arrange your data as required. You may be able...

.00 Oh yeah! Forgot that bit! In the query, where you put in the formula to do the rounding, make sure that the properties of this new field (in the query) are set to Currency or Fixed.

Now 23 Not quite sure what you're after but ... Removing the lower 'true' from under the criteria for OnBoard field in qryPracticeReports-WestLeagueTable gives me 23.