Search results

again apologies for scant information, i am creating a continuous form that displays a set of records that will allow the user to determine where invoice information is not created. the list the query gives in both circumstances displays the right data what i'm concious of is as part of the...

i knew i probably didn't describe things right, let me try again: Option 1 would just refer to a query like SELECT test.* FROM test; Where Test looks like: SELECT DISTINCT [FACT-Deliveries].del_arrival_date, [FACT-Consignments].cons_supplier_id, [FACT-Consignments].cons_albaran...

Hi All Not sure how to phrase the thread subject better than the above as i'd probably end up writing most of the paragraphs coming as the subject. Anyway I'm trying to understand if there is any discernible difference between the following 2 options for a forms Record Source. Option 1 If i...

@Gasman followed the link, read the thread and followed the link provided by @MajP of "Working smarter not harder" creating the Csql code to use. So thank you for pointing me in the right direction as i now have a module that will help me now and in the future, much appreciated

brilliant, thank you i'll check the link and implement the suggestions and update this when its working

Hi All I am trying to query my data to get the top 1 record based on a todays date as part of the WHERE criteria but have found that if i use Date() no records are found when 1 should, if i put the date in manually it doesn't return records. This was getting very frustrating but then i just...

ignore this please, i've decided to add alternating line colours and remove the dividing line, it actually looks better and resolves my issue

Hi All Not sure if this picture gives a good representation of the issue but i have a dividing line between rows that is underneath the fields in the details section. It is grey to not be too intrusive. At the bottom of the report i have my totals and i have surrounded them with 2 darker...

@gemma-the-husky your sig talks about scales and thanks buttons, i can't see any of them......... i've liked all the responses but i'm not sure if thats the right way to reward people

its one big ongoing learning process for me over the past 6 months from knowing nothing about databases to where i am today. my initial methods of doing things was very much a "traverse the data programmatically and do things as i go" the RBAR method described above, i'm finding now how to do...

@cheekybuddha thank you, appreciate the response. i do - as a matter of course - set things to nothing and close off recordsets etc so that is being done later on in the vba after the snippet above that i'm looking to replace the findfirst with the query the Me. bit i seem to have lost the me's...

@Minty thank you i'll take a look at the link as well as everytime i get a bit more information it helps me go back through my "poor" decisions on how to do things (due to lack of knowledge and experience) and re-do in a more efficient way so just for a final confirmation the update query and...

@cheekybuddha the percentageOfAmount is calculated earlier in the VBA code based on a number of factors including user input. the recordset definition was a copy paste thing where i just removed the findfirst and replace with the first queries and then the single query if the single query does...

so would this 1 line be the equivalent of the 3 lines: dataBase.Execute "UPDATE [FACT-DeliveryProducts] SET [del_prod_claim_cust] = " & CDbl(txtTotalQualityAmount) * percentageOfAmount & _ ", [del_prod_claim_cust_quant] = " & CDbl(txtTotalQuantityAmount) *...

Hi All I am very green when it comes to databases and queries etc so i'm constantly learning as i go. initially i had some processes which update records in a table using a recordset and findfirst function but the more i learn and understand the more i'm trying to improve the way in which my...

@June7 perfection, thank you, your suggestion worked. Thank you all for your help as always all your suggestions got me to where i needed to be overall, thank you

@June7 oh, yeah, that makes sense i'll give that a go

ok so this kind of works, the issue is: UK: EU:

ok so dlookup and conditional formatting is working ..... to a degree....... So above is what i have so far, which works, but the reports either have a blank space underneath or above where the text is white'd out. If i overlay the lines then i just get a blank space in the footer, so i'm...

right ok, so a DLookup is the way to go i see now, i was over thinking things and confusing myself, thank you, i've got the idea now and can run with it, if i run into an issue i'll add to this thread if not and i get it working i'll mark as "answered"