Hi all
I have created a combo in the form. combo Name is accNum.
When the combo is clicked(accnum) 4 column shows data shows, because combo is linked to a table with 4 colums).
when the user click the combo, one of the column store as a value.
How i can show a another column (out of the 4...
Hi all
I have table called "Customer Data" and it has a field called AccountNumber.This field is a Auto/Number type. Life is normal at this point.
Now I have a form with text boxes, user enters a value in text box. ( which is a accountnumber). Upon entring a account number I have the following...
Hi all
I have a simple forms with couple of text boxes, and one commad button and it has the following code : my tabe name is Customer Data
it seems that access doesnt like the line :
Set cusdata = CurrentDb.OpenRecordset("Customer Data")
Private Sub Command12_Click()
Dim cusdata As Recordset...
I am desinging a report, I cannot see some fileds in Sorting and grouping. The query that I am runing has those fieds, How can I get to see all the fileds in sorting and grouping?
Thanks
Hi all
I have field Name called EMPNAME
The records like this,
Brian,Smith
Ray,Vernner
Ken,Ibrahim
Now I want to separete them as Firstname: Brain
How do I find the comma "," in a text?
thanks
:confused: