Search results for query: *

Hi All, I am trying to create a trigger that auto-increments a PK field from another sequence table. Since I cannot change the structure of the existing table, I need to pull and increment the field and update the record for insert as a char type field. When I insert the record in the...

I have recreated a new report from an existing report but accidentlally saved the .rol file. Now i cannot see the old query (.rol) file. I have the orinigal from the install but cannot link the originl file (.rod) to the original .rol. Is there a way to do this? I have renamed both files but...

I am trying to create a dynamic sql process based upon the following update code: UPDATE WORKORDER SET STATUS = 'COMP' WHERE REPORTDATE >= TO_DATE('08/01/2006','mm/dd/yyyy') AND STATUS = 'INPRG' AND ACTFINISH IS NOT NULL AND WONUM NOT LIKE '7%' Which works fine. The dynamic sql code is as...

I continue to get the the following error when importing a CVS file into SqlServer2000: "cannot insert duplicate key row in object 'table1" with unique index 'table1_ndx'. I have looked at the records and there are no duplicates. No matter how many rows I test, I continue to get this error...

I have a form that displays records based on a form filter and combo box. The problem is that no matter what I select, the last null row from the table keeps printing and I cannot figure out why or how to hide it and do not know why it is printing. Can anyone help? Homer: But every time I...

Does anyone have any idea hot to insert row totals for a crosstab query? My form/report is grouped at two levels and using the =Sum(NZ([2005])) returns the sum at the highest grouping. Not at the lowest one. Homer: But every time I learn something new, it pushes out something old! Remember...

Help! I have an application that selects user and the user's security level. It works fine until for no reason it stops and when I stepped through it I found that the Case value was getting set to nothing but the user value reamained which is good. The case variable is global. Do I need to...

Hi All! I am trying to use the following code to populate a form with a record. The code allows the user to select either the barcode or the PO number to select a record and that has worked fine. The problem is for mutliple records for a PO. If I select a PO number which has mutliple...

Hi All, I am trying to print a report based upon the condition that a checkbox is checked in the database. I have tried to ' If CompleteStatus = True' and ' If CompleteStatus = Yes' and neither works. When I put in a message box to display the value, it shows nothing. What If conditiion do I...

I am trying to print a report based upon the condition that a checkbox is checked in the database. I have tried to ' If CompleteStatus = True' and ' If CompleteStatus = Yes' and neither works. When I put in a message box to display the value, it shows nothing. What If conditiion do I use...

I am getting the above error when I load my form. ' Connect the Data control to the database. datAssetsDrop.DatabaseName = dbname Here is the code: Private Sub Form_Load() Dim dbname As String Dim db As dao.Database Dim rs As dao.Recordset ' Open the database. dbname =...

Hi, Can anyone tell me why I have the following error on the "Select Statement" code when I open my form?: Type Mismatch Here is the code: Private Sub Form_Load() Dim dbname As String Dim db As Database Dim rs As Recordset ' Open the database. dbname = "C:\Documents and...

I know that this is not hard but I am having some problems. I have a form that the users want to use multiple combo boxes to select the records. If I select the ID number from the combo box, all of the filds populate except the PO NUmber. If I select the PO from the combo box, only the PO...

I have a form with a user text box that I want to default to the current user logged into the application. I track the latest user in a separate table so this info is updated. After the user logs on, he/she opens forms with a user field that should default to the following sequel: SELECT...

I need to provide security for swithboards at the user group or user level. Does anyone have an idea as to how to accomplish this? Homer: But every time I learn something new, it pushes out something old! Remember that time I took a home wine-making course and forgot how to drive? Marge...

I have the following code and I am receiving the error: Too few parameters. Expected 1 I know its the delimeters and I have tried every combination around the fUser variable yet I always get this error. I have no idea what is wrong. Private Sub Form_AfterUpdate() Dim db As Database Dim...

I cannot figure this one out. What is it looking for? Can someone please help me? Private Sub Form_AfterUpdate() Dim db As Database Dim today As Date today = Date Set db = CurrentDb db.Execute "INSERT INTO [Comments] " _ & " SELECT [Assets].[Mylan Asset ID Number]...

Can anyone tell me why this event procedure won't work"? The error is that the Exp1 is an unknown field but this works in the query builder. I need to insert the current date. Private Sub Comments_AfterUpdate() Dim db As Database Set db = CurrentDb db.Execute "INSERT INTO [Comments]...

I have a form that autopopulates a barcode number into the form field upon opening the form. The user then selects a button that will will call and print the barcode through another application. I only want to print the field and not the entire record. Will the following work? The other...

Please help. I am trying to print a barcode by calling a barcode application and printing the number thru a test label formated for a Zebra printer. I have read the docs and continue to get the "Object variable or With block variable not set" error when I open the form. The application is...