General :: How To Save Multiple Records In One Go

Sep 25, 2012

I am using access around after 15 year, now I am trying to build small database for my budget purpose

Here is the situation example:

FY2013 = Total working days
Period 1 = No of working days & expected Exchange rate
Period 2 = No of working days & expected Exchange rate
so on........
Period 12 = No of working days & expected Exchange rate

Now once i done - I want to save all record in single go, plus since this budget - total working days can't be change therefore, to avoid any error made by someone, i would like to save Total working days = (Period 1 ++++++++ Period 12)

View Replies


ADVERTISEMENT

General :: Restrict Records To Update Until Save Button Is Pressed On Form

Jul 16, 2012

How to restrict the updation of a record while entering until a save button is pressed on the form ???????? is it possible without the vba ?

View 10 Replies View Related

General :: Open Save File Dialog - Select File From Text Box And Save To Selected Location

Aug 8, 2013

I need code for save dialog file ,and select the file from textbox and save it to the selected location.i have only this code and i dont know what else i can do with this because it just opens the save file dialog !

View 1 Replies View Related

General :: Create Multiple Records From One

Jun 19, 2012

I have three tables:

tblClient (for basic client information),
tblDischarge (for client discharge information), and
tblAppointments (for appointments that are added to an outlook calender).

All three tables are linked using the IDNumber from the Client table. I have a form where a user inputs a discharge date for the client.

Once that date has been added I need to add 5 records to the Appointments table for different followup times based on that discharge date (such as one month, two months, three months, etc.).

I have the code working to add an individual appointment to outlook but not 5 different ones at one time. So the question I have is how to add the 5 records based on the one discharge date?

View 1 Replies View Related

General :: Add And Update Multiple Records To Different Tables

Jan 12, 2013

I have a pretty normalized Access Database. The table that I am trying to add new records is tbl_returns and has 4 fields: return_ID, serial, reason and inv_num.

When I sell a card (or a range of the cards) an invoice including all the information is saved as a record in a new row in tbl_invoices.

If a vendor wanted to return a card (or a range of the cards) in the next visit (weeks or months later) I will accept and in most cases they want me to switch the cards with new ones. Therefore in a new invoice (different date and invoice number) I will give him new cards and return the cards that he wanted to change or return.

Now I have to assign NULL to the inv_ID field in tbl_allPins in order to make it available for sell in future. At the same time I want to have a record of the returned cards including serial number , the reasoning of return, invoice number and/or a little note about each one/range of the card(s).These are to be recorded in tbl_returns as you can see.

For instance you want to return serial numbers between 9876 and 9880 (includes 5 cards) because of the "scratch off problems" and your invoice number is 22222, using frm_returns. After you process it and then open the tbl_returns to check the result, you will see 6 records are added instead of 5. I was able to understand why it is happening (I believe so!) but I could not fix it. Also I cold not write a VBA to remove the inv_ID in front of the related serial numbers in tbl_allPins.

Also in another trial was ended up to creating the Form1. Form1 looks better (has no extra records) but I have trouble to navigate through the records in tbl_returns. There was a sub-form added but it was showing all the records in tbl_returns which is unwanted.

By the way, serial numbers and PIN numbers are each a unique number in tbl_allPins.

View 3 Replies View Related

General :: How To Divide 1 Record In Multiple Records

Nov 12, 2013

I have an order table

order nr quantity.
100 110

and a pack table

pack quantity
1 1
1 2
...
1 25
2 1...

I want to make a query that returns this :

order nr pack quantity
100 1 25
100 2 25
100 3 25
100 4 25
100 5 10

View 8 Replies View Related

General :: Creating Multiple Records (with Queries)

Jul 19, 2012

I'm working on a contact database for my company's sales efforts. It tracks interactions with prospective customers and assigns them to employees here. My question is this: For mass contact efforts (such as mailings), is there a way to create mass entries to my "Interactions" table so that no one has to enter a mailout interaction 1000+ times?

Structure of the relevant bits of the database is as follows:

Contacts Table
Interaction Table

Contacts Table is linked with Interaction table via ContactID

Queries are run to narrow Contacts by various criteria (ex.: by the employee they're assigned to).

So if I run a query to get all the contacts assigned to me, and there are 450 of them, and I send a mailout to all of them, and I want to add an interaction to those 450 people, is there an automated way to do this?

View 5 Replies View Related

General :: How To Filter Records Using Multiple Combo Boxes

Jun 29, 2014

I have a table with the following 5 fields. (Service Type), (Valve Name),(Size),(Rating),(Description).

I want to do two thing:

First: I want to select the required information from the first 4 fields using combo boxes and get the last field (description) based on the selected 4 fields. In other words, i want the record to be filtered using first 4 fields to give me the last field info.

Second: I want to store the filtered record (all 5 fields) in another table.

View 6 Replies View Related

General :: Find Records That Match Criteria Of Multiple Fields

Mar 12, 2013

Using sql or access query I would like to create an expression that aggregates the first field and I would like to see all records grouped by the relationship with another field. Let me show an example.

My query shows:

field1 field2
apple a
apple b
banana a
carrot a
carrot b
dog b
elephant b

I would like my query to now display a third field and group field :

field1 field3
apple both
banana a
carrot both
dog b
elephant b

View 1 Replies View Related

General :: Search Records Based On Multiple Check Boxes?

Jan 3, 2013

I have a table of data regarding companies (contact info, etc). The company I work for provides these companies with up to 10 different products. On my input form, I have created 10 check boxes (and thus, 10 columns of Yes/No data in the corresponding table).

Each company has at least 1 product checked off, and up to all 10.

I would like to create a combo box that lists all 10 products, and upon selecting one, a list box then populates with the names of the companies (primary key) that use that specific product.

So, for example,

Company A buys CATS and DOGS from us
Company B buys DOGS
Company C buys CATS and ELEPHANTS
Combo box options: CATS, DOGS, ELEPHANTS

If I choose DOGS, then a list box gets populated with:

Company A
Company B

and when I click either of these, the record should be brought up for the respective company.

All of this should take place in the header of the form, while the form itself can be updated based on search selections.

View 3 Replies View Related

General :: Audit Trail - Capture Occurrences When Multiple Records Selected To Be Deleted

Jan 15, 2013

I've always used an audit trail for tracking changes of records that already exist but I have had a situation come up where I now need to track records that have been deleted. For example, if I delete a record in the datasheet view.

I've seen several examples how to do this, with the most common seeming to store the data into a temporary table while waiting for the delete confirmation. If I am reading the notes correctly, it's done this way to capture occurrences when multiple records are selected to be deleted. Is this the best approach for this type of task?

View 1 Replies View Related

Reports :: Multiple Clients On Each Page - Save As PDF

Sep 21, 2014

I have a report that has multiple clients on each page. In the report, some clients have data for a specific date while others do not.

I would like to be able to Save As PDF each page to a specified folder but only if that client has data in the report. I am currently doing this in Excel, but would like to move my data and reports over to Access. My Excel VBA code is:

Sub SaveAsPDF()
Dim ws As Worksheet
For Each ws In Worksheets
If ws.Range("B66").Value <> "" And _
ws.Name <> "Notes" And _
ws.Name <> "Lookups" Then

[code]...

Which says if B66 is empty then don't Save As PDF. Is this possible to do in Access?I'm very new to Access and have never used VBA in it before.I would like to be able to create a button in a form that when I click it will run this code.

View 1 Replies View Related

Multiple Entries In A Form At Same Time And Save

Oct 5, 2011

In access 2007, I was wondering if it was possible to have multiple people enter information in a form at the same time and have it save? The database is split so that multiple people can be in the whole database at one time, but when two people enter information in the form at one time... only one of the two can save...

View 2 Replies View Related

Save And Retrieve Multiple List-Box Selections In / From One Field

Feb 21, 2005

Hi,
I’m trying to develop a form for coding data from historiocal documents into a dataset. The form is used to avoid errors when converting ‚questions’ in the codebook to the codes for later statistical analysis.
Some questions allow for multiple anwers – but need to be stored to one field in the data-table, separated by semicolon. Ideally I would have a list-box with the questions and write the codes into one field after selection. Another difficulty is, that later the data need to be read from the table and the selections should be visible in the form (if the table contains „1;6“ items 1 and 6 in the listbox should be highlighted).

I’d be grateful for tips or links to relevant sources.
Thanks!

View 2 Replies View Related

Forms :: Save User Name That Update Record For Multiple Yes / No Box

Sep 6, 2014

I am creating a form that has a bunch of yes/no box for daily task. Is there a way for access to record which user selects yes/no.

For example

yes/no box1 - user 1 completed this task
yes/no box2 - user 2 completed this task
and so on

So when i look back i can see which user complete which task. I did a bit of research and saw that i can save a user that update a record. But since this is a daily task, each new record will be a new day.

View 3 Replies View Related

General :: Updated Database Won't Save

Feb 26, 2013

I am working on a database. I changed some of the data that was already in the database and it saved without any problems - when I reopened the database, the data was still there. But when I try to input completely new data, none of it will save (it is a database of employees and their information). So, just to make it more understandable, when I change one piece of information, it saves without any problems, but when I want to add a new employee together with their information, save it and reopen the database, it is not there.

View 4 Replies View Related

Newbie Question Cant Save Records?

Nov 21, 2006

I have made a simple form this is my first form in access 2003 and when I go to save record and close out and I open the form again the inputs that I did to the form do not save. Also It wont let me click on the new record button or anything.

Any help thanks

View 3 Replies View Related

Forms :: Macro To Save New Records?

Jun 19, 2013

I've created a macro for saving records, but it's just over write on the previous record, what's the best way to save new records using forms?

View 2 Replies View Related

General :: Using Command Button To Save New Record

Dec 7, 2012

I have have a form with 4 subforms in it, one of the subforms is based on a filtered query . For a reason I can not work out I cannot get it to requery when I add a new record.

To add a new record I select from a combo box and use a command button to save the record

I have tried using this in the buttons on click event

Code:
Forms.trialcatalogueF!TrialCompetitorsSF!competitorsSF.Form.Requery

with no result, however it does kinda work in the combo's after update event, just not until I select another value.

View 2 Replies View Related

General :: Save PDF Report Into A Table (OLE Object)

Jul 6, 2013

How could I save a PDF report into a table (OLE object).

I want to click on a button, then that button should save the file into a table which formatted as OLE object ??

View 3 Replies View Related

General :: How To Repeat And Save Recurring Data

Jul 8, 2012

I need to design a simple clinical database that will allow me to collect and display recurring data. Example. Every year a patient comes into clinic for follow-up. They complete a fixed data set questionnaire, their vital statistics are recorded and any new clinical results recorded. I have created all the tables/Forms but i don't know how to automatically add a new event that repeats the same data. So far i have 5 excessive years worth of follow-up data. Sadly, I have had to make massive tables by copying the identical data with either a 1,2,3,,, to signify a different year.

View 6 Replies View Related

General :: Save Button On Form With Subform

Oct 11, 2013

I have created a form with subform on it having one to many relation .

I have created a save button on main form and edited the before update property of main form to require the click on save button to update the record.

But when i enter the fields on form and click inside subform to enter child values , all the main form data is removed automatically .

What am I doing wrong i just wanted to save only when user clicks the save button. (see the image attached)

View 6 Replies View Related

Save Function For Adding New Records In A Form

Nov 24, 2006

Hi guys and girls,

I'm fairly new to Access and I'd appreciate some help. I've built a form with buttons to open new forms for that specific record (based on queries as all the data is held in a single table). This works fine until I try to add new records. At the moment the only way I can make this work is to add the new record, shut the original form before re-opening it and proceeding on to the other sections (via the buttons I mentioned).

If anyone could tell me how to get Access to save the record before it opens the other forms I'd really appreciate it.

Cheers,
Franny.

View 2 Replies View Related

Forms :: How To Save Records To A Table Of Web Database

Mar 5, 2014

I'm using Access 2010 and now trying to save a selected record to another table which I have no clue where to find the "Code Builder" to put my code on after spending hours and hours, I managed to create a form, but couldn't figure out where to save this data.

All I need is to put this line
"INSERT INTO ResultTable (StudentID, CourseID, PaidID, Comments) VALUES (" & cboStudentSelect & ", " & cboCourseSelect & ", " & cboPaymentSelect & ", " & txtComments & ") WHERE StudentID = cboStudentSelect

Perhaps, the new Access 2010 doesn't use this or something new that I couldn't it.

Attached is the file.

View 2 Replies View Related

General :: How To Save Sharepoint ACCDB To Standalone Front-end

Feb 11, 2015

I have a sharepoint database accdw which works well as I can update something and sync it to the server, and another user with the same database can receive the changes just by syncing.

However, I want to share a version of this database with a different start up form, some restricted forms etc. If I make a copy of the accdb it creates and make changes to that, it still synchronises those changes and they affect my own version.

What is the correct way to create a different database version from my accdw?

All I want to do is take the accdb it creates, change the startup form and give it to somebody to use.

View 1 Replies View Related

General :: Save Database With Date And Time Stamp?

Aug 10, 2015

Code for saving access database with date and time stamp when close database as database on 11:11am on 11082015

how can i set it

View 2 Replies View Related







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