Search results

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]?|" &...

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...

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...

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...

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...

Hello, I have created a database in Access 2002 which on opening starts up a menu form containing buttons linking to the other forms in the database. I have a macro setup on each form to maximize the size on opening, my problem is I want the previous form the menu to close when the...

Im composing a letter to be attached to a button on a form to preview a letter about a debt. The thing is when I open the letter, the data that I have entered is repeating and I dont know why, I know I can finish this letter if I can only find out why the data is repeating so I can stop it...

This seemed simple enough to do but upon trying it I cannot get the date to appear in my letter. I have included the whole text from the letter so you can see where I want the date to be, as you can see the date part is entirely wrong, how can i correct this error. ="If we have not received...

I am trying to make a macro that i can assign to the after update property of a text box on a form, I have tried this in the macro: Set Value Item :[Forms]![frmTenants]![Credit_Ref#] Expression: UCase([Forms]![frmTenants]![Credit_Ref#]) The trouble is this wont work, what am i doing wrong...

OK I have created a form which shows tenants details, I have also created a report which shows a breakdown of all the tenants rent details. What I wish to do is create a buttton to link the report to the form so that the report will only show the relevant rent records of the tenant being viewed...

Im trying to make an append query to add the weekly rent amouts from one table called tblProperty_List to another field called Amounts in another table named tblRent. I made the query thinking oh this is simple enough, but upon running the query I received an error message stating the records...

Ok I am trying to do a calculation on my main form totalling some amounts. On my sub form the control source is =Sum([Amount]) my subform is named frmWarrantyListSubform, the Textbox on the footer of the subform is named txtWarrantySubform. My main form is named frmProvider, my control source...

Im working with a form and want to include the staff members forename and surname in a textbox next to the checked by box. In the properties i can select either forename or surname but not both. I thought about the expression builder and tried using Staff Forename And Staff Surname but this did...

I am trying to set up a validation rule for a field of data. I am using the following rule: Like"[ABC]###" I want the user to be able to enter 3 letters followed by 3 digits, though whenever I enter data like ABC123 I get the error message. Why is this? Thanks Charlie

I am trying to build a query that will produce the records for one person from my database. The query I have got produces all persons results, I have tried adding Where [FirstName]="Jack" But this produces a single row of empty cells. can anyone show me what am doing wrong? Charlie

I am trying to create one to many relationships in this database file I am currently experimenting with and cannot get the thing to link the way i want. Could someone give me some advice on it please. I was trying to maintain referential Integerity, but have found it impossible. Thanks Charlie

Im having a nightmare getting the figures on this form to total, I cant understand what is wrong, i have done this before. the total amount I am getting after my calc is £3.95 which is only half of what I would expect. I am using =sum ([amount]) in the footer of the subform, and in the mainform...

I am using access 2002, I have two forms, one named frmEquipmentWithTests which I want to be my main form, I also have a form named frmTestHistorySubform which I want to be my subform, my question is: How do I insert the subform into the mainform ? Ive read my book and cant find anything about...

Im trying to calculate the totals in a text box on my subform using this syntax, =sum([Amount]) the trouble is the text box remains blank, could someone take a look please. http://homepage.ntlworld.com/charlie_chuck/invoice12.mdb The subform is part of frmInvoiceSubformsupplier. Thanks Charlie