use this code below to find record on the form. is working fine without error. my problem when it show me msgbox "record found" it doesn't call my client record on my client inforamtion form. i think i need to add more code to pull my client record if it show that the record exist.
Private Sub...
I use this code below to find record for client in client form. My problem when I run the application I get this error message.
Cannot start you application. The workgroup information file is missing or open exclusively by another user.
Dim Conn2 As ADODB.Connection
Dim Rs1 As...
I am working with vb6, to find record for one client I have to use arrow key to navigate through client form till I find the record for that client. So I use code below and is working fine, but I think there is easy way to search client form by insetting text box in client form and search...
I use this code to select one item from the list box to enter into text box in my ms access form.
on click event I insert this code.
list10.value=text10.value
text10.setfocus
list10.visible.false
this code is working fine. how can i use this code to to select item form subform instead of list box.
I have main form with text on it when it get focus another form with list items open.
I would like to select one item from the list this item I selected enter in that text on the
Main form and list items form lost focus or closed.
I have customers form with four option bottons , I want the value of these option bottom to be be "X" instead of 1,2,3,4 when I print my report.
it means that the value of option botton which are 1,2,3,4 to be X,X,X,X because I use this form to print pre-printed form.is this possible...
I put this code on click event on command bottom in my form to pull up print dialog box how can I use this mothed to print my report instead of my form without preview the report.
Private Sub print_Click()
docmd.RunCommand acCmdPrint
End Sub
I have two option bottoms for male and female on my form.
the value for male is 1 and for female is 2.
when I select male I get 1 when I select female I get 2. I like instead of 1 and 2 get "X" when I print my pre printed form.
please help
I have two synchronize combo box on a form I would like to select record from the first combo box the second combo box get first index record automatically is that possible and how I do that.
please help.
I would like to know this code is right:I insert it after update evern on the first combo box on my form, if is right why is not work and what is the right code. please help.
If Not IsNull(ME.COMBO1) Then
Me.COMBO2.ListIndex = 0
end if
why this code work on text box and is not working with combo box. I have form with text box when I insert this code is work.
If Me.text1 <= orderDate Then
MsgBox "my message ," & vbCrLf ""vbExclamation,
"title"
but when I insert same code on combo box is...
I used this code on text on my form to seach for my customer information on my customers form and is working very good.the problem is that only I can write the (lastname) of my customer and I obtain the information.I would like to know can I add anything to same code and find same record by...
I have a main form holding my customers information like first name last name telephone number, etc.
I would like to create another seach form with one text
box and command buttom. I want to write phone number or date of birth on the text box and click "ok" this form with one text box...
I create a form with one text . How I make this form as seach form. I would like to write last name of my clients on this text once I press enter I get all the informations of that client in the main form.I want to know how and where to write the code . please help.
I have main form with text on it when it get focus another form with list items open.
I would like to select one item from the list this item I selected enter in that text on the
Main form and list items form lost focus. Please anybody can help.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.