Recent content by MasterPO

That did the trick! I found an Access True/False field that converted with NULL values in the SQL bit field. I updated all NULL records to a 0 and the problem went away. Many many thanks for delivering me from my frustration!

Hi All: I used DTS to move data from an existing Access 2000 database to a SQL Server 2000 database. I linked the SQL table back to Access. The Problem: Imported records will not allow any data fields to be updated via Access. New records can be added and updated with no problem! When I...

Yes, compact-and-repair was my firast thought too, but it has no effect.

A2000 I have a column of textboxes on a form,. The bottom textbox displays a total of the values in the textboxes above (Control source = Val(txt1) + Val(txt2), etc) It worked properly for months, but has now started some bizarre behavior. The calculated total textbox is blank. It does not...

I would like to use an 'insert' trigger on a table to write a record into a similar table in a database on a remote server. (Replication is not an option for this project) 1. Is it possible to use a trigger to do this? 2. Must the servers be linked or can you use something like the 4 part...

Thanks - I don't know how I missed these format numbers!

I am trying to insert records into an existing table that has a specific format for dates and times in the existing records: Date format (Last_Chg_Dt) is '2005-09-16 00:00:00.0000' Time format (Last_Chg_Time) is '1900-01-01 12:26:16.060' Using GetDate(), I cannot find a format to replicate...

Selecting the Max(Hst)Tm) field (by itself) will not return the last record written to the table since a record may have been written later in the day on an earlier day! To select the last record written today or the last record for a specific PO, you could select Max(Hst_Tm) Where Hst_Dt =...

If it's an mdb file and if the code that is attmepting to connect to the SQL Server is running when the mdb opens, just open it in design view (hold <Shift> key while opening the mdb file.) This will allow you to relink tables or address any code or macros that are calling the connection on startup.

Good morning all... I need help with the syntax for a Select statement. Table = AROPNFIL Fields = Doc_Type, Apply_To_No, Reference I want to select the Doc_Type and (when Reference field is Numeric, choose Reference field, else choose Apply_To_No field). All my attempts at 'If...then' and...

Thank you.... works perfectly!

This should be so simple, but I can't seem to get it! I have two databases that are identical (Demodata and Data_01). When a user inserts or deletes a record in a specific table in Demodata, I want to make the same thing happen to the same table in Data_01. I wrote an Insert trigger than works...

Just a little more FYI... The same 'Format..' technique works well for padding the Customer No and/or Vendor No (assuming you are using numeric values for those!), PP Order No, SF Ord No, etc. Watch out for the PO_No (Purchase Order No.. see POORDHDR_SQL). It is eight characters, with the...

The message you are seeing is usually caused by a screenset error, not necessarily a code error. I have encountered this problem when the screenset has been altered and not copied to the username (or group) trying to access the screen with Flex code behind it; I have also had corrupted...

Use 'Print' instead of 'Write' When you substitute 'Print' you will lose the quotes, but the file will be formatted with TABS between the datafields: Results: H 12345 ACTION Write the Print statement like this to get rid of the tabs: Print #1...