Recent content by BLeslie88

MikeLeBen worked out fine thinks! :-)

It is a text file - delimited file - that there is headings among other lines that generate errors on every import as I have some forced field specifications... This causes import errors. I am not the one maintaining it and do not want accumilated error tables - so I do not see how not doing...

Doing a loop to remove error import table: Example: "CONTACTS1_ImportErrors" DoCmd.DeleteObject acTable, "CONTACTS" & myNum & "_ImportErrors" This has been working well - now today - suddenly there is no error with one table import... So I get title error message. "Run-time error '7874'" Is...

Code that fixed it - found in the help - DoCmd.RunSQL ("UPDATE tblAddress INNER JOIN tblInventory ON tblAddress.CUSTNO = tblInventory.CustNo SET tblAddress.FAXDESCFR = """ & Combo13.Value & _ """, tblAddress.FAXDESCGR = """ & Combo19.Value & """ where tblInventory.CreditRep = """ &...

Doing an update query - and... when user enter "it's" the ' Because it crashed - I will do a few tests such as change string to text... Any tips clues appreciated. DoCmd.RunSQL ("UPDATE tblAddress INNER JOIN tblInventory ON tblAddress.CUSTNO = tblInventory.CustNo SET...

You were right for turning on the record selector's... Knew should be easy - where the row number appears isn't important. Thanks. "Duh" :eek:

That is done on reports she gets. Or are you suggesting a counter for each action taken?

Thanks for replies, all valid points from a stand view of data. If a user would like to know how many records they have to get through without counting though... Or to set a goal for where they want to be... Such as . Say 1 2 3 . . . 49 50 And at noon would like to know where there are...

Searched left right and center. All the things we can do & no simple way to display the current row number? A simple counter - autonumber feature of sorts... I am running off a table on my form, and want to refrain from doing this in the query and recordsets... Is there no simple way to...

I simply need to display the row number.... (On a form in a text box or label) 1 2 3 4 5 Immagine not only can I not figure it out I can't find it in a thread searching.... :cool:

I was running an update query which was a work around dealing with an OLE object I needed to assign to the active table to allow changing rows colors on the fly based on an action taken. (BckGround bitmap assigned) It was working fine until I made the table loading on a query instead of a table...

Worked perfect. Thanks.

I have a field that attains focus, CustNo on a seperate database outside our normal application. I would like to automatically copy it to windows clipboard. I have tried a few forums searches and google searches and do not want to download that clip program I found. This is the only time I want...

. "[txtName] = '" & Me.cmbOfficer.Column(0) & "'", acFormEdit May be all you are missing...

Must commend you Pat.. I just used this in an append query!!! lol And it worked incrementing the ID . . . . . So cool. Excellent little bit of code!