Search results

OK try this then, in Excel create a table with the Friday dates for a long period of time. Say in B1 = Type in Friday Dates, then in B2 add in the first Friday then in B3 add in the Next Friday then highlight the 2 and drag on the autofill down until you have say 1 years of Friday (Just to see...

I would be more interested in why is it creating a copy to the users PC? How have you uploaded the database to the SharePoint site.

Sorry that isn't available. You can create a table and use a drop down with the Friday dates. I would ask why though!

Thanks for letting us know you have resolved the Thread.

What have you tried from the suggestions you have received so far?

Try something like this, change the details in coloured in Red

What you are exporting is not a report it is a form, that is why you have got the coloured grey background.

Enjoy the weather!!

Yes try a re install. Macro's in Access aren't that hard to create. Take a look here: https://www.google.co.uk/#q=MS+Access+2013+import+excel+youtube

Can I suggest that you look at setting up a macro in the Database to import the spreadsheet to see if this resolves the issue.

Welcome to the forum, this sounds as though you are missing Library files or you might need to repair MS Office. Please read the following thread to see if it helps. http://www.pcreview.co.uk/threads/what-does-no-object-in-this-control-mean-when-importing-data.2624277/

Welcome to the forum, If you have several tables perhaps one with the list of staff so you can relate that to a drop down (which then provides an easier manageable system for updating staff), then one for the ceremonies and what you need to place within it. You can then create a query...

Can you upload an extract with any sensitive data being removed and can you please state which query you are exporting and into which program. A small example of what it looks like know and what you would like it to look like.

Welcome to the Forum, I would suggest take a copy of the database first then convert the copy and see if there are any issues. As we don't know the database in question it is hard to give you a clear concise answer. For instance: Is the database using and VBA Is the database connected...

Can you look to upload an extract of the database, you can upload up to 2mg which can be zipped or place a copy in dropbox or something like that so someone can take a look at either advice or help on creating a solution.

Hi David welcome to the Forum, as you have created the query then perhaps the results can be exported into Excel to supply a suitable Graph and use the Query as the Data Source. Alternatively you can setup a Chart form in Access and use the Query as the source and model how you want to see it.

You could set up a query and convert that to a form and use the form when the database starts. Autoexec Macro or File Options Current Database and select the form. You would need to give more details if you need help in doing this.

I believe you need to convert your ADP SQL code into ADO within Access. How this is done I am not totally sure as I am not aware of the ADP SQL Server side. I don't know if this link will help but there are suggestion of third party software to help...

Happy to help and thanks for letting me know you know have a working solution.

Remove this line.