Search results

How then How are we expected to validate then?It seems like there are a thousand and one formats

Ok Like"[A-Z][A-Z][0-9][0-9][0-9][A-Z][A-Z]"Or Like"[A-Z][A-Z][0-9][0-9][A-Z][A-Z]"Or Like"[A-Z][0-9][A-Z][0-9][A-Z][A-Z]"Or Like"[A-Z][0-9][A-Z][0-9][A-Z][A-Z]" Are you sure these are valid postcodes?

Erm Like"[A-Z][A-Z][0-9][0-9][0-9][A-Z][A-Z]"Or Like"[A-Z][A-Z][0-9][0-9][A-Z][A-Z]"Or Like"[A-Z][0-9][A-Z][0-9][A-Z][A-Z]" I don't allow spaces in my DB sorry

Solved: Like"[A-Z][A-Z][0-9][0-9][0-9][A-Z][A-Z]"Or Like"[A-Z][A-Z][0-9][0-9][A-Z][A-Z]"

Upsizing Input masks don't get upsized to MSSQL but check constraints[Validation Rules] do, they haven't when I have tried upsizing DB's before.

Problem Anyone know what's up with this ? My existing data is regarded 'invalid' when I add the or condition?

Looks like Looks like I am sticking with Like "[A-Z][A-Z][0-9][0-9][0-9][A-Z][A-Z]"

I have searched the forum for posts on the subject of UK postal code validation and found the reg expression that seems to be recommended for this. I tried the expression but it will not accept this postal code? TS183AM Like "(?:(?:A[BL]|B[ABDHLNRST]?|" &...

Gracias Thanks man

Hi, I have built a query which works fine in access. The thing is I now want to use the same query in MSSQL 2000 and the synatx is wrong. I have tried altering the syntax myself but i am unable to get it to work. Can anyone show me how? Access Syntax: SELECT DISTINCT Holiday_Bookings.ClientID...

Ah Got it Will the currency formatting apply to any upsized data to MSSQL 2000?

Thanks Man That works great, but can you tell me how to format the result into currency, sorry to be such a dummy it's quite a while since I used this stuff.

I have developed a query which adds accumulated costs for each client in my DB, I am having trouble adding the VAT tax which is 17.5% to the query though, I seem to get a lesser total once tax is added which can't be correct. Here is my query: SELECT DISTINCT Holiday_Bookings.ClientID...

Sorted Ahh I think I have sorted it out. Thanks again Pat ;) SELECT DISTINCT Holiday_Bookings.ClientID, Holiday_Bookings.Booking_Cost, Room_Facilities.FacilityCost, Rooms.BasicCostPerNight FROM Holiday_Bookings RIGHT JOIN (Room_Facilities INNER JOIN (Hotels INNER JOIN Rooms ON Hotels.HotelID...

Thanks I have altered my query to remove the unneeded tables and now I get 6 results instead of one. I am puzzled. SELECT Holiday_Bookings.ClientID, Holiday_Bookings.Booking_Cost, Room_Facilities.FacilityCost, Rooms.BasicCostPerNight FROM Holiday_Bookings, Room_Facilities INNER JOIN Rooms ON...

I am trying to build a query which will find the costs from a set of tables where the client has costs. The client has a cost on booking a fee, he has a hotel room cost and a room facility cost. My query brings up what I want but each result is repeated 3 times. I don't know why, can someone...

I don't know if this post is valid here but I thought it might be so here goes. I have a MYsql database and I am developing a Perl script that runs a query against this database to output all the registrations and colours of the make and model of the car selected in a form. I think my problem...

Thanks again The message tries to send using the line you suggested but i get an error stating that the "message has an unknown recipient and was not sent". Command47.HyperlinkAddress = "mailto: " & Me![Text45] Charlie

Thanks Hi, I looked around and found a little code that almost does what I want. Private Sub Command47_Click() On Error GoTo Err_Command47_Click Dim stDocName As String stDocName = "tblChemistClientPersonal" DoCmd.SendObject acReport, stDocName, "RichTextFormat(*.rtf)"...

Hi, I have created an application in Access 2002, in the application I have several forms that display clients data etc. Also I have a button that displays a report that is linked to the ClientID field which is formatted into a letter, either complaining about late payment or requesting the...