Recent content by FrankPV

The data is stored in an nvarchar type field length of 8. I will try converting to int rather than numeric to see if that works. The confusing thing is I didn't have to do any conversions to select the records I needed using the ordernum field later in the stored procedure.

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...

Thanks for your suggestion. I had a chance to test this over the past few days. The user can access all the tables, add records individually, and edit all records on all tables. They just cannot run this query. I gave a user administrative privileges and they were able to run the query just...

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 the On Change Event for the Quantity Field. The code I'm attempting to execute is as follows: Private Sub QUANTITY_Change() Dim lngInvItemID As Long, lngPOItemID As Long, lngQuantity As Long Dim receivedqtytest As Long Dim rst As Recordset Dim qtytest As...

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...

Thank you. I will look into the CASE function. Appreciate your advice.

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...

How would you recommend upgrading my application to an Access Project? Do you find it requires a lot of recoding? Thanks again for your help.

This form is used for two purposes but I can split the functions. The first is to allow the operator to distribute the items that haven't been done - this is what the following line is for. strCriteria = "([SECQTY] = 0 OR IsNull([Secqty])) AND ([EDIQTY] = 0 OR IsNull([EDIQTY])) AND...

Hello, and thanks for your help. I am using Access 2002 but the application was written in Access 2000 format and has not been upgraded to Access 2002. There are 30,000 records in the cloned dataset. The form consists of a main form which has a listbox linking to the main form. The user sees...

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...

Thank you. This is exactly what I was looking for and it works fine. Frank

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...