Moving From 1 Data Base Entry To Another By Double Clicking
Sep 19, 2007
I am new to access and all of this and trying to create a database to record livestock (budgerigars) I have put in the reletive informnation for 2 generations but would like to beable to click on a record in forms view and for the grandparents to be automatically inserted. Something like a family tree.
Also I would like to be able to double click on a entry which shows as a parent in a form view, and for the database to go directly to that entry and bring it up onto the form.
I hope someone can help and that I'm making so sense
(anyone know a good book that would help me understand all of this)
Hi all, I have a query to recall all the events related to a certain employee by running a query and inserting the staff number, I then have a form showing the details of all employees; what I need is to add a button on the form that runs the mentioned query without having to insert the staff number again as the form is already showing that employee. Thanks Marco
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:
I am using the access program to create a mailer. The fields are really basic... Name and address....
Many of the fields are going to be identical. City, state, zip code for instance.
The way we had it set up on our first try was to create the data base with all of the fields empty and to input everything over and over. I imagine there has to be a way to set it up so you only have to enter "San Diego" or "CA" once and then simply do manual entry of the names and street address.
Any help getting me started would be well eppreciated.
i have a subform which displays data depending on the criteria selected on the main form. I want to be able to double-click on the row in the datasheet view to pop up a form and display the selected row contents. is it possible? if so then what event do i have to code it in?
I have a form with a list box in it which is populated by the data from a query. What I would like is that when a user clicks on one line of data so that the line goes black and the text goes white, I would like the code that when double clicked, will take you to a form with the record displaying the same data as the one that was in the list box.
E.g. The list box would be a work queue of outstanding post items to action and when a record is double clicked on, it takes you to another form but shows all of the data for that record as opposed to just the data in the list box query result.
I have a form that users will use to add new records (customers).
There is a field named VAT_Registration_no
First of all i want some code to check for duplicates in that field only,before entering the next field.If the record exists i want to show a msgbox and set focus to the vat_registration_no field. Also I want the same thing to happen if the vat_registration_no field is empty.here is what i have tried:
Private Sub VAT_registration_no_AfterUpdate() Dim btest As Boolean If VAT_registration_no = "" Or IsNull(Me.VAT_registration_no) Then MsgBox "Please enter a Vat Registration No.", vbOKOnly, "error" Me.VAT_registration_no.SetFocus Else btest = True End If End Sub
and to all other fields:
Private Sub textfield_Enter() If Not btest Then Me.textfield.SetFocus End If End Sub
If I just press enter to go straight to the second field I dont get a msg. If I write something and delete it and press enter i get the msg but when I press ok the cursor goes to the next field. I want it to go to the vat_registration_no field again. And I also want this to happen even if dont write something and then delete it.
http://i9.photobucket.com/albums/a66/bubbajoe12345/workspace.jpgI've created a nice form for entering information into the record -- works for viewing the records as well. Here's the thing, in a traditional Rolodex you can somewhat see the names of nearby records. With this form as is, when using the arrows at the bottom to move around in the records, you can't really be sure how far away the name you're looking for is. See that mini table in the top left corner? I'd like to make it so that, when you click on a name there, the rest of the form changes to the corresponding information.
All of the rest of the form is linked through social security number. When a new person is chosen in the main body, all of the other tables change to reflect his information. Except for that single table in the top left corner. That table is unliked to the other tables and is merely sitting there on the form right now.
So, how can I link them such that selecting a name from that top left corner will change the person in the main body of the table (and thus change the other tables)?
While I'm asking, what's involved with turning this form into one of those Database Web Page things?
Thanks for all of your help, everyone, I wouldn't have made it this far without you.
I have 3 peices of data that I am working with: Group number, plans and benefit elections. On my form I have fields for the group number and plan and 2 queries. When I enter a group number the first query displays a list of plan descriptions for that group. From there I can enter the plan description into the form's plan field and that runs the second query to give me a list of valid elections for that plan. This all works fine but I want to make the plan selection a little less tedious. What I would like is to be able to double click the query field housing the plan description and have it copied to the form's plan field. I could use the ID instead of the plan description but I work in a production environment and very key stroke counts so I would really like to have a simple double click process.
Is this even possible? If so how would I set that up? I tried using the double click on event macro builder but it does not seem to have this kind of option.
My form contains fields for group number and Plan. The same form houses 2 querys, one that pulls plans based on the group number and the other to pull elections based on the plan field (not the plan query). Would like to double click a plan within the plan query and have that description populated into the form's plan field.
I have been searching the web for some examples of a double entry accounting systems made with MS Access. I havent found any that I can open... examine the tables, queries, relationships and everything else. Not that I am planning on spending a year or two building one :) But I want to know how to. So if anyone knows of any good examples please post the links for me. Thanks
I'm looking for someone who knows a bit about this one... maybe done one before. I've started a DB for an accounting system, I've worked with MANY of these over the years, but from a user standpoint. Now I'm trying a shot at putting one together, just for a learning experience if nothing else. But I would like someone to take a look at the beginning structure of the DB and let me know if I am on the right track. Any input and suggestions would be helpful and appreciated. Keep in mind there is ALOT not here yet... and some loose tables for future expansion. I didn't want to get too deep into it and find out I need to make a major change. I'll post the DB. Thanks Curtis
Hello All again,I am working on a form for my database this time and I have noticed something odd that I cant figure out. I have managed to make the following form (http://members.iinet.net.au/~a.beardsley/database/1.jpg) from a Staff Table, Activities Table and a Total Expense Query, all in the one form. My problem is that I only have two entrys in the activities (http://members.iinet.net.au/~a.beardsley/database/3.jpg) but I am recieving 4 entrys in the form. 2 of witch the totals do not add. (see other 2 entrys here: http://members.iinet.net.au/~a.beardsley/database/2.jpg). Does anyone know why this would be happening?
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
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:
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.
(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!
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!
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
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?
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.
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.
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.
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.?