Search results

I think people might need more info to help you... For example, could you explain what this section of your code is doing... [AuditItemID] = Me.MPOIAuditItemsTB [POIDocNum] = Me.TotalTB [POIYes] = Me.YPercTB [POINo] = Me.NoPercTB [POINA] = Me.NAPercTB [Summary] =...

Some would say it's hogwash, but I'm relatively certain pigs flew in an earlier stage of their evolutionary development.

Yet another year down the tubes...hope you enjoyed the day, Barry...

I presume you're happy with it? Any others -- of a similar size -- that are worth a look?

http://www.youtube.com/watch?v=EUGNKqwHp0s Wo. That's excellent, Barry. Looks like great fun... Thanks. Ron...Nice digs. Ditto, Ken...

It's do-able... As a place to start, I suggest you search for and read up on the following form events in Access Help, here in the forum and on Google: After Update and Before Update. You will want to put code in one of these event handlers (I'm guessing most people would use the After Update...

Contingent on knowing a bit more of what you require, perhaps you can take a different route -- somewhat less complex -- and build a query in which you use the datediff function...and then, once complete and functional, you can create a report in which you use the query as the record source. If...

For a split second, many years ago, I considered buying a Ford. Just kidding...I'm not that brave...

Recently I drank a red bull.

You can work around the trimmed textbox phenomenon using code. For a working example, create a form and drop two new textboxes on it. Name them txtX and txtY. Set the form's Key Preview property to Yes. Then paste the following in the form's code module. Option Compare Database Option Explicit...

Do you know if in fact the trailing space exists? I ask because if you, say, requery the form in some fashion (it's not clear if you are doing this yet it sounds like you might)...Access chops trailing spaces from data in the form's textboxes. Another thing to try... ' Position the cursor in...

I am not sure if I follow your first paragraph but to answer your question: me.undo Regards, Tim

Perhaps... Me.ComboName.Selected(someItem) = True http://msdn.microsoft.com/en-us/library/bb240110.aspx Regards, Tim

I think Brian's in a higher state...

If you use SQL as the form's record source it might look like this: SELECT Customers.CustomerID, Customers.CompanyName, Customers.ContactName FROM Customers ORDER BY Customers.CustomerID, Customers.CompanyName; Regards, Tim

I like the one-liner... My guess is Sue will probably be spending much of her time on exception handling for this effort...

A place to start... Private Sub CommandGo_Click() ' Get the path to the access file. Dim DBpath As String DBpath = "\\ComputerName\ShareName\databaseName.mdb" ' Create a connection string using the path. Dim Connect_String As String Connect_String =...

Private Sub cboX_Change() HideLists Me Select Case Me.cboX.Value Case "networking" Me.ListNetworking.Visible = True Case "X" Me.ListX.Visible = True Case "Y" Me.ListY.Visible = True End Select End Sub Sub HideLists(myFrm As Form) '...

That's excellent. Now I get it. Count me in -- or out, as the case may be...