Search results

Hi, A friend did this for me and it works. Try it out for your case Private Sub REP_TAG_KeyPress(KeyAscii As Integer) If Len(Me.REP_TAG.Text) >= 6 Then If KeyAscii > 48 And KeyAscii < 122 Then KeyAscii = 0 End If Me.REP_TAG.SelStart = 7 End If End...

Hello All, I'm having trouble pasting a series of records of text from an excel sheet to a table in access. The field (Instructions) in the main table gets its values from another table (Instructions) with Inst_ID(autonumber) + Text. The (Instructions) table was constructed based on the...

Hello All, I'm having trouble pasting a series of records of text from an excel sheet to a table in access. The field (Instructions) in the main table gets its values from another table (Instructions) with Inst_ID(autonumber) + Text. The (Instructions) table was constructed based on the...

Hello all, I'm trying to make this work, but dunno how. I have a tblProducts table that consists of: ID_Products (autonumber) Product(text) PartNumber1 (number) Partnumber2(number) I have an input form where i have a combobox thats related to that tblProducts that lists a series of...

Truckfin thanks for your feed-back. Your suggestion implies that this be done within Lotus Notes, however what i'm looking for is an automated method. I.e., just as a predefined message is sent from Access to the body of a user's Lotus Notes i was hoping to include a hyperlink to the database...

Not sure if this is what you're looking for... Create a button that once clicked turns the filter off and resets all the combo-box filters Private Sub Command62_Click() Me.Form.FilterOn = False Me.Form.Filter = "" Me.Combo32 = "" Me.Combo38 = "" Me.Combo40 = ""...

For a simple Message box (my case), I used a conjunction of newline and spaces to relative success. MsgBox "____________Blah Blah Blah____________" & vbCrLf & "____________Blah Blah____________"... where ____________ = spaces Apart from this, and like adevera mentioned, create a form that...

Many thanks for your help Ghudson Although in the end i didnt use your code, i did fiddle around with it trying to make it work with my setup and ultimately helped me reach my objective. Heres how i got away with it :D Private Sub UpdateProbBtn_Click() '@@@@@ Restricting editing...

Hi all, I'm trying to restrict alterations to an existing record according to user. In the end what i'm trying to accomplish is: Only the user that entered a new record is allowed to make modifications, at a later time (updating with new and available info), to that record. Other users may...

Hi all, Could someone help me in inserting the correct syntax for Lotus Notes to accept a link to a database. I am able to send certain fields of a form to the body of a lotus notes, however i'd like to include a link to a file "S:\Database\main.mdb" This "S:\Database\main.mdb" appears in the...