Search results

Hi all, I have 2 tables i wish to check if records exist in both - Unmatched query methinks - however to create a unique identifier for each record I create 2 sub queries that takes the employee ref no and the date for that record, converts the date to text (using a function found on't web)and...

Trevor, the form was already on current record only to stop unintended changes happening But the grouping by trick worked and stopped the duplicate records - so Thank you for that. Still baffled why it was happening - I have used the same technique to enter data into a table dozens of times...

Hi Guys This is a weird one I have done this dozens of times, but something is happening I have never hit before. I have a a form bound to a table, but it has fields that are unbound to this table within it, these fields are either combo or text box's - data is entered into the field and and...

amended reply set your original field as hidden then create a new blank text box with its control as described as before. don't think you can do it using conditional formatting

The formula goes in the text box No, you put the formula in the Control source for the text box. Eg control source: =IIF([YourField]=2,"required" ,"") the same as in a form control hope that is clear cheers Dean

try this =IIF([YourField]=2,"required" ,"") might work

cool namliam, did not know that one - learn something new every day

Your Welcome No Problem - it was things like that in excel, that made me start using access more and more BTW: if you want to paste just calculated values not formulas try paste special, values. Dean

use the dollar sign Hi, If you put a dollar sign "$" before the cell reference eg: instead of A3 you use $A$3 the formula value stays the same when you copy and paste better example: Sum(A3+A4) in cell B3 when copied and pasted to C3 will become Sum(B3+B4) however, Sum($A$3+$A$4) in cell B3...

Oooops Sorry - Gemma not Emma :D

Was trying not to do that Emma, thanks for your help - was trying to see if there was a more elegant solution, but do have a suspicion that it may not be possible;)

Hi, Think this may be mission impossible :-) I have a multi page report based on a query to reprint invoices, however the invoices could be for different customers. What i am trying to acheive is: If a page of the report (1 invoice) is for a certain customer - I want to print 2 copies, if...

Works for me Hi, CEH your little snippet of code worked perfectly for me - I was trying to the same thing, open a form with details from a form with the summary, after messing about trying to write my own stuff - did a search found yours and voila - problem sorted, so just a quick note to say...

Rich sorry can you please explain ? sort of lost me there - know what a totals is etc but the date value is a expression in the query ta Dean

that works - but still need to tweak Allan Thank you that query did exactly what I need for 1 day - now just need to work out how to generate a table for every day, maybe a vb loop ? - will have a search round, but if you come up with something please let me know cheers Dean

Hi, I have a query that has the fields start date (when job started) Finish date (when job finished) total cost (invoice value) No of days (date diff between start and finish dates) earnings per day (calculated from total cost/no of days) what i would like to achieve is a table/query that...

thanks Ruralguy thank you for your help - that seems to cover most issues cheers again Dean

Guys, don't know if you can help me - I have been tasked with creating a simple DB but for use on systems that have access 97 installed, I use access 2003 (reasonable standard) is this possible and are there any pitfalls I should be aware of? cheers

verify date Hi, just done something simular - is the user entering a date and you want to verify that it is between those paremters ? if its on a form just use vb along the lines If (Me.Date.Value) < (Me.StartDate.Value) Then MsgBox "Date before start of period!!", vbOKOnly, "Incorrect Date"...

Thank you Ghudson, thank you - I was able to adapt that code to what I wanted, funny when I searched using backup as the search string it never turned, should try harder I think is the answer to that one. anyway thank you again Dean:D