Search results

That would certainly explain why records are lost. So my thought that there should be no difference between a FE/ back end link on the server and a drop box is incorrect. Back to drawing board to think of some storage approach that will allow me to get remote access. Many thanks

Thanks for this - as above going to try the individual loading on the various C drives with the BE on the dropbox The database can find the back ends OK and is linked ok just for some reason does not save all the records. You thoughtts are as per mine the location should not technically...

Hi Pat - thanks for your comprehensive response. You opened my eyes with point 1 - I thought in my naivity that if I used access to split the database that the code forms etc was protected and that only the datatables could be accessed. Point 2 I was aware of and what I was trying to do...

Has anyone any experience using Dropbox to host a split database. Ulimately I would like to create a run version for users with the back end held in a drop box directory. As an unsplit database everything is working fine on dropbox records are saved in a timely manner and great. Once I split...

Hi Old Soft boss - I have tried to convert this utility to access 2007 and it saves the file as below - putting the date and time in the middle of accdb so system doesn't recognise access file. Can you give me any guidance on the change to get this sorted SJO Contacts...

Thanks for this - yes it is access 2007 I hope to try to use this info over the next few days.

I have found a package from peterssoftware www.peterssoftware.com/ka.htm - Keyedaccess to support the licensing and control of packaged databases. Has anyone had any experience with this package. Thanks Humph

I need to create a runtime version of an application and am very new to this. I have read a lot of articles on this forum re doing it but am still a bit stuck even down to getting through screen 1 in the package wizard. Can anyone refer me to a location or reference book or guidance notes...

Hi I have a tabbed form and one tab sub form shows total costs however another tab subform gives the option to add an activity and thereby increase the total cost. I have everything referenced correctly annd totals work out when i close and reopen the master form. what I need is a button on...

Hope someone can help with this - firstly I have very basic VBA knowledge so sorriy if it is easy to those who know. Cant find any other thread on the default date but sorry if already on there. I have a couple of calendar files in my database and I would like the form to reset the calendar to...

Exactly - once again many thanks - this is a fantastic resource One very happy chappie Humph

Hi I am trying to develop an application and would like to hide the access blue line and menu - behind a form or any other way that anyone suggests. Was planning to hide a close form button to allow me to get to the database window. Got rid of formatting menus etc but then stuck...

Hi The echo options works - apparently can't hide the printing flash. Thanks again

When I enter the text box on a form set to add new data the currency £0.00 comes up as soon as I enter data but the numbers entered go to left of £sign eg 23£0.00 and need less to say data not appropriate for field. Assume need setting - really need it to stay as new data to avoid previous...

Had a quick look and found the setting but now seems to want to print the macro definition. Appreciate the speed of response and will look at this again tomorrow in case I have done something silly. . Thanks David

Hi Paul It is an auction database and using the macro I am running some update queries and then printing two different forms and then reseting various indicators. Query updates the invoice number and date to one table, adds other data input immediaitely prior to the macro to another and then...

Hi folks I have a macro that opens and closes a number of forms and then prints. The screen shows what is happening very quickly and annoyingly. Can I hide the actions and possibly show the timer. Thanks again

Thanks for this It is version 2000 - I have reset the auto name correct as suggested so hopefully that will be it. First view seems to be ok but it was quite random when it happened. As usual a fantastic source of info Thanks :D

Hi - Margins and layout do not remain constant when database closed and re-opened - reverts to 24 mm and when reset to 14 mm when database closed and reopend it reverts to 14.99. I did not set layourt before I designed the report which probably would have avoided the issues. Am I missing...

Hi - got this all to work great but I have a question in that I want to turn my access database into an MDE file with no mouse on a number of forms. Is there any way the mousehook dll file can be included - my initial thoughtrs are unlikely but people on these forums have come up with the...