I have several thousand hyperlinks that need to be changed due to our network server being changed. I have tried to change the hyperlink field to a text field and do a find and replace. (See mandaman post 3/13/06) The problem that I have is that all the hyperlinked fields have a different text comment in the field to identify the hyperlink to the user. When I change the hyperlink field to text then it thinks that the text in the field is the hyperlink and in fact it has nothing to do with the actual hyperlink. Any suggestions?
I have a massive database...100,000 records (well, it seems massive to me right now!).
A part of each record is a hyperlink to a PDF document on the server. I didn't map a drive letter for the path, as everything I've researched has said to not use drive letters but the actual server name and the path.
I did that. Unfortunately, they had an issue with the server a couple of weeks ago...and in mapping it again, they added another layer of folders on the way to the location of these PDFs.
Now I have to go in and edit each individual hyperlink to reflect the new path.
1. Is there a faster way to do this? They want their first report half an hour ago.
2. They have a whole new set of these PDFs to be attached to the records that don't have them yet. Is there a faster way to do it than to have to open each record and put in the path to the document?
Given a table field that is a hyperlink type. I need an Update Query to set all records of that table so that the Displayed Value part of the hyperlink field (not the Address part) is set to a particular value. Any ideas how? Thanks.
i have thousands of data records with hyperlinks that are correct. Each data record shows the actual link (google.com, foxnews.com, espn.com, etc.). However, i want to change all of the records to just say "link" instead of saying espn.com, etc. How can i do this automatically without having to manually right click, edit, and changing the text to display?
I have a table that collects training information for our company. Some training is limited to one or two employees and that is easily entered by using a form linked to the table. However, some training is mandatory, company-wide training that all employees must attend. How can I add a record for each employee reflecting this training most efficiently? Is there a way to do a mass update?
I'm trying to update this movie database, and I need something to save me time, not to mention my finger. One field in this db tracks if a movie is colour or black/white. In the old/existing db, that was done with text - "color" and "black & white". I want to replace that with a yes/no field [Color]. But the db has a few thousand entries. What I would like to do is either change all of the [Color] fields in the new db to yes, and then manually uncheck the ones that are b/w. But I guess it should also be possible to do the whole operation automatically. Any ideas as to how to accomplish either of these would be appreciated.
I recently posted a question in the REPORTS section asking if it was possible to generate a report that contains only the email addresses of my contacts to generate and send a mass email. There were no responses to that...so that makes me ask - Is there anyway in Access to generate mass emails using only the email address field in a table or query?
I am aware of other programs you can buy to do that - but was hoping to stay within Access.
I am sending out multiple emails to my customers in my customer table manually. As it is time consuming to send to about 100-200 customers daily, I am wondering if it is possible to automate the process in access in such a way that I can load all files from a particular folder and the access application will be able to sort the files in the folder for each company based on their name in the field(e.g.CompanyABC_DailyReport,CompanyDEF_DailyR eport) before sending out.
I've been asked to come up with a way (one-off) of renaming over 100 hundred tables. The table are all called "STUD_ADMIN_blah". We need to remove the "STUD_ADMIN_" part of the table name.
Is there a nice easy way of doing this without having to physically rename each table individually?
Hello, I have been working on my database for sometime - searching this forum for answers, thanks to all the experienced people for their sharing of knowledge.
My question is this: My database will be over several years of data, on my splash screen (switchboard) I would like to have a combo box of with choices for years. When a user chooses a year, the entire database is filtered. Say if the choice was for 2005, then anything with a binderdate of 01/01/05 to 12/31/05 will be filtered.
This will need to be done across several tables, queries, forms, and reports.
Once the choice is made for that year - any form the user is on will be filtered for that specific year.
I am still fairly new at access programming, so any code snips or working examples would be greatly appreciated.
Hi, can any help : ) i am trying to mass update one field in a table. Basically i have created a new check box (Yes/No Value) in my customers table. Basically i will tick this box if a customers placed any order with our company.
At present all our existing customers have placed orders with us. and i want to add value Yes to this field.
What method can i use to make this Mass update all customers records.
I've read through many of the threads relating to sending Email from Access but can't seem to find quite what I'm looking for. I work as a Tutor Coordinator at a local college and I've set up Access to handle a lot of the day-to-day chores that our administrative assistant has to deal with.
One feature that would be absolutely wonderful would be to create and send Emails to students at the click of a button. I have several types of Email I'd like to be able to set up, but the one most needed (and probably most complex) is this:
Students come in to the office and request a tutor. If we have a tutor available, we assign them to an available tutor. If there is no tutor availabe, then every Friday we send out an Email to each individual student saying something like this:
"Dear John Doe - We currently do not have a tutor for MATH 101 at this time, but when one becomes available we will let you know... blah, blah, blah..."
I'd like to set it up so that the body of the message comes from a template - such as a text file (that is easily edited by a user) and populated with fields from a query.
Probably do something like this:
Query the Student_First_Name_field, Student_Last_Name_field, Department_Name_field, Course_Number_field, and Student_Email_field. Send an Email to each Email address pulled from the Student_Email_field and tell them the following - "Dear <first name, last name> we currently do not have a tutor for <department name, course number> at this time... blah, blah, blah..."
Currently the way the administrative assistant handles this is to send each student an Email individually - manually creating each Email with the specific data needed. As you can guess, this is quite time-consuming.
I'm rather new to Access but have been a RDMS programmer (in PICK) for several years. I know what it is I want to do, but don't know how to do it in Access.
Any help?
Would the best way be to use text files for templates?
Can text files be set up with field codes (Access recognizes "<LAST NAME>" to be Student_Master_Table.Last_Name_field)?
I'm guessing this will likely have to be a Visual Basic loop that works with data from a query.
I have a database for clients and have set up a form and code to run a query for different types of clients and to send emails to the group.
Everything works fine until I try to send and then I get a Microsoft Outlook pop-up which states:
"A program is trying to automatically send e-mail on your behalf. Do you want to allow this? If this is unexpected, it may be a virus and you should choose "No."
This message stays for 5 seconds and then I can click on "YES" and it will send the email, and start all over for the next recipient.
I am assuming this is an Outlook Spam Blocker, but is there any way to stop it?
I have 300++ Excel files that contain data in the format of column1 = textual identifier, column2 = numerical value. Each file can have up to 1300 rows. The text identifier will be 95% the same in all files with slight variations.
I want to create a database to store the numerical value of each identifier from every excel spreadsheet and average the value.
This should be ~1300 instances, each with 300++ value assigned to it. Then run a report to pull the average value of every instance/identifier.
My (many) questions as follows..
-Is Access a good way to go about this? -Is there an efficient way to bulk import from excel ( I just saw a script to do this below )? -How to set up tables/queries/relationships?
So I am building a database to track PTO. I already have a form set up with an append query but what I want to do it use a list of check boxes to create mass appends incase a large group of people leave, Holidays, etc. Instead of having to do them individually.
In my simple database (attached), I need to mass duplicate Tasks and their Notes.
I have three tables: tbTasks (PK: Task_ID), tbNotes (PK: Note_ID), jtbTaskNotes (FKs: Task_ID and Note_ID). jtbTaskNotes is my many-to-many junction table that ties Tasks to Notes.
The main form (fmTasks), bound to tbTasks, has a subform (sbfm_TaskNotes) that displays notes associated with each Task. On themain form,you select which Tasks you want duplicated via a checkbox. The append query (quCopyTasks) will duplicate all tasks that have the checkbox checked. All good there. However, I can't figure out how to also duplicate each task's Notes.
I found Allen Browne's solution [URL] ....., but that only handles duplication of one record at a time, whereas I need to duplicate many records at a time (sometimes 10+ records). How do I go about duplicating multiple Tasks and their associated Notes?
Before you ask "why are you duplicating records?": There are times when tasks need to be re-accomplished and therefore need to have a new record. It's easier to duplicate records than it is to hand-jam everything again.
I am trying to change the button color on a subform if a related form data changes.Main form is products with a continuous subform with serial numbers of products i.e, serial number, location, price and a button to add addtional issues if there are any for this particular serial number (this will open up another form related to the serial number so I can add an issues if there are any).The reason I would like the button to be a different color is so I can quickly see if there are any additional notes been added to the serial number. Just in case you may ask why not add the field to the continuos form is that the issues and be quite lengthy and there may be lots of serial numbers on the form
TxtHyperlink is bound to the hyperlink field, when the code is executed the Hyperlink field is filled with the right address. but I think the code just fill the text to display "parameter" of the hyperlink field and not the actual adddress. what should I do to get the result of the function to be saved as the Hyperlink address?
Hey guys. I am VERY new to Access, and trying to learn as fast as I can, but I have no idea how to do this.
I have a database, brand new, it will eventually be holding hundreds of docs. Anyway, we have it as a document naming machine. We insert all the data associated with our document, it stores it and gives us a name for the doc, we then save that doc as a pdf with the name given.
After this, we are going to put all the documents in one central folder on our network drive, as follows:
F:FolderAccessDocuments*.pdf
So, what I need is to create an automative hyperlink creater, that will take our document name once created, put it on the end of the "F:FolderAccessDocuments" and have the hyperlink sitting there ready to go.
One more thing, I need to be able to change my Initial Drive Directory (from "F" to "E") at any point in time, and the switch would have to go through and change every hyperlink.
If anyone can help with any part of this problem, I would appericiate it.
is it possible to have a txt field which will contain an email address and once you input teh address it becomes a hyperlink, so you can just click it and send an email from outlook?
Hello , I have ListBox and I have put in ControlSource: SELECT HorizontalniDrzaciKabela.Referenca, HorizontalniDrzaciKabela.Opis, HorizontalniDrzaciKabela.Visina, HorizontalniDrzaciKabela.Napomena FROM HorizontalniDrzaciKabela WHERE (((HorizontalniDrzaciKabela.PickFlag)=False));
Can I make column HorizontalniDrzaciKabela.Napomena as hyperlinks for each record when I open ListBox?
In design view I put Napomena as hyperlink (I have added hyperlinks) but it will not work,
I have a Hyperlink field (can be a text field if necessary) that is intended to open the document listed in the field. I have all of these documents stored on a server and I have set up another field that contains the path to the server directory. So, at the time I click on the document link, I want to concatenate the path with the document name, so I can open the file. This will enable me to not have to type the full path everytime I enter a new document name.
I tried setting up the field as a text field and I can concatenate the path and document name, but then I cannot open the file. I want to be able to pass the concatenated variable to the Windows OS and have it launch the document, regardless of the file type.
I have not done much work in later version of Access. Now I found if I change a design in one form and similar forms (names are different) which are linked to the same tables got changed as well without openning them up and making changes. Is this something new with Access 2003?
I have been searching the forums and all I could find was how to hyperlink to outside url such as www.google.com and likewise.
I am looking for some kind of code or a direction that will help me hyperlink between records in my form.. best method probably would be using an ID number.
Hello. New to this, but am creating a hyperlink in a new form. Using Edit Hyperlink, I direct the program to open a PDF format file. All seems fine, the path is relative to the main file, (although it does display %20 between all separate words, why?), but when I click on it, the warning : "No prgram is registered to open this file". This file itself is fine, and opens happily when dble clicked. The hyperlink works fine when opening a Doc file. Help as I need this working...