Search results

Ok, check the line that says "Loaded = True" and change it to: IsLoaded = True. Mea Culpa. HTH By the way, Bob, I don't get what u mean by duplicated post: is it my post or Strawberry's?

Ok, now you're talking. How about: Private Sub cboN_Number_AfterUpdate() Me.cboM_Tach.RowSource = "SELECT M_tach FROM qryTblAircraft WHERE N_number =" & Me.cboN_Number & " ORDER BY m_tach;" End Sub This will populate combo cboM_Tach with all occurences of M_tach where N_number is the same as...

For grouping the selected reports and have them printed 1 after the other u might: 1. Create a dynamic array and the loop through it to print; 2. Create a temporary table, populate it with the selected reports, then print by looping through the records in that temp table. The working of...

Well you need to first have the IsLoaded function somewhere in a module. U might use the following one: Function IsLoaded(ByVal strFormName As String) As Boolean Const conObjStateClosed = 0 Const conDesignMode = 0 If SysCmd(acSysCmdGetObjectState, acForm, strFormName ) <>...

Well wizards are helpfull sometimes, but nothing beats a manually designed Object. Best thing would be to build a query with the fields u need in your report, then build a report in design view and design it exactly to suit your needs, just fiddle and play around till u get it right. You might...

Well, why would u want to reenter a value in textbox which is already selected in Listbox. Imagine a Car table; you're basically trying to do "Select * FROM tblCars WHERE BMW = BMW. One would rather expect something like "Select * FROM tblCars WHERE CarName = BMW" Or: "Select * FROM tblCars...

Not sure what you're really after, but I guess u want to populate a comboBox with data from m-tach, based upon criteria from n_number? Pls be more elaborate...

Well you could check out the structure in the Northwind example DB. Your Customer Account would correspond to the Orders table there (orders from clients, not suppliers) and Sales would correspond to Order Details. Now for the automatic stocklevel to work u might want to throw in 2 extra...

Pls note that this is more a VBA (Access) related question, but since my posting in the access forums didn't yield any results so far, someone suggested I'd more likely to get help for this in the VB Forum. Sorry for the cross posting, but I'd really like to solve this one asap) The Problem I...

Hi there, I have a medecine table with records already tagged in HTML, for example the field named Description: <h3>ABILIFY - <em>B-MS</em></h3> <p><em>Antipsychotic</em> <br /> For Adults. Oral Use. </p> ... I would like to be able to display this text on my form. Using Data Access Pages...

Well just create an append query in the query designer and on the field line for fldErr you put something like: Errs: [Field1] & ", " & [Field2] & ", " & [Field3] HTH Premy

No prob. U see, when my brain gets close to melting point while working on my projects I need to divert it to some specific and delimited problem (like yours for example) for it to cool down a bit. It's just healthy recreation ;-). Regards, Premy

Well, that'll take some extra steps then, like a MakeTable Query and some code. In the attached sample there's now a form, just open it and select a name to see what it does. Then take a look behind the scenes to see the how. The query from the previous example has been enhanced a little and now...

There u go again, another sample bd. FYI: The help u looked for here is for very lowdown basic topics. This means that u know next to nothing about the subject. If this is all u are ever going to do in Access (or any other dev platform, for that matter) then I'd say OK, no problem. But If u...

I think this query might get you what you want or almost. SELECT tblReadings.ReadID, tblReadings.PersonID, tblReadings.LabDate As sDate, (SELECT TOP 1 T2.LabDate FROM tblReadings AS T2 WHERE T2.PersonID = tblReadings.PersonID AND T2.LabDate > tblReadings.LabDate ORDER BY T2.LabDate...

Ok sorry, here u go again. http://www.access-programmers.co.uk/forums/showthread.php?t=138021 If there's a problem again, just copy the link to your browser's address bar and replace the dots by forums/showthrea Good luck Premy

Well, u can build a query for yr report based on the recordset of the form, then open the query with your combo's selected values as arguments in the Where clause. HTH Premy

U might want to take a look at this thread http://www.access-programmers.co.uk/...d.php?t=138021 HTH Premy

Well, how about just adding a text field, say txtToShow, put the value u want to show there and include it in your form, or wherever u want to show it? In the qry designer just add: ToShow: "MyWhateverText" on the field-line (new column of course) and txtToShow on the append-to-line. If u...

Your example is kind of confusing. Does a test complete on the same day or does it take several days to complete? I mean if I do a test on day 1 and it was, let's say 45, then another on day 5 with a score of 60, then another on day 9 with a score of 48 then I have: Test1 Day1 = 45 Test2 Day5 =...