Data Grid View

Clayhead

Registered User.
Local time
Today, 00:22
Joined
Jan 3, 2016
Messages
13
Hi All. Im still really new to all of this. I have a form with tabs. In a tab i am trying to build a searchable table that contains account id, Account Name, Status, Type, Mobile and email address. At the top im trying to get boxes to search and boxes that display the data i have clicked on.

I have managed to get the table through datasheet view but it doesnt look professional. I was told about a datagridview but have no idea where to start.

Can anyone please help or advise?
 
You'd want a subForm on the tab control.
Each time the tab changes, the form changes to another data set.
The search controls would search in the query the subForm is currently on.
 
datagrid is a vb/wpf concept - the equivalent in access is a datasheet or continuous form.

not sure what you consider to be 'professional' but a continuous form provides a lot of flexibility for look and feel.
 
Apologies upon re-reading my post it sounds quite snobbish. What i meant to say is that with this data sheet view i could not format to make it look more stylish. I am trying the continuous form now. Do you know how i would add a filter via a text box at the top?
 
depends how you want the filter to work, but assuming the user types something like a customer name into a text box and then clicks a button, you would have some code behind the button click event something like

Code:
 me.filter="Customer='" & txtBox & "'"
 me.filteron=true

if you are new to access, be aware that text, numbers and dates are treated differently - text you surreound with single quotes as above, dates in text format use #, whilst numbers use nothing - plenty of short courses on the web.

Also, you can right click on a field and select filtering and sorting options for that field if the user so desires.
 
Brill! works fine thanks. I have a few more questions however off topic so will ask in another post.
 

Users who are viewing this thread

Back
Top Bottom