Search results

I have the same problem here. i recently found this possible solution but i do not have access to the servers to test this out. One the server guys try this, i'll let you know the outcome. danmyhre.wordpress.com/2012/12/18/blank-report-exports-from-access-web-databases-in-sharepoint/ Happy...

This is ridiculous but i found a workaround. open both databases. (one in each window) Select the tables, queries, forms, etc and copy them with CTRL-C (single or multiple items) from the source database. then from the source database, click file then new. (which essentially closes the source...

I can only use macros on a web database. And i'm not sure how to create your query code you have listed.(sorry, I do not have the full understanding of all this like i need to have.) How do i indicate that the item is out on loan in the Device data tab? How can i tie that to the out on loan table?

Here is what i have, however this only works locally on my laptop. When i publish this to the sharepoint server it either limits the dropdown box to the first 400 numbers (i have over 4000) or if i change the combo box to a text field it does not allow me to add a line via the data sheet. I...

Can i attach the database so you can see what i'm doing wrong?

If i need to get rid of the check boxes, how will it flag that the device is out for repair? can you give an example?

I have that and it works. i have created a query based on my out on loan table. the query has DeviceAssetTag, LoanStartDate, LoanerInfo, LoanEndDate and an out on loan checkbox. The query is setup to display those records that the out on loan checkbox is true. i can change that to display only...

What i have is this... there is a table of devices. 4000 laptops, desktops, printers etc. this table has the device serial number, Asset Tag, and a check box for Out on Loan (plus other device info, like make, model, location, etc.) Then there is another table for device that are Out On Loan...

I am new to coding and i need a macro code to uncheck a yes/no check box when another field (date field) is updated. Macro code only since this is a web database and vb is not available. The only actions available are those listed in the screenshot attached. Basically i need... if Date field...