Search results

using vba would be the way to go for this. You could use some trickery like instr to search for the commas and mid, left, and right to build up the variables which you could display. Aren't you better off normalising though and creating a proper structure so fields like that aren't included???

Change to sql view in your query and use a union to join your 3 select queries together (using top 5 for each) http://www.fabalou.com/Access/Queries/unionquery.asp

cheers Bob. I actually found a great bit of code by one of our own members here: http://www.access-programmers.co.uk/forums/showthread.php?t=162910&highlight=html+outlook.application

Hi guys, Ive been using the outlook.application method to email results from various queries like this: .Body = "1)" & Chr(13) & Chr(13) _ & s1 & Chr(13) _ & "2)" & Chr(13) & Chr(13) _ & s2 & Chr(13) & Chr(13) _ & "3)" & Chr(13) & Chr(13) _...

Hi and welcome. Good to have you here.

Hi Brian and welcome. You'll never look back. Using excel as a database solution is a nightmare.

Hi Robbin. Welcome to the forum. vba is nice and easy to pick up the basics.

At first I thought you could combine into one select statement, but then realised you have probably got more than one instance of DatabaseID in [Interaction Table]. I find access to be very slow when combining more than one query. I usually do maketables instead and then use your 2 new temp...

Hi and welcome. Sure, you could use vba to work through a recordset of account numbers for input into your query: http://allenbrowne.com/ser-29.html Then after each result use the docmd outputto command to save each file. http://www.blueclaw-db.com/docmd_outputto_example.htm Doing it...

No probs. Any questions about it, ask away.

sure. I usually use http://www.w3schools.com/sql/default.asp and http://www.blueclaw-db.com/docmd_runsql_example.htm and I search this forum. Nearly always has my questions already solved.

Hi and welcome, Best way would probably be in vba code. You can feed your whole table/query into a recordset, grab the relevant fields including email address, and then send the emails.

Hi and Welcome Justin, basically all you need to do is execute a couple of sql queries within vba. One being an "Insert into" query and the other being a "delete" query. You can use DoCmd.RunSQL to run your sql queries in vba (there are plenty of other methods too)

Here are a couple of options: http://www.google.com/chrome http://www.mozilla-europe.org/en/firefox/

popup blocker is probably enabled. If you are using internet explorer, go to tools > pop-up blocker and either switch off completely or adjust the settings. edit: sorry just read your post properly. If it's not that, try another browser to see if the problem goes away. At least then you'll...

looks like you might be missing single quotes for the SYear string so instead of: CQuery = CQuery & "' and Year = " & SYear should be: CQuery = CQuery & "' and Year = '" & SYear & "'"

I 2nd that. Also if its a string field, enclose your sql clause in ' For example if strmonth = July then: strSQL2 = strSQL2 & "'" & strMonth & "'" ps those are ' enclosed in "

I would tend to do something like that by vba, as it would require no maintanance. With a macro you would probably do a separate SendObject for every worker, which would send out thier own table, report, excel spreadsheet, etc. But you would have to add new workers into the macro when needed...

Hi Pepper. Ive been following your thread here: http://www.accessmonster.com/Uwe/Forum.aspx/access-gettingstarted/23694/Back-end-is-broke You mention I found this, I hope it helps: http://www.access-programmers.co.uk/forums/archive/index.php/t-93725.html

Can you not access the laptop at all from the desktop??? What happens when you try to ping it? How are they connected to eachother and what operating system are they both running?