Recent content by Bursal

I have a form with several pages that relate a contact or organisation. I need a combo box on the header that will select a specific page, search a table or query and fill in values on the page. I am sure this a simple task but I can't find an answer. Thanks for reading my post and hope you...

I have three columns with check boxes that I need to change to No if before a date in either DateAdmitted or Date Renewed. I have included a test database rather than trying to explain. After running the Update query there should be one contact left with as a member. Thanks for reading my post...

Thanks JHB for the reply. I revisited the query with a clear head and I have it working. This was the line that I was having trouble with: WHERE (((qryMembershipCurrent.Ordinary)=False) AND ((qryMembershipCurrent.Organisational)=False) AND ((qryMembershipCurrent.Associate)=False)) OR...

I have a membership database with checkboxes for three types of membership and date columns for Date Admitted and Date Renewed. I need a query that will uncheck the checkboxes that have a date before a specified date. I can get the checkboxes unchecked but I can’t get the date part right. I...

Help with simple query to exclude records after a date I have an access 2010 contacts database with 736 entries and I need a simple query to filter out entries after 1/03/2013. The date is entered by the Date Picker and there is no Input Mask set. I am using d/mm/yyyy in the table. The query...

Thanks Rx and spikepl, I like spikepl's solution because it is simple so I will start there and see how I go. Thanks to both of you for taking the time to answer my post. Di

Thanks for the reply Rx. The workstations are on a LAN in the one location and the backend is Access 2010. I would make changes at weekends and only when there no one is in the office. The solution sounds just what I need but when it comes to code and bat files I have no idea. I don't mind...

Is there a way I can relink a split database frontend and backend remotely? My situation is I am a volunteer with a community organisation and I administer their Access 2010 database, which is a ‘work in progress’. The database is split and the backend is stored on a server running WS2013E...

I am having trouble with the subforms on the RE and Species forms. The two main forms mfrmREI_nfo and mfrmSpeciesInfo and are fine apart from formatting changes. I am having trouble designing the queries for the subforms. The forms and subforms are for data entry and searches. On...

Sorry jdraw I forgot to answer your questions in the post. The SpeciesID is in tblRE because when I started that was for a one to many relationship before I realised I needed a many to many relationship, so in reality it is not needed now I have a join table. The classes is just a way of...

Thanks Pat I will remove those fields and have a good look at your ManyToMany database and if the brain fog doesn't clear I will be back. Di

Can someone please help me with a small database with many to many relationships. See my relationship.jpg for the design so far. I have been asked to create a small database for a Landcare community group. It contains data about Regional Ecosystems (RE) and the three classes of plants...

Hope it's OK to jump on an old thread. Bob I have an Access 2010 split database. I want to do the same as Lifeseeker but I can't get your method to work. The backend is password protected, I deleted the table links in the frontend and relinked (not import) them. I had to add the password but...

Eventually I would like to have a button on a form that will automatically create a text a tab limited text file to and get Outlook to put it into a contacts folder, I say do say like because I am sure it is possible. First I want to start the Export to a text file, I will worry about the...

I would like buttons on several forms that the user can click and get customised help relating to a field or data entry. I would also like to have a customised warning message on an append query and a delete query so that when the user clicks the button that runs either query they have to click...