Search results

Has anyone used or encounted a program called Fashion Sense 2000? It is a front-end written in delphi that uses microsoft access as a back end (for the tables). We currently have a client who are using this software and are having problems with record-locking. When using the system across a...

..or alternatively, you can use the code If IsNull(Me.FieldName) then Me.FieldName = 0 or Me.FieldName = "" (if its a string) ElseIF ... Endif Although then you probably might want to use the "Nz" function as mentioned above

You could maybe use some validation, ie IF IsNull(Me.CompanyName2) Then MsgBox "Please enter the company name!" ElseIf IsNull(Me.ClientSampleID) Then MsgBox "Please enter Client Sample ID" ElseIF IsNull(Me.BBCID) Then [...and so on for each field...] Else 'All fields are...

Rich you were right, as when i went back to using the SQL in a form's code, it continued to cause errors once again, so I renamed the field to 'invoiceDate' rather than just 'date. using queries to figure out problems in SQL statements also is very helpful. I've learnt heaps from this board...

Figured it out Yeah i tried it out, and although i got the same error msg, it highlights the part of the SQL statement that is causing the problem. It turned out that it wasnt the way I was entering the date after all, but the fact that the field i was inserting the value into was called...

This is a common and simple problem many people (beginners like me) seem to have... but i couldnt find anything to help my specific problem on the forums so.. I am using an SQL statement in a form's code like this (simplified): SQL = "UPDATE tableName " & _ "SET date...

For some reason, the database has began complaining about 'Form1' being missing when coding my forms, even tho I'm not using a form1 anywhere. I get the following message: "The form name 'Form1' is misspelled or refers to a form that doesn't exist. If the invalid form name is in a macro, an...

Thanks a lot, that's exactly what I need.

ok that sounds good.. could you give me an example of actual SQL code one would use ? that would be great thanks.

I want to display all the products in a products table, and then display the sum of the quantity of these items that are on the order table. However, if a product thats in the product table is on no orders (that is there are no related records in the orders table), it will not appear in the...