Form Creation Help

May 30, 2006

hi there,

i also need help in my form creation. as you can tell from my post, i am clueless.

anyways, here is what i want to do.

i have an input text as:

title1
name1
address1

these will grow based on how many people information one needs to enter. so say if i have 3 people i should have:
title1
name1
address1

title2
name2
address2

title3
name3
address3

and so on

the thing is i only want to show input text 2, 3, etc when i have several names to enter.

so what i want is, a button, such that when i click on that button, it creates input text 2, 3, based on the number of people i have.

i know how to do this easily with html/javascript, but i MUST do this in ms access, so i hope somebody can help.

TIA
chocho

View Replies


ADVERTISEMENT

How To Make Creation Of A Record In A Table Trigger Creation Of New Table

Jul 17, 2013

I have a table that is a list of all of my events. Each record of events should have a child table that list all of the things that happened at the event. When a new record (event) is added how can I have a new child table created and linked to that record. Also I have a blank table to serve as a template for what each child should look like. How do I make sure this occurs? The child tables can have the same name as the index. I am just using numbers 1- for the index with 1 being the first event and so on?

View 8 Replies View Related

Form Creation With Query Source

Aug 8, 2007

do you guys use a query as your data source in you form?
if not how do you build a form with mutilple tables with the same unique id.

View 1 Replies View Related

Form Creation All Records Not Shown

Sep 30, 2015

My Database consists of three tables and a linking table, tbl graves, tbldeceased,tblmemorail and tbl memorialtablejoin.

Having completed my tables and checked that the relationship data gives the correct data I decided to embark on a simple form to display all the data on a single form.

So I used the create Form option, selected add existing fields. All of my tables are shown in the fields list.

From tblgraves I selected plot and grave Id, from tbl deceased forename and surname and from tbl memorial the inscription field.

The form was created but on examination I realised that my total records was shown as 12000 records whereas tble graves and tbl deceased has 39000 records and tblememorial 17000 records

So I created the form using just tblgraves and tbldeceased and that shows my 39201 records.

If I leave form view and go back to design view and add the inscription record from tblMemorials I see the message box as per the attachment.

Not every grave or deceased has a memorial but I would expect to see my 39000 records

I've also attached a screen shot of my relationships...

View 4 Replies View Related

Automating The Creation Of Multiple Records Through A Form

Feb 20, 2007

Sorry for the long winded question but want to be sure i clarrify exactly what i'm after.

What I currently do with my database is each time we send an email or a letter or have a phone call with a contact it is logged in our correspondence database. This is achieved by creating a new record in the correspondence form by filling in the contactID of who the correspondence was made with and then filling out the rest of the details as per the correspondence fields below. This works fine at present but occasionally we do mass mailouts of information to say all the centres in a state. Instead of someone having to enter a correspondence record for each of the 400 centre contacts we have in a given state and repeat the date, time, and details information each time so that an individual record appears for each centre, I would like to automate this process.

What I envisage is something like the picture I’ve attached. Where the user could filter by either the state or maybe even select specific centres from a listbox (filter by state is the most important one) and then fill out the rest of the correspondence record and have Access automatically create an Individual record for each of those centres selected, in the Correspondence tbl (from research it sounds like I need some sort of a loop task performed?). I need these records to be added to the bottom of the existing correspondance table

Unfortunately I have no idea how I can achieve the actual creation of all these records. Creating the form and queries based on a form I am fine with.

My table structure is below

Tbl_Correspondance
ContactRefNum (PK)
CDate
CTime
StaffID
ContactID
CentreID
CouncilID
CompanyID
ContactMethod
Project
Details
FollowupReq
FollowupCompleted

ContactID,CentreID,CouncilID,CompanyID are all linked fields to their own tables.


I am a novice user so the simpler the solution the better. Any assistance you could give in this task would be appreciated.

View 5 Replies View Related

Creation Of A Word Document From The Access Form

Oct 17, 2006

Hi....

I have created an Access Form wherein i have given lots of text box and text areas...

Now i want to create a word document dynamically using the information that has been given by the user via the Access form...

I want to create a Table dynamically in the Word Document using the VB code behind an access form... Also through that code i want to manage the font of Word Document and most if its controls..

Can u plz help me in this or provide me with a document wherein i can get some info in regard to it i.e. to manage the Word using Code...

Thanking you,

with regards,
Kapil Sharma

View 1 Replies View Related

Dynamic Creation Of A Word Document Using Access Form

Oct 17, 2006

Hi....

I have created an Access Form wherein i have given lots of text box and text areas...

Now i want to create a word document dynamically using the information that has been given by the user via the Access form...

I want to create a Table dynamically in the Word Document using the VB code behind an access form... Also through that code i want to manage the font of Word Document and most if its controls..

Can u plz help me in this or provide me with a document wherein i can get some info in regard to it i.e. to manage the Word using Code...

Thanking you,

with regards,
Kapil Sharma

View 1 Replies View Related

Modules & VBA :: Prevent Record Creation If Form Is Null?

May 11, 2015

Nutshell: My user DB has one menu with 4 tabs (2 for adding records, and 2 for searching/editing records). Since the form opens up in the acFormAdd mode, Access already creates a new record (blank) before they type anything. It is resulting in blank false new records that are getting added to the table and they are getting annoying. My audit table is full of "user X created new record at this time" when it's just a blank record.

There must be a way to prevent this using VBA, but I cannot find it.

I've seen ways to disable "add new record" buttons and such, but nothing that disables Access from being smarter than me and creating a new record before I decide to.

View 2 Replies View Related

Forms :: User Creation Form - Get Primary Key And Use It In Subform

Apr 1, 2015

I am building a user creation form. I set it up like the screen shot in the first attachement. 3 different tabs.

In tab 1 you create the user which then gets a unique key (DocentenID).

Tab 2 you can input more information about the user (in a different table).

I want it to grab the primary key (DocentenID) and insert that into a field in the other table same goes for tab 3.

View 1 Replies View Related

Utilities/code To Make Form & Report Creation/Edits Easier

May 26, 2005

I am wondering if anyone can recommend shareware or free ware Utilities/code to make Form & Report Creation/Edits easier?

I'm thinking of something like Cub Editor http://www.peterssoftware.com/ce.htm or SmartForm+ http://www.aadconsulting.com/smtfrmplus.html

but alas .... I can't do anything that will edit the registry (company politics says Access and it's Wizards is plenty 'perfect' http://www.dbforums.com/images/smilies/frown.gif maybe I will convince the powers that be but not in short time)

Also the code (or forms / reports built) need to work on Access 2000, 2002 and 2003. or well-commented on how to modify as I'm only modest with writng VBA code.

Any ideas? Thanks!
Mark

View 1 Replies View Related

New Table Creation Using SQL

Apr 9, 2008

How would I archive all orders place by customer 'x' in to a new table called tblArchive?

something like:

CREATE INDEX tblArchive ON tblCustomers WHERE customername = "x" ?

View 5 Replies View Related

Counter Creation

Jun 20, 2005

Hi everyone,

Here is my problem:

I Have a form that shows bills in a continuous form. My problem is that I want to put a textbox or a label that will display a kind of counter for each bills. For example, If I have 3 bills to display, I want my label or textbox to display 1 for the first bill, 2 for the second, 3 for the third, and so on.

But I don't know how to do that with a continuous form.

Could someone help me, please...

Thanks in advance!

View 1 Replies View Related

Report Creation

Apr 18, 2005

I am attempting to create a report that the user can specifiy a contact type which is selected from a drop down list and the report will only show those records. The name of the report is "Contact Listing bu User Supplied Contact Type." I also have a form called "Report Contact Selection."
Right now I am getting only contact type of "recruiters" to appear when I run the report even when I select a different contact type. As you will see when you look at the "contacts" table, I do have records with different contact types.
I am including a *.zipped version of this database and if you should need any additional information, please feel free to ask.
Thank you.

View 6 Replies View Related

New Table Creation

Apr 15, 2005

I created a new table for my database that contains three fields. A first name, last name, and a full name field. Is there a way in the definition of the table that I can define the full name to =[TrackComposerFirstName] & " " & [TrackComposerLastName]? I'm not sure where I would define a formula in data elements of a table.

View 10 Replies View Related

Daily Record Creation

Jun 26, 2006

i have a table..

staffdayid
date
timein
timeout
notes


i want to have a feature in my database like the following..

these are basically day to day clock in times for my staff..

is there a way that everday.. a new record will be created..

eg.. on 04/06/06... i turn on my pc for the first time.. and when i view the timesheet form.. a record for today is automatically created.. then throughout the rest of the day, this form will be displayed..

when i turn on my pc on 05/06/06, the database will know its a different day, so it creates a new record for today... then i can just move back and forth throughout the days to see the details..

if i then turn my computer off for 5 days, then turn it on at 10/06/06, it still should have made records for 6,7,8, and 9th June, but they will be empty, and the record im shown is for the 10/06/06,

how can i make this?

View 3 Replies View Related

Log Creation For Editing On A Table

Dec 7, 2005

Hello,

I have created a table containing jobs that need to be done from my team (IT production). Each time someone start or finishes a job, he must fill a box that updates a specific row in the table. I want to log the time of that action.

Any ideas of how I could set this up in Access? I have tried the Now() function in the Default Value of the field End Time, but this is updated everytime I refresh the table

View 5 Replies View Related

Creation Of Two Fields From Parts Of Another

Jul 5, 2006

In a field “NAME” I have “Adam Smith”.
From this field I want in a QBE window (not in VB) to make two new fields “FIRST NAME” “Adam” and “LAST NAME” “Smith”.
In Excel there are the functions FIND and SEARCH with which I take the number of the gap “ ” (5) between Adam and Smith and with the functions LEN, RIGHTS and LEFTS I have a result.
What could I do in Access 2003?

View 3 Replies View Related

Run Query On Record Creation

Aug 9, 2007

I been tasked with a project to be written in access which I am rather unfamiliar with, web design is more my area.

For part of the project I need to copy some pricing fields from a pricing table to a new record at the point that the new record is created. The new record is created when a 'new form' button is clicked.

What I would like to know is what and where I should trigger the copy query from and what function should I be using?

cheers
John

View 1 Replies View Related

Need Help On Join Creation Query

Mar 12, 2008

Hi! Im wondering why my code below Does not work!.... any suggestion???


strStatement = "SELECT SessionData.RunNumber, SessionData.SessionID, SessionData.SequenceNo, SessionData.SubjectID, SessionData.Latency, SessionData.BeamBrk1, SessionData.BeamBrk2, SessionData.BeamBrk3, SessionHeader.SessionDate, SessionHeader.ChamberNo" & _
"SessionHeader.GroupID, SessionHeader.SubjectVariables, SessionHeader.TestDefName FROM SessionData" & _
"INNER JOIN SessionHeader ON SessionData.RunNumber = SessionHeader.RunNumber;"

getQueryname = InputBox("Enter a name for New Query?", "Enter a Label or Name for Query", "Enter Query name/Label Here", 500, 700)

Set qryEmployees = curDatabase.CreateQueryDef("getQueryname", strStatement)

View 4 Replies View Related

Editable Textbox Creation

Jan 16, 2006

I have a continous form bound to a query which also has a group by function. Is it possible to create an editable bounded textbox because Access is giving a message saying recordset not updatable.

View 2 Replies View Related

Rumors Of Creation Stamp?

Sep 7, 2006

I been browsing and I seen a few statement regarding a timestamp that displays when you create a new record so each new record would have the time it was created. What function is this?

View 1 Replies View Related

Creation Of New Record When Tab Last Field

Sep 7, 2011

I have a subform with a lot of fields in which require input. I have set the tab order correctly so they go through in sequence. However, I have found when I tab out of the last field. Its creates a new record which I dont want.I want it to either return to the first field to just stop.

View 2 Replies View Related

Automated Table Creation And Backup

Aug 17, 2005

Hello all,

I need some advice for an ASP.NET web application I am working on. I am trying to automate the making of a new table within a database and then have all records from an old table migrated to the newly made table. I would like this task to run from the scheduled tasks on the server in the way of an .exe

The new table would be created on the first day of every month, taking the name of that month. I was thinking to use an empty template table which already has all the fields, and then making a copy and renaming it to the current month.

After the new table has been created I need to copy all the records from the table that represents the previous month over to the new table that represents the current month.

Any advice would be much appreciated.

Thanks

View 1 Replies View Related

Database Locking During Query Creation - Need Help!!

Oct 13, 2005

why is it that as soon as you fix one problem another one needs dealing with :mad:

OK, the problem i have is that i have a BE/FE configuration database in a multiuser environment. I have built all the tables and the relationships in the BE configuration. In the FE configurations i have built the main forms to input data. It has no come to the point where i have begun to create the queries to allow reporting and data searching. And this is where i have a problem. I am trying to create a simply query and i do mean simple (at the moment i simply want 2 fields from 1 table and 2 fields from another table) no calculations or anything i just want it to display the data. I have tried creating this query numerous times and i keep getting the same error.

"The wizard is unable to open your query in datasheet view, possibly because another user has a source table open in exclusive mode. Your query will be opened in design view"

the above is the error i get when i use a wizard to create the query, after getting this message and going into design view i try to view the results in datasheet view and get the following error "Type Mismatch in expression"

If i dont use a wizard and create it in design view, when i go to view the results i get the second error message everytime.

If i create a query from 1 table only the query works without errors, but i always get errors when i have more than one table in the query.

Also i am the only person with the database open so therefore it is total impossible for the database to be open by another user in exclusive mode.

Anyone know what the problem might be or how to fix. Your answers will be very much appreciated.

View 1 Replies View Related

ERD Creation Of IT Audit And HelpDesk Database

Dec 9, 2005

Hello forum!

Im pretty new to access and im trying to create a database for the company i work at so that to begin with they can log details on all hardware they have.

See the image attatched, at the moment i wish to store details on there computers and also on other hardware is it ok sofar?
http://img210.imageshack.us/my.php?image=erd9xa.jpg

View 1 Replies View Related

Table Calculated Field Creation?

Feb 12, 2008

Is it possible (and logical) for me to create a table with a calculated field from 2 other fields in the same table? Example; I have a long time field (mm/dd/yyyy hh:mm:ss) aka StartTime, and a long time field EndTime. I would like to subtract the StartTime field from the EndTime field to get the total time elapsed, but in hh:mm:ss format. I can get it in hh:mm format, but I really need the hh:mm:ss format. Any Ideas? :cool:

View 4 Replies View Related







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