Search results

Hi all, I have a query that is basically loading values from a open form. Im using the format of Product: Form!form1!products to assign the value of products to product in my query... Now all this works with straight text, however this technique does not appear to work with dates or yes \...

Maybe I need to go back a step! When the form loads, the value for the textbox apples on the form is got by apples = DLookup("myapples", "Query1") Query1 is basically a filtered record from the main table RECORDS. I basically need this line of code (or similar) to work just before the cancel...

nope It doesn't allan, it still keeps the newly typed value in, and doesn't return to the original value. It does put the focus in the textbox though? Its a unbound textbox

re: It doesn't return it back allan? but atleast the code doesn't bum out. Any other ideas?

re: Allan, if you get this message, somewhere in this code, i want to return the original value of apples back into it's textbox on the form should a duplicate be found. Just after the msgbox i put something like apples = (DLookup("[myapples]", "RECORDS", "[myapples]='" & Me.apples & "'")) but...

re: Allan, you really are an Access guru! i am very greatful for your help.

re: Thankyou muchly, for your replies gents. The control code is now in the beforeupdate as below, but where do i set or put the cancel = true?? never done that before Private Sub apples_BeforeUpdate() Dim testfruit As String testfruit = Nz(DLookup("[myapples]", "RECORDS", "[myapples]='" &...

Ok guys, I have another problem...last one for today. When i click save on my form, it will check for nulls or 0 entries on 3 text boxes... I'm using fruit in this example for arguments sake and it works ok... I'd like to introduce testing of duplicate entries somewhere in this code, so on each...

re: Rural guy, that was exactly what i needed. thankyou

re: It doesn't help mate sorry.. Dlookup syntax can get real messy at times. I hope someone can spot the problem.

Hi all, txthours is a textbox on my form, but i can't get the dlookup syntax to work... theres a syntax problem i think in the line of code? I get the values for aserial and ahour from a query.. this works ok. any ideas?? thanks Dim ahour As String Dim acomment As String Dim aserial As...

Hi all, I need some help figuring this problem out. I’ll keep it simple. I have a data entry form with 3 text boxes where you can enter product name, serial number and comments. A save button writes the entry to a table called “Products”. That’s all fine. I also have a data edit form and this...

Hi all, i want my report to print on single sheets. At the moment our IT dept have set our office printer to print double sided. Is there a way in code i can use the docmd.openreport or similar to print on single sheets only? thanks!

Hi ted, thanks for reply. The paragraph of text will hopefully be inserted into the detail section of the report. There will also be some additional data in the details section of my report from a query. Also, when inserted text this way, is it possible to specify the text font and size? Thanks...

Hi all, I need some help on a method to insert a paragraph of text into a report based on the country the report will go to. The paragraph(s) of text is basically some end user information and consists of 7 lines and 100 words. The wordings within the paragraph text are slightly modified for UK...

re: Between Date() And DateAdd("d",-7,Date()) Or Is Null Worked fine chaps. Many thanks

Hi all, Can someone please help me with a date range query. Basically I have a query that shows delivery dates, from 01/01/2006 to 01/01/2009. I just want to modify the query so it shows all deliveries within the past 21 days and all outstanding deliveries until 2009. Please note that in some...

Hi all, can someone please help me get the syntax below right? I'm loading the values of 2 text boxes, tabl and text10 from my form into the statement. Many thanks db.Execute "DELETE * FROM " & Me.tabl & " WHERE ID = ('" & Me.Text10& "');"

re: Thanks! i sorted it :)

Hi all, I'm trying to splitt the name of the clients in my query into a column called Initials: Their 'Names' are in this format SMITH,JOHN JONES,PETER Therefore in Initials, i want to see in column Initials JS PJ How do i do this please? Many thanks