Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 57
Search took 0.03 seconds.
Search: Posts Made By: david.brent
Forum: Modules & VBA 05-17-2007, 05:42 AM
Replies: 0
Views: 4,433
Posted By david.brent
Embed Image in a VBA created email.

Hi all,
Very long time no post. I'm working in a non-IT post at the moment but someone has asked me to do them a favour!

OK I know I shouldn't strictly embed images in HTML emails but that is...
Forum: Modules & VBA 09-14-2006, 07:35 AM
Replies: 5
Views: 3,301
Posted By david.brent
You could check if any of the dates in the range...

You could check if any of the dates in the range are a Saturday or Sunday. I would use 'format' to check what day it was. Something like...



Something like this will work but I'm sure there are...
Forum: The Watercooler 09-13-2006, 01:58 AM
Replies: 38
Views: 2,237
Posted By david.brent
That girl can't be from Essex (got family in...

That girl can't be from Essex (got family in Church Langley, Harlow).

Where are the white high heels, the Burberry cap and the double buggy covered in cigarette ash.:D
Forum: The Watercooler 09-13-2006, 01:16 AM
Replies: 38
Views: 2,237
Posted By david.brent
I work in an atmosphere similar to what you...

I work in an atmosphere similar to what you describe. IT in our organisation is largely male dominated. I would expect the average age is mid 40s. The first time I saw this happen I was amazed. They...
Forum: Modules & VBA 09-12-2006, 07:42 AM
Replies: 6
Views: 1,860
Posted By david.brent
Do you need to put the records into a temporary...

Do you need to put the records into a temporary array .GetRows. Can't you just work with the recordset?

Your SQL statement could take a while



as I'm not sure it be taking advantage of any...
Forum: ASP and ASP.NET 08-17-2006, 01:54 AM
Replies: 12
Views: 1,834
Posted By david.brent
Kodo, Adeptus - Thanks guys. I find your last...

Kodo, Adeptus - Thanks guys.
I find your last posts particularly valuable.

My company is a bit slow on the uptake when it comes to development. We have a web development team for in-house...
Forum: ASP and ASP.NET 08-16-2006, 01:23 AM
Replies: 12
Views: 1,834
Posted By david.brent
Cheers Kodo, I agree a string is just a...

Cheers Kodo,

I agree a string is just a string the url to the asp is something like this

...search.asp?mr=smith+1&am=1000

when I request.querystring(mr) the value I get is 'smith 1'
when I...
Forum: ASP and ASP.NET 08-10-2006, 10:51 PM
Replies: 12
Views: 1,834
Posted By david.brent
Adeptus, Thanks for the reply. It gave me an...

Adeptus,
Thanks for the reply. It gave me an idea to write a URLEncode type function in Javascript. I iterate through the reference and check each character to see if it's none alpha numeric (using...
Forum: The Watercooler 08-06-2006, 11:18 PM
Replies: 2,923
Views: 571,440
Posted By david.brent
There are two statues in a park, one of a nude...

There are two statues in a park, one of a nude man and one of a nude woman.
They had been facing each other across a pathway for a hundred years, when one day an angel comes down from the sky and,...
Forum: ASP and ASP.NET 08-06-2006, 10:54 PM
Replies: 12
Views: 1,834
Posted By david.brent
Cheers Keith, For concatenation in Access, I...

Cheers Keith,
For concatenation in Access, I always use '&'.

This issue is about getting the information from the input page (HTML) to the ASP. If the reference being searched for contains a '+',...
Forum: ASP and ASP.NET 08-03-2006, 06:35 AM
Replies: 12
Views: 1,834
Posted By david.brent
Help with + and &

Hello everyone,

How do you all deal with + and & when sending info to an ASP?

Some of our Reference fields contain + and/or &

When the user enters a ref containing + eg SMITH+1, SMITH 1 is...
Forum: ASP and ASP.NET 08-02-2006, 08:16 AM
Replies: 4
Views: 3,753
Posted By david.brent
When you say ASP, do you mean VBScript? If so...

When you say ASP, do you mean VBScript? If so it's quite simple...

Replace(string, char(s) to replace, char(s) to replace them with)

Hope this helps.
Forum: Modules & VBA 07-17-2006, 01:08 AM
Replies: 4
Views: 821
Posted By david.brent
Thanks again Workmad3. He's back in work and...

Thanks again Workmad3.

He's back in work and no-ones the wiser. He's decided to leave the database as I recreated it. This makes life easier for everyone. He's going to do a back-up every week....
Forum: Modules & VBA 07-12-2006, 10:47 PM
Replies: 4
Views: 821
Posted By david.brent
Thanks for the reply workmad3. I was afraid...

Thanks for the reply workmad3.

I was afraid that the records were gone for good.

The database in question was something I set up many years ago to store Management Information. I wrote a...
Forum: Modules & VBA 07-12-2006, 06:26 AM
Replies: 4
Views: 821
Posted By david.brent
Recover deleted records?

Long time no post.

The guy who took over from me has been a bit silly. He was in a 'test' database and deleted some records from a 'test' table.

Problem is, he was in a live database. Instead...
Forum: Modules & VBA 04-07-2006, 04:03 AM
Replies: 2
Views: 722
Posted By david.brent
I'm not entirely sure about the exact problem but...

I'm not entirely sure about the exact problem but it looks like you have to pass a date into the function.



So I would say when you're setting the control source of the text box instead of

...
Forum: The Watercooler 04-03-2006, 08:24 AM
Replies: 2,923
Views: 571,440
Posted By david.brent
Four friends, who hadn't seen each other in 30...

Four friends, who hadn't seen each other in 30 years, reunited at a party. After several drinks, one of the men had to use the toilet. Those who remained talked about their sons.

The first...
Forum: Modules & VBA 03-20-2006, 06:59 AM
Replies: 12
Views: 1,445
Posted By david.brent
Could it be your mouse? Does right clicking in...

Could it be your mouse? Does right clicking in another application work?

Sorry I know they are dumb questions but you never know.

Take care
Forum: Modules & VBA 01-25-2006, 05:13 AM
Replies: 2
Views: 3,532
Posted By david.brent
Hello, modDate= FileDateTime(Your Filename...

Hello,

modDate= FileDateTime(Your Filename inc path)

This should do the trick.

Take care.
Forum: ASP and ASP.NET 01-23-2006, 09:11 AM
Replies: 2
Views: 1,997
Posted By david.brent
Sorted now thanks

I've sorted this out now. The last column in my html table is a hyperlink to another page. It has details of the references input by the user. This hyperlink was terminating at the single quote. As...
Forum: ASP and ASP.NET 01-20-2006, 08:40 AM
Replies: 2
Views: 1,997
Posted By david.brent
Damned Single Quote and SQL Server 2000

I know the single quote issue is well documented throughout t'internet but I can't find reference to my particular problem. I have also read up on SQL injection.

I have my data and stored...
Forum: Modules & VBA 01-20-2006, 02:29 AM
Replies: 4
Views: 9,182
Posted By david.brent
When I was doing this sort of thing, I used to...

When I was doing this sort of thing, I used to use this to make sure all was well with Outlook.



' Declare module level variables
Dim mOutlookApp As Outlook.Application
Dim mNameSpace As...
Forum: Modules & VBA 01-20-2006, 02:14 AM
Replies: 18
Views: 2,912
Posted By david.brent
After xlApp.Quit type Set xlApp = nothing. ...

After xlApp.Quit type

Set xlApp = nothing.

That should do the trick.

Take care.
Forum: Modules & VBA 01-18-2006, 08:42 AM
Replies: 3
Views: 23,886
Posted By david.brent
I think I've used somthing like this in the past...

I think I've used somthing like this in the past but I'm not sure.

Set accDB = CreateObject("Access.Application")
accDB.OpenCurrentDatabase("Database Name")
accDB.DoCmd.OpenModule...
Forum: Modules & VBA 01-18-2006, 08:15 AM
Replies: 3
Views: 23,886
Posted By david.brent
Just to make sure do you just need to establish a...

Just to make sure do you just need to establish a connection or extract some data?

I normally do something like this.

sqlString = Some SQL
conn_String="Provider=Microsoft.Jet.OLEDB.4.0; Data...
Showing results 1 to 25 of 57

 
Forum Jump



All times are GMT -8. The time now is 06:14 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World