Search results for query: *

I'm running a stored procedure which attempts to delete records that are greater than an order number which is selected in the previous line and stored in a variable. The delete line does not delete any records and I don't understand why. Any help would be appreciated. The relevant code is...

I'm having a problem with a query executing in my application. I'm using an Access Front end to an SQL Server 2000 database. I recently upsized the tables to SQL because we are adding users. After upsizing and specifying users, roles, and permissions everything worked fine except for one...

I'm using an Access form field (Quantity) to perform a calculation if the user changes the field. The problem is when I try to use the field to perform the calculation it is pulling the old value, not the changed value. How do I reference this updated value to use in the calculation after the...

I am trying to implement referential integrity using a trigger because I have two related tables in two different databases. The table which holds the trigger is the invoices table in my Hardgoods database. This table is related to invoice items in the same database with the invcnum field and...

I'm running an Access 2000 front end to an SQL Server 2000 Database. I developed a Data Access Page to allow display of some price data for salespeople over our company intranet. My problem is the Access query data source for the new Data Access Page will not work. The query relied on several...

I use the following code to locate and display records on an access form. The data resides in SQL Server 2000. Performance of this screen is slow. Can anyone recommend improvements in this code to increase performance? Thanks. Private Sub Form_Load() Dim strCriteria As String Dim...

Hello! I have a form that displays a msgbox if a query has any records. The query executes when the user exits the combo box. If there are any records in the query I want to display a msgbox. If the query is empty I want to skip the msgbox. I don't know the proper VBA code to test whether...

I just upsized my Access Front end to SQL Server 2000. I do most of my development at home on a standalone PC and just transfer the front end back to my work PC when I'm done. Is there an easy way to continue development on a stand alone PC and transfer the front end to work without having to...

Can anyone tell me how to set up Access so when a user starts an Access application they automatically download the latest version of the application from the file server? Thanks.

Hello: I am working on a form where I would like to click on a command button and display the open file box (like the one that displays when you click the open folder on the toolbar). The user will have the option of choosing a folder, subfolder, different drive, etc., The resulting path and...

I'm trying to use an MS Access form to control a digital camera. The camera will be used to capture images and MS Access will be used to download the images from the camera into an MS Access database or file that will be later linked to MS Access data. Any experience with this?