Search results

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

Thanks Pat I will try that. Di

Thanks Kipcliff, I have sorted it out. I think a couple of grey hairs got in the way! Di

I have tried creating a new database with two tables Contacts and Locality and I am having the same problem the Loocality table is the primary table and so the one to many relationship goes the wrong way.

I have a contacts database and I am trying to set the relationship between the contacts table and the locality table. The contacts table has a LocalityID field that is a long integer and the Locality table has an autonumber as the PK. When I drag the LocalityID on one table to the other...

I think most of my problems are coming from the fact the lookup fields on the table, research tells me that’s a NO NO, not on the form as combo boxes linked to queries based on the tables. So some more work and hopefully that will fix it. That link to the cascading combo boxes was a great...