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?
I have a database set with user level security (via the wizard) and I want to give "Full Data Users" the ability to enter hyperlink addresses. Currently only I can do this as I am set to "Full Permissions / Admin"
The associated table is set to accept hyperlinks, and the relevant text boxes are in place and unlocked on the forms, however when logged in as a Full Data User, you currently can not set or add a hyperlink address, only follow the hyperlink path's that i've already put in.
Is there an easy way to have Access format all values in a particular field with the hyperlink data type to add the mailto: prefix so you can just click on the links to email someone?
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?
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 been using Access for several years but always in a basic way. I have started work on an existing Members database where the Members Addresses have been pasted in from Notepad or been imported from csv or manual entry.The ones that have been manually entered are on one line. The ones that are imported from csv or pasted from Notepad are on multiple lines like you would naturally type on an envelope..In Notepad they look like this:
'Oakdale' 123 Expression Road Name of Town Name of County Postcode
Sometimes the addresses have 4 lines and sometime they also have the name of a village which makes it 5 or 6 lines. When imported into Access they also view (datasheet view) in the same way with the return at the end of each line. However, I cannot enter a new address in this manner directly into Access.How can I enter the address text into a text filed and be able to format it so that it looks like the above?
I have searched many times for an answer to this but cannot find a way of explaining it that search engines understand. I first came across this 12 years ago when I worked on a massive Members database for a radio station all the addresses where formatted in the same way and had been imported through csv. When I do this the csv file marks up the text as "'Oakdale' 123 Expression Road□Name of Town□Name of County□Postcode"
I have tried exporting to csv ad then importing it into GMAIL and this works fine I have also printed off labels and envelopes and all the addresses print fine too; I just don't know how to input it in that format other than pasting all addresses through a basic text file.
I am trying to construct a query to extract mailing addresses from a table. I have individuals entered into a table (a separate record for each person) but if they are married I want an address such as Mr and Mrs J. Doe so that only one address label is printed off so that only one letter is sent out. If one of them dies then the address should only go to the surviving party eg Mrs J.
In my 2002 Employee table, I have a field which is a hyperlink to photos: C:photosemployee1.bmp (This is what I have entered into the Field as the Hyperlink)...However, from other PCs, I connect to this database and photo folder as a different drive letter, say Z, so when I am on the other networked PCs, and I click on the Hyperlink field, the data will not come up?
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 am creating a task tracker where the user will enter a task which is working. If he is complete the task at that moment he will submit the task and everything is done for that task. However, if there is some issue or if the user need any information, then the user will enter a comment and will hit hold. My queryis once the user hits hold button, the table "Main" will capture the hold date and time. I need a second table, may be by name "Inbox" which will only show records kept on hold.
Secondly there should be hyperlink for "ID" of Hold records in table "Inbox" and when the user click on the the "ID" to resume the task, it should take the user to "Main" form and display that particular record (record which the user had clicked). Also, the date and time should be recorded when the user click on the hyperlink in Resume_Date and Resume_Time fields for that record.
Is there a way to insert a hyperlink in a field title on a table? For example, I have a field that is a check box for whether the person has taken a class. What I would like to do is insert a link in the field title for that class so I can click on it and bring up the supporting documentation in a PDF file for that class.
I Have a table with 15000 entries. This table lists components we use. This table is used to generate queries/forms. I have been asked to add a hyperlink to this table to link to a drawing of the component. All the drawings are in PDF and in the same folder. I am looking for a way to automatically update the hyperlink fields all at once. The Hyperlink will be in the format of servershareddrawings12345.pdfwhere 12345 is the component name from the table.
But there are a few small problems with the component names. 1. If the component begins with a B- . The drawing name will be all the characters except when there is a second dash in the component. So if the component is B-12345-678 the drawing name will only be B-12345. 2. If The component begins with AB, The drawing will be the first 5 characters regardless of what follows, e.g. AB123. 3. Finally for all other components the full component name will be the drawing name.
Putting the naming to one side, how to go about auto generating the hyperlink. I have posted this in the table section, but maybe this should be in another section like queries or VBA.
In the Access Table, how does one Find and Replace part of the hyperlink if the Text to display is different?
Example of Hyperlink Editor:
Example of Find and Replace
In other words, I'd like to find FAKESERVER and replace it with C:Users in all 1000 records. Is there any possible way to do this if there is Text to display?
We sometimes make an error in entering a stock code and have to change the code.
Our main table is = Investments01_tbl Other tables that use the same stock codes from the above table are = Alerts_Stocks = Investments01_tbl_SubForm
The table = Investments01_tbl_SubForm = can contain the same stock code many times.How can we create a query that can be used to enable us to change the stock codes in the 3 tables at the same time?
we want to run a ping command via a radio button or command button. We have IP addresses set up for multiple pieces of equipment, each IP address consisting of 4 different text boxes. We want to be able to launch a ping and have the program read the values from each of the 4 text boxes that make up the IP address.
A few years back I saw a program which helped with database changes. I want to change names of fields and tables, queries etc. in a rather complex database. Does anybody know where I can get this tool or program to run through the database and change it in all corners and crevices on a search and replace basis?
I came into a database where the forms have checkboxes connected to table fields that are in text data type. I see that when the checkbox is checked, the value in the field is still -1 in the table. Is there a reason to change these fields to Yes/No data type or just keep them as they are? Are there limitations or problems to having Yes/No values (-1) in a text field?
I am trying to change the name of a field in a table. When I hit save, it gives me the error:"Could not find field 'originalFieldName'"..I hit OK and it says: "Errors were encountered during the save operation. Properties were not updated."
There are no queries, forms, reports, or relationships shown on the relationships tab. The other fields in the table have drop-down menus of values stored in other tables, but not this field. It just has values I entered in it manually.Why can't I change the name of the field? I have Access 2007.
Access 2010. I inherited a database that I need to copy and get it ready for next year's data. There are several places in the various tables where the default value on a field is 2013. I need to change to 2014. Any vba code or macro that I can do this without opening all the tables to change the values?
How can I sort string addresses so as to get the correct number order? I know that strings sort on each character, which causes the problem. I have tried some things (with VAL and Len), but was not completely successful. I do not want to enter an address number as 0630, when I want 630.
Why does this not work:IIf(Len(Str(Val([address]))=3),"0" & [address],[address])? Address has 3 and 4 numbers only.
I am currently designing a contacts database for my business and need some advice on how to store addresses.
As I see it, I can either use a single field and carriage returns, or multiple fields which for some records may leave some blank fields.
The data will be used to perform mailmerges and will also be output to a contacts directory and I would be looking to display the address both horizontally and vertically. Is there a simple way of manipulating a multi line field so that it can be displayed on a form across the page on one line in a report?
Hi. I have an Access 2000 database running on Windows 2000 Operating System. The database is on a shared drive on a network with approx 20 concurrent users. It runs a bit sluggishly so I am looking for ways to speed things up. The network guys say that the bit rate is OK so I need to tweak the database. I have run the performance and table analysers and get no suggestions for improvement. However, I have spotted a potential problem with the way addresses are stored.
Currently addresses are stored in the person table along with personal stuff like date of birth, gender, ethnicity etc. the address part has six fields:
Oh by the way - this is for the UK so the address structure has to be a bit flexible to accommodate quite a few variations of how addresses can be written but a reasonable guide is:
Number (or house name) and street name (often a second line for part one of address) Village / urban area Town County Postcode
Part one of my question is - is this the best way to store this information or should I just gather it like this on a form and then store it as concatenated text in a single field. I have tried this on a small test database and it works OK and prints address labels etc. - - But is it better or not?
Part two is - should the addresses be stored in the person table at all or should it be in a separate table. This is the bit I cannot get my head round. If it is in a separate table then each record in the table needs to be unique but because of the nature of the client base (i.e. students) many students share accommodation - OK a 1 to many relationship - but what about students in halls of residence they will have an individual room but the remainder of the address is the same. So for say 1000 students in the same hall 95% of the address is repeated although each address is unique overall. And with 4 halls there are 4000 entries that could potentially be reduced to 4 plus a room number and hall name, but I am not at all sure how to achieve this. And then what about addresses for students not in halls but shared houses? I cannot get my head round this. I can see why it was set up the way it was but there must be a better way.
Do I need one table, two tables or six tables (one for each field)?
And how do I then enter data? Do I have to have combo boxes on each line to see if that value has been entered before?
The data gathered would always be entered via forms so I can get the fields together but I don't know how many tables I need nor how best to relate them.
Can anyone suggest how I might get round this problem?
