Search results

Thank you :)

No i want to stay with the report :(

The table is updated normal just by hand but after i save or close it I want the report "Calender" to automatically open.

Hi everyone, I have a question and really hope someone can help me out here :rolleyes: I was wondering is it possible to open a report automatically after you updated a table in Access? My table is opened by a AutoExec Macro and will open automatically if the database is opened but my goal is...

SELECT TrainingCalender.Title, TrainingCalender.Location, TrainingCalender.[Start Time], TrainingCalender.[End Time], TrainingCalender.Description, TrainingCalender.Duration FROM TrainingCalender, Selection WHERE (((TrainingCalender.[Start Time])>=[start]) AND ((TrainingCalender.[End...

Can someone atleast tell me or it is possible?

I have a question and really hope someone can help me out here :rolleyes: In access I have made a report with fields I have also made a Button to send a mail to users but my goal is now that if users click the button they can insert the "Start date" and the "End date" in a inputbox the "Start...

Hi everyone, i have a question and really hope someone can help me out.. I have a Excel file with data of different users now is my question: Is it possible that if I or a someone else opens that Excel file automatically a Inputbox show up where a user can enter his NAME or E-mail and than...

Maybe a stupid question but i really hope someone can help me out.. NameStr As String Like you guys and girls can see i have mad a name string Now i would like to add the nameStr near "Dear " how can i do this? strbody = "<H3><B>Dear [I want the placed nameStr here] </B></H3>" & _...

Hi, in Access i have made a report with data and now my goal is that if i click on a button the data will be exported to a existing Excel file under the other existing data so in row A6. Is this possible true a VBA code? :)

The second one worked! :D THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! :D :D

I cannot do that because the database form is connected to SharePoint is there another way to solve it?

I'm stuck :banghead:

I still get the error message :( How can the code be fixed? Or is there another possibility :confused:

Thanks but when i insert the Start date i get the following error message: Run-time error 3421: Data type conversion error. And the following line is selected in yellow: qdf.Parameters("[van: dd-mm-yy]") = Format(InputBox("van: dd-mm-yy", "Start Date", Format(Date, "dd-mm-yy"))...

Yes it is the start date en end date, and it depends on what the user fills in because when you open the report the parameter shows up and the user can fill in a start and end date and the you will see al trainings days in that period of time. I want to put the current output info that show up...

SELECT TrainingCalender.Title, TrainingCalender.Location, TrainingCalender.[Start Time], TrainingCalender.[End Time], TrainingCalender.Description, [Training description].[Training description] FROM TrainingCalender LEFT JOIN [Training description] ON TrainingCalender.Title = [Training...

I thought to find the parameter and open the query.

Sorry i forgot the code. Private Sub Command18_Click() Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem Dim objOutlookRecip As Outlook.Recipient Dim objOutlookAttach As Outlook.Attachment Dim qry As QueryDef Dim rst As...

Ok i did that with the Query Def but when i run it i recieve the following error: Run-time error 2482: Microsoft Access cannot find the name ' van: dd-mm-yy' you entered in the expression. Private Sub Command18_Click() Dim objOutlook As Outlook.Application Dim objOutlookMsg As...