Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS & have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for

Sponsored Links:

Related Messages:
Google Maps W/ Access
The table I created keeps track of several addresses and I use a report to print them into a booklet. I'd like to include a small map in the printed booklet for each group or one map showing all the addresses in the booklet but I am not sure if there is a simple way for Access and Google Maps to communicate. Anyone have experience in this area? Thanks in advance.

View Replies !   View Related
Google Search
Hi, Im trying to make a google like search query on my database so a user can type in one word and then the database will search for all the records which contain this word and display them.

Any ideas?? I only want it to search through the one table,

Im no expert on VB so if someone could translate it into basic english that would be good.


View Replies !   View Related
Using Google To Search The Forum
Did you know that you can use Google to search the Access Forum and get a more refined result?

I find that the search facility provided is excellent at searching for single words. However it does not provide the sophistication of tools like Google for searching for exact phrases.

To get this sophistication do this:

Open Googles advanced page: (

The first section of this page is shaded blue, and contains the following items:

with all of the words
with the exact phrase
with at least one of the words
without the words

You can add words to varying degrees of sophistication for your search.

This is the important bit!
Just below this blue shaded area there is another section, go to the fifth item down in this section which is:"Domain" also make sure "Only" is selected. In the next text box (to the right of Only) place the domain you want to search in, this case you want to search the Access Forum so place in this box the following:

Now give it a try! Try searching for: "Date Selection" (without the Quotes)

If you search for this with the above Google method, you will get 90 results, If you search this result with the Forum search then you will get over 300 results.

Your search will only return items within the access-programmers site, and only items that are allowed to be indexed by Google.

Cheers Tony...

View Replies !   View Related
Sub Query Unsure And Google Failed Me
i have been running a query


[Select * from tblStudents]

Now this is part of an ASP system which logs when the students log in

[SELECT * FROM tblStudenttracker ]

now I dont update the student record regarding when they log, I track when the logins occur so I have a login history.

But I have now been asked to track the last logged in date

so I figure

[SELECT fldStudentID, fname, lName, [SELECT TOP 1 [tblStudentTracker]![fldDateStamp] FROM tblStudenttracker where [tblStudentTracker]![fldStudentID] = [tblStudents]![fldStudentID] ] FROM tblStudents]

apparently access says this is incorrect :(
and complains about the FROM in the SUB query

View Replies !   View Related
Icon As DEFAULT, When Embedding PDF's
In an attempt to keep the aged and wise users of the DB from overlooking the "display as Icon" cbo when embedding PDF's, and thus finding them unaware of attached documents, I'm searching for a way to select this by default to eliminate the problem altogether.(leban's didn't seem to say anything helpful on the matter)

Any ideas, virtual-mentors?

View Replies !   View Related
Embedding Loads Of Photos
I am wondering if it is possible to embed all of the photos that I have into my photo table automatically. I have the table set up with all of the data that needs to be there but I have over 1500 photos that need to be embedded and wanted to save myself some time and automate the process somehow. I already know that embedding these photos is going to make my database huge but that isn't an issue for this particular project.

As far as I can tell from this forum, the help and the Northwind database this isn't possible without manually going through every photo but I am pretty new to Access so thought I would throw the question out there.


View Replies !   View Related
Embedding A Report In A Form
Is there any way to embed a report in a form?

What I want to do is something similar to using a subform, but I want to use a subreport as part of a region of a form (linked by the master/child fields).

The reason for this is because it is impossible to draw lines on a form. I MUST be able to do so (I've been through all the API stuff and after 3 hours, I realize it's just not an option). I can easily get a report to look the way I want it, and I want to display the section that has lines in the report.

Yes, I realize that it's read-only; there will be another interface for getting the data in. I just want to display it graphically with connecting lines.



View Replies !   View Related
Embedding Single Page From Report In An Email

From advice I have read on here I have worked out how to create a button on a form which opens a report to show the values which match the record open on the form. It then attaches that page as a txt file to an email. Which is great.

What I would like it to do though is insert into the body text of the email the text from the report. Have looked as much as I can at the properties of DoCmd.SendObject acSendReport but cannot achieve this myself.

What I have is pretty much this:
Code:DoCmd.SendObject acSendReport, "Your matching details this week", acFormatTXT, Me!PersonEmail, , , "Details this week " & Date, "Please see the attached text file for details this week which match your selection criteria.", False

How can I make the text appear within the email body?

View Replies !   View Related
Embedding .swf Files Into Asp Pages Using An ACCESS Database.
Hi Guys, I'm trying to work out how to go about this. I maintain a website built for a client built with asp and it is updated using an access database and an access CMS. I have already got include files in all pages that are updated via the CMS these are used to place banner ads and smaller ads in the left-hand column of the site. It accept .jpgs and .gif files. Which are just placed in a folder by the client and uploaded into the appropriate positions using the CMS. What would I have to do to the code so that I could use the CMS to also embed .swf files into these .asp files as well.
I'm assuming it would be some sort of if else statement that if the the file was a .swf file then extra code would have to be included instead of the <img src> code that is witten to display jpgs and gifs but I haven't got a clue how to go about it. Could you please help or point me in the right direction if you know of any articles that might help me. Let me know if you need more info. Thanks in advance.

View Replies !   View Related

Copyright 2005-08, All rights reserved