Search results for query: *

is there a way to add an onclick event to a checkboxlist control?

Is there a way to run a sql select query based on criteria that might be in a pipe delimited string in a table field? For example if a record has its column value as AB||CD||EF||GH, how would i run the query and select all records where this column has either the value "CD" or "GH"? I can...

The loginname control in vs05 is nice but is there a way to assign the value that it displays into a variable or to another control on the form such as a text box? It does not seem to have any property that can be referenced to retrieve the user login that it displays.

I am new to .Net and I have a webform that will be used for adding new records and editing existing ones. I would like the page to display one record at a time, which it is currently doing but is there a way to page through these records by way of clicking a Next or Previous button? I tried...

Here is the ideal scenario - When a command button on an Active X control that is embeded in a datarepeater is clicked, a popup form loads and displays detailed information based on the ID of the current record on the repeater control. I am passing the Id of the current record to a public...

Is there a way to do this, for example: SELECT a,b,(a+b) as ab, (ab/2000) as d FROM Table1. The problem in the above occurs at column d, whereby SQL Server throws out the error message: Invalid Column Name ab I tried passing ab to a function and having it compute and return the result as d...

I receive the above error even when I manually execute a stored procedure that is joined to a table valued function. I confirmed in sysusers table that dbo is the owner of both objects. What could be wrong with the following statement? The error I get lists the function, [Resolved Issues], as...

Hi everyone, Is there a way to directly attach a MS Access report to an email generated by the VBSendMail dll without first saving it to a directory? The dll requires that a file/report be saved on disk before it can be attached but it would be nice to directly attach the report from...

Hi all, I am developing a vb.net application but I'm not sure what report writing tool to use. I have neither used crystal nor active reports. Regardless of price and considering such general factors like learning curve, development speed, portability, etc... does using one over the other...

I have a production database residing on a remote sequel server that I can access indirectly through a citrix connection. However, because my database front end resides on my local machine, I chose to have my development database on my local machine as well, running in MSDE 2000. Problem is...

...in a continous form using the keyboard arrow keys just like in a datasheet? Currently my users are having to click on each row of the field they are editing and there are tens of them at a time. Thanks.

New to .Net and I'm not sure how to do this. I have a form1 with a combobox1 and a command button1.A user makes a selection in the combo then clicks button1 to open form2. However, how would form2 get access to the value entered in combo1 of form1? I'm trying to use that value as a parameter...

Is there a way to unlock an mdb file that has been locked by a user on a machine. I have a database that is still locked by a user on a machine even after they've quit the application. I tried rebooting the pc to no avail.

I have a couple of access databases that I am considering upsizing to sequel server db. Are their any major issues that I should be concerned with that any of you may have encountered? I know for one that the DAO code that I use will have to be re-written in ADO and that security for all objects...

I have a couple of access databases that I am considering upsizing to sequel server db. Are their any major issues that I should be concerned with that any of you may have encountered? I know for one that the DAO code that I use will have to be re-written in ADO and that security for all objects...

I have secure a database thats runs on a win 2k server. Users have to login into the server and then login into the database to run it.Is there a way to capture the userlogin and password from the server and pass it onto the access database so that the application launches without requiring a...

into another database. I find it interesting that another mdb can import tables from a secure mdb into it. Is their away to prevent this from happening? jlitondo@gatecitysteel.com

I have an application that I developed using Access 2002 but is distributed to a couple of users who are running Access 2k on their machines. On the references priority list, I set DAO higher than ADO and this works fine through the initial run of the application from the user's machines...

I have an Access 2000 application that is shared across a wide area network by several users. Occasionaly a user would receive the "Disk or Network Error" message that not only locks up the application running in their session but also prevents any other user from running the program...

I have a main form with an Add New command button which opens up popup form for a new record entry. After closing this popup, I requery the main form and its combo box.Does anyone know how to set the focus of this main form and its combo to the newly entered record? jlitondo@gatecitysteel.com