Search results

Actually I can think of some pretty easy ways to get this done. Surely the easiest is to recreate the PDF form as an Access report and then output as an adobe PDF report.

Hi Bob, I took your database and reworked it to do what I think you wanted, now when you change the Short name near the top the records below will automatically change to the correct name records for the application table. I set it to continuous forms so you could see it is pulling all the...

Remove the [] I only added those to indicate where your combo box details needed to go :)

Do You mean that you want to have the combo box display the first returned result rather than a blank? in that case add in the statement Me.[Your Control].Requery Me.[Your Control] = Me.[Your Control].ItemData(0) after the SQL statement has reset your form recordsource

Ahh yes you are quite correct, A thank you to Mr. Brown/e as well. :cool:

Ahh that worked a charm, thanks a lot to all the contributors! Been bugging me for a while that has.... Final Code incase anyone needs wants an example - Add module as per link in BrianWarnocks post Then I modified my existing code from my previous post to read - Dim DateTomorrow As String...

Ok Im back, the code change I tried infact caused other issues so thats scrapped. Im back to doing the below as I tried the Try ? DateAdd("d",1,#30-Apr-2010#) Example but I enter the date and it auto defaults it to American, even if I specify the date as medium date or short date...

Hi DCrake, I tried that and it did not work however I changed my code a little and this seems to work... Me.dteDate = DateAdd("d", 1, Me.dteDate) Forms.Dispatch.RecordSource = "Select tbl_Record.* FROM tbl_Record WHERE (((tbl_Record.DateR) = [forms]![Dispatch]![dteDate])) Order By...

Hi Thanks for the quick reply, I tryied that and no good! :( I also attempted to format the Day1 field as well to ensure thats pulling through in the correct format and it still did not make any difference. Below is the code updated as per your suggestion + doing day1 value as well Dim...

Hi, New here so thanks in advance. I have a section of code on the OnClick event of a button, what it is supposed to do is take the date from the Form on which the button is placed - Form Name - [Dispatch] - Date Field - [dteDate] Then add one day to the date above and requery a table for...