Search results

Thanks yes agree re backups - customer didn't do as told. I have run it through thestelllar software and it seems to be throwing up the data in one of the important tables but doesn't show some others but for one database it is a bit too expensive.

Hi I have a database with a client and it seems that there was some power issue resulting in corruption within the database. The database now has the message Msysdb is missing. The database will not open so cannot get to the repair tool and I cannot import the tables etc into a new database...

Be careful using the Switchboard manager especially if you expect to have more than 8 buttons on a page (think its 8). The switchboard manager restricts you to that and you then loose a forward button and a back button on the sub menus. I have found from bitter experience that it is better to...

Yes I had tried to package it and install on another machine without Access loaded ( using runtime ) and got the error message. I also note your step re Package and Sign - is that an essential or optional step. and where does it come in the process. Thanks for your help with this and I hope...

Yes many thanks CJ - Ready is a relative term - ready to test and do my best to ensure that everything works the way it should. Regarding the ACCDE I have tried this and got the error message " Database cannot be opened because the VBa cannot be read". Hence the post and the query about am I...

I am trying to package and distribute an Access Database which is 2007 format but I am using Access 2010. The package does not have an autoexec macro but the display form is set. I have unsuccessfully spent the weekend trawling the web and this site to try to find the correct steps. The...

I have developed an Access application with Access 2010 on a 64 bit machine and I have look through the registry and it would appear that my office is 64bit. I have gone through all the steps in the Package and distribute- downloaded the Access 2010 runtime and the runtime file works on one...

Found the solution below - it seems to have been written with Excel in mind but it works perfectly in Access. The only problem seems to be that any attachments must be from outside the database. My apologies to the person that posted the code - I accidently closed the forum and lost the...

Access emails without outlook warning - solved Hi - I am developing an application which is going to be packaged into a run version in Access 2010 / 2013 and I need to send emails containing invoices to a lot of clients. How can I send the emails without the security warning or alternatively...

I have developed an Access 2010 desktop database for a client which is currently held on dropbox and we want to split the database fe / Be and increase the user base - max 8 users . Spent a lot of time reviewing youtube / this site and others and am now getting very confused. Question - If...

I am really not sure if this can be done but hopefully someone will point me in the right direction if it can. I have a contacts database for an accountant with hyperlinks to numerous documents all set up and they work correctly - open the application and show document. What I would really...

I have read Pat Hartmans very helpful ideas in relation to databases and Access 2013 with remote access. " Publishing Access database on web. How and which way is best" - posted by Shutzy 9/9/2013. My question is a bit different hence the new thread. I have a couple of quite complex...

Has anyone had any experience with moving data from Access into Sage - I am not even sure if it is possible. High level overview of what I am trying to do is I have a package which prepares customer invoices which is one segment of a customers business. The customer uses sage and would like...

Hi folks - thanks for reading - I am developing a database that I want to distribute to a number of customers and they will want multi user and web access to the database and will need formated reports out. I have been reading literally hundreds of web sites to try to find the best answer and...

Hi I have a text box on a report that has a series of text fields joined together. I want the field to be calibri ( my Access default is garamond which I prefer but my client prefers calibri) I have changed the field from Garamond to calibri using the format in design view - I revert to...

Hi Why not try in a new field in design mode on your query open the builder Then select [field 1]&", "& [field2] This would give a field on your query 12345, 1000 56789 2000 23456 3000 You can then do a cross tab query on the result to get one long line You will need to play around...

Hi folks looking for some help with PDF attachments /uploads I have always tried to link to attachment documentation rather than importing it and am fairly comfortable with that approach primarily to avoid database bloating. However I have now been asked for a database ( Access 2010) that...

What a fantastic piece of code worked absolutely perfectly first time in my Access 2010 database .

You might have previously seen my question about using Dropbox which is a defiunite non runner but has anyone had experience using GotomyPC for a user to access their desktop remotely. http://www.gotomypc.co.uk/remote_access/remote_access The website would seem to suggest it is exactly as per...

Yes thanks in advance for help - really quite a simple application System will have 6 users 2 office based other mobile with internet connection. Front end Was planning to provide application on a runtime version - one copy for each user. Had originally thought of hosting these on Dropbox...