Search results

Hi, I have an access database that only I use. However, I'm always a little worried that I'll accidentally mess up the data in one of the tables, even though I back it up often. I use Access 2007 by the way. Therefore, is there a setting that allows me to add new records to the tables, but...

Hi, I have a database set up for one company at the moment. I would like to add another company to this database, as both companies share the same customers and suppliers, more or less. However, to make it look cleaner, is there a way to set it up, so that the left pane (the one showing all the...

Hi, I have a form which is working great, which I'm very happy with. I'm attached a sample database in case it helps to put my question in context. Basically, I posted for help regarding my main form, and arnelgp suggested adding a subform below, showing the summary. I'd like to incorporate...

Hi, I have what I hope is a simple question, if I can work out how to phrase it! Basically, I have a table, and two of the fields are foreign keys. What I'd like to do is to create a form, so that I can easily add data to this table. However, in the form I would like to see a drop down list for...

Hi, I have attached a sample of my database that'll hopefully make my question clearer. Basically, I have a report that's linked to a query. Before I open my report, I firstly have to manually filter the query based on a specific job number (otherwise the report would be meaningless). Also...

Hi, I have a report, which is linked to data in a query. The query is a list of invoices, and the first field is the unique invoice number. If I filter the query by invoice number, and save it, when I open the report, it shows just that one invoice, so I am able to save it as a PDF manually...

Hi, My aim is to reference an Access table from Excel. I found a Youtube clip that has code to achieve this, however, I get an error when I execute a line. I've posted what I have so far (see below). It's the very last line (Connection.Open ConnectionString = Connect) that causes the error...

Hi, I'm quite new to Microsoft Access, and have a couple of tasks I'm trying to complete, which I'm hoping someone can give me some advice, so I can get started please? Firstly, I have been using Excel as a database. I created a form to create a new entry to this database, and when I submit...