Recent content by formerTexan

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...

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...

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...

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.

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

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...

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...

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...

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...

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...

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...

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...

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...

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

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...