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)

Thanks

Norma

View Replies


ADVERTISEMENT

Select Data From Double Clicking

Dec 29, 2006

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

View 7 Replies View Related

Moving The Data Base Window

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

Data Base Creation, (Redundant Value Entry)

Jan 2, 2007

Hello,

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.

Thanks

View 1 Replies View Related

Double Clicking In Datasheet View?

Aug 26, 2006

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?

View 1 Replies View Related

Double Clicking Query List Box Results

Oct 18, 2006

Hi,

Does anyone know how I can set up the following?

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.

Many thanks

View 2 Replies View Related

Forms :: Cannot Open Form By Double Clicking List Box

May 3, 2014

When double click the entries given in the attached database I cannot open the correct form. it gives parameter value.

View 4 Replies View Related

Modules & VBA :: Mandatory Data Entry In Field Before Moving To Another Field

Aug 22, 2014

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.

View 3 Replies View Related

Clicking On Name In List To Move To That Entry In A Table

Jan 31, 2006

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.

View 5 Replies View Related

Update A Form Field By Double Clicking A Query Field

Apr 25, 2013

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.

View 6 Replies View Related

Double Entry Accounting

Sep 5, 2005

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

View 9 Replies View Related

Double Entry Accounting DB...

Sep 7, 2005

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

View 4 Replies View Related

Double Entry On Forms?

Dec 7, 2005

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?

View 5 Replies View Related

I Would Like To Use The Data Base For...

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

How Set Up Data Base....

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

Data Base Help

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

Zip StoraGE/ DaTa BAsE

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

Creating A New Data Base From An Old One.

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

Call Out Data Base

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

Data-Base Demo

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

Sample Data Base Request

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

Inspired Data Base Design

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

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 3 Replies View Related

Add Write A Letter To Data Base

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

Data Base Left Open

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

Help Sharing Simple Data Base.

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







Copyrights 2005-15 www.BigResource.com, All rights reserved