Part List Data Base
Mar 25, 2006
I am trying to create a database to create a purchase list of parts for a final assembly. There are several subassemblies that make the final unit. There are also subassemblies within subassemblies.
I want to be able to create a list of parts for purchase for the completed unit.
I have a table of part numbers that assigns part numbers to parts as ewell as subassemblies. in this table there is field that designates what type of part it is, System, assembly or base part. I am trying to query the "system" to get a quantity of all base parts contained in it. The feils in the table are part number, part name and what type of part it is.
I am having trouble with the queries or what should be in the table.
View Replies
ADVERTISEMENT
Dec 16, 2004
I have what I think is a difficult problem to overcome...
I am designing a form to create an invoice. The user will select a workstream and a date range in form frmInvByHrs. Within this I want two sub-forms, one is frmInvByHrsTsht and the other is frmInvByHrsBill. I want the first one to display all the staff and their hours done, and the second one to be in data entry mode where you can enter the hours you want to bill. Each sub-form is based on a separate query.
Is it possible to do this? ie. to have one sub-form in data entry mode, and the other not? It seems to me that the data entry mode is controlled by the MAIN form regardless of the sub-form settings!
If this is not possible, do you know how I can acheive this?
Thanks
S
View 1 Replies
View Related
Jan 29, 2006
See attached database
List box connect to qryInsurance
Main Form Employees
1st Question is how to i add a wild star character so that if a user types a all insurances starting with that letter letter a will show up in the list box
User Type B, c d etc etc
2nd Question if you take a look at the main form employee you will see to text box One called Primary Insurance the other called secondary insurance
followed by a hyper link
The hyperlinks open the list box
What i want to do is when a user double clicks Insurance name from list box it will insert insurance name into text box
View 6 Replies
View Related
Jul 11, 2006
Hello all,
I am a new registration chair person for a small convention for 200-250 persons.
I would like to set up a database that I can access to print out address labels and name tags, by selected specific cells or sections.
Is there a way to do this with a Microsoft Database or Spreadsheet programs?
Any help would be appreciated
Thanks
Leneda
View 2 Replies
View Related
Dec 13, 2007
I am just beginning to design a small data base, where end users will mainly use an Access Form to search and view data.
The (lab) data will be arriving to our group occasionally over the next 2 years, and will be put into an Excel file (formatted the same, each time). The new data could be appended on the end of a master file...so I could link just one file to a table in Access. I need to build a Form, based on this data.
But, I am not sure if I should link the file from the beginning (since I've read that I cannot change data types or field sizes, if I link)....
Maybe I should import one existing file, manipulate the table parameters as needed, then design my Form....then link later?????? :confused:
what would you do in this situation?
thanks!
View 6 Replies
View Related
Oct 29, 2004
I am very new to Access, I do work for different companies inputting data.
I usually use excel and then I have to retype the information into another database.
One of my companies is a school. I have to print certificates when the class is complete, but what I'd like to know is,
is there a way I can take the names of the students and using Access just have the names appear on the certificates without having to retype all of the names individually?
I would appreciate any information you can provide for me, this sure would save lots of time.
I hope I explained my question clear enough.
Tim
View 2 Replies
View Related
Jul 6, 2005
(this is a repost )
I will skip the basic intro of "Hi im new to access and i dont know.."
anyways, what I am trying to search for and I dont know what Im looking for is this.
Q1) I would like to be able to open a zip file, read the NFO/txt file from within and import certain areas of the NFO file,the NFO file of course is layed out with ascii art but there is a predetermined area where certain info is obtained. for example: I would like to capture/import the URL, testers name, date avaliable, zip file name.THEN the text imported would be written to the database. It would be nice to figure out how you go about importing certain lines but im not sure how to ask the question and find the answer the right way. ie...(ascii art found here http://www.ascii-art.de/)
-= I did search import text and get text and didnt find what I was looking for=-
Q2) How do I write to an ascii file/nfo/txt using access, there is a template or a layout that is pre done,and i need certain fields filled out, just like they above layout.
thanks for all your help, you guys are awsome, and keep up the good work!
View 6 Replies
View Related
Nov 8, 2005
I want to create a new data base from an existing one in Microsoft Access. I want to use all the fields but not the data. Can I do this? I also want to keep the form that I created. Can anyone give me suggestions? Thank You!
View 1 Replies
View Related
May 21, 2007
hi i want a call out database with a calender with blocks in to represent slots booked and free, with a form with time start, duration (default 60mins) address, work to do, and milage. and the a report for the customer to sign. i have tried for about 6 months with different ways and means, to no aval, it would help if i had som knowledge of vb programing, ect, i have basic knowledge of access, eg add data, search data, and reports. please can someone helpme design one, as i would be very greatful, thanks in advance
View 2 Replies
View Related
Jun 3, 2007
Hey,
I'm from Portugal, i need asap a Access DB demo - example about a DB that controls Hotels reservations.
Is there anyone that can help me?
My mais is E-Mail address blocked: See forum rules)
Many thanks
View 1 Replies
View Related
Jan 2, 2006
Does anyone know of a simple database for investment tracking. Basically, investment names, buy and sell dates, and return info?
View 1 Replies
View Related
Jan 13, 2006
Hello All,
So much has been discussed on the main boards about the techniques available to solve technical problems.
When you read books on data base design; much is discussed on the structure of databases and much more is left out concerning how people actually work. A properly designed data base enhances work flow and changes workers bad work habits into useful and efficient ones.
My primary market is emerging small businesses. Typically my customers have been using spread sheets and Quick Books to keep track of ordering, scheduling, resource allocation, and accounting.
As you can imagine it’s a disaster. Individuals in the company have spent much time working out their problems in Excel. This poses a real challenge, many of the user are very emotionally attached to the existing non-system, and they are often determined that the “new database” will function in the same way as their tried an true spread sheets.
So to open the discussion.
I’m curious. What do ya’ll do to ameliorate this and what is the general theme you prefer when creating a system for people that have never had one before?
View 3 Replies
View Related
Feb 5, 2006
When pressing F11 to access the data base window, somehow I have docked it in an awkward position on the screen where as the top of the box containing the minimise, maximise and close button are not visible, how can I drag the data base window to the position I want i.e in the centre of the screen? :confused:
View 4 Replies
View Related
Dec 3, 2006
I am developing a membership data base from a MS Template. It aleady has the means to print member lists and invoices, but no letters. I would like to also have the capability of writing a letter to one or all of the members directly from the data base.
View 4 Replies
View Related
Feb 1, 2008
How can I stop agents from leaving a database open after they have finished there days work. I maintain and modify a database from home, but some agents forget to close the database at the end of the day. That prevents me from doing any modification on the database. Maybe a simple message that would come up and close on a regular timed bases. Or some other simple way of reminding them to close before leaving for the night.
View 9 Replies
View Related
Nov 6, 2004
Hi i've read a few post regarding sharing db accross a network but still not too sure if i'm doing it correctly. please bear in mind i'm new to access.
ok so far i've created my database (db1.mdb) which consists of 1 table 2 queries & 1 form.
i've placed this on my XP pc which is my dedicated server, Access is installed on this pc.
i've split the data base which creates db1_be.mdb, now am i correct in thinking that db1_be.mdb is the back end file which needs to be placed on my local pc's.? i've also linked to the table & sorted out all the permmisions stuff.
but i loose my queries & form.? (on the local pc)
what i really want to be able to do is store the database on my XP (server) pc & each user only requires the form to be available strickly for data entry only.
i may need to modify the form or queries at a later date but this will be done from 1 pc. am i on the right track.?
many thanks for any help in advance.
John :confused:
View 8 Replies
View Related
Sep 16, 2004
What access and vb, are all about are images - I want to display in vb, form containing bit map images.
I am trying to display on a vb form data that is stored as a bit image in an access data base- (the image is stored as a ole object in the access data base). I have tried having the object linked and also tried embedded in the access data base.
It displays just fine on the access form running under access. However, when i open the file in vb do the select, then the movenext, and then try to assign the value of the field to a picture variable and other types of variables i come up with a data type mismatch error -
this is a repeat of an earlier post, but i'm hoping this wording might get a better response
thanks
View 1 Replies
View Related
Nov 12, 2004
OK, here is my situation. I am just starting out with Access, so please be patient:
I have a database which keeps track of two things: Student Information and Student Visit Information. The student information keeps some general information about my vistors, and is rarley added to, with only one entry per student, while the Visitor Information has new data updated regularly, when people come in.
Basically, what I want to do, is create some sort of Report, in which, if I want to pull up "Billy Bob", it would bring up not only his information but also all of his visiting information. Here's the thing--the Visitor information has "Billy Bob"s name in it more than once, as well as everyone else who has visited:
Example:
(Student)May Alle (Visited) 10/26/2004
(student)May Alle (Visited) 10/27/2004
(student)Billy Bob (Visited) 10/26/2004
(student)Billy Bob (visted) 10/27/2004
(student)Billy Bob (visted) 10/28/2004
(student)Candy Cane (visited) 10/26/2004
(student)Candy Cane (visted) 10/29/2004
You get the idea, so each student is in the Visit Information multiple times (maybe there is a more effective way to do this, I don't know...)
But basically, I want to be able to get all of Billy Bob's info, including his visits, on one page. Something like this:
_________
Billy Bob
Visits:
(Visited) 10/26/2004
(visted) 10/27/2004
(visted) 10/28/2004
____
How would I go about doing this? Thank you!
Nathan
View 1 Replies
View Related
Jan 1, 2006
HI Sir....
I want TO Attach my ASP PAGES WITH ACCESS DATA BASE THROUGH DSN...WHAT WILL BE MY CONNECTION STRING IN ASP PAGE???
RIGHT NOW..I HAVE MENTION DATA SOURCE NAME IN MY ASP PAGE...AND MY CONNCTION STRING IS.....
conn.connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Mydb.mdb"
..........
Now..i want to connect through dsn...plz tell me what altration i have to do in my Connection string..and secondly what will be the location of my Access Data Base
waiting for ur Quick Reply
Thx
View 2 Replies
View Related
Mar 1, 2007
I have a data base which is lying on server - back end and front is on 17 machines. Because of some firewall restrictions, I have to put front end on user's machines for better connectivity. Now the problem is quite oftenly server IP changes and because of that I have to roll back all the tables and split the data base again because tables are linked thru server IP.
Is there any method to autoupdate server IP for connectivity? Or I am thinking if there is a way of making a field in one table in which I can put / change IP and automatically link is created/changed.
View 7 Replies
View Related
Nov 14, 2012
I have a master list of projects, with project reference number, project name, and nature of project.
I have also got a form for individuals to fill in details of project events, with date, time, name, and two or three other fields - also included are project reference and name. I'd like the name field to be auto filled when the user selects the project reference from a combo box; I think? (the list only shows open projects).
I'd did something similar some years ago in Access 2003 (I think) but cannot figure it out in the version I'm currently using 2010.
View 8 Replies
View Related
Jun 1, 2005
Good Day,
Is it posibble to refer data from table and using it for a application title?
I know we can used tool/startup to change a title of application but I need to combine with other data refer from table.
For example : Microsoft Access (Company Name)
+ company name is a data refer from a table company.
TQ
View 1 Replies
View Related
Dec 22, 2005
When should you backup the data base and when should you use compact and repair the data base. We have been doing a compact and repair at the end of each day's shift, but one of my employes wants to only backup after the day's shift. What is the best way to backup the data base?
View 2 Replies
View Related
Mar 29, 2008
I have been helping a friend make a data base that is essentially the same as my own but since it is being made from scratch I have tried to remove the problem areas that exist in my own.
The main problem area with this data base is the size of the main table which is about 240 fields. This limits number of records, speed being one issue with some queries that are run. I have managed to lop this table down in size by a large amount. Much of that being done by moving to different tables the records for prospects, insurance clients and personal or non insurance records. That removes many fields because each category has different description fields.
But I have a problem with the table that now holds prospects for telemarketing. There are about 30 fields that hold data that results from each telemarketing call and instead of that being 30 of 240 fields it is now 30 of about 50 fields so looks like a big deal now:D. Five of those are for the date/time of each call, and the others are the various call results and date/times, days which determine whether the record will be displayed (call backs, appointment made etc). After the call is completed clicking "next record" opens a new record in another table and SetValues the field with the required data from the "main form". So some double handling.
However, if I remove all of this from the "prospect table" I have a display problem and changing the display is not an option as it evolved over a long period to give the best calling results. The various fields are displayed in groups on the main form. It could not be duplicated with the normal subform. Perhaps a subform that was columnar would work. Although I would need to keep a few of the fields in the prospect table as they determine "if and when" are record is in the cold calling list for the day.
I could have two tables and join with query but I don't think there is much point. One reason alone being that for the vast majority of prospects there would be no records in a second table because they have not been called.
My feeling is that leaving the prospect table the way it is would be the best and easiest. But I am open to any suggestions because at this stage there is nothing hanging off the table so am I free to do whatever.
View 14 Replies
View Related
Oct 4, 2004
Im trying to create a Data Base that will allow me to keep a track of a score for Shearing Competitions.....the main aim is for the judge judging the sheep having no idea who shore it therefore no cheating can occor. Need one Table for pens (each shearer has a pen allocated to him with a certain number of sheep that have eartags with a number identifying each one). The sheep is shorn and let out the back were the judge identifys the sheep to the person inputing the data and the score without the shearers name being reveiled.
Ok now this is were I am lost I need to be able to create a report run of a query reveiling the shearers name and score for each sheep he has shorn in the heats, would be simple if I could link the table (shearers) to the table keeping scores, sheep ID etc but then they would know the shearer who shore the sheep, bring it back to square one.
If anyone has a idea on how to get around this please it would be appreciated.
Im only a basis Access user and dont know much Visual Basic.
Regards Dave.
View 9 Replies
View Related
Oct 23, 2004
I have got a dbase created however getting it to print in the order I need for the PVC Id card just is not working.
Any Ideas
thanks
Matt
View 1 Replies
View Related
