Create Automatic Interchangable Hyperlink
I am attempting to creae a hyperlink to set into a table that is generated automatically by other information curently residing on the table, and with the ability to change the disc location.
The table I have created is an application that will name reports that I have in .PDF format. I put in the report title, date, inspectors, etc. and it gives me a unique name for the document. I then go to my document and name it what the application gives me. Now, we would like to have a link to that file that resides on the table, so if we look it up in the future we don't have to search any further, we can just click right there and go strait to it.
I know how to insert a hyperlink to get to the file, assuming it stays on the same directory. Our directories change fairly often (can go from C:/My Docs/File to E:/My Docs/File in a matter of a week), so I would like to know if there is a way to create a partial hyperlink that I can change the begining to whenever need be.
Any ideas or suggestions are greatly apericiated.
Thanks guys!
View Complete Forum Thread with Replies
Related Forum Messages:
Set Up Automatic Hyperlink
All Do anyone know if it is possible to make a automatic hyperlink in one field by combinding other fields. Eg. one field : 257_ second field: 601-01-001 Third field: A Fourth field: c:drawings Make hyperlink field c:drawings257_601-01-001_A
View Replies !
Automatic Transformation From Text Format To Hyperlink
Hi all, I've made a create table which gives 2 fields which contain links to websites. In the new table these links are in "text" format. I need to change those 2 fields from text to hyperlink in an automatic way. Currently I've manually changed in the table the "data type" of those 2 new fields from Text to Hyperlink. In this way the hyperlinks work. I can't do this job every day. How can I make it automatic? How I can change automatically the formats from text to hyperlink? Do I have to use VBA or can I avoid it? Thanks. Fabrizio
View Replies !
Trying To Create An Automatic Payroll Form
Hello, I am basically doing FORM to automatically figure out my stylists commission pay, based on 5 levels of sales and 3 different pay levels, that I will cut and paste in a table from my POS system. 3 Total Tables. tbl_Employees, with the headers ID, Name, Payroll ID, Comm_Level. tbl-Current Year with the headers ID, Payroll ID, Name, Service Sales. tbl_Comm with the headers ID, CommLow, CommHigh, Level1, Level2, Level3 In a query, Qry_Years, I have Payroll ID, linked between the tbl_Employees and tbl-Current Year. I am close in a FORM to getting this to work, unless DLookup is the wrong why to go about this. This is not correct, but gives you an idea of what I am trying to do. In a FORM text box (called framePayrollIDLookup) I have =DLookUp("Level1","tbl_Comm",[tbl - Current Year.Service Sales] & " between [CommLow] and [CommHigh]"). This pulls up the correct pay percent for level1 employees, but i need to change out Level1 to something variable. This also doesn't work, but gives you an idea of my though process. =DLookUp(" " = framePayrollIDLookup,"tbl_Comm",[tbl - Current Year.Service Sales] & " between [CommLow] and [CommHigh]"), but this doesn't work. I might be way off base on how to do this, but I am trying. Thanks for any help. Chris
View Replies !
Automatic Splitter!
I am tying to create a setup application in access. The setup forms are incorporated in the database application.It has to split my database into a FE and BE so that the corresponding files can be placed in thier corresponding files folders automatically. Iam doing this because the database has to be exported to a number of remote locations every after two weeks. Apart from using the Database Splitter, Could there be any Ideas on how i can split and link my database through code.
View Replies !
Automatic Sending
Hi , I have one question. Can MS Access 2002 version do automatic send the record by E-mail without click the button? I just want to know that. I know how to create the button, and then using docmd.sendobject command to send, but I wonder whether or not MS Access can do automatic sending by e-mail without click the button. Please let me know. Thanks.
View Replies !
Automatic AutoNumbering
I am using DMax function for my custom autonumber I just realized that when using this in a multi user environment, I am getting duplications. This field is not the primary key, and I am using this as a group ID and cannot set it to “no duplications” My form also has a sub form, and when entering the sub form, the main record gets saved automatically. First I added the following procedure Private Sub Form_AfterInsert() If IsNull(Me.OrderNo) Then Me. OrderNo = DMax("OrderNo ", "tblOrder") + 1 End If Private Sub cmdSave_Click() If IsNull(Me.OrderNo) Then Me. OrderNo = DMax("OrderNo ", "tblOrder") + 1 End If However, I then realized the after insert function will add the new autonumber to the form. However, it will not saved it to the table until the main record is saved again (which may not happen) “DoCmd.RunCommand acCmdSaveRecord” doesn’t seems to be working after the “Form_AfterInsert” Now I moved the code to the “Form_BeforeUpdate” (still testing) Does anyone have any experience on this problem? Thank you Joe
View Replies !
Automatic Updates
Hi there,I know very little about Access but been asked to find out if this is possible:On a database we have a date field for when subscription is due, is there any way that if a DirectDebit method of payment has been chosen, when the date of renewal is, access will automatically update the year to the next one?Thank you very muchCathy
View Replies !
Automatic Renumbering
Our small newspaper needs to create a database of subscribers from which we can print labels in what the post office calls "Walk Sort" order, the order in which the mail carrier hand delivers the mail on his route. The number associated with a particular subscriber is not fixed because if another subscriber is added on that mail carriers route, it may fall between two existing entries. So the Walk Sort field needs to automatically renumber up or down when an entry is added or deleted. I will use that field to sort chronologically and print form feed labels. I've figured out a way to do this in Excel, but I think Access might be a better program to use for this database. My question is, can Access automatically renumber a Walk Sort field if I add or remove entries? If so, how do I set it up to do that? P.S. I haven't used Access for quite some time, and I wasn't very proficient with it then. :o
View Replies !
Automatic Refresh
Hello everybody, I have many front end's (using ACCESS 2007 runtime version) in different terminals. Suppose that from 'terminalA', I am assigning a task to an employee who's using 'terminalB'. The user is already looged on to the program by this time, so I want that 'task' to appear on his terminal without him having to press the 'Refresh' button (that I placed on the form) every time I give him a new task when he's logged on so he could see it. How would I do this? Thank you very much.
View Replies !
Automatic Backups
Quick question about backing up a database: Is there a way I can have Access automatically save to a different path/filename dependant on date/time? I used to have my database backed up every hour automatically through Windows Task Scheduler. My IT section has removed that capability from all PCs here! (Something about allowing viruses in??? doesn't make sense to me). So I'm stuck trying to find out a way to back up my database automatically. I seem to remember reading through one of my access books that this was possible, but I never could figure it out. So, thought I would turn here for help. THX! AC
View Replies !
Automatic Date Qry
Hi, i need to run a specific qry that runs from 5th to 5th of every month to show payments made between the dates. i dont want to fill anything in as these dates are set. can a qry be made to run and retrive the info between 5th of last month & 5th of current month automatically ( by the press of a button ) every month? many thanks, NS
View Replies !
Automatic Lookup
hi i have two tables. One with Item Data - ITem ID, Item Name and Item Value On another table, i have transaction data - Transaction ID, Item 1, Item 1 Value, Item 2, Item 2 Value etc. What i am looking for is a way of when i lookup item 1 and enter it, item 1 value will appear automatically. Any ideas
View Replies !
Automatic Value Of The Column
I am creating three columns a,b,c in a table in MS access When I enter the value of a and b, the value of c should be a+b automatically Is this possible in MS Access, if yes how?
View Replies !
Automatic Dates
I am building an employee performance report database. Part of this report I need to integrate initial and midterm feedback dates. These dates are as such: The initial is 30 days after supervision started or annual performance report completed The midterm is 120 after supervision started or annual performance report completed I'd like to give the supervisor a set month for their feedback completions as a guidline. If they are a few days prior or after the "30 day or 120 day mark" it is not a big deal, so I am just wanting it to automatically calculate the month rather than a specific day. After a performance report is completed the intial and midterm feilds should automatically update to calculate the new feedback dates for the next year. The most updated dates need to be available for supervisors to print on a master report on all their subordinates. No need to store older dates (unless the performance report has not been completed yet) Pertinent Info: Form: Perf_Report Table: Rater_tbl Field Name 1: Initial ::: (format = mmmm) Field Name 2: Midterm ::: (format = mmmm) Field Name 3: Date of Supervision ::: (format = dd mmm yyyy) Field Name 4: Report Completion ::: (format = dd mmm yyyy)
View Replies !
Automatic ID Generation
Hi I have a column which is made up of two parts from the table as follows... function area .... FINANCE ID number ... 001, 002, 003 etc combined together this will make my ID column which should look somehting likie this : FINANCE 001, MARKETING 002 etc BUT the problem is that now i need to import some existing data into the tables and it appears as though the existing data has repeating numbers for different function areas e.g. FINANCE 001 FINANCE 002 MARKETING 001 MARKETING 002 how would i get this imported into my current table structure?
View Replies !
Position, Automatic
Please Could any one help out, i have this Database am building for students in a school, The attached WORLD file respresnt a query in the database. The Position in class and Position in level is suppose to grade the student automatically i.e 1st, 2nd, 3rd, 4th, 5th e.t.c. according to the score in a particular subject in their class and in the level. I dont know how to go about this, am not even sure if this could be done using the query or i should do it using VBA on the report sheet that i generated from the query. If any one has any idea on how to go about it please let me know it will be highly appreciated. David
View Replies !
Automatic Completion
i build a query that filter names. i want that when the user start to write the name he want to find in the query , he will get a list of names that starting with the same letter he wrote how can i do this thing in access ?
View Replies !
Automatic Pop Up Reminders
Hi I'm fairly new to Access and databases in general but I have built a great database which I am really pleased with, but I want to be able to have a pop-up reminder which is activated when a date in one of the form fields is reached. First of all is this technically possible? If it is could somebody give me an indication of how to go about doing it because I have no idea! If it is not possible, is there any other way around it? Thanks in advance for your assistance and the simpler you can keep any advice the better!! Many thanks Steve
View Replies !
Automatic Checkmarks
Hi All, Total Newbie questions……I’m hoping it’s something simple, I have missed while searching through the forums. I am looking to have the invisible checkbox field on subform 2 automatically checked when the Form2ID field is saved with a command Button. My next step is to have the checkbox on subform2 activate another checkbox on a third independent form thus pulling the information from the newspaper field on form 1 And The option group choice from form 2. FORM1 Form1ID FTMID NewspaperName SubFORM2 Attached to Form 1 Form2ID FTMID OptionGroup(incomplete, complete,NA) Checkmark FORM3 Checkmark(from form2) NewspaperName (from form1) OptionGroup(from form2) Any pointing in the right direction would be greatly appreciated… ~Van
View Replies !
Automatic Date
This is going to be a dumb question for all you Access experts, but how do I insert a field that will automatically display the date that the record was created (not updated, but created)? Thanks!
View Replies !
Automatic Date
This is going to be a dumb question for all you Access experts, but how do I insert a field that will automatically display the date that the record was created (not updated, but created)? Thanks!
View Replies !
Automatic Updating
I have a form that has a combo box. The row source of the combo box is a query with 3 fields. I also have a text box located to the right of the combo box. I would like the first item to the left in my combo box to show up in the actual combo box when selected. Then I want the value of the second field to be automatically placed in the text box. I had this working kind of when my text box was a list box and in the combo box code i put Me.MyListBox.Requery But this changed all of my records from that point on. Everytime I change the value in the combo box, the list box value changed for every record. Please Help.
View Replies !
Automatic Numbering
Hi I am a newbie on here!!!!! Anyways, now that I got that out of the way.... I need help on my Access Database. Hopefully this isn't a stupid question..... I would like to have one of my cells in my form to automatically count from 1000-9999 when I go to the next form. when it hits 9999, I need it to start over, but not delete any of the previous entries that I have in there. Anyone willing to help me out? Greatly Appreciated, I am sure I will have more questions!!!
View Replies !
Automatic Date
I am trying to create a function whereby when I update a memo field or a field where I put in notes, after I am done, it will automatically put in the current date.
View Replies !
Automatic Date
Hey ASP Fam, I am putting this form together that involves the user to enter in the current date 2/20/2007 in that format. Is there a script or something i can do in access that will autmatically put the current date in the date field and just update the date as each day changes everyday? Thanks N Advance
View Replies !
An Automatic Date
OK, next question. I have a query for my database that asks for all records reviewed on a particular date. I've got it set up so that when I run the query, it will ask me for a date range and then run the query only bringing up the records that meet the date range criteria. I then developed a report from this query and it too asks for a date range when I run the report. My question is this: I hit the button to run my report, the box asks me for a beginning date and then a ending date. I enter the date range and the report runs great. Is there a way that after I put in the date range, that date range will show on my report? Thanks once again for your help. Example: NAME OF REPORT 1/12/07 - 1/20/07 (this is the date range I entered) Body of report
View Replies !
|
TRACKER
