Have set up an access database with automatic email. Would like to send out an e-mail with a link to an existing web page. The following syntax isn't working...any suggestions?
.HTMLBody = "<HTML><Body> Hello <a href=chr$(34)http:\\www.google.com chr$(34)>Google</a></BODY></HTML>"
I...
Would like to implement persistant-named cache on concurrent sessions in Informatica 7. The question I have is if the recache is set on one of 7 sessions in a concurrent batch will the other concurrent sessions wait for the recache to occur?
Also, if the look-up using persistant cache and...
Would like to implement persistant-named cache on concurrent sessions. The question I have is if the recache is on one of these sessions will the other concurrent sessions wait for the recache to occur?
...time picker value to a date field in access, but cannot come up with the right syntax. Would appreciate any suggestions
i.e. .Open "Select * from tblDate where EffectiveDate = # & dtpEffectiveDate.Value & #
This syntax does not retreive any records.
Also tried to set the...
...for use
With rsSalesHours
.ActiveConnection = CurrentProject.Connection
.CursorType = adOpenStatic
.Open "SELECT * FROM tblCrosstab"
End With
With rsDifference
.ActiveConnection = CurrentProject.Connection
.CursorType =...
VBSlammer
thanks for the help. When I used this code I get a 9-page report preview - but there isn't any records showing (i.e. the 9-pages are blank).
I feel really stupid, but what do you think I am doing wrong?
Did this in a project at school, but really went around the mullberry bush to get there. Probably a better way, but here goes:
We put the file path in the database and then called the path to load the picture box.
Hope this helps
I didn't realize this was in the solutions database...
Got the structure from a book.
Have several cross-tabs queries that will feed into unbound reporting structure with the above code running in the background.
The code I have listed is working for dynamic column headings - no problem...
...for use
rsSalesHours.ActiveConnection = CurrentProject.Connection
rsSalesHours.CursorType = adOpenStatic
rsSalesHours.Open "SELECT * FROM qryMonthSalesHours"
'determine number of columns in the recordsource
mintColumnCount = rsSalesHours.Fields.Count...
Trying to hard code a report based on a recordset. Problem with obtaining more than one record in the details section of the report.
I tried without a loop and with a loop. Without a loop I get the first record of the recordset - with a loop I get the last record of the recordset.
Is there...
I have recently upgraded to Windows 2000 from Windows 98SE.
With Windows 98SE I was able to set up connection sharing with two NIC cards and checking the sharing box on my local network card.
I have kept the same set-up with Windows 2000, but the Macintosh can no longer touch the internet...
I am using the following autorun.ini with a director 8.5.1 projector:
[autorun]
open=repke.exe /autorun
It is not working. This same autorun.ini was used with an 8.5 projector and it worked just fine.
Any suggestions?
"SELECT SUM(Questions)as Question, FROM qryStats WHERE OrigDate >= # " & DTPBegin.Value & " # AND OrigDate <= # " & DTPEnd.Value & " # "
You can either SUM() a field or COUNT() a field over a specific date range.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.