It sounds like the datagrid column that is meant to show the p_id field has been set up as an int column. You need to change this to be a varchar column.
Does anybody know how to set up a datagrid so that it's paging is by letters not by numbers?
For example all the people whose surname begins with the letter 'A' is displayed on the page under the 'A' link etc.
Thanks in advance.
You need to set the PageSize property of the datagrid to a number depending on how many records you want displayed. Just try it out with different numbers and see what suits.
Cheers
You might have the macro enabling code in the Document > New code window. Therefore, whenever a new document is created from the template, it will activate this code module.
You will need to use a For loop to read in every line.
If each line has individual values that you need to read in, you will have to use a nested For loop.
Hope this helps.
Hi, I want to add some combo boxes to a spreadsheet so that a user can either select a value from the box or enter a new one. I'm not quite sure how to do this.
If I have 5 columns and infinite rows, does this mean that I have to have a combo box in every cell or is there a way that I can just...
Hi, I want to add some combo boxes to a spreadsheet so that a user can either select a value from the box or enter a new one. I'm not quite sure how to do this.
If I have 5 columns and infinite rows, does this mean that I have to have a combo box in every cell or is there a way that I can just...
Hi I am creating a query based on a date range. I am currently using Between .... And however this isn't producing the right result.
I have 2 parameters (Start Date, End Date) for the date range but I want the result to return the records so that if a start date is before the specified start...
Hi I am creating a query based on a date range. I am currently using Between .... And however this isn't producing the right result.
I have 2 parameters (Start Date, End Date) for the date range but I want the result to return the records so that if a start date is before the specified start...
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.