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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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