Search results

Well... to be honest, something troubled me about your question. You said: >> a card can only be associated with 1 person (i.e. client_id in ORDER), So each of your cards can be associated with one one Client. Does that mean that a client can have many cards, but they all belong to only one...

As strSearch is declared as a string: (Dim strSearch As String) Then the comparison to Null won't only possible fail - it always will. As a string can never be Null, your other lookup strSearch = DLookup(... can also fail (fail as in raise an error if Null is returned). So another Nz wrapping...

Hi You insert a new row into the Cards table: >> strTmp = "INSERT INTO CARDS ( CARD_NO ) SELECT """ & NewData & """" But, as you said, you have criteria upon the combo source to limit the results. FROM ORDER INNER JOIN (CARDS INNER JOIN ORDERCARDS ON CARDS.CARD_NO = ORDERCARDS.CARD_NO) ON...

I agree wholeheartedly. And that, without a mechanism specified, any solution is valid. (Even possibly one the course teacher isn't necessarily familar with!) Toby was indeed trying hard, but with a good few syntax errors and concept grasps yet to come. When struggling so much with coding in...

You'd have to assign the goup in code - which is no as trivial. There's a thread here (started by an absolutely charming member) on that subject. http://www.access-programmers.co.uk/forums/showthread.php?t=215544 Everything Brent has to say I agree with. The concept of a Maketable and then...

Hi A few questions. What is your method of execution? Literallly one of the Execute methods? (You'll find UI like execution with a DoCmd.OpenQuery instead - though you must also hush warning messages.) Not that I'm advocating them as a preference. You can delete the table first in code...

Well, I'm sure you'll appreciate that respondents in any quality forum would be about as like to give you the full answer as the teacher here (or your own teacher). In any query in Access, an entry in it that's not a data object (table or field) is considered a parameter. If you use a form...

There's some weird part of me that finds it wonderful that there's an AS level ICT student being clocked by someone teaching the course. :-) If it's one from your own college/school.... Busted!! :-p That said (and my enjoyment put aside), I do agree. (With most things already said in fact.) No...

And yes, CopyFromRecordset works in 2003. As it's part of Excel's object model and as it accepts either a DAO or ADO recordset, then by the point of calling it, Access as a data source is essentially redundant. :-)

I've a long standing generic function to do that recordset insert work for you. CopyFromRecordsetPassed. Same concept, wrapped up re-usably. http://www.utteraccess.com/forum/Export-Excel-Sql-t1976533.html You'll see how to call it there too. You should be able to see that site no problem...

I don't think Nulls are the problem here. As I understand it, it's the lack of a field being included in the resultset at all. (Hence the #Name). And perhaps extra fields not included. Null values would be happily returned and displyed in controls with are bound to the field returning them...

Hi Rather than specifics, some general comments: Ummm did you say "to" an ADP?? The first thing to mention is that the latest release of Access (2013) no longer supports ADPs. I appreciate you say you're using 2003, but can you be certain that it won't be opened by a user in Access 2013 at...

The mechanism you're attempting isn't unbound. You're binding the form to a recordset, thereby making it bound. (It's simply being bound late.) You would have control sources set up for the textboxes as normal (based on the field names in the table). If you want a truly unbound form, then you...

You're welcome. Glad to know it was indeed the reason (and therefore, follow to have been the solution. :-)

I understand your scenario. There's no problem. But you reported an non-printable Ascii character. I was supposing it might have been due to type conversion - and that is we type cast the Null which was being UNIONed with that integer data, it might have prevented that character problem (it...

Yeah I realised after posting that you don't need this value to bind the coombo's value (unless you were making the 5th column the bound one - which would be unusual). But I'm way too pressed for time to start mentioning addendums to my posts at the moment (unless prompted to do so :-p) None...

Well, you've lost Null then really. You've got a ZLS. However, that is, at least, an actual value - so your combo box can retain that selection (whereas it will lose any Null entered, returning to no selection). You just need to compare against a ZLS instead of Null for subsequent use. Just...

It's apparently showing a, previously, non-printable Ascii character... It could be data type coersion - but that would be a common occurence during which you wouldn't expect to see this. I see you've posted in the mean time... There's nothing wrong with specifying Null as Null. Perhaps a data...

Oh... Examples of assigning recordsets to list controls... Yoinks. Several files do that in the examples page linked to in my sig. Combo Filter is one example and more involved are the last two Generated and Shaped recordsets (which contain a lot more going on that just the assignment to a...

Once assigned as the combo's recordset object, there's no need to persist the original object variable (there remains a pointer to it from the control). Your earlier example of a SELECT statement without a FROM clause does indeed work... but not when in a UNION query in Jet/ACE. (It would be...