Search results

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

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

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

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

I am losing my mind... Keep it simple, have you deployed a vb project in 2003 VB .net? They totally changed the packaging scheme. Let's call form "Hello world" I can not "Deploy" this for my life.... Add a deployment project to your solution. "CHECK" Associate the deployment project with...

Ways to notify people with an application that there is new records in the system? With-out re-loading forms.... :cool: No this is not a repeat question... I am talking about a creative way to set up notification of new data. So far I got, a timing sequence using field (lets call it...

is there a way to either attain the last value from a text box on a form. or to get the record count of the current object....? what I mean... let me explain it another way. I have 10 record on a form... If I assign the value from the text box to a variable, it gives me the first one. I need...

No need to read rest... Simple : I need other users to see new records. They all access same table, the receptionist enters new orders... Now after she has entered the orders, if there a way to have them show up on everyone elses forms??? Without.... closing and opening forms??? thanks.

Ok, problem at hand. My boss wants my application to come to the front after the reception enters info pertaining to an order. Interaction.AppActivate "frmMainOrders" This sets focus and causes the application to flash on the bottom of the screen. But does not move this application to the...

Is there a way to show a user all the text they are typing into a control. Example.... field 25 length the layout on the form ... when the user is typing into the text box. They only see upto say.... 10 characters ... I can adjust the width on got focus and change it back on lost focus...

To do a loop ... Char = "A" Do while Char < "L" Char = ".... next Char ... A , B , C , D , E ... so fourth" Loop Char reserved word... I just wanna know how to increment a string single letter. Is it possible.? Ascii maybe...?? Simpler code maybe.

I have 40 combo boxes .... Basically an array of controls... anyhow to the point... I want max length of 20 characters... These controls are unbound. So setting char length in table can not be used. Validation text / rule should provide my solution somehow. I have tried a few things, and...

Need numbering of details. 1- 2- 3- 4- for each detail line. I did a search can't find answer. Been a long day, can I get a fast easy answer. My old job I had this code, dumb me didn't keep my best secrets... lol they didn't let me keep templates.... on the reports... details... in case it...

Default value = "000000" now how do I check what user is entering....? If on keypress ... first entry is.... say '9' following code shows "000000" and length 6 ... when actual length is 1.... Private Sub txtFld03001_KeyDown(KeyCode As Integer, Shift As Integer) Dim lenChk As Long If...

Ok keep it simple. I have a combo box. Row Source Type Row Source are assigned from tables values. They select a value.. and I do alot of magic on the form for formatted data entry... (Too long to explain why) I need to assign a value to this combo box, based on another combo box selection...

I searched to no avail. I want to make a shortcut. Keydown.... but anywhere on the form.. I have tried Form_AfterUpdate() Private Sub Form_KeyPress(KeyAscii As Integer) If KeyAscii = "myutest" Then cmdSendMail.SetFocus End If End Sub would be the ideal place ... I first need...

Alright, I have searched and searched, found alot of examples and guidelines for arrays and their existance and non existance in access... I need to change properties of 1500 text boxes... 100 X 15 ... This is an entry screen and the formatting changes depending on the selection, being the...