Search results

OK I have just tried it in another field where the field is a set date and it all works perfect. but when I try to change it to another date field where that date field is calulated it appears blank?

Hi Bob, Thanks for that I have looked at the tutorial and I have made the query. However the problem that I have is beciase the filed I want to query is a calulated date field it is always blank in the report?

Hi Again bob, Thanks I opened the sample and thats what I want. Could you please explain a bit more how I can link my table to a query. Thanks

Hi I am trying to make a report where it will display the results in a report based on the date inputted. I have a table which the filed that I am doing a report for is calulated. I want to make a query so that if you enter a date it will so you all the dates before that date and show it...

Thanks Bob, it works fine nice one. Cheers Lee

Sorry I took so long to reply. I have attached it. Please could you have a look at it and let me know where I am going wrong. Thanks again for all your help.

Hi Bob, It wont allow me to upload it. It says failed. Can I email it to you. If so whats your email Thanks

Hi Yes I did do that I changed the name to my form name

I just tried what you said above, I coped the function code created a new module and saved it as modTests. I then went the form and entered the other code to call it in the control. It displayed a #name error. I also tried it in the table and it couldnt find the form?

I just tried what you said above in my form control and got a #name? error. So I tried it in my table and it could find the form?

ignore my above post didnt see your reply. I will try it now

Hi Bob, I created the module using the above code, then I tested it and there were no errors. I saved it and then ran it using a macro. The macro just opend the code. The next test field is still blank. Am I doing something wrong?

I have entered =if([Frequency Test Daily]='Daily',[Next Test]=[Last Test] +Dateadd("yyyy",1,Date()))

Date Issue Hi Nope non of the fields that im am trying to use have the word date in them Lee

Date Issue Hi Bob, Thanks for your suggestion. I have now tried the function in the default value of the field form and now have a name error #Name? in the next test field where the date should be. I think #Name? means that the name is the same as the control source so I have changed it but...

Date Issue Hi Brian & Adam, Thanks for your suggestions, unfortunately it still does not work. When I tried your suggestions Adam VB said there was a syntax error. Do you have any further suggestions on how I can get this working. Thanks Lee

Hi, Could somebody please help me, Im having a bit of trouble making a automatic date appear in a table field. What I want is as follows: I have a date field called "Last Test Date" which I input a date manually, I also a text field called "Frequency Of Test" which I input either Daily...