Recent content by yu217171

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