I've inherited an Access Application which is basically a Front End for calling Integration Service Packages - for all intents and purposes it could be stored procedures or anything other executable. A number of forms have hard coded links that point to a particular executable on a network drive.
With regards to this the UAT packages will live in a different directory than the DEV code so is it possible to parameterise the link e.g. could W:CAT DevelopmentAutomation PackagesOTCOptionsImport.dtsx become W:PARAMETERAutomation PackagesOTCOptionsImport.dtsx - if so then how do I create a parameter, capture it and use it in the link above.
The whole project is lacking the use of parameters at an ACCESS level and Integration Services level but due to time constraints there is no scope to major overhaul the system design.
I am a developer with many years of experience but my Access knowledge is limited so any pointers would be helpful.
I want to put a command button next to the customer's email address so that the user simply presses the button and Outlook will be started with the customer's email address automatically inserted from the table.
I am playing around with the Hyperlink Address function and whilst this seems to do what I want, I can't figure out how to get the customer's email address from the tabel and insert it......
I have a form with a textbox with the "LinkedIn" profile address that I want the user to be able to pull up when they click a command button. It works, except that the link opens twice in two tabs in the browser. I've checked over the code for the whole form, and this code is only being run from the click event of the button, so why would it open the same tab twice? Here's the code:
Private Sub cmd_Click() Dim ctl As CommandButton Dim txthyper As String Set ctl = Me!cmd txthyper = Me!LinkedIn
I have a command button on a Web Mutli-Record form that is using a "= [Report_URL]" value within the Hyperlink Address property. This all seems to work other than the fact that when the link popups up it has a "#" on either side that basically makes it an invalid address. How do I get rid of the # signs to get the web address popup in the URL when a user clicks on the Command Button that is associated to the row the record is on.
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?
I have an access table which lists a customers address, however, if the customer has a temporary address it will also list that on a separate line -
CustID Address Type 1234 5 The Street P 1234 12 The Street T 2345 13 The Road P 3456 12 The Avenue P
Where P = Permanent and T = Temporary
I want to set up a query to show the permanent address where there is only one address, but where the customer has a temporary address also, I want to list the temporary one instead.
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 form bound to a table which stores contact info for a person. I have two controls that are email_address and website_address. I set them both as hyperlinks. So now when the user clicks on the email_address Outlook opens a new message with an email_address in the To field. (I had to use a function found on this forum to replace the "htttp" with "mailto" on AfterUpdate event in order for this to work properly.) However, now trying to add some other features to my DB I ran into problems listed below. I wonder if I should have rather left that control as Text instead of Hyperlink, and use the DoCmd.SendObject on doubleclick event instead of using the above solution. How people usually store email addresses and enable emailing on click?
The problems I ran into: 1) My main form is in popup mode and therefore right click on the hyperlink does not give an option to edit the hyperlink 2) I copied a function from this forum which gathers a list of emails and sends one message to the emaillist. However, my email list instead of generating as: email1@a.com; email2@b.com it generates as: email1@a.com#mailto:email1@a.com#; email2@b.com#email2@b.com#
I guess I could extract the email using vba (not sure how), but I still don't know how to solve issue number 1. So maybe it is better to siwtch the field to plain text and forget the hyperlinks?
Thanks, Mariusz
PS. What procedure on double click would open a default browser, since I also have to deal with web addresses and thought of turning them into text controls?
I have an address all in the one line at the moment. My front end has been programmed this way. Now I have to split the address into 3 or 5 lines. The address looks like this:
3 Thorn Road Edinburgh Scotland G68 2AA
The post code is in a seperate field so that makes it easier for me.
I have a table that has about 5000 street addresses (ex. 1234 your st.). I want to get the all the characters until the first space. So for (1234 Your St.) I want to get 1234 for W1234 St I want W1234. Is this possible?
Hi Ive got a form that has customer details at the top i.e name, address etc. and then a products subform. Once I have chosen a customer it then automatically fills in the address fields and i can then add products to the order. I then press a button which produces a form showing the customer name and address and the products they ordered. I want to be able to have it so I can add a tempory address if the customer wants the goods to be shipped somewhere different to there normal address. How do I do this without adding another address into the database?
I have two addressess, primary and secondary. I would like to make an option button on the form that indicates (when selected) which address to use for mailings? Although, 9 times of 10, mailings are sent to the primary address, but there are those exceptions...
Can someone direct me to an example code to perform this?
I have a form "frmsend mail" whic have fields "To" and "Cc" i want to have a address book in the access itself having same functionality as outlook i.e it should add new email id to the address book, prompt the email id,etc. How to do tht. thnxx
Just a little advice on how to approach a problem.
I have some simple address validation in an unbound form. When the user types in a suburb, I have a DLOOKUP function that returns the appropriate postcode for that suburb.
My problem is that most suburbs have more than one postcode (standard and PO BOX).
How can I return both values?
My intention is to then allow the user to select the appropriate postcode.
I have a form for all my clients, and currently there's a separate field for each part of the address. This does not make it easy to cut and paste an entire address block. I therefore created an unbound text box with the control source as:
This works ok, but if someone doesn't have anything in the fields [Pref1] or [Pref2] it leaves blank lines. Is there a way to code it so that I can have a complete address block? Thank you.
Hi - I am importing information into my database of customers names and addresses. The country part of the address comes in 2 letter code - eg AU = Australia, IT = Italy etc. What I would like is to change these to the actual country name. Is there a neat way of doing this? I am thinking doing a whole line of if then, but it all looks really messy. Thanks Fiona
I have a form "frmsend mail" whic have fields "To" and "Cc" i want to have a address book in the access itself having same functionality as outlook i.e it should add new email id to the address book, prompt the email id,etc. How to do tht. thnxx
Problem: Turning an address column containing a comma into two or three address colums containing no comma
I have a database with the structure: company address town postcode (zip code)
The present address column contains one of the following (I give examples)
-76 Nelson Street
-99 Bush Lane, Waddington (where Waddington is a village, or quarter of the town named in the town field)
-Nixon House, 150 Clinton Street, Hareswood
-sometimes there might be a redundant comma at the end of the string e.g. 99 Bush Lane, Waddington,
-very occasionally the address field is empty (when the record is still incomplete
----------------------------------------------
We now have to interact with another company and its software, which takes commas as field delimiters. We therefore have to get rid of all commas in our address field.
I have therefore revised our structure so that it now is: Company Addr1 Addr2 Addr3 Addr4 (which contains what was formerly 'town') Postcode (zip code)
Now I must distribute the contents of Addr1 into Addr1, Addr2, Addr3 and eliminate the commas in the process.
Our database has 4000 records. Therefore doing this manually is prohibitively expensive and takes far too much time. We need the revised database virtually overnight.
My knowledge of Access is fairly limited, but it is ***I*** who has to solve the problem.
Request ------------
Is it possible to do this automatically?
How would you proceed, which steps?
If an Action Query has to be used - well, I have never used an Action Query before (but I have a hefty book about it = "Willing to learn - fast").
If there is a simple formula to be entered into the Action query, could someone please give me the formula?
When I joined this forum last month, I attempted to enter my current email address and I got a message box that my email address had been banned. I tried several times to enter the correct (current) email address and each time was told that email address had been banned.
I attempted to contact 'jon@access-programmers.co.uk' on the 13th and 27th of April with no response.
As it is right now, this forum only recognizes my old email address instead of my real email address as that's the only way I could continue the join process.
Can anyone: 1. tell me why my current email address has been banned 2. help me get my correct information entered?
