473,320 Members | 1,961 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

I need some advice on creating a manifest database that autofills on a acc number.

Hi, I've only ever used Microsoft access once, this was a few years back and my knowledge of Access is limited to the basics.

Basically every day we hand input atleast 10 possible 30+ address into a microsoft excel speadsheet, then print and fax to the courier company. I would like to create a database that when I enter there account code in one box, it auto fills there address and other relivant details. I've exported my Sage customer database to excel and inported it to a table in access, I've created my form. I just can not remember how to create auto fills on an account ref.

I guessing its a combo box but when i do what i think will work its not.

Can somone please help. Im using version 2003.

Regards

Glen
Apr 6 '09 #1
9 1886
ChipR
1,287 Expert 1GB
The easiest way to do this would be to drop a combo box in the Form Header, and use the wizard with the "Find a record on my form based on the value I selected in my combo box." option.
Apr 6 '09 #2
Hello, Firstly thankyou for your help. I hate to sound like a total noobie. but where is the "Find a record on my form based on the value I selected in my combo box." option located. I can't locate the wizard.


Regards


Glen
Apr 6 '09 #3
ChipR
1,287 Expert 1GB
Is you form bound to a table? If it's not, you won't have this option as the first step in creating the combo box.
Apr 6 '09 #4
It's ok, I've done it now, I was using Design view not the widard. it work now fine. when I print will it print the form header? or just the details?

Thanks again

Glen
Apr 6 '09 #5
ChipR
1,287 Expert 1GB
You can set the properties for the Form Header section. The "Display When" property can be set to Screen Only, then you won't see it on the printout.
Apr 6 '09 #6
Ok brill, I've just made a working versions and its all working great. However I want to be able to have four differnt companies and there addresses on the manifest, other wise its going to create a need for more paper to be used. I've tried creating other combo boxes and more fields but all it does is change both addresses and doesn't seperate for differnt companies and addresses. Do you know how I can make a combo box specific to fields I select or is there a way I can have a tick box to select what fields I'm editing?


Regards


Glen Aka Noobie
Apr 7 '09 #7
ChipR
1,287 Expert 1GB
Right now you are working with one recordset, and the combo box is taking you to the appropriate record. If you want to have 4 different records on one form, you would place 4 subforms on your form, one for each recordset, and link each of them to a different combo box. Then the main form would not be bound to anything, it would just contain the subforms.
Apr 7 '09 #8
When I go to create a combo box in the sub form it doesn't give me the "Find a record on my form based on the value I selected in my combo box." option. Is there no other way of doing this with out subforms? it's just that I have to fit this on a A4 sheet and If I use subforms it will be huge.


Regards


Glen
Apr 7 '09 #9
ChipR
1,287 Expert 1GB
Make sure you get this working, and then copy the process 3 times.
  1. First, the main form will be unbound. Remove the data source, or preferably just start with a new form.
  2. Make a combo box on the main form (not in the header) and set it to look up the values in your table that you will select from. We are no longer using it to move to a record in the way that the wizard was.
  3. Give the combo box a name that makes sense.
  4. Make a subform based on your recordset.
  5. Go to the subform properties and in Link Master Fields put the name of the combo box.
  6. In Link Child Fields put the name of the field in the subform that will be chosen in the combo box.
Now, when you choose a value from the combo box, the subform will filter automatically to that record.

Subforms in form view do not take up the space they appear to in design view. If you can fit 4 records on a sheet, you can show them in subforms.
Apr 7 '09 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: nmac | last post by:
Hi all, hopefully someone can offer some sagely advice regarding Production use of Jakarta's Tomcat. First, some brief background. My company have a servlet application that connects to a MySQL...
3
by: sandrina | last post by:
Hello everyone, My name is Debi and I am an Administrative assistant with a large company in their sourcing department. I was hired one month ago, and walked in to a HUGE filing nightmare. My...
9
by: Laban | last post by:
Hi, I find myself using static methods more than I probably should, so I am looking for some advice on a better approach. For example, I am writing an app that involves quite a bit of database...
5
by: Ekempd | last post by:
Hi I need some advice about this situation an how I'm current handling it I hava a ASP.NET solution that in some point start multiples lenghty verification agains diferent databases, my big...
3
by: Richard Lewis Haggard | last post by:
We are having a lot of trouble with problems relating to failures relating to 'The located assembly's manifest definition with name 'xxx' does not match the assembly reference" but none of us here...
1
by: Ben | last post by:
Hi, I come from classic asp and i need some advice for this application. It's about a computer reservation system in a school. I want a page where a student can see his own made reservations,...
4
by: Jerry | last post by:
Hello! I'm creating an application where users can enter their hours worked on certain projects and have them saved to a database. Right now there are about 60 different projects and that number...
11
by: Alan Mailer | last post by:
A project I'm working on is going to use VB6 as a front end. The back end is going to be pre-existing MS Access 2002 database tables which already have records in them *but do not have any...
1
by: TexCube | last post by:
Hello everyone, I have an urgent question. Can data be pulled from an access database table to create a directory that can be printed out and bound together? I need to have each row of a...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.