Search results

Whate date fields do you have in the report? I am not sure what you mean by Access defaulting to week numbers...

Is it a table format or is it a bodu of information. Why isn't an attachment an option? You can convert your macro to a modules. If you search this forum for recordsets, you will see plenty of examples of code. If you post an export of a sample query you want to send I will see what I can do.

No set address? Not sure I understand what you mean there. You will need to do this as a module, not a macro. You need to get the data from your query, and add it to a string, then use this string as the body text of your email. How much data is there in the query, and what sort of format is it in?

I believe the "wildcard" character you need to use in SQL is "%" not "*"... http://www.w3schools.com/sql/sql_where.asp

Interesting, I didn't know you could filter like this in formulas.

Try the Environ(Username) command.

You need to add another column. In it, put =IF(B2="601",G2,"") Then at the bottom of this column (lets say its H) =COUNTIF(H2:H6000,"Claim")

You can easily make a link from a field in an XML file using XSLT. However, if you are not familiar with XLST, this might not be the easiest way.

Use Firefox ;-)

Don't have a DVD recorder, so I couldn't tell you. If this is more useful as a device to you than the TV Tuner/Capture card, then I guess it would be a better solution for you. Is this Novatech US or UK? The card here would do what you wanted...

Wow, thats some old software. Have you verified that Outlook Express is working? I have no idea about mailing on Windows 3.1 its a long time since I have used that. If price is a consideration, have you considered using free software on your PCs???

Tea tray riding is my favourite. Got to be damn brave/crazy to do that one.

Unless you have actually recorded the changes somewhere, you cannot simply query for all changes.

Yeah I did have some problems accessing it from work intermittently, but someone in the IT department must of got a gmail address I think ;-) Incidentally Ken, if you did get one set up and can't access it through your browser at work, you could check your gmail via POP3 if you can set this up.

FYI; Gmail is google's free online email service, similar to hotmail, only superior IMHO. You can only get a gmail account by getting an "invite" from an existing gmail account holder. Not a problem, as you get 100 and they seem to be topped up periodically. For more info, see here...

Not sure what you are trying to do, but you could try a "Select Case" rather than If's. Also, can you specify the dblAcc by looking for all the values in the table and offering them in a query to speed things up?

I tried to have a bit of a play with the Linux version of this in Beta; I was going to try and attach it to my MythTV MySQL database, but the ODBC linking wasn't too happy. I don't really like scalc, Gnumeric is a much nice OSS solution IMHO for what I need at home. From the blurb, Base has its...

Have you tried "Compact and Repair"???

Ah I see. When you said "file", I didn't realise you meant something which wasn't produced by Access. Yes its still possible. I have some VBA which will attach a file (or files) I have exported from Access (an .RTF version of a report), however this is for GroupWise, not OE, so I doubt it would...

You can do all this with formulas and filtering. Why do you need code to do it?