Search results

Hi Guys, I have a database with nearly 50,000 records in including sub forms that are connected to the main form, what I want to be able to do is, have a button on my switchboard that when clicked with export any records over 6 months into an Excel Spread Sheet. Is this possible at all and if...

Hi, Can anyone help me at all, I have an access database with a Table that contains The first 4 digits of a UK postcode, Town & County it relates to. I would like to be able to type a postcode in a form and have the Town and County auto fill with the info on the table. Does anyone know how...

Hi All, Can anyone tell me if and how you can use an Excel Spreadsheet with loads of Towns,Counties and The first 4 didgits of all postcode to lookup info in a Access Form. Basically I have a spreadsheet with the data in, I want to be able to Type a Full postcode in a Field and have the Town...

Hi, Can anyone help me I have a database that has a lot of data in it, I have one field which is set to numeric and obviously only has numbers in it, I need to change it to text so that I can start adding Letters to the field, I have absorlutely no idea what I need to do. Can anyone pleeeese...

I have a Query that I type a start date and an end Date and all records come up within that date range, I now want to mass fill 1 field within all of these records with a date, I know you can not copy the date and paste into all the field like you can in excel, I have been advised to do an...

Can anyone help me, is there a way to copy a date from one field and paste it into a load more beneth it. In other words I have a date field and I want to paste todays date into 300 beneth the first line, can this be done. At the moment if I copy two dates, it will only paste another two date...

Hi, Can anyone help me, I want to use Conditional Formatting to flash up the Words "Payment Overdue" or "Paid" depending on what the Balance Outstanding field reads, ie £00.00 or £1.50 or more. Basically I have a Database that after 7 days a Payment become due and I would like to be able to...

Start at First Field in Subform Can anyone help me, I have a form that has a subform within it, when I first open the form and tab to the Subform it always starts at the first Field, but after adding 1 record the next time I tab to the Subform it always starts at the field that I ended on in...

Hi Everyone, I wonder if you can help, I have a very basic database as I am fairly new to this, I need to know if it is possible and how to Select a Compnay name and in another box the Full address, Tel No, Mobile No and Contact name comes up automatically. Is this possible, if so could...

Hi Guys, I have a Holiday Database that keeps a record of Holidays, sickness and appointments, it work perfect except the year always runs Jan to Dec, I would like to be able to choose how each years fruns for each person. For example March 2009 - April 2010 or June 2009 - May 2010 I have...

Hi can anyone tell me how I do a query that will bring up a box that I type a word into and it will then find any records with that word, I know how to do a Start anbd End Date one but not sure about this. Can anyone help? Shazz

Can anyone advise, I have created a Database with Users, permissions and logins by using the Users and permissions button then using User Level Security Wizard, it all works fine but, It create a shortcut of the Database with I can use, but the original will not allow me to open it, it get the...

Can anyone help me, I have a database where I have a DATE RECEIVED field and a DATE REPLIED Field, I want to put in a field that shows how many days it has taken to reply, is this at all possible - if so could someone tell me. The other thing is is there a way that a form can flash up of all...

Can anyone help me, I want to be able to set permission so That only myself and one other person can access add data to my database, everyone else can have read only access, can anyone tell me how I go about this? Thanks in adavance of your kindness. Shazz

Hi, I wonder if you can help me, i wont to put a Button on my switchboard that will link direct to files on my computer, can you tell is this possible and if do how? Thnaks Shazz :)

Hi everyone, I would like to put a Pop up Box in my database that pops up with a message on a certain date, can anyone help me with this? Happy New Year to you all. Shazz

Can anyone help me, I have created a database to record Holidays taken, when I came back from the Christmas Holiday, I went into the database and all the dates I had entered in have gone, when I try and reinput some of the dates they just disappear. Can anyone help at all, I am not sure if it...

Does anyone know how to minimse a form in Access 2007 so that the form opens up to the size of the data on it?? I know how to do it in 2000 -2003 but it is not the same in 2007. Shazz

Can anyone help, I have a form with two subforms in it, one is showing up when printing the other is not. The properties of both are exactly the same and they are both set to show Always. Can anyone help at all. Shazz

I wonder if anyone can help, I have a dateabase which I want to be able to calculate the age from the Date of Birth field, can anyone help me, please keep it simple as I have no knowlegdge of this kind of thing in Access. Thanks Shazz