Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. formerTexan

    query function call

    I'm using a simple query with a function call. In the trial the function returns a constant integer value. The source table has only 1 record. SELECT tblRoster.RosterID, tblRoster.RosterName, tblRoster.Comments, pfRosterStatus([RosterID]) AS RosterStatus FROM tblRoster; the function...
  2. formerTexan

    Disable control/field once if a value already exists

    I should think something like the following would be a more appropriate criteria for DLookup since you appear to be looking for a value related to a specific student. Check = DLookup("[Wt1]", "queryxx", "[StudentID] = " & Me!StudentID) I'm really unclear on what you are trying to accomplish...
  3. formerTexan

    Inspection Tables Picker

    Without knowing your business model, this is speculative. But rather than maintaining the OrderID in the Customer table, I would put the CustomerID in the Order table. Your current arrangement assumes that each customer will only have one order. Also leaving the spaces out of field names is...
  4. formerTexan

    Graph.SeriesCollection(x).Name property

    Am i correct in the assumption that .Name is not an exposed SeriesCollection or Series property in Access Graph objects? It seems the Access object model version is considerably restricted. I had high hopes for a handy means of conditional formatting.
  5. formerTexan

    Problem binding subform to disconnected ADO Recordset

    Alas, I see that the attachment didn't attach. I'll have to see if there is a provision on tek-tips for uploading attachments. formertexan
  6. formerTexan

    Problem binding subform to disconnected ADO Recordset

    Hello lameid, I looked back at my sample and noticd something I ran into. When I thought I was binding the recordset to the form, the form was simply assuming the recordset's source as the form recordsource. In my case this source was a table or SQL string. So disconnecting the recordset was...
  7. formerTexan

    Multiple Subreport Calculated Field Population -- HELP!

    It does sound like some possible performance issues. Table design, indexing, number of records, number of tables involved, query design, use of combo/listboxes and a host of other factors may be at issue. Not having specific info, I suggest 1. opening each report/subreport separately to see...
  8. formerTexan

    Display checkmark based on condition?

    Hello Jonathan, Add this function to the report's code module Private Function fConvert(var As Variant) As Boolean If Not IsNull(var) Then fConvert = True End If End Function Then call the function from the checkbox by adding the following for the checkbox's controlsource...
  9. formerTexan

    Problem binding subform to disconnected ADO Recordset

    Greetings again, Some years back when I was tinkering with disconnected recordsets, I wrote the following function to see what I was actually getting, Try plugging it in after opening the ADO recordset. ' input: ADO recordset ' returns: string with Supports and other recordset info ' created...
  10. formerTexan

    Problem binding subform to disconnected ADO Recordset

    Hello Lameid, I think you will need to set the recordset to the form before closing the connection. Also remember that closing the connection means that data changes are only reflected in the recordset, not saved to the tables. Though probably irrelevant to your issue, you may want to have a...
  11. formerTexan

    Many to Many Relationships; Handling input from "One" Sides

    Hello kjscmitz, Combining Unit_Bid and Alt_Bid into a single table seems sensible from a database and development standpoint. Sounds like you have a bid that can alternate status - it can be either Unit or Alt, but not both. If so, I suggest adding a status field to the Bid_Details table and...
  12. formerTexan

    Error 3856 cannot update

    This problem has seemingly been resolved with thanks to posts at http://social.technet.microsoft.com/Forums/en-US/officeappcompat/thread/52509a01-1c70-4507-a3d2-b4e1c68fb8bb I'll summarize what appears to be happening. When developing in A2010 with the default version set to A2007, using...
  13. formerTexan

    Error 3856 cannot update

    Greetings, I hope someone can offer suggestions as to why the following error is raised(aside from the obvious: running on a non-2010 version)? Error 3856: The Microsoft Office Access database cannot update the data in tblNextNumber. The minimum required version to update the data is...
  14. formerTexan

    A2007/2010 set form recordset - error 7965

    Hello MajP, You are right. Of course that's why form's RecordsetType property is limited to Dynaset or Snapshot. Thank you. formertexan
  15. formerTexan

    A2007/2010 set form recordset - error 7965

    Greetings everyone, Binding DAO recordsets to a form raises Error 7965("The object you entered is not a valid recordset property". Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("tblProject", dbOpenTable) Debug.Print rs.RecordCount 'sanity check Set Me.Recordset = rs...
  16. formerTexan

    remove grouplevel section

    Thank you Duane, I was stuck in a right-click, menu-centric universe. Cheers, formertexan
  17. formerTexan

    remove grouplevel section

    version A2K
  18. formerTexan

    remove grouplevel section

    Greetings folds, It has been donkey's years since I removed a grouplevel section from an A2K report and all I can remember is that it was a non-intuitive process. Can anyone refresh my hazy memory on how it is done. By the way, these are sections created via the sorting/grouping dialog, not...
  19. formerTexan

    Word 2007 - cell not in table

    Formula: {IF{B3}<500 "not available" {=((((B3*E1)/100)+B3)/6)+50}} Initially placed in what I presumed was cell E5. However which cell seems irrelevant. Same results when placed in other cells. Cheers
  20. formerTexan

    Word 2007 - cell not in table

    I inserted a new 5 column (presumably columns A,B,C,D,E) table into a Word 2007 docx. I entered a formula in the table referencing B1. No problem. Then entered the same formula in another cell of the same table and changed the reference to cell E1. I get a "E1 is not in table" response...

Part and Inventory Search

Back
Top