Search results

Hi, I am trying to multiply £127.65 by 1.175 to produce and store the answer £149.99 in my “answer” field. I have spent more than a few hours testing different methods, but none so far seem to be suitable. I used to use the currency data type, however - although the field would show £149.99 –...

Hi, I have five text boxes on my form where I enter my data, its very important that a button is pressed after anything is entered into any of the text boxes. I want to have a “bulb” (or realistically an empty text box) underneath these five boxes that starts off being “lit” green – but...

thanks for your help guys, I ran a delete query, then an append query, then the final query to select the data. I didnt realise that append queries allowed sum functions to be used! Thanks again. Dean

Hi, I have a make table query that deletes the old table every time the new one is made. However every time the new table is made it resets the field property for the “Date” field to “Text” rather than “Date/Time” Does anyone know how I can avoid this problem please? I’ve tried an update...

Cheers John, You were a great help! I used the following code: Me.Customer_Name.Value = Split(ImportCSV, ">")(0) Me.Customer_Address.Value = Split(ImportCSV, ">")(1) Me.Customer_Postcode.Value = Split(ImportCSV, ">")(2) and changed the "," to a ">" so when a customer used a comma when typing...

Hi, I'm looking for some help to parse or separate data from one field and copy it into different fields on my form. I’ve written a PHP Script on my website that sends the data entered in a web form to me in an email, I currently send the data to myself in the following format...

Hi Aziz, Thank you for your reply. The reason why is because the csv data is sent to me in an email from a web form - some customers type out their address with commas, for example: Joe Bloggs, 50 ABC Street Gatling Anywhere West Yorkshire, WY34 45BW is sometimes written as: Joe Bloggs, 50...

Hi, I have information in a csv format, like this: Name,surname,address,postcode,telephone I have a memo field on my form which shows this data - currently I am cutting and pasting the name, telephone details into the relevant fields on my form. It’s quite time consuming and I was looking to...

Hi Moniker, Thanks for the reply - the code performed the query as normal but didn't solve the problem, tried moving the brackets and using "speech marks" but no luck. Cheers for trying tho Moniker :)

Hi, I use a query to return values between two dates, here's the code I use: Between [Select Start Date:] And [Select End Date:] However because my dates are time stamped (they need to be!) the query omits anything on the end date, for example: Between [01/09/2007] And [05/09/2007] will...

I calculated C directly on the form using: Me.FieldC.Value = [FieldA] * [FieldB] Thanks for responding ajetrumpet :)

Why don't you copy the whole database, or just the form and table that you use, and use that on another computer? The form itself is unusuable without a table to save the data to

Sorry WayneRyan, it was your code I used before my last post and it worked fine, so thank you - any idea on the Macro problem? Cheers again

Hi, All my fields are currency fields and they are set to 2 decimal places, both in the table and the form that uses it. On my form I multiply Field A by Field B and the result shows in Field C. The answer in Field C appears to be a 2 decimal figure but when I click on the field it shows 3...

Beautiful, thank you Wazz for your help. I setup a command button using that code and it works perfectly.... One last question if I may? Do you know how I can use that code as part of a Macro? I already have a button that runs a macro on the form, so I was hoping to add that code to the macro...

Hi Wazz, Thank you for responding. Rather stupidly I've named all my fields and tables "Paid in Date" - so the following code is a little confusing - here's what I entered: "Private Sub Command234_Click() Me.[Paid_In_Date] = DLookup("Paid in Date", "Paid in Date") End Sub" However the...

Hi, I have a table [Table A] - it contains two fields: [Date ID] & [Date] To enter the details into this table we use a [Date] form. There is only ever one record, because when a user writes a date into the [Date] Form it overwrites the old date that was in [Table A]. I want to be able to...

I've managed to solve the problem, by adding .csv to the end of the file name on the transfertext version.

Hi, I run a make-table query which saves the data I require to a table called "tempcsv". I can manually export this to a csv file - however I have tried two different methods to do this automatically, however both have errors - if anyone could help me to solve either one then I would be very...

Thank you Bob, I had a quick look after posting that last message and thought that might have been the case.