I'm trying to use the ASP.NET gridview that is bound to a datasource that has a connection string to a Access 2007 database that I have stored in my Sharepoint server sites document library.
I tested the following connection string in Designer and then the query that I am using and it works...
I'm actually trying to work with a BLL that my boss created to do this. Believe I would much rather roll my own but I have to work within this constraint.
Nikki Wright
http://www.codergrrl.net/
Hi, I have a FormView bound to an ObjectDataSource that is bound to a BLL. The object has a Read-Only field called "OrganizationId". When I try to update the FormView, I get the following error message:
The 'OrganizationId' property on the type specified by the DataObjectTypeName property in...
Thanks, that put me on the right path....
I fixed it by making putting the textbox and button control within it's own list item and adjusting the <li> spacing in the stylesheet.
<StaticItemTemplate>
<asp:Label ID="lblItem" runat="server" Text='<%# Eval("Text") %>' />
<%--...
I added a textbox and button control to my menu control that is being populated with item from my database. I can't figure out why there is extra space being added to the top of that part of the menu. Can anyone help with this one? I've attached a link to a screenshot of the menu.
Nikki...
I have a page that has a textbox with a image next to it. When the image is clicked it pops up a calendar that fills in the date in the textbox. This works fine when I open the page initially but when I open the same page with a querystring from another page it doesn't recognize the ClientID for...
Hi,
I am trying to create a series of pages that allow the user to filter data by passing selections to session variables. The first page has checkboxes that return codes. When I test the submit button it is not going to the next page...here is the code
</head>
<body>
<form...
Another modification of the .BAT file solution if you want to avoid opening and doing manual stuff is...
Open up Notepad, copy and paste this:
dir *.(FILE EXTENSION) /B > File_List.txt
Then save it as: Make_File_List.BAT
Then put into whichever folder you want to make a list of, double click...
I downloaded a component for linking Access to Outlook because I have Access 97. But if you have a newer version you should be able to:
Click on File --> Get External Data --> Link Tables.
In the Link-screen, select 'Exchange()' or 'Outlook()'.
You will see all the public folders on your...
That sort of what I have now:
Forms![Splashscreen]![DataMerge]![TextCritBuild]
Is of the format.....
Forms![Form]![Subform]![Control Name]
Nikki Wright
"You'll get nothing and like it."
Hi all,
I have been fussing around with this all afternoon. I am trying to filter a query from a form's textbox by entering the field name in the query's criteria as such:
Forms![Splashscreen]![DataMerge]![TextCritBuild]
It did work at some point but now I can't get it to work no matter what...
Yes, I did mean Append Query. I meant to say when I browsed in Datasheet View it didn't return any records.
Anyway, I found the answer in thread 702-113995 in this forum.
Thanks anyway,
Nikki Wright
Database Specialist
"But I'm not crazy, I'm just a little unwell"
Hi All,
Here is the problem.
I am using 4 textboxes to set the criteria in an Append query.
I have set defaults for 2 of them, the other 2 can't have defaults
set for them because I need to return all values for them if the user
hasn't specified a certain value.
So the query is returning...
Hi All:
I am trying to figure out the problem with the following function used in a update query:
Format([RecID],'000000')
I think what the programmer was trying to do (wasn't me) is format the number as 6 digits so that it could be like "000010" etc.
What is wrong with this...
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.