Search results

Hi all, I have an Access database for customer orders. We would like to output something to Microsoft MapPoint to plan routes for delivery drivers. Currently I have a form where the database user selects orders to load onto a van, then presses a command button. It outputs to a report for the...

Any ideas on this? :(

Hi all, sorry I didn't know which forum this fitted into so hope this is ok? Could you please help me to work out whats going on here? I have had a database in use for about 7 years and the table relationships have always been fine. I am trying to move the database to sharepoint. To that end I...

Any idea's on this? I was wondering if it might be something to do with my relationships? I'm a little confused about those. The database was split a year or so ago and after splitting the back end had relationships and the frontend also had relationships? I have found that I can create a...

Hi all, I have just finished moving a small company database to Office365/Sharepoint and was pleased I accomplished it Updated the backend to make it web compatible, linked the front end to sharepoint lists etc. I was getting ready to hand it over for use and have found a couple of 'major'...

Yes I don't know SQL Server :( I could potentially learn it but the company is looking for something to put in place quickly. I came across this interesting article. Does it mean I can use sharepoint and keep my existing frontend with all its VBA? I can't really get my head around how...

Hi all, sorry I know this question has been asked/answered before but I couldn't find an answer for what I was looking for. I work with a small company and have created and administered an Access database for them over the last few years. Now they wish to allow users access to it over the...

Brilliant, thank you Chris! You're a star :D and thanks for the little lesson :D

Hi all, I know this can be tricky from searching myself but I couldn't find an answer... I have code for multiple instances of a form from Allen Browne http://allenbrowne.com/ser-35.html It works fine, I just have a problem with closing the forms. The form I use the code on has two buttons to...

Chris, brilliant! I didn't think this would make a difference at first but I tested it and it does!! :D Strange how the multiple instances can all open in modal and not affect each other but it does going from not visible to visible! Oh well, I can live with having them not modal :rolleyes...

Nothing? :(

Any idea's? :(

Hi all, I have a form where users select multiple records to print using a check box, then click on a command button to open the report in print preview. This then requeries the form and removes the selected records (because they have been printed). When testing I found that if a user selects...

Hi all, I have recently added code to allow a pop up alarm form (frmPopUpAlarm) to have multiple instances so more than one alarm can open at once. With some help from this wonderful forum I got it working here :D However I now have strange behavior with one of the forms buttons to hide the...

Ok I moved the Me![cbAlarmViewed] = -1 to the command buttons which close the form (one to open another form, one to ignore the alarm) and it all seems to be working fine at the moment :) fingers crossed!

Hi Chris thanks for the reply. I tried both code suggestions you gave, and have found the following... If I try the first bit of code and just try the varCommentNumber as a simple number with the Call OpenAnAlarm() code, I get the same error as before... the form opens at the first record and a...

Hi Paul, thanks for the reply. The function is below... Option Compare Database Option Explicit Public clnPopUpAlarm As New Collection 'Instances of frmPopUpAlarm Function OpenAnAlarm() 'Purpose: Open an independent instance of form frmPopUpAlarm Dim frm As Form 'Open a...

Hi all, I have been implementing code to allow me to have multiple instances of a 'pop up alarm' form from Allen Browne. I have added and altered all the code, I just need a little help with the last bit. My startup form timer had code to open the alarm form at the correct alarm using the...

Brilliant! Works perfectly Bob! Thankyou both for your help! :)

Can anyone help with this? Thanks