I Want To Duplicate Info Automatically

Jan 14, 2005

Having a problem where information from staff worksheets has some constant data and other info is static.

I have added file for your viewing. The Propagation form 1 is the original form I was using to input the data, this was time consuming. I am trying to upgrade the form so that constant data can be entered in once and static data entered onto a sub table within the for.

Problem is that when I view the table to make sure everything is working the constant data is only recorded for one record not the balance(pls go to last record to see problem). ie date is not repeating in propagation table

Can ANYBODY help with this as this problem occurs in other forms as well.

View Replies


ADVERTISEMENT

Duplicate Info In Table

Dec 14, 2004

I've got a huge table with one column that shows a lot of duplicate
info in it. How can I let it identify the unique names and "hide" all the
duplicate info that falls under it e.g.

Columns:
Col.1:Fruit Col.2 Col.3
Apples A 1
Pears B 2
Peach C 3
Apples D 4
Apples
Apples
Pears
Pears
Pears

I would like the table only to show the say Fruit column with Apple, Pears,Peach
and list when you click on it all the related data to it. Along with this I would like to
associate all this info in the form. If I select Fruit in the form the related data should appear
below in maybe a subtable or something which I should be able to select from which info I need.

View 4 Replies View Related

Creating Equipment ID's Automatically From Departmental Info

Jan 17, 2005

Hello,

I am starting to get further into access development, originally i started from a sample database and have been teaching myself as i go along. This database has come pretty far and the farther it comes along the more my company demands of me from it!

either way, it is basically a database that holds all of our asset information, equipment parts, workorders and preventative maintenance. We've been plugging along just fine but I want to help their productivity and have access automatically create "Equipment ID"'s from information that is entered by the person adding an asset. I would like it to create an ID from Entry of the Department, Location, and then a 4 digit Autonumber after that.

Basically we have a few basic departments, IT, Facilities, etc. and a few locations... So we have been setting our equipment ID's like this:

AA - Two characters for the Location
BB - Two characters for the department
0000 - numbered field

So I really would like to be able to create these automatically instead of manually typing them in to a text field with an input mask.

AABB-0000 to automatically create entries from the departmental info, location info and then automatically create a 4 digit number in order to follow it.

What is the best way to do this? Keep in mind I am just barely able to do any code, I only have been going from what i see in the database and building upon it and learning a few bits and pieces of code from there. So if you start going into a code explaination go slow~!

Thanks,
Jim

View 4 Replies View Related

Autopopulating A Form With Duplicate Info

Oct 27, 2005

I have a form with two fields, work_email and home_email. If after entering work_email, I would like to click on a check box if the home_email field is going to be the same information and have it copy what I entered in work_email into home_email.


Please help!
:confused:

View 1 Replies View Related

Forms :: Stop Duplicate Info From Table A To B

Apr 3, 2013

I have a database that lists all the books I have read. The Table "Books" holds "AuthorId' "Title" etc. I have another table that is called "Whats Next To Read" which I store the next book that I will read from that author. It also uses "AuthorId" and "Title" etc. In the form, how can I look to see if the title put in for that author in "Whats Next" does not have the same title already in "Books" table. I can use Dcount to find the title but it could be same title different author. I need same title with same author.

This is what I have so far.

If DCount("Title", "Books", "Title = '" & forms!Whatsnexttoread!Title & "' > 0 Then
Msgbox "Title is already in books.", vbInformation
End If

I need it to only look at the same author.

View 3 Replies View Related

Forms :: Duplicate Form Opens But Area With All Info Is Blank

Jul 2, 2013

I just copied a form from one database to another and for some reason the copied form in the new database does not display. the form opens but the area with all the info is blank... When I choosed design mode it all shows up correctly but in form mode it is just blank.

View 3 Replies View Related

Update Order Info Based On Quote Info

Nov 7, 2006

I need help on this, from what the best concept is, to what I need to look into using:

I store Quote data from phone calls into tblQuotes. There is a seperate table that holds much of the same information except that it is for actual orders called tblOrders.

As far as function goes, I have each working much the way I need it to except for one thing... If a sales person is on the phone with a customer with a quote already in the system, right now they re-enter the data into the Order table. Most times, the order is what was quoted, but maybe with a few small changes (so I will wnt to keep a historical record of the quote). How could I copy the contents of the quote recordset into the recordset for an order, where all the sales rep does from there is edit the quote to the actual order?

Would I use VBA or an update query that is executed via VAB? Honestly, I am unsure how to do this at all, I hope someone has seen this before and has a good suggestion...

Thank you.

View 2 Replies View Related

Forms :: Prevent Duplicate Values With Alert After User Enters Duplicate Value

Dec 30, 2013

We are working on an Access (2007) database that is on a SharePoint Site (2007).

Currently the form is operational, but there is one last thing that would be nice to have.

The table is "Updated Headcount" which contains "EMP_ID" which are unique numbers stored as text.

In the event a new employee is entered in the system by another user on this site we would like to prevent any duplicate "EMPID"s from being entered and saved on the SharePoint, we would also like to alert the user and prevent the data from being saved.

All data is currently bound, so once the user makes a change it is made, no submit button is required.

We are running into some difficulties in doing a dlookup from the value entered and comparing to a column in the table.

TABLE - UPDATED HEADCOUNT
COLUMN in UPDATED HEADCOUNT - EMPID
FORM CELL user will input an EMPID - newEMPID
FORM CELL used for a dlookup to compare what user has entered to what is already in the table - duplicateEMPID

So below is what we are trying to do, we are sure there are a few commands missing....

=IIF(newEMPID=dlookup([UPDATED HEADCOUNT]![EMPID]), newEMPID, "Error, EMPID already exists")

View 11 Replies View Related

Need Info Again

Sep 21, 2005

is there a big diffrence between vba an vb.

Would you be able to have the same databasing power in vb.

a company offered me a job but they would prefer if all my programs where in vb, but i have never even lokked into it. i know there are a few extra thing like menus and stuff like that.

Would i be able to say that since i know vba i would be a ok candited?

View 4 Replies View Related

Need All Info In One Row

Nov 10, 2007

I have a query that creates 8 columns, exactly as I want. However, the information in the last 2 columns, Dbk and Com, I'm trying to get on the same row. Right now, when the query is run, the Dbk amount shows up on one row and the Com column is blank, then the next row shows the Com amount and the Dbk column is blank. Is there a way to get both values to show on the same row? Thanks.

SELECT tblCorpCodes.[Client Code], tblCorpCodes.[Client Name], tblCorpDollars.[Month/Year], tblCorpDollars.[Invoice #], tblCorpDollars.[Drawback Entry #], tblCorpDollars.[Claim Ref #], IIf([tblCorpDollars]![Income Type]="Drawback",[Amount]) AS Dbk, IIf([tblCorpDollars]![Income Type]="Commission",[Amount]) AS Com
FROM Query4, tblCorpCodes INNER JOIN tblCorpDollars ON tblCorpCodes.[Client Code] = tblCorpDollars.[Client Code]
GROUP BY tblCorpCodes.[Client Code], tblCorpCodes.[Client Name], tblCorpDollars.[Month/Year], tblCorpDollars.[Invoice #], tblCorpDollars.[Drawback Entry #], tblCorpDollars.[Claim Ref #], IIf([tblCorpDollars]![Income Type]="Drawback",[Amount]), IIf([tblCorpDollars]![Income Type]="Commission",[Amount])
HAVING (((tblCorpCodes.[Client Code]) Like "566") AND ((tblCorpDollars.[Invoice #]) Like "7315"));

View 14 Replies View Related

Deletion Of Certain Info Within A Row???

Aug 4, 2005

Hello Gurus,

I need to perform a massive deletion within Access and I want to find out if there is a simple piece of SQL that can be written to complete this task.

Example:

I have a table called GAB - one of the columns is called email addresses

Currently all the email addresses look like this: m14.dpitts@****.com

I need them to look like this: dpitts@****.com, so all I need to do is remove the 'm14.'

Is there something within Access that will accomplish this?? Kinda like substr in Oracle?

Any help would be great!!! :)

View 3 Replies View Related

Info About 'like' Operator From Help

Sep 26, 2005

I am new to this forum, so forgive me if this question has been asked before

I needed exact information about the way the 'like' operator works, so I pressed F1, typed 'like' in the "Answer Wizard" and was told to "rephrase my question". :eek:

The index was slightly more helpful as it obviously contains 2 topics with 'like_operator', but choosing them does not reveal anything. :confused:

Where can I find info about such things?
I also need to use an operator called 'contains' which I have used when working with SAS, but appearently it does not exist in Acccess or it has another name. Has anybody heard about it?

View 2 Replies View Related

Merge Info

Jan 17, 2006

I have 3 tables: tbl_1, tbl_2, tbl_3
All 3 have the same 3 columns: name, email, code

Can I write some queries or a code or something that can create one "tbl_MASTER" with the same 3 columns?

Ex:
tbl_1 - 3 records
tbl_2 - 7 records
tbl_3 - 21 records

tbl_MASTER - 31 records. Now the information in the other 3 tables changes everyday so I want it to all be automatic, I dont want to execute 3 different queries or anything like that. Is this doable. Thanks.

Travis

View 9 Replies View Related

Info On Recordsets

Nov 21, 2007

Hi All,

Can someone point me in a direction to get some good information on how and when to use recordsets? Ive gotten by without having to use them for the most part up until now.. but the inevitable has happened and i figure i might as well learn to use them

for the most part i know When to use them, but its getting into the how and where to use it for the most part.

simple examples or even perhaps a tutorial would be great! thanks guys

View 4 Replies View Related

Getting Table Info From Another DB

May 13, 2005

Guys i have tried to seach the Forum but can't find a solution to my need.

I would like to get a collection of table names from another DB, what i am trying to do is populate a table with a list of table names that the front end links to and their paths once a user has selected the data file location.

Instead of me having to force a user to place the DB files in a location of my choice when the database first loads it will prompt the user to select the location of the data file then (this is why i need the above) populate a table with a list of table names and their source, then establish a link to them for the front end to work.

Also if i ever send amended DB files or they move the location of the data files they can automatically re-establish the linked tables.

Hope this makes sense.

Cheers guys.

View 3 Replies View Related

Info Gathering

Aug 28, 2007

Hi,

I have been struggling with a project and cannot seem to get a solution. The following is a bit drawn out so I apologies, but if anyone can help - (or tell me if it is not possible) I would be grateful.

I have a club DB with 42 members, and have a table with members details etc.

They meet 12 times a year and I have a table with details of the meetings (each meeting is a separate record with date, venue etc)

I use forms to view the records.

What I would like to do is be able run a query/report to see who attended each meeting/or how many meetings an individual attended over the year. (I have not got to the query/report stage yet, as I cannot figure out how to set up the information).

(I need to know each year how many meetings an individual attends)

I thought of putting a list of the members and a tick box next to their name on each of the 12 meeting records, (which will update when members join/leave) then be able to run a query with the name of the member, and the dates (or number) of the meetings attended, but don'y know how.

At the moment all I can think of is a memo field, and just type in their names on a specific meeting record.

Any help would be gratefully received

Regards

Adrian

View 2 Replies View Related

Last Record Info

Jul 19, 2005

I have a table for Contact history.
All data ca vary except for two fields The ID wich will be multiples of and the election date.

I want to display the last contact info we have how can I do this.

View 2 Replies View Related

Info From Two Columns In A Third

Jan 22, 2008

Hi!

Say I have a table/qry:
ID | VARIETY | PRODUCT
1 | Fresh White | Garlic
2 | Fres Valencianita | Onion

Is therey a way to merge variety and product? Cause I want to make an invoice description with a text that can be made out merging fields of a same table/qry.

Sth like the following:
"[QUANTITY] of [VARIETY] [PRODUCT] from [COUNTRY], size: [SIZE]...."

I saw a topic about listing items horizontally but I think it was kinda different from what I wanted, specially cause involved more than one table.

View 2 Replies View Related

Info About A Control

Aug 4, 2005

I have a form with some controls, and for some of the controls, I would like to provide some info, when a user key presses a particular key. I would like that when this assigned key is pressed a small box will pop up providing the relevant information. However, for this feature i do not wish to use the msgbox, to provide the information in, but i would like to use something as those "white boxes" which are normally used in help files (the ones that normally describes a definition of a particular term).

Can this be done in access, and if you kindly could you point me in the right direction.

Thank You for any feedback.

View 2 Replies View Related

Retrieve Info.

Mar 21, 2007

Hi,

Suppose I have sharing drive, let's say "\server1sharefolderDatabasesdb1.mdb"

if I run this CurrentProject.Path inside the database file, it will retreive the current path with drive letter, but how can I retreive the server, and sharefolder information?

View 1 Replies View Related

Finding Info In Another Table

May 11, 2005

Please note that I am self taught (90% of what I have learnt has been off these boards!). I did make this form with info I found on this forum.
I am having problems with a log in box for a database, the line of code is -
If Me.txtpassword.Value = DLookup("password", "customers", "[customerID] =" & Me.EbayName.Value) Then
This code is in a Form; "password" is the value in the table of "customers"; [customerID] is the primary key value I wish to remember; Me.EbayName.Value I assume is the value in the table that access is looking for.

Questions -
A) It is not looking up the value for [customerID] - what have I done wrong?

B) In the line of Me.EbayName.Value what does the 'Me.' part tell Access to do? I assume it's a pointer to it's own form? What part of the line do I need to change to make it point to another form (or table)?

C) When this is finished how do I get the program to remember the 'customerID' while the customer is fillling out other forms?

James

View 2 Replies View Related

Options To Get Info From Tables

May 16, 2005

It seems that there are a few different ways to get info from the tables when developing an applications that i know of:

1)queries
2)dao
3)ado
4)selects without any of the above

I lean towards the last 2 but I need to know this: is there any advantages in using ado as opposed just sql?

For instance i ran this sql:

Private Sub Command0_Click()

Dim SQL As String
Dim strCriteria As String

strCriteria = Forms![form2]![Text1]



SQL = "SELECT * FROM Table1 WHERE (((Table1.clinic)='" & strCriteria & "'))"


DoCmd.OpenForm "frmClinic"
Forms![frmClinic].RecordSource = SQL
End Sub

it worked fine. I could see how a beginner would prefer to use queries over sql but I would prefer to use sql in vba. I've read that dao is older and I should use ado instead. So that leaves ado vs. the way I displayed it in the above code. So which way should I go? If I'm over looking queries or dao in favour of ado/sql, just point out their advantages if you don't mind.

Thanks,

scratch

View 4 Replies View Related

Getting Existing Info To Different Table (same Db)

Aug 8, 2005

I have an inventory table and a repair table for computer equipment. The inventory table is already set and working with all the data I need.

In the repair table, I would like to just enter the ID number and have some of the information already stored in the inventory table automatically entered into the repair table as needed.

For example, computer 138 has repairs done to it. I would like to then go into the repair table to add a new entry, type in 138 and have the some of the data from inventory table (model, serial number, etc) transfer into the repair table.

Is this possible with Access?

I have only been able to do something with the lookup wizard, but that doesnt seem to work well.

Can anyone point me in the right direction?

View 1 Replies View Related

Get File Info FROM Properties

Dec 4, 2005

Can anyone tell me a sample code on how to write/develope the Advance file properties like....

File version
Description
Internal Name
Product name

I have seen different types of files properties some has additional features while some has none - its just click once on any file and then click the right hand side mouse button and select the properties that will display all the information about the files click on second tab version (if there) will tell you the additional info about the file.

View 3 Replies View Related

Automatic Computer Name Info

Jan 24, 2007

How would I get Access to autopopulate a table's text field with the user's computer name when they enter data into a form? The user shouldn't have to enter this...

View 4 Replies View Related

Business Info Systm

Jan 24, 2007

Hi. I'm a freshmen currently in college and I'm taking business info systems right now... and well I'm just being paranoid. Anyway, i really hope this isn't at all too confusing or anything... but

For a hw assignment we where sopposed to like dl this database and just do random commands on it. Anyway, we're sopposed to save it at the end... and email the file to the professor who will grade it.

Anyway, I asked her how she would know if we actually did all the steps and shit... and how she could tell (esp if the directions where like... "1. filter this out." then "3. take out the filter."

she replied that access "saves" all the actions in a database in the document so she will be able to see all the actions that we took.

I did all the assignments, and I'm just being paranoid about my work right now... since it's the new semester and the teacher is SO NICE but very picky when it comes to grading.

My question is just to ask if anyone knows the "secret" command/function/button or whatever you do to basically do what the professor would do to grade my database / ie see that I did everything.


I just want to check to see all my work is good before I submit it to her.


Thank you so much for your time and reading this. :)

View 1 Replies View Related







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