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

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

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

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

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

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 have a split contacts database and I would like to use hyperlinks in the email address field so that when clicked Outlook would automatically open with the contacts address added. That’s fine but one of the functions of the database is mail outs and I could not get a query to sort the snail...

I have a contacts database that uses lookup fields for some data and this seems to cause a number of problems! First: I have a lookup field that the following three options ordinary member, organisational member and associate member but all fields are not populated because there are contacts...

I am sure there is an extremely simple solution to this question. I have started a contacts database for a community organisation that I belong to. I am having trouble working out how to do a query that will return a list of contacts that don’t have email addresses so that I can create postal...

A quick intro a little old grey haired woman who plays with IT and has done so 15 years or so. I haven't done any access since the days of Access 97 so I am shaking my head just a little. I just hope I don't ask too many dumb questions. Di