Search results

Hi all, I know this should be simple but I can't work it out? I have a sharepoint database accdw which works well as I can update something and sync it to the server, and another user with the same database can receive the changes just by syncing. However, I want to share a version of this...

Hi all. I have a button on a form which calls a module to show a calendar form. The user picks date and time, and saves it. The calendar form closes and adds the date and time to a text box on the initial form. At that point I want to save the record so that the underlying table/query is...

Hi all. I have the following module in my database to allow for multiple alarms. It all works great, except before showing the actual alarm record called, the form first pops up showing the first record in its record source. I.e. it flashes up showing the first record in the table, then...

Hi all, this is my code for a search form. At the moment if searched with nothing entered into the combo boxes it returns all records. Could anybody tell me how I can adapt it to require something to be entered into the combo/text boxes? Many thanks! Option Compare Database Option Explicit...

Sorry about this one, I know it's simple but I've not used Access for a while and my brain's not working :bang head: I have a blank form with a subform. All I want to do is have a combo box with the names of the subforms in, and when you choose one it is displayed in the subform box. Names of...

Hi all, could somebody please help me to construct this form? I have a few duplicate customer queries (different duplicate fields etc). I would like to construct a form to make it easy for an end user to remove the duplicates. The main problems are... 1. the newer customer is to be deleted 2...

Hi all, this one has me stumped. I have a database with customers/orders etc. I need to create a form or something which will show if a duplicate customer is entered. I know about the duplicate records query wizard, but I also need an easy way to consolidate and delete records. When a duplicate...

Hi all, simple question... I have a report with an unbound checkbox which has a null (greyed out value) when printed. I'm just trying to set it to false when the report opens. I have Private Sub Report_Open(Cancel As Integer) Me.CheckNotPaid = False End Sub but it just says 'Runtime Error...

Sorry, I didn't really know if this should be in the VBA, Reports or General forum. I have a field 'Payment Types' with values (Cash, Cheque, Debit/Credit Card) and a field 'Payment Received' which is Yes/No. When putting the order through the user selects the payment type and ticks a box if...

Sorry for the long title. I have the following code in the On Load of a report which shows multiple records:- If Me.PaymentType Like "Debit/Credit Card" Then Me.Check94 = True Else Me.Check94 = False End If This ends up checking all check boxes in the report if any have "Debit/Credit...

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...

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...

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'...

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...

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...

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...

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...

Hi all, I currently have the standard code on a command button. The form holding the command button shows customer comments and its record source has both fields - 'CustomerNumber' & 'CommentNumber'. The form which the button opens has a main form and a subform. The main form has the...

Hi all, I currently have the code below on a form. The before update code is there to prevent alarms being entered at the same times and works perfectly. Private Sub btnReschedule_Click() Call GetDate([Form]![txtCommentAlarm], 0) End Sub Private Sub btnResetComputerName_Click() If...