Search results for query: *

Thanks for your feedback 2 Questions 1. The code I have works even if a quote exists, I've tested it and it correctly identifies that the name exists 2. Is it not better to use direct sql statements from code (if you can) to ensure the program runs faster e.g. "Delete * from tblMain where ID...

Yes I agree, got confused while trying to figure this out. When I used parameters it works fine. I created a global function to fix any field that has a quote, then pass that “Fixed” value to the stored procedure as a parameter. Here is the working example I used to ensure the name is not...

Problem above cant use like but SQL has built in functions String of ? 128 characters QUOTENAME(@variable, '''') String of > 128 characters REPLACE(@variable,'''', '''''')

It took me ages to figure this one so I said i would share. Just a note its much better to avoid using sql directly from asp e.g. “select * from table 1 where name =’” & name & ‘” or “insert into table1 (name) values (‘” & name & “’). User Stored procedures and parameters Problem When passing a...

I deployed the site to Test Web Server 2003 IIS 6.0. However when I try open excel through the web page I get this (in event viewer). Note all works fine on development machine. "The machine-default permission settings do not grant Local Activation permission for the COM Server application with...

It seems to be a bug in VWD 2005, as the table in question had 18 records but when I removed most of them the form started working again. I decided to use a gridview instead of a formview.

I have a webpage with a filter invoked by a javascript function - <script type="text/javascript"> <!-- var theForm = document.forms['form1']; if (!theForm) { theForm = document.form1; } function __doPostBack(eventTarget, eventArgument) { if (!theForm.onsubmit || (theForm.onsubmit() !=...

I have a webpage with a filter invoked by a javascript function - <script type="text/javascript"> <!-- var theForm = document.forms['form1']; if (!theForm) { theForm = document.form1; } function __doPostBack(eventTarget, eventArgument) { if (!theForm.onsubmit || (theForm.onsubmit() !=...

Ok just created 2 gridviews one with delete button and the other without then set the appropriate gridview visible depending on the session variable.

If a session value is true how to disable the entire delete button on the gridview. e.g. If session("AllowDeletes") = false then me.gridview1.Allowdelete = false End if Thanks!

Fixed it, had to open it with Access 2000 instead of the default access 2003 since the database was originally created in Access 2000 format!

Hi, I have an access program that 6 people use. However when 2 users open a form and click on a column and sort it sorts fine but when they close the form access crashes and asks to "send or don’t send" standard Microsoft reporting error. It works fine on the other 4 PCs. I reinstalled access...

Yep that was it, a trigger for each update inserted all rows from deleted - "select * from deleted" and inserts into the history table. I recently added a new field and never added it to the history table, thanks guys!

Hi, If I try a simple updated e.g. update referrals set notes = '' I get the following error Msg 121, Level 15, State 1 The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns. If I try a similar...

http://www.lebans.com/mousewheelonoff.htm

Maybe you need to change the search from "like '*Bla*' to "like N'%Bla%'

I would add a textbox (txtSeachFor) for the search criteria 2 buttons - "apply filter" and "remove filter" Private Sub apply_filter_click() Me.Filter = "SearchFieldNameInTable like '*" & me.txtSearchFor & "*'" Me.FilterOn = True End sub Private Sub remove_filter_click() Me.FilterOn =...

This is real basic stuff you should look at the sample Northwind database from Microsoft but this is what you got to do 1. Setup a query that pulls out the fields you need 2. In the date column place "between #DateFrom# and #DateTo" 3. Run the query and it should prompt to enter the dates Test...

There could be a few reasons 1. I find that adding an auto number field to each table reduces the probability of locking 2. The size of your data along with extra users could now be causing problems - could you archive off certain historic information and create 2 database 1-current 2-historic...

Lameid, I acknowledge that SQL personal edition is handy but the procedure I have in place is that if no IT (SQL tech guy) is around the end user simply opens a different front end and voila - the entire database(from the previous day) at a click. And besides if the backup if held on the SQL...