Search results
-
A
Date format problem
Hi Brian, It is indeed Allen Browne code: http://allenbrowne.com/ser-62.html But that format isn't proper for the UK and changing the Const conJetDate = "\#dd\/mm\/yyyy\#"does not put it in the correct format. Any ideas how to get it to use dd/mm/yyyy? -
A
Date format problem
Kiwiman Thanks for the reply, I believe I have tried that, I get a Syntax error. I'm sure that you are along the right lines but it just will not work for some reason. Andy -
A
Date format problem
Hi, I am using someone elses code and I am struggling to get it to so what I want, could you help please. Const conJetDate = "\#mm\/dd\/yyyy\#" 'The format expected for dates in a JET query string. 'Date field example. Use the format string to add the # delimiters and get the right... -
A
setting default VAT (Sales Tax for non UK) value
Thanks a lot for your response missinglinq. For the life of me I could not figure that out. Sometimes the simple things can illude me, appologies. My thinking behind storing the vat rate in just for simplicity reasons really. The VAT can be calculated then as and when needed i.e. in the reports. -
A
setting default VAT (Sales Tax for non UK) value
Hi, I am creating an Invoicing database for a friend. In the Invoice table there is a field for VAT(%). When a new Invoice is entered I would like the form to show VAT at its current rate (15). I have created a table VAT_Rate with a field VAT. Is it possible to point the default value to...