Recent content by Arcadia

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"))...