Search results for query: *

Hi cmmrfrds, I got it to work. My program was returning a type mismatch but I later found out that it was a foreign key constraint violation. Thanks again, Keith

Thanks hmckillop. I created an ODBC System DSN and it worked. The reason why I'm using DAO is because we have a legacy app designed in VB and rehauling to use ADO or .NET is just not worth it. Thanks again everyone. Keith

Hi everyone, What's the SQL Server equivalent of the OLE Object datatype in Microsoft Access? I tried Binary, VarBinary and Image. All three of those datatypes give me a type mismatch when I try to insert an image into SQL Server. The insert works when I insert into a MS Access DB with the...

Hi everyone, Does anyone know how to connect to SQL Server using DAO? Here's some code I dug up but it doesn't work. Dim connString As String connString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDatabase;Data Source=MyServerName" Dim...

Hi everyone, I was wondering if I could get your opinion on something. I was asked to design a quiz for HR. Something in the form below: Category I (1) I am cool. Agree O Disagree O Don't Know O (2) You are cool. Agree O Disagree O Don't Know O Category II (1) I am cool...

Hey hodgesp, Its just that GOTO is seen as bad programming practice. If you had GOTOs all over the place (like in the days of BASIC code), it would be a real headache to debug. Keith

Hi Bernie, If you are performing database interactions using Access, you should do so with the System.Data.OleDb namespace and its objects. Keith

Hi everyone, I have a text menubar that goes horizontally across the top of my page with the margin-left at 0, margin-top at 0 and margin-right at 0. The text in the menubar is an unordered list. The problem I'm having is centering the menu items (text links). Here's my CSS. This is my...

Ok, thnx for the insight guys. Keith

Hi everyone, Every application that I've compiled has a PDB (Intermediate file, according to Windows Explorer) in addition to at least one DLL file in my BIN folder. What exactly is this PDB file? Is it ok to delete it? Hope someone can shed some light on it. Thanks, Keith

CJAI, I've gotten this error before. It was due to Microsoft update/patch that was installed on the server. Can you tell me what Event Viewer says about the error? Keith

How about converting your string into a double? double myRate = double.Parse (txtRate.Text); cmd.parameters.add(New OleDbParameter("@rate", myRate)); HTH, Keith

AtomicChip, That's what I did to get around it. I wrote a function and bound it to the column. Thanks again, Keith

Hi everyone, I cannot get into Design View after I insert this piece of code. <asp:templatecolumn visible=False headertext="Edit Comments"> <edititemtemplate> <a href="javascript:void window.open('comments.aspx?reqID=<%#DataBinder.Eval (Container.DataItem, "RequestID")%>','test','width=500...

Hi Jen, You don't access your controls through the ItemDataBound event? I thought that was the only way of accessing the controls. (when they are created and bound to the datagrid) Keith

Hi everyone, I'm having a tedious problem that I'm trying to figure out. I would like to set the initial value of a dropdownlist when the user goes into Edit mode in a datagrid. I'm trying to access the dropdownlist to set the SelectedIndex in the OnEditCommand event but the dropdownlist...

Thanks Boulderbum, I forgot to rebind the data. Thanks again. Keith

Hi everyone, I am programming a simple editable datagrid and when I click on my EditCommandColumn to edit a row, I need to click it twice for some reason. It doesn't work if I click the EditCommandColumn once. This is driving me insane! =( Anyone ever come across this before? Keith

Hi guys, Firstly, thanks for the responses. It seems that regexes originate from the Unix platform. I've been reading that a lot of the utilities; sed, awk, perl, delimit regexes using forward slashes. ie: /[A-Z]+(abc|xyz)*/ So my first post was wrong to assume that regexes are delimited by...

Hey cathiec, Try this. Open up VS.NET with your original project. Click the Copy Project icon located at the top of your Solution Explorer toolbar or Project >> Copy Project. Type in a different path for your application (I put http://localhost/TestWeb2 for mine). Make sure the web access...