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

Thanks Coach works fine. I have been doing backups regularly using the free version of Syncback. I think a setting must have been incorrect as I don't seem to have the latest copies of things. My database was one, .pst file another. I will check that they are working next time instead of just...

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

Where do I put this code Bob? Thanks for your reply but where do I put this - in the table design or in the query? Cheers Dave

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

Charts I suppose you have thought of embedding Excel in a form? Theres loads of stuff on that. Otherwise I have no idea. Sorry.

Alternate colour - thank you all Thanks very much for all the help - brilliant. I got loads to go on now. Sorry about the duplicate thread.

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

Get this nonsense OFF here. Its a forum not a recruitment page.

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

Got it Thanks very much, works great now. I appreciate you taking the time to answer. David

Try this Hi I use this code to write data from an unbound form to a table. You will need to declare the recordset and database variables first. Cheers David MyRS.AddNew MyRS![Balence] = MyBal MyRS![Credit] = [Forms]![FrmTransaction]![Credit] MyRS![Debit] =...

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

Right.... Well if the code builder window is open when it stops, that suggests it's trying to debug. Look carefully at your error trapping code and thoroughly debug it. Task manager will also tell you if whether the program is responding or not. You could also create an empty database on...

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

It works Thank you very much for your advice. I am a beginner and it is my aim to write good fast code, but we all gotta start somewhere. Thanks again. David