Predictive Address Form Entries
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 Replies
ADVERTISEMENT
Nov 7, 2013
I have a database where several entries may have the same address, but someone has been inputting some of the zip codes incorrectly. I want to come up with a way to get a query or the like to spit out a report with just the entries that have identical addresses and conflicting zip codes, and have hit a brick wall.
View 5 Replies
View Related
Aug 16, 2005
I have many rows of information i am entering in access. I want to setup this spreadsheet to look at previous rows of information so when I fill one field it will automatically fill some of the other fields in the same row with the information from the rows above.
if this is not possible then I want to create a dictionary of information so if information is typed in one of the fields it will automatically populate some of the other fields on the same row.
View 2 Replies
View Related
Aug 16, 2005
I have many rows of information i am entering in access.
I want to setup this spreadsheet to look at previous rows of information so when I fill one field it will automatically fill some of the other fields in the same row with the information from the rows above.
sorry cannot explain very well
if this is not possible then I want to create a dictionary of information so if information is typed in one of the fields it will automatically populate some of the other fields on the same row
View 1 Replies
View Related
Apr 3, 2013
i have a combobox which i want to use on a touch screen using touch buttons in ms access 2010
i set the combobox ime sentence mode to phrase predict, allow autcorrect to yes, row source type to value list and typed some words that i want in the row source eg. "kitchen"
i've set the on click event of my buttons a,b,c,d..... as following Me.Combo56 = Me.Combo56 & "A" for button a and so on.
the problem is that when i press the first letter of the word lets say "k" for the "kitchen" on my onscreen keypad the combo can not predict the word.
View 1 Replies
View Related
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
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
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
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 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
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
Mar 13, 2014
I have a table in access which is updated weekly; I need to create two tables from this updated table.
1st table will consist of all the new entries for the current week
2nd table will consist of all the entries from the previous week - an amalgamation of all the entries which are not from the "current week" (table) For example; the table below shows the two entries from last week.
ID
Name
1
Adam
2
Ben
This week I have three new entries New entries
ID
Name
3
Charles
4
Richard
So when I run the same query next week I will get something like this.
Old Entries
ID
Name
1
Adam
2
Ben
3
Charles
4
Richard
[code]....
How do I get a query /queries which divides up the weeks new entries and also all the old entries.
View 11 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
Sep 28, 2006
I have two forms "Enter_details" and "sendemail"
on typing txt in "enter_details" forms txt field " checksum" i want it to be updated in "BODY" field of "Sendemail"
"SendEmail" form may be open or may not be open. I put this code on "Sendemail" but its not working plz help
Private Sub txtBody_BeforeUpdate(Cancel As Integer)
[txtBody] = Forms!Enter_Release_details.[Checksum]
End Sub
View 1 Replies
View Related
Feb 25, 2005
I have table with different companies and related info. Another table with contacts for each of the companies, each company might have different number of contacts. I want the form to show all the contacts for each of the company, if there are two contacts in the company then show two, if five then show five.
Just to make sure I am doing it the right way, what is the best way to build a form that is based on multiple tables.
Thanks in advance,
John
View 1 Replies
View Related
Oct 30, 2005
I'm trying to build a Form that will allow one field to be automatically populated when data is entered in another field. I have a table that contains two Fields: Course Name and Course Code. When I enter the Course Name in a Form, I would like the corresponding Course Code to appear in the relevant box on the Form.
Can anybody point me in the right direction as to how this can be achieved
Thanks
DD
View 3 Replies
View Related
Sep 6, 2004
hi,
i have tables called JobRecords and Customer, JobRecords contains 10,000 invoices (jobnumber 1-10000, but all are blank) these 2 tables are related by ContactRef. the idea is to select the ContactRef when entering an invoice and it will automatically fill in the address, phone number fields etc from the Customer table.
now since i need a VAT and Total values, i used a JobRecords Query, when creating the entries i had the default value for ContactRef set to (select) which in the Customer table has N/A values for all fields. my form shows all invoices with data from the jobRecords Query and Customer table, so when i added some new contacts into the Customer table, and then changed some of the invoices to show these addresses instead of (select) and N/A, they disappear.
i know that if some of the fields are null then it wont show the entire entry but even making sure all fields have data in it, it still doesnt appear in form view. it doesnt dissapear in the JobRecords Query either only the form.
my form is based on this
SELECT [JobRecords Query].JobReference, [JobRecords Query].InvoiceDate, [JobRecords Query].ContactRef, [JobRecords Query].JobDescription, [JobRecords Query].AuthNo, [JobRecords Query].AuthName, [JobRecords Query].OrderDate, [JobRecords Query].CompletionDate, [JobRecords Query].NettPayment, [JobRecords Query].VAT, [JobRecords Query].Total, [JobRecords Query].Invoiced, [JobRecords Query].Paid, [JobRecords Query].IncomeRef, Customer.DrawerRef, Customer.CustomerName, Customer.CustomerAddress, Customer.[CustomerPhone 1], Customer.[CustomerFax 1] FROM Customer INNER JOIN [JobRecords Query] ON Customer.ContactRef=[JobRecords Query].ContactRef;
can anyone help?
thanks
Barrie
View 1 Replies
View Related
Jun 14, 2005
I'm working on a pre-existing form. When I open the form, I am able to enter new data and this data gets stored in the database fine. If I close that form and reopen it, I cannot view past entries or edit them. I know of a property (Allow Additions, Allow Edits, Allow Delete) which can change this behaviour, but these seem to do nothing for this form. I have them all set on yes and it behaves as I've described. Ideally, I would like to allow edits of previous data.
I thought maybe the SQL query controlling the data wasn't returning any entries, therefore no entries would be displayed. So I saved the query and opened it up to see how many entries it did find. And it found all that it should have, so I know that the SQL statement controlling the form is what I want it to be.
So my question is this: are there anymore properties or values that I don't know about, that would control the mentioned behaviour of the form? Maybe something somewhere that I'm missing, that would make the form add only?
Thanks in advance for any help. Kevygee
View 2 Replies
View Related
Jun 11, 2006
Hi all
I'd be very thankful if someone can please help me with this problem.
I have 1 Table. This Table is imported and contains data from Excel. It also contains fields I added manually. There is about 20 imported fields (full of data) and about 100 manually added fields.
Then I made a Query of this table. I made some calculations in this Query.
I then created a Form based on the Query. I then made a Combo Box. This Combo Box selects a customer, and then updates the other fields (the ones I imported from Excel) depending on the customer I selected.
So now what I want to do is this: I want the fields (updated from the query) and newly entered data to save to another newly-created table. Can someone please help me with this? Any ideas?
Thanks a lot. All input greatly appreciated.
kruger101
View 2 Replies
View Related
Jan 12, 2014
I need to create a form that will allow the user to enter details about say a water meter - make, model, size for example.
These will be from combo boxes.
Each time the form is opened though, there could be a different number of meters to enter, from 1 to xxxxx
I will need to use this method for entries on other things as well, such as users and a couple of other things. Same basis just different information.
What I want to do is have a form where they enter the number of each thing that is going to be entered, so 3 water meters, 2 users. Then hit "next".
That will then open a form with the right number of spaces to enter the details for 3 water meters, or 2 or 1 or 999 depending on how many have been entered.
As apart from putting a look in and closing/reopening a single entry form each time.
View 5 Replies
View Related
Aug 10, 2007
I'll start by saying that I'm not sure which sub-forum to choose, as my question(s) covers several areas, so I have tried with this one first.
I'm currently making a database, which among other things contains a 'Port of Call list' table. I have a form, where I can add data to this table, meaning, that whenever a vessel has left its port, user can update following: Port name, security level, arrival date and departure date.
What I need is two things (it might be more or less the same):
1. When user click a "Generate" button on a form, the 10 latest port calls from the table, should be shown. I'm not sure what kind of control is the best to should the list on the form. Code is also needed.
2. I would also need to be able to print the list. It should be part of a report. Again which controls/which code to be used is needed.
I hope that someone are able to assist, as I have no clue what to do.
Thanks.
View 10 Replies
View Related
May 14, 2006
hi
i am trying to show the total number of records that are in a table.
there are currently 8 entries in the table 'applications'
now i would like to show this on a tabcontrol in a form. I have been told to use Dcount. I have read about this and tried this on my form but unfortunately its not working.
Can anyone show me an example of how i would do this.
View 1 Replies
View Related
Apr 8, 2013
I'm trying to design a simple wildlife tracking DB, so that when myself or my colleagues spot an animal we can enter its ear tag number via a form. That will either bring us up a list of previous dates/locations that animal was observed, or if it's not in the DB, allow us to enter the new animal and location.
I have two main data tables:
dt_Animal- which stores the ear tag info, species, and other information about that unique animal
dt_Sightings - stores info on when/where animals been seen (linked to dt_Animal in a one-to-many relationship, of course)
What I want is that when you open up the form, you get a box (text or combo) to enter the animal's ear tag number.
- If it already exists in the DB, it brings up all the info on that animal and its previous sightings - with the option to fill out any missing info and (of course) to add a new sighting - and it WILL NOT add a new record to dt_Animal - just to dt_Sightings
- If it DOESN'T exist in the DB, it creates a new record in dt_Animal and allows you to enter any/all of the other information
Where I'm running into problems is that I don't want duplicate records in dt_Animal - each animal is unique. I haven't found a way to set up a form so that you don't get pop-up errors if you're typing in an ear tag number that's already in the system.
I've tried various tactics involving simple coding (NotInList, etc.) that I pulled out of this forum and other places, but haven't had any luck.
View 5 Replies
View Related
