Form To Build Web Address
Feb 9, 2006
Hi all.
I have been given a simple task, but i have no idea how to do it! I need a form to do the following:
User types in a reference, for example TEST1
We have a standard link along the lines of http://www.testtesttest.com/blaablaa/
We need access to append the "TEST/1" (or whatever the user has entered) to the end of the link, so the result would be:
http://www.testtesttest.com/blaablaa/TEST1
I would be extremely greateful of someone could let me know the best way of getting this done.
Kind Regards
Darren
View Replies
ADVERTISEMENT
Sep 17, 2012
I have a form where the user puts in a email address, eg test @ myserver.net
So the link opens a new mail it has to be prefixed by mailto:
How can I automatically replace the address the user enters with the format mailto:test@myserver.net
View 3 Replies
View Related
Mar 17, 2006
Hi, I'm new to Access.
I'm trying to do a very simple thing but I can't.
Let's say I sell a lot of cars, every day so I need a database only to collect info about selling. I need a table (SoldCars) which need refers (read: field) to 2 other tables: 1.Constructor and 2.Model, or only to Model (because Construvctor could be redundant). Anyway, when I register a new sold car, I want a menu in which I can find a Model but not after having chosne the Constructor, so when I choose "Ferrari" then I can only find "Testarossa" and "GTO" and choose one of them. Stored field can be Model, because Constructor is implicit. But I need this tip because let's say I sell thousands of cars per day and I want it to be very quick. Please help or I'll die under piles of cars!
Thanks!!!!
View 2 Replies
View Related
Jun 19, 2007
Hope you can help!
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.
Thanks
View 1 Replies
View Related
Sep 9, 2013
I'm making an accounts package.
I've made a graph of revenue by customer but due to the number of customers it's a bit hard to see the customer names.
So I would like to be able to select my own custom group of 5 customers to plot on the graph.
To do this I think I need a query that selects the 5 customers which is populated from 5 comboboxes on a new form that the user can select customer names from but I'm not sure of the VBA that links all this together.
View 2 Replies
View Related
Mar 18, 2015
From a dropdown field in the form it's currently possible to choose a geographical region for which to generate a report. The data populating this dropdown is pulled in from a Value List as follows:
" ";"*";1;2;3;4;5;6;7;8;9;10;11;12;13;EU;WD
I now need the ability to choose various different regions simultaneously which is not possible with the current method. I've looked into a nested continuous form and a multi-select combo box or list box, but none of these are as user friendly as my preferred method.
What I would like is 15 checkboxes plus a 16th to select/unselect all. When any of these checkboxes is checked, I need to create something like a dynamic value string or temporary table to hold the list of chosen regions until the generate button is clicked at which point the data is used to generate the report and cleared. I also need a piece of code to check/uncheck all the boxes.
View 3 Replies
View Related
Jul 14, 2015
I have an endpoint for students so they can report any faults in the compound.I want to build a form that contains buttons of a certain value so that a student clicks on the button.Is fed directly to the table and pass to the next form to another value table.
View 7 Replies
View Related
Aug 9, 2006
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?
View 1 Replies
View Related
May 4, 2006
I'm sorry if this has been asked before but I've had a look through the forum and tbh some of the answers were more complicated than I could cope with lol
If someone could explain simply how to do this I'd very much appreciate it :)
I have 2 tables:
Table 1 "Addresses" which contains Company, Address & Postcode
Table 2 "Shipping" which contains Number of pallets, Weights, dimensions, and a combo box for "ship to address" (which doesnt work lol)
and 1 form (which we print and fax) which I'd like to be able to select the company to which the shipment must go (looking it up from the "Addresses" table) and which would then fill the relavent fields on the form for the rest of the address.
I seem to have a mind block on this as I just cant get it to work :(
PS I'm VERY new to access so "the simpler the better" please :)
Ta muchly
View 13 Replies
View Related
Jan 16, 2014
I want to get ip address in a text box on a form?
View 12 Replies
View Related
Dec 1, 2006
i have an address memo field
on the form.. is there a way to display entries already present in certain address fields
eg..
the following address is in the 'pickup address' field and the 'destination address' field
23 High Street, South Kensington
so...
i put a rule on my pickupaddress memo field on my form..
if they type 23.. the rest of the above address appears and offers itself to the field as a sign of good will.. of course the user can just type over it if it happens to be a different address starting with 23..
is this hard to do?
View 10 Replies
View Related
Feb 7, 2013
I have a form that shows first name, last name, email, date appointment, time appointment.
If I just select the regular email option (form attached as pdf) I have to type in the email address manually.
How can I make sure the form is attached as a pdf to my email and the email address that is on the form that I have open is automatically put in the TO: field in my outlook?
Basically I just want to use 2 mouseclicks: button on the form to create an email in outlook and click the send button in outlook.
View 7 Replies
View Related
Feb 8, 2005
I am bulding a contacts DB for work and am a bit of a newbie with Access.
I have a table for Individuals and a table for Organisations. Both have address fields.
On the individual's form there is a drop down for Organisation, which is linked to the organisations table (fk). The form has a sub-form which displays work address. I want the work address field to update to the Address field in the Organisations table when an organisation is selected on the drop down.
I am using Acess 2003.
Could somebody point me in the right direction please?
View 2 Replies
View Related
Dec 9, 2013
I am opening a new mail message in outlook using a button in a form.I want to change the "from" email address to a specific inbox (NOT personal email). Even though the email address is switched, after I hit sent and check my sent items - the email is actually sent from my personal email address and not from the inbox email address i wanted it to be sent from. I have access/permission to sent emails from the other inbox.
Is there a way to make sure emails are sent from specific email addresses and not ONLY personal inbox.What I read online is probably because of some "network" connection issues. Is there a way refresh connection between access and outlook? I am not even sure what the problem is.
View 1 Replies
View Related
Jul 1, 2015
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
[code]....
View 3 Replies
View Related
Aug 8, 2006
How do I build a form which will pull only certain work orders from my table [Work Orders], filter it through a query, [Payroll] which gives me only those work orders which match a certain repID#, for only certain Invoice Dates, and and then display a talley of the total number of times a certain product appears in the field [ProductSold] on the query [Payroll]?
View 1 Replies
View Related
Feb 23, 2007
I can't find anything in the archive relating to this...
Can someone tell me how to enable the "Build" feature in the Visual Basic screen in 2003, please?
I recently upgraded from 97 and can only find the "Build" feature in Query Design.
In 97 it was available by right clicking the screen and selecting "Build". I have no such option when right clicking in 2003.
Thanks
View 5 Replies
View Related
Dec 4, 2006
Can anybody help me build the last table in my database? I have taught myself Access – and can usually get by with a little help from this forum. I have been trying for days to try and solve this !!!
The database is designed to manage feedback questionnaires from attendees of training courses.
I have attached the relationship diagram.
- A course may run for several days. The details of the course are held in the table ‘Courses’. During a course, attendees may be asked to fill in several Questionnaires
- An Attendee is a Person that attends a Course. Attendees are held in the table ‘Attendees’ and their details are held in the table ‘Person’.
- There is a ‘Library’ of questions that sit in the table ‘Questions’
- The questions can be assembled into “Standard Questionnaires”. These sit in the table called “Questdesign” which is a junction table. Assembling a Standard Questionnaire involves using a form to pick questions and give them an order (Qnumber). I HAVE DONE THIS.
- A specific “Questionnaire” is a “Standard Questionnaire” that is used on a specific course. The list of Questionnaires is held in the table “Questionnaire”
- Scoresheet is the junction table between Attendee and Questionnaire (an Attendee on a course may fill in several Questionnaires and a Questionnaire may be filled in by lots of Attendees.)
I now need a table (Scores) in which to put all the scores to the questions (in other words, the scores of the questions on the Questionnaires that are completed by the Attendees on a Course.)
At the end of the day I am aiming to have a form in which:
The Attendee number is entered and all the person’s details are filled in automatically) – I HAVE DONE THIS
The Questionnaire number is entered and all the course details are filled in automatically – I HAVE DONE THIS
A Scoresheet ID is filled in (Autonumber) - I HAVE DONE THIS
A subform appears which shows the right set of questions and question numbers for the appropriate Questionnaire – with a blank column so that the user can fill in the scores which get stored in the Scores Table. - I CAN'T DO THIS !!!
I cannot work out where to link my Scores table and how to build a query that drives the correct behaviour of the subform
I hope I have explained this clearly. I would be so grateful for any help. This Forum is fabulous.
Many thanks
NoVoiceLeft
View 6 Replies
View Related
Aug 28, 2007
I have some database with columns 'Number', 'Mfr Name' and 'Mfr Part Number'.
Number - internal catalogue item of a company.
Mfr Name - name of a manufacturer where from we purchase the item
Mfr Part Number - part number of a manufacturer where from we purchase the item
Each item may have one or more Mfr Name & Mfr Part Numbers.
----------------------------------------------------------------------
I need to build a following query:
Input gets part of Mfr Part Number and output is all Mfr Name & Mfr Part Number of match item.
View 6 Replies
View Related
May 26, 2006
I have attacked quite a few guides ( Dummies & Absolute Beginners ) on how to build a database of my gardening clients, but have run into a problem that they can't seem to resolve. Is there anyone out there who can help me with "referential integrity" and trying to link relationships between the various tables I have created.
View 3 Replies
View Related
Jan 8, 2007
Hello All
Does anyone know how you might build sliding bar displays as an input device for scores into an Access database? I am building an application that could really use something like this.
Here is an example. First go to the 'Chelsea tab', slide the bars, submit the results, and see the results on the "Results" tab
http://news.bbc.co.uk/sport1/hi/football/teams/c/chelsea/6173703.stm
Very impressive
NoVoice
View 6 Replies
View Related
Apr 22, 2006
hi
hi
i have sql query in a string
strQuery="...."
how to create temporary table with the result of this query?
thanks
View 1 Replies
View Related
Oct 7, 2005
How can I build a date in a query that is used for filtering purposes? The data is in the records in two fields - Month and Year. In our query we have an expression that builds a date - DateRange: [Month]/1/[Year] in order to qualify the record with the criteria Between FromDate and ThruDate. DateRange as it is shown here returns a date of 12/30/1899 for all records. DateRange: #[Month]/1/[Year]# is invalid syntax. DateRange: [Month] & "/" & 1 & "/" & [Year] is not recognized as a date.
View 4 Replies
View Related
Jul 5, 2006
Hi all, I have a field that stores software versions as text. The version numbers can be simple (4.0, 5.0) or unknown or more complicated (4.5.200512, etc). The user wants to be able view data in a pivotChart without seeing interim versions- so 4.5.200512 would not show up but its data would be counted as part of 4.5. Anybody know how I can do this?
thanx
View 1 Replies
View Related
Oct 26, 2006
Hi everybody,
Let's say that I've got the following tables:
- tblCustomers(IDCust,NameCust)
- tblEmployees(IDEmpl,NameEmpl)
- tblProjects(IDProj,IDCust,IDEmpl,Duration)
My query:
SELECT tblCustomers.NameCust, tblProjects.IDProj, tblProjects.Duration, tblEmployees.NameEmpl, Sum(tblProjects.Duration) AS SumOfDuration
FROM (tblProjects INNER JOIN tblEmployees ON tblProjects.IDEmpl = tblEmployees.IDEmpl) INNER JOIN tblCustomers ON tblProjects.IDCust = tblCustomers.IDCust
GROUP BY tblCustomers.NameCust, tblProjects.IDProj, tblProjects.Duration, tblEmployees.NameEmpl
ORDER BY tblCustomers.NameCust;
What I'd like get when running my query is:
NameCust ------ IDProj - Duration ----- NameEmpl ------- ?????????
CUST1 ---------- 1 ------ 3 ------------ EMPL3 ---------- 7
CUST1 ---------- 2 ----- 10 ------------ EMPL4 --------- 10
CUST1 ---------- 9 ------ 2 ------------ EMPL3 ---------- 7
CUST1 --------- 11 ------ 2 ------------ EMPL3 ---------- 7
CUST1 --------- 13 ------ 8 ------------ EMPL1 ---------- 9
CUST1 --------- 18 ------ 1 ------------ EMPL1 ---------- 9
CUST2 ---------- 3 ----- 20 ------------ EMPL1 --------- 20
CUST2 ---------- 4 ----- 12 ------------ EMPL3 --------- 17
CUST2 ---------- 5 ------ 3 ------------ EMPL2 ---------- 4
CUST2 --------- 10 ------ 5 ------------ EMPL3 --------- 17
CUST2 --------- 17 ------ 1 ------------ EMPL2 ---------- 4
CUST3 ---------- 6 ----- 25 ------------ EMPL4 --------- 27
CUST3 --------- 14 ------ 2 ------------ EMPL1 --------- 14
CUST3 --------- 15 ------ 2 ------------ EMPL4 --------- 27
CUST3 --------- 16 ----- 12 ------------ EMPL1 --------- 14
CUST3 --------- 19 ------ 2 ------------ EMPL2 ---------- 2
where ???????? (manually done) = the sum of the Employee duration for ONE Customer !!!
But what I get instead:
NameCust ------ IDProj - Duration ----- NameEmpl ------- SumOfDuration
CUST1 ---------- 1 ------ 3 ------------ EMPL3 ---------- 3
CUST1 ---------- 2 ----- 10 ------------ EMPL4 --------- 10
CUST1 ---------- 9 ------ 2 ------------ EMPL3 ---------- 2
CUST1 --------- 11 ------ 2 ------------ EMPL3 ---------- 2
CUST1 --------- 13 ------ 8 ------------ EMPL1 ---------- 8
CUST1 --------- 18 ------ 1 ------------ EMPL1 ---------- 1
CUST2 ---------- 3 ----- 20 ------------ EMPL1 --------- 20
CUST2 ---------- 4 ----- 12 ------------ EMPL3 --------- 12
CUST2 ---------- 5 ------ 3 ------------ EMPL2 ---------- 3
CUST2 --------- 10 ------ 5 ------------ EMPL3 ---------- 5
CUST2 --------- 17 ------ 1 ------------ EMPL2 ---------- 1
CUST3 ---------- 6 ----- 25 ------------ EMPL4 --------- 25
CUST3 --------- 14 ------ 2 ------------ EMPL1 ---------- 2
CUST3 --------- 15 ------ 2 ------------ EMPL4 ---------- 2
CUST3 --------- 16 ----- 12 ------------ EMPL1 --------- 12
CUST3 --------- 19 ------ 2 ------------ EMPL2 ---------- 2
Any suggestion to build this Query ??
Thanks in advance
View 3 Replies
View Related
Dec 25, 2006
Hi
I 'm new at this Forum and also I'm new programmer in Access.
I 'm trying to answer project called (Cerulean Bee) ,which is attachment down
I do the table and forms but I don't know how I can let them as it the question (Artwork Order-Employee Work Log-Print Order-Project Cost Analysis).
Her my file http://www.megaupload.com/?d=XP34TRO3
Please help me to find ant error I do , and to get best answer for my question.
I'm realy need your help
Thank you all
View 2 Replies
View Related