Search results

Ok thanks problem solved

I am trying to open my database for exclusive use but i get the following message: You can't open "" for exclusive use because you do not have permissions to open exclusively Any ideas why this is happening? The only security i have is password prtection

Ok cool, if i was to deign the data entry forms in access, when it comes to the windscreen company and broker would i load the contents of the windscreen company and broker tables into comboboxes? And also in the database itself would it then just display the windscreen company id and Broker...

Ok i think i understand you know. My project is actually near completion now apart from displaying the reports and the help file but i will be revising it at some point after its been released and tested so when revising i will play about with my tables and normalise them. If i understand you...

I have the following sql statement: SELECT * FROM Autoglass UNION ALL SELECT * FROM AutoscreenNetwork UNION ALL SELECT * FROM Autowindscreens UNION ALL SELECT * FROM Glasscare UNION ALL SELECT * FROM MobileWindscreens UNION ALL SELECT * FROM NationalWindscreens This just unions all...

Ok thats kinda confused me slightly maybe if i explain what my application does this this will make things easier. Basically i haven't vreated any forms as none of my data entry is done in access it is all done from my vb.net application. Basically the system is to keep track of windscreen...

I have changed my reports now havent finished them all but managed to make them look a bit more professional. The only one im stuck with no is having a report showing the sum of the Total and Completed columns of all tables. I have attached updated database. Appreciate your help. By the...

Sorry my fault i had attached one of my testing databases. Correct one with reports is attached. Password is the same. Thanks Please could you also advise why the sub reprts look different to the main reports?

No theres no front end just tables and reports as the database is being used my my visual basic application users wont have any direct interaction with the database itself.

Ok i have created the report with all my sub reports. This is the report called total. I have attached my database for you. Any advice on making my totals report look better as it looks very tacky at the moment. The next thing i wanted to do was to calculate the total for the total and...

Can anyone show me how to write a UNION ALL sql query in VB.NET

I have made separate reports for all of my tables. How do I add each of them to an unbound report? Basically I just want one over all total for both columns total and completed Thanks for the help

I have six tables which contain the same sort of data but aren't related in any way. The first thing i want to do is have a report that shows all fields of each table on one page. I would also then like to get the sum for two different columns from all six tables. The columns are called Total...