Choosing Addresses
Sep 28, 2007
Hello everyone. I hope you are well. I am new to this forum and need some help with access.
I have a database which records an organisations addresses. There is the main address, where the activity takes place, and then there is the postal address, which is often different. What I want to be able to do is to select all the organisations in one town (e.g. Town1), but send information in the post to their postal address (Town2).
Is this something that can easily be done? I hope somebody can help me (especially with some user friendly terms).
Many thanks,
Chadder
View Replies
ADVERTISEMENT
May 2, 2006
I am trying to make a form that will allow me to make several selections and run a report. I want to be able to select from a list of Grade Levels, 9th, 10th, 11th and 12th. After I have picked my grade level or selected more then 1 grade level I want to be able to choose from a drop down list of school district. After I have choosen my grade level and my school district I want to run my report. How do I do that?
View 4 Replies
View Related
Dec 23, 2007
I am running a query which uppends the record to one table from another table. My requirement is that, it should check one field of the destination table table before inserting the record. If that field matches, it should run Update query or else it should run Insert Query. How Can I do that?
Please Reply!
View 1 Replies
View Related
Oct 6, 2006
I have a list box box which contains a ProNo and ProName.
I want to be able to select a value in the list box and pass it to another list box in the form so i can pick the projects i want to print reports on.
Is this possible or is there another way of going about this problem.
View 1 Replies
View Related
Dec 14, 2004
I have a list box that pulls data from a form. It pulls ProjectID and ProjectName. I want to be able to select one of the ProjectName(s) from the list and have it take me to a form for that ProjectName. I have one form for all the ProjectName(s), and want to be able to simple select one of the ProjectName(s) from the list and have access bring me to the right page of the form. Please Help! Thanks!
View 4 Replies
View Related
May 2, 2006
I am trying to make a form that will allow me to make several selections and run a report. I want to be able to select from a list of Grade Levels, 9th, 10th, 11th and 12th. After I have picked my grade level or selected more then 1 grade level I want to be able to choose from a drop down list of school district. After I have chosen my grade level and my school district I want to run my report. How do I do that?
View 2 Replies
View Related
Jul 11, 2006
Hi,
I would like to have a dialog box open when the user clicks on a command box so that they can choose the file name and the directory where the exported excel spreadsheet would be saved. Does anyone have any ideas? Btw, my code to save an excel automatically is below and I would like to use code.
DoCmd.OutputTo acQuery, "qryPipelineAndCommission", "MicrosoftExcel(*.xls)", "ClientList.xls", True, ""
Cheers,
Ben
View 3 Replies
View Related
Nov 6, 2006
I have a database with information on carriers, lanes, and prices.
I need to choose the cheapest 3 carriers for each lane.
The lanes are either 3-digit zip code to 3-digit zip code or state to state
(410-300 or CA-GA, etc.)
So for each of these lanes, I need to find the 3 cheapest carriers all
in one query.
So the resulting table should look like:
Lane Carrier Price
..........
TN-FL Schneider $50
TN-FL JB Hunt $66
TN-FL Dart $78
646-303 JB Hunt $77
etc.....
Except of course in columns :) Any ideas on how to do this? Thanks in advance!
View 2 Replies
View Related
Aug 25, 2004
ok this is weird post but im wonderin how to go about it easily cause i can think of a few ways, dunno if they will work of not, so im asking for ur opinion. I need to find out possible cominations for a salary cap football league based on dollar amounts for the players and points based on last years results, yet it cant go past $100.00...so one possible choice is (QB Tom Brady $22.56 183.50 points). its 1 QB, 2 RB, 3 WR, 1 TE 1 Kicker, 1 DEF team and i have to do all 9 for it to count...so would i have to set up 6 columns, one for each position and have a way of picking 1 of A 2 of B 3 of C 1 of D 1 of E 1 of F for 1 qb, 2 Rb, etc? and have it so sum of values is < $100 and it also must add the points so i can see the best possible combination/most points i can get for $100.00...i know its last years points and this year will be diff but I am just comparing...all i need is an outline i dont need u guys to do it for me i have some experience with access...thanks for anyone who can help
View 2 Replies
View Related
Apr 19, 2014
I'm rather new to Access.
I have 2 tables.
Table 1 : invoices
Table 2 : customers.
I want on my form of invoices to have a way to select a customer. I want a button, and when I click on it I want a list of all my customers.
How do I do that?
When I select a customer, I want that the fields in the invoice are automatically filled in . (Adress, zip, city, phone).
View 2 Replies
View Related
Sep 6, 2005
Hi guys,
I've run into a little problem while working on a electronics component database:
My plan was to use one specific table for each kind of components, i.e. resistors, capacitors, transistors etc as the specific data of each type is quite different from the other types (resistance/capacitance etc). I also thought I'd use a main form with a drop box allowing the user to choose which component to look for and then a component type specific subform to let the user make a more detailed search.
The thing is that I'm not quite sure how to call different subforms based on the drop box selection (I guess I need a subform for each type of component)? Or can I call a table with each component's specific data types and generate a subform based on this table? (I'd prefer the latter...)
To find a specific resistor you might want to specify the resistance, the type of resistive material, size and tolerance whereas an integrated circuit requires information on type of circuit, package, size etc.
All similar questions I've found relates to the use of a single, main, table only, I can't really see how to do that here...
View 1 Replies
View Related
Jan 30, 2015
I would like to have Access launch an Outlook email with a specific font (Arial). How could that be accomplished?
Here's my code:
Private Sub cmdEmailAO_Click()
On Error Resume Next
Dim OApp As Object, OMail As Object, signature As String, Email As String, FirstName As String
Set OApp = CreateObject("Outlook.Application")
Set OMail = OApp.CreateItem(0)
[Code] ....
View 9 Replies
View Related
Jul 2, 2014
I'm quite new to creating a database. On my navigation form, I have a dropdown list/combo box that contains up to 16 possible selections. The user should be able to select more than one item, but can't, when using the navigation form. In the man form that this 'writes to' the selections can be made, with checkboxes in front of each item in the list; but not in the navigations sub-form. the Navigation sub-form only shows the list in a column. I don't see any properties that explicitly allow more than one suggestion or restrict to only one, so am I using the correct control?
View 3 Replies
View Related
Nov 10, 2014
I have a form with a command button that runs a report. I have been asked to modify things and if the data in the text box is "A", run report "A". If the data is "B", run report "B" and so on.
View 3 Replies
View Related
Sep 12, 2013
I Export data by ID from Access to Excel.
Is it possible that two mgsbox will Show up, where the user can put in the timeperiod.
The time period would be the starting day of the contract.
It's called inception_date
Code:
Private Sub Befehl1_Click()
Dim xlApp As Object 'Excel.Application
Dim xlBook As Object 'Excel.Workbook
Dim xlSheet As Object 'Excel.Worksheet
Dim rstID As DAO.Recordset, tmpStr As String
Dim rstGr As DAO.Recordset, strSQL As String
[Code] ....
View 2 Replies
View Related
Dec 1, 2014
I have a form for user to select multiple items from a combo box, and 18 unbound text boxes , each time user selects an item in combo and hits "add" the value appears in txt box by order, I mean select1 then "add" filling txtbox1, select2 then "add" filling txtbox2 ... and so on till we reach txtbox18, then msg box appears that he filled the whole 18 boxe. I have already done this before for one txtbox which is a very simple operation, but i cannot figure out how to do it with multiple txtboxes.
View 2 Replies
View Related
Sep 6, 2005
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.
Any ideas/suggestions greatly appreciated.
View 14 Replies
View Related
Feb 28, 2007
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.
View 2 Replies
View Related
Apr 11, 2005
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?
View 2 Replies
View Related
Jun 10, 2005
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?
Thanks... Sprocket
View 4 Replies
View Related
Sep 13, 2005
Hi,
I have a field in one of my tables that contains IP Addresses. These addresses can look something like 142.67.214.73/24 or 192.168.196.0. I would like create a calculated field so that ALL IP addresses just show the first 3 octet's. So the first one would just show 142.67.214 and the second one just 192.168.196
Any help would be great .......
Thanks !
View 2 Replies
View Related
Jun 12, 2006
Simple query from an amateur. I have a list of people in a table, each with thier email address. How can I convert this into a list of addresses to paste into a group email? (Ideally with ";" as a separator between addresses)
View 4 Replies
View Related
Feb 6, 2008
Hello all I am using MS access for a little personal project and I have house number and streets along with a day they are serviced.
example:
unit road type day
1 main st friday
2 main st friday
3 main st friday
4 main st friday
5 main st friday
6 main st friday
7 main st friday
13 turtle st monday
15 turtle st monday
16 turtle st monday
I want to make a report of this data to look like this
unit road type day
1-7 main st friday
13-16 tutle st monday
I figure I have to do some sort of query before I can make the report im jsut not sure how to seperate it or what symbols to use. I know this is faily simple I just can not get the computer to give me what I want....
ok I think i figured it out what I did was take unit and I put it in 2 times one fo min and one for max and then I grouped the road by ascending and it worked out
View 1 Replies
View Related
Dec 14, 2006
Please please please!
It's driving me crazy!
Is it possible to send e-mails to all of your e-mail addresses in one single e-mail?
Right now I am able to open up an individual e-mails for each of my stored e-mailo adresses but it would be so much better (and more user friendly) if I could just have one e-mail with all addresses in the To: field.
Any help would be really appreciated.
Rob
View 3 Replies
View Related
Feb 20, 2007
I need some input on what to use for a field that contains a range of IP addresses, and have it sort numerically by octet. I currently have that field assigned as text, but were not happy with the sort order. I've played a little with the number format type, but still did not get the correct sort order. Any suggestions would be appreciated. Thanks
View 2 Replies
View Related
Mar 24, 2008
My database is a maintenance record of our building complex. The unit/building number is the key field. The problem I am having is having access recognizing the unit numbers and building numbers, not as whole numbers.
Example: I-380, 10-380, 2-390, 13-370, and so on. When sorted, access treats them as whole numbers. I have tried two separate fields but it would be nice to have only one field and be sorted by building numbers.
I am not a coder so be gentle.
Can you help?
View 9 Replies
View Related
