Search results

Ahh I see, thanks, that makes much more sense than the way i was doing it! All working nicely now. Thanks Again!

Ta very much, worked like a treat! One more thing....... When calling the function must you declare a variable and then make the function equal to that variable to make it work? Even though you are not getting a value returned from the function? i.e. Dim intDone As Integer intDone =...

Hi, I want to pass the name of a form control to a function so the function can check the value of that control (Check box) i.e. If Forms![FormName].[CheckBox] = False then ..... Would you send it as a string or a control or ??? and if so how would you go about using that as a control...

Thanks, i will do a bit of searching, see what i can find.

The Application.FileDialog(msoFileDialogFolderPicker) that you set me up with has a method .initialFileName eg. strSelectedPath = Forms![MIP-Preview/Print/Export].SelectedExportPath.Value dlgFolderPicker.InitialFileName = strSelectedPath & "\" so you can set where the file picker...

O just one more thing, would you happen to know if there are any methods available for the the 'outlook session' i.e. via DoCmd.SendObject to initialise its Attach File 'File Picker' so that i can point it to the path i have saved? i have to make the dots really close together for certain...

And Finally this to email Function Email_Weekly_Report() Dim strMsg, strExpPath As String, MsgBoxRes As Integer strExpPath = Forms![MIP-Preview/Print/Export].SelectedExportPath.Value strMsg = "Please remember to attach 'Weekly Training Hours Reports' to email, "...

And then this to export to saved location Function Export_Weekly_Report_as_Snapshot() Dim strMsg, strFileName, strExpPath, strRepDate, strRepName As String If Not IsNull([Forms]![MIP-Preview/Print/Export].[SavedWeeks].Value) Then strRepDate =...

Thanks vbaInet! that was just what i was looking for. I put this in a module Function SelectExportPath() Dim dlgFolderPicker As FileDialog, strSelectedPath As String Set dlgFolderPicker = Application.FileDialog(msoFileDialogFolderPicker) dlgFolderPicker.Title = "Choose or...

yea like a folder picker, that's it. Thanks, I will have a search for Microsoft Dialog Control and see what i come up with.

All i could find was DoCmd.RunCommand acCmdSaveAs What i had envisaged was something similar to what you see on many applications where you are able to set the destination folder in 'settings' that you want any post processed files dumped into. Is this a bit of a tall order? I have a feeling...

Could anybody point me in the right direction? I want to put code behind a command button to open up windows standard 'save to' or 'export to' destination box and then save the selected path in a table so that i can reference this when i trigger DoCmd.OutputTo function to export reports ready...

Ok I think i got it. Convert everything back to normal date format as you said Mailman and then do a iif(DateDiff ("m", [LeaveDate], [SelectedDate]))=0 Thanks for the help!

Thanks for the pointers! Would you have any ideas about how i would say: Include [LeaveDate] if within SelectedDate month? Thanks!

I wonder if someone could help me with this. I have 2 combo boxes on a form. One with Month and one with Year. I am trying to get a query to look at the combo boxes and return values from a table and thus generate a report. Table has amongst others, these fields; [Name], [StartDate]...

That is a very kind offer, thank you. Will keep messing about with it for a while and see how i get on. Even though it can be very frustrating it is a great way to learn what is going on.

Thanks so much for clarifying. Because I am such a noobie, when i did not see the 'function()' at the top of the code it did not ring any familiarity bells so i thought i must be missing something so apologies for the extra effort, but it really is appreciated. I think i am getting there...

Thank you ajetrumpet, however i really don't know what i am doing :confused: Where does this code go? Do you put it into a module and then call it from a query? If so what would Query sql code look like? Thanks.

Yes i have access set up to display reports of journey information but unfortunately this information is available from a different database so one has to be closed down to access the other. So i decided to link the tables from one into the other. But in one database records are by journey with...

Would really appreciate any help on this, can't seem to find a solution.