Search results

I designed a database in Access 2007 which is used by separate offices across our organisation. It has a main table, with a related sub-table in a one-to-many relationship. Recently, a user in another office decided to split the database because they were having difficulties using it...

Hi I´ve created a tabbed form in a database. When I drag fields into one of the tabs, the fields are duplicating across the others. When I then try to edit/delete the fields from one tab, they are also deleted in the others. I can´t for the life of me see why they are linked. Please help! Thanks

Hi I've tried to create a simple query pulling together a simple count of three separate fields from two different tables. All fields are date fields, which have criteria for the choosing records from the previous month. However, when I run it I get an error message saying that the selection...

Hello I have a DB with a Customer table that has a 1-to-many relationship with other tables. Each of these sub-tables are accessed through control buttons on the form of the customer table. What I want to do is change the colour of the control button when there is data in the related record...

Hello Is there any method to set a field's Required property to 'yes' depending on another field's value in the same table? I am collecting data on someone's nationality and if I select a certain nationality from a value-list then I want to set other date-fields Required property to 'yes'...

I think this is a form query but maybe it should be in the macro section. I have an query that pulls up all the records using a date criteria of on or before today's date. It works fine. I wanted to use an autoexec macro to run this query and pull up the appropriate form IF there was data in...

Hi I'm trying to put together a fax template for my database, formatted through a report. I've got two main tables, customers and incidents with a one-to-many relationship. In the incident form, the user can press the button 'Send fax' and another fax form opens, drawing info from the...

Hi I have a table called Incidents with two date fields: 'date of contact' and 'deadline date'. When date of contact is entered I want the deadline date to be automatically completed as two weeks after the date of contact. I was thinking of using an update query automatically run 'on exit'...

Hi I'm creating a new database in Access 2007 and I understand it has the facility to attach files to records. However when I follow the instructions in the help guide by creating a new field, the option of choosing 'attachment' as a file type isn't there. Can anyone help? Thanks

Hi I think I need to use a query to resolve this problem which is why I've posted here. I need to add new records to my database involving fields from three different tables. The tables are called Customers, Incidents and Outcomes. Customers has a one-to-many relationship with Incidents...

Hi I've created a form form a query that takes data from mulitple tables. After finishing the form I've realised I need to get more fields on the form. I've added these fields to the query but they don't show up in the field list and I'm not sure how to include them any other way. Can anyone...

Hi I'd appreciate some advice on how to do this without resorting to VBA. Simply, I want to output the current record displayed on a form to Excel. I thought of using SetValue to change a FLAG 'field' to 'Yes' and then using a query to pull up the record with this value set. Can't do it...

How do I write a query to export the last record from my database? I can run a query to export the whole dataset into an excel file - no problem - but we only want to export the last record in order to email it to a different office. The dataset consists of five different related tables with...

Hi We have the same database set up in three different offices - it is not shared. I want to run a macro to export and email individual records from a database in one office, and import them from the email to the database in another office. Is this possible without exporting and emailing the...

I have a form that displays the actions we take on our casework. Obviously, each set of actions is self-contained in that only those carried out on that specific case are shown within that case. However, they don't always display in order of their reference number and I'm not sure why...

Hi I have a database for our customers that contains a number of tables and respective forms. I want to redesign the database as it has a design flaw but this will involve the transfer of a large amount of data from one table to another. The first table contains all our customer's details...