Search results

Thanks lightwave, I have done basic queries and I can do basic Button commands ie open a form/table etc, but I am unsure how to export the data if it is 6 months or older.

How would I go about creating the query though, I am very new to all this, I need to be a ble to have a button that would know what 6 months + date was and auto export to a saved Excel Workbook called "DTDs Exported Excel Data Archive". Can you help me I assume I would use the code below as...

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

Your all talking gobledygook to me, I am very new to this, I have a subform linked to another form, I have changed the numeric field to text but i am getting this error and it will not allow me to open the form. Shazz

I have tried that but when i try and open the form it come up with "Data Typr Mismatch in Criteria Expression" Any suggestions? Shazz

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

Can anyone help me please, i have tried everything and It will not work. I would like to link to all my sheets in the attached workbook and then hide all except Employee data, then when you click on a link or button it goes to the relevent page. At the moment when I hide the sheets the links...

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

Sorry yes they are, basically I have 300 hundread people that letters are being sent to and i want to mass fill the date sent field for those 300 records. Thanks Shazz

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

Does anyone have any ideas how to do this please?? Shazz

Thanks, this is now working a treat, thanks for you patience we me as I am a Newbie to all this. Shazz x

Thanks for that, but this shows all money outstanding, I do just want anything over 7 days to be highlighted?? Sorry to be a pain. Shazz

Ok, How do I do that Then?? Shazz

Hiya, anywhere on the Form really, maybe under the Needs Urgent Attention field?? Shazz

Hi, I have done this but the database keeps flashing up an error saying Cant find the object "me". Shazz

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