Search results

So now I have 500 or so customers and I want to send them all and email (I have all their email addresses in the table). can I get them all into the TO field an Outlook message? I have Office 2010 on Win XP Pro SP3 Thanks Dave PS I have checked some previous answers and on other boards but...

Hi, I have Office 2010 working on XP Pro SP3. This is the first time I have tried to append/import a bunch of names and addresses from a spreadsheet into my access table. I thought it would be easy with all the integration of applications but it's not. What happened to the bit where I could...

Hi I had a normal select query that when I ran it offered up two Message Boxxes for the user to enter the start and end date from which the records would be selected. I lost it!!! Bu99er! Can anyone help me recreate it - I can't remember whether there were two new fields in the query (...

What are the little plus signs you get in tables? I have never used them myself but I have just taken over another database with loads of tables that have these little plus signs placed before the first field. When you click on them they show other data. Seems a good feature but I have no idea...

Hi, I have a straight forward table with a field called DATE. I run a query on that table so that I can create a Report selecting data between 2 dates. What I want to do now is to create a new field in the query that displays the actual day of the week (Monday, Tuesday etc). I have tried...

Hi, I just got Access 2007 and split a database into a front and back end to see what it was like. Is there any way of joining them back again? Thanks David :o

Hi, I am trying to produce either a report or a form that displays records 1 to a line. That bits easy enough using a tabular layout. I would like to make text boxes that hold the data a differnt colour on each alternate line. So the background colour changes from white, then green, white ...

Hi, I am trying to produce either a report or a form that displays records 1 to a line. That bits easy enough using a tabular layout. I would like to make text boxes that hold the data a differnt colour on each alternate line. So the background colour changes from white, then green, white ...

Hi - I am trying to open a recordset, move to last record, put a value in a variable for further use. When I use the MoveLast method it doesnt work. It goes to the the 3rd record from the end and gets that value. I have tried deleting the primary key field and entering a new one but to no...

A quick search of the net shows me that new templates for boring old Access switchboard cost a few quid. Anyone know if there are any low cost or free templates out there?? I am not much of a graphic designer otherwise I would have a go myself. Thanks David

I am trying to create and edit a new record in an existing table,(Transactions). It has 3 records in. When the code below runs, it creates the new record, (Record 4), but updates Record 3 - NOT the new one. The field I want to update is called 'Balence'. Any help apopreciated. I have run this...