Add Multiple Record Quickly (details Inside, Void Where Prohibited)

Mar 27, 2008

Situation
My database stores course information for faculty in my department and prints out various reports based on that information.

The 2 mandatory fields in the form are [AcademicYear] and as they create the potential for classes to be added to the curriculum.

Question
Is there a way to add multiple records to the db based on the which year and instructor combinations were use prior?

[I]ex.
2007/2008, prof-a
2007/2008, prof-b
2007/2008, prof-c
2007/2008, prof-d

This represents the 2007/2008 school year where professors a through d taught courses. Is there a way to add records for another academic year so that:

2008/2009, prof-a
2008/2009, prof-b
2008/2009, prof-c
2008/2009, prof-d

appear with just the press of a button?

I don't know if I'm being clear enough. :p

View Replies


ADVERTISEMENT

Append Query - Appending Multiple Tables Quickly

Aug 12, 2005

Hi Guys and Girls.

I have about 100 or so tables that I need to append back into one table :eek:

However all of these 100 tables all begin with the number 100 at the beggining. I know that you can append tables - but as far as I know you can only do one at a time. Is there any easy way to do this - for example writing a small SQL statement - saying select all tables that begin with 100* and then append into a master table :confused:

Alternatively are there any programs on the net that can do this (I just wrote a massive macro to import them from a text file in to access- not realising this problem would happen!) :(

Unfortunately each of the tables has the first row as the column heading too?

Any help would be much appreciated!!

Cuurently using Access 97 though.

View 1 Replies View Related

Void Of Ideas?

Dec 9, 2004

I have decided to amend a database because my original design was rubbish!!

Why? Currenlty a user selects a ServiceID from a combo:

SELECT tblServices.ServiceID, [ServiceCategory] & "-" & [VehicleType] & "-" & [ServiceType] AS Expr1 FROM tblServices ORDER BY [ServiceCategory] & "-" & [VehicleType] & "-" & [ServiceType];


That produces:
Car-Larger-Wash

I have added a new table to the DB to list car makes and models.

The user will select a car make and model from one field (combo) on a service form.

From the next field they will selct the service to be performed on the selected vehicle i.e. Wash / Vacum / Full Valet

My dilema? I can not think of a relationship for the new table 'tblVehicles'?

Any suggestions?

Should I add a new field to tblServices?
Cheers,
Phil.

View 14 Replies View Related

Multiple Details Sections?

Jan 29, 2007

Hello,

I have not used access that much, but what I am looking to do is basically have 2 details sections within a report that will have different records in them.

I first used a subreport but that really did not work as intended. It left large gaps in between the records and just plain didnt work.

Here is a image of what I am trying to achieve:
hxxp://img379.imageshack.us/img379/9471/accesshelpnx9.gif

As you can see theres two different sections. One is for regular campaigns and one is for extended campains. There is a field in the table that has the extended date. For the compaigns that field should be blank or null and for the extended campaigns it is not blank or null.

Is there anyway to achieve this in Access 2003, if so can you tell me or describe me the steps?

Thank you!

View 1 Replies View Related

Making Transactions With Multiple Products (Diagram Inside)

Mar 21, 2008

Hey people, hows it going? Quick question

I am creating an EPOS system for a bookstore and I have a many to many relationship between the transactions table (tbl_transactions) and the products table (tbl_products) using a link table (tbl_linktblproductstransac). The below diagram shows what i mean below:

http://img512.imageshack.us/img512/3246/relationnshipswd9.jpg

I made it many to many because 1 transaction can have many products on it and 1 product can be on many transactions.

Now what I need to know is how will i make records with more than one product on one transaction (in the table itself or in a transaction form). I would really appreciate if someone could help. Thanks :) and have a good Easter

View 2 Replies View Related

Viewing A New Form With More Details Of A Record

Nov 27, 2006

I have got a form with summarised data (of records) on view for people to look at. (this is a continuous form). For each record I would like to have a button that displayed another form with more details on it. So by pressing the button opposite a particular record it would take the Id value of the record and open another form (with more details) at that particular record.

I would be very interested in seeing this done with a macro if possible but beggers can't be choosers!

View 4 Replies View Related

Use Previous Fields Record Details

Jan 7, 2008

Dear Guru's,
Happy New Year 2008.

:confused:

I have a task of implementing a fleet fuel consumption. I have made a form where user logs in previous odometer and current odometer reading. I have been challenged to make the system to automatically use previous odometer reading next refuelling. Please assist.

Joseph Njoroge

View 6 Replies View Related

Printing Only One Record Details On Report

Jan 6, 2005

I have a form which is used for data entry for a new record only. I then wish to print some of this record's details on a report, using a command button on the form. At present I cannot filter to get just the current records details on the report - I am getting the report containing all records in the table.

Thank you

View 3 Replies View Related

Forms :: DLookup And MSGBOX With Record Details

Jun 18, 2015

I've got a form which holds data for employees, fname, lname, ..... and an entered date which defaults to now().

On the before update event, i have the following.

Code:
If DCount("*", "trainingdata", "[Empid]=" & Me!EmpID & _
" And [subjectid]=" & Me!SubjectID & _
" And [trainingdate]=#" & Me!TrainingDate & "#") > 0 Then
MsgBox ("This record already exists")
Cancel = True
Me.Undo
Me.SubjectID.SetFocus
End If
End Sub

With the above vba code, a msgbox pops up if the record combination already exists. What I would like to do is in the same msgbox have the "entered" date display and make the msgbox say something like.

This record already exists and was entered on 6/18/2015, [entered]...

View 5 Replies View Related

Forms :: Editing Record Details Not Allowed

Sep 28, 2014

I have had a form working for ages. It has a main form and eight subforms at the bottom of the form. The main form can be edited in all fields.

I have taken a copy, modified the form added new fields to the main source table and updated the query that feeds the form.

Now (in the copy environment) it won't allow me to edit any of the fields. All of the form control properties are the same as the working model (in the live environment) I can run the query by itself and all is OK

There is obviously some little control that I have inadvertently changed and can't see it.

View 1 Replies View Related

Input Fields To Change Record Details On A Form?

Aug 17, 2005

I have a query with the fields employee_name, shiftname, shiftdate and have set it up so that 2 input messages boxes popup allowing the user to input a shiftname (a,b,c) then a shiftdate. from this query i have created a form, but instead of having 2 message boxes popup on screen before the form is loaded is it possible to have 2 input fields on the form (one for shift date & one for shiftname) that allows the user to enter into these fileds whenever they wish provided the form is open and all the records bellow change matching the employee name with the corresponding shiftname & date?, any advice would be great.

View 4 Replies View Related

Queries :: Retrieving Record Details With Max Value Date Field

Mar 26, 2013

I am trying to retrieve data for a particular record.

When Project field matches a certain project number I want it to pick the record with the latest date in the date field field to select certain data fields(Owner & Rating) from that record.

Below is my attempt. However the problem is that displays all records with that project number and not just the record with the latest date.

Code:
SELECT [Combined PRB Roadmap].ProjectNumber, Max([Combined PRB Roadmap].DateField) AS MaxOfFDateField, [Combined PRB Roadmap].Owner, [Combined PRB Roadmap].Rating
FROM [Combined PRB Roadmap]
GROUP BY [Combined PRB Roadmap].ProjectNumber, [Combined PRB Roadmap].Owner, [Combined PRB Roadmap].Rating
HAVING ((([Combined PRB Roadmap].ProjectNumber)="NR-4237"));

View 2 Replies View Related

Queries :: Including Record That Is Inside Excluded Range

Oct 2, 2014

Including a record that's inside an excluded range.

I have a table with record numbers from 1 to 91599. I want to exclude records from 91011 to 91599 but I don't want to exclude record 91102.

How do exclude a record that is included in the excluded range?

I could write two queries the first will excludes 91011 to 91101 and the second excludes 91103 to 91599. Is this the only way?

View 3 Replies View Related

Modules & VBA :: Display Particular Record Inside Of A Tab Located On Popup

Jan 7, 2014

What is the syntax to display a particular record inside of a tab located on a pop-up?

In other words,

I have a pop-up called People_Enter.

On People_Enter is a tabbed control called TabCtl89

On tab (2) is a subform called company_contacts_attachcompany that displays a Single Form record.

I want to open that particular Single Form where EntryId = value

I know how to assign the Where but not how to call the form.

View 4 Replies View Related

Queries :: Double Click On Results In Order To Go To Original Record Or See More Details

Jun 2, 2015

Is it possible to once you have run a query be able to somehow double click on the results in order to either go to original record or see more details? Similar to "show details" in excel?

I have made some queries that are working well however they are specific in nature and once found display a list of results. I have left a field that uniquely identify them and are after a quick way to view the details of the results from the query rather than take the ID# and manually search the original table.

View 8 Replies View Related

I Need Help, Quickly, If You Can...

Feb 5, 2006

I am making a database and I require a box in a form where when I press a key, it enters the drink name, price, and stockID. It should also keep a running total of the price and make a subtotal where I can then input the cash given.

Can anyone help? How do I make the box?

Thanks,

Fred

View 4 Replies View Related

Forms :: Recordset Of Subform Inside Another Subform Which Is Inside A Mainform

Dec 16, 2013

I'm having a problem with the syntax of a recordset of a Datasheet inside a subform which is also inside a Main Form.

Main Form - frm_1_0_LMS
Subform - frm_1_4_0_TeamApprovals
Subform(Datasheet) - frm_1_4_1_TeamApprovalsList

Here is my code:

Code:

Dim rs As DAO.Recordset
Set rs = Forms!frm_1_0_LMS.frm_1_4_0_TeamApprovals.frm_1_4_1_TeamApprovalsList.Form.Recordset
If Not (rs.EOF And rs.BOF) Then
Forms!frm_1_4_2_ApproveDeclineUserLeave.Controls("lblFiledDateLeave").Caption = rs!Leave_Date
End If

I am getting this error: Object doesn't support this property or method

View 1 Replies View Related

Quickly Fill Fields DOWN With Same Value?

Apr 24, 2014

I'm wondering if there is a way in Access 2013 to - for example - enter a value in a date field and then highlight it and drag it down to populate all the records in the table with that value, as can be done in Excel?

View 2 Replies View Related

Quickly Entering Thousands Of Lines

Feb 7, 2012

I have three account types, 110 fiscal months, seven types of fees each associated with a cost. That's 2310 pieces of data if I enter the information with the collumns: AccKey, DateKey, FeeDesc, FeeCost (e.g. For account type one on Fiscal month Jan '11, an overdraft fee was $10). I have all the data on an excel sheet, but it is formatted so that each fiscal year is separate. Is there a way for me to enter this info quickly?

View 1 Replies View Related

ACCESS DB File Opens And Closes Quickly

Dec 19, 2005

Hello Ladies & Gentlemen,

I was trying to access this particular MS-ACCESS file which serves as a DB for a software. But the file opens and closes in a split of a second and was impossible to view its structure. :mad:
I beleive it's made to respond so by the programmers in order to hide the content. Can anyone please help me open this file? PLEASE...

Teddo

View 8 Replies View Related

Queries :: Quickly Diagram A Query Like Flowchart

Jun 11, 2014

All I have taken over a database. It has dozens of queries. Is there a tool or code that I can use that would quickly diagram the querie like a flowchart telling me what queries are related and the steps and so on.

View 1 Replies View Related

How To Easily And Quickly Change Width Of Columns

Jul 1, 2014

I have a file with 45 columns and I need to be able to make 40 columns quickly dis-appear and re-appear. When I search for responses to similar questions I get references to "Horizontal scroll bar and List Box control" which I do not know how to find and/or use.

View 4 Replies View Related

General :: Close Access DB Present In Network Quickly

Aug 23, 2012

I have Access as front end and SQL Server as back end. The Access application is placed on a common network drive for theusers to access it. The compact on close option is enabled when the access application is closed.

I have a local copy of the access app. When I close the app, it takes ony a few seconds. But when on a network drive, it is taking 2 mins.I just wanted to know if the time taken to close the application on the network drive can be brought down without disabling the compact on close option.

View 1 Replies View Related

Order Details

Nov 7, 2005

Hi Folks,

I'm working on an order management database for a small company and have an order details form which I hoped to list each product of the order. As each customer has a different price per product I have a combo (based on a query) to choose the product and display the unit price (working fine) - the quantity and product ID are also input on the form and stored in the order details table (un-tested). My problem is on the first line of the order you choose the product and it and relevant details are shown, however, on line two, three etc when you choose the product - the other lines change to this too. How do I fix this???

Many Thanks in advance for help given!!

Mary

View 6 Replies View Related

Need A Bit Of Help With The Final Details

Jul 6, 2005

I am almost finished this project. :p There are just a few things left that I would like to do and I need some help.

1. Add an email notification when data on the form has been edited
2. Filter the form for only OPEN orders, status not equal to 6 or 7
3. When an order is closed (status field) I would like to default the "Date Closed" to today, but allow the user to edit the date if need be.
4. Once the status is closed and the date closed is entered, ask the user if they would like to create a followup order.

I have most of #4 done. I added code on the After Update event on the Status field to set the Date Closed to today and then disable the control, then ask if they would like to create the followup order. The users would like to be able to modify the date closed if they don't happen to do the entry until the next day. I have tried adding my code to the After Update of the date (which is updated with a pop up calendar), but once I select the date from the calendar, the focus stays on the date and the user is not prompted to create the followup order.

Any help you can offer would be wonderful

Thanks
Pat

View 2 Replies View Related

SQL Error Details

Oct 8, 2004

I have extensive experience of other SQL databases but, in Access I don't know how to access the SQLCODE (as it would be in other DBMSs) to see if my query worked and if it did then how many rows were updated.

Anyone speak my language?

View 4 Replies View Related







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