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...
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...
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...
jools.
officer is in both tables...?
So when they select an application an officer ties to it.?
What exactly are you trying to acheive.?
At any rate after selecting the officer in a combobox. you can run a search on the after update event and update any controls on the form.
How would you...
hehe
Sorry to reply to this, and bring it back up, but if anyone else has this problem it is quite simple, wizard add a picture, so remove the picture from the form and presto you will be able to change the background color.
Trying to carry data from previous record to 'new record' ...
Ways for this...?
Now why do they allow a user to use CTRL ' to copy data down but give no way to the programmer to do it....???
Please enlighten this frustrated soul.
Thanks,
Brian