A query based form is used for tracking the different EVENTS, LODGING data, EMPLOYEE personal data and FAMILY members. I'd like to creat a combo box that shows only the events that the employee attended, not all the events in the EVENT_JUNCTION tbl.
View RepliesWhat I need to be able to do is write vba to find the value inside the comboxbox and then either:-
1. Run a macro with the same value that is in the combobox
Or
2. Run a set of reports and print them off but are linked to the combobox value.
The combobox name is ODTyper
The combobox control source is ODType which is a field in TblType
The combobox row source is SELECT [TblType].Model FROM TblType;
The value inside the combobox are in the format of TE4700
The name of the macros are in the format of TE4700
The Main form is called FrmOrderDatabase.
Plus somehow i need to get the value of the combobox and link it to print off the correct reports.
Hi all, I am looking for an employee record template for data including sickness, vacation, skills, CVs etc. I would have thought there would be loads available but alas, I can find none
Can anybody point me in the right direction please.
Thanks in advance
Rob
Is there a way to track the changes made to a record? I have added a timestamp field to my form that indicates when the record was changed but I would also like to know which of my staff has made the change. I found this on line but I'm having no luck with it working:
CODE:
Private Sub Form_BeforeUpdate(Cancel As Integer)
' Log the user details to the table
Me!UpdatedBy = CurrentUser()
Me!TimeStamp = Now()
End Sub
What this gives me in the Updated By control is "Admin" instead of the users name.
I need to add a persons photo to their employee record and don't know where to start.
View 11 Replies View Relatedi have been trying to create an employee database to record:
1. Name , Address
2. Telephone
3. Date of birth
4. employee ID#
5. Emergency contact -name, address, telephone
6. Photograph
7. Other pertinent information related to employees
So far I have incorporated the contacts database forms into my new database but I am unable to link the forms into one form that will incorporate all the information needed. Is there an existing employee database that I may edit to suit my purposes?
I have a table with following two columns
TechName Version
SQLServer 2000
SQLServer 2003
SQLServer 2005
SQLServer 2008
SQLServer 2008R2
Oracle 11G
MSOffice 2000
MSOffice 2003
MSOffice 2007
MSOffice 2010
How can i show this data as components eqch version for a techname to be one component order need not follow
TechName Component1 Component2 Component3 Component4 Component5
SqlServer 2000 2003 2005 2008 2008R2
Oralce 11G NULL NULL NULL NULL
MSOffice 2000 2003 2007 2010 NULL
In my form the default for a field is 0 and the format is currency. How do I get the field to show $0.00 when there is nothing in it?
View 1 Replies View RelatedI have searched similar posts to solve this, but havn't been able to make it work yet, so apologies if this sounds like an existing post.
On my form (frmContacts) I have a combo box (LstCompany) that lists companies. The default value is set to "N" (so this is the value when nothing is selected).
I have a query (qryContacts) that retrieves records of People and their Companies from a single table (tblContacts - this table includes the fields 'Person' and 'Company'. Some people have no company). I want this query to:
- When no company is selected in LstCompany: show all people (whether or not they have a company).
- When a company is selected in LstCompany: show records for that company.
I have added the following expression to my query:
Expr1: IIf(([Forms]![frmContacts]![LstCompany])="N",True,([Forms]![frmContacts]![LstCompany]))
Criteria = True
This works fine for showing all records, but the Expr1 field returns #Error if a Company is selected.
Any idea what I am doing wrong, or what will work?
How do I get the second filter to show all the values and allow me to check which ones I would like to select? I cant seem to recall how to do this. I remember having to do it a while back.
View 8 Replies View Relatedi want to be able to create an On Click Event when pushing a command button that will run an Update query to update a record and after it has been updated that specific record will pop up on a Form and be displayed. i know a different way is to run the Update query and then have it displayed in a Select query but i want it to be displayed on a Form instead. is it possible?
View 4 Replies View RelatedI am trying to generate a report, or even a word merge doc, that will print only the fields containing values above "0". I have to print a one page benefits report for each employee, yet not everyone has values in each available field. On each report, I only want to show the fields that actually pertain to the employee. Is this possible?
I have tried doing this as a Word merge, but the field names do not show up, only the values...I have been struggling with this for over a day...please help!
So I have a multi-select listbox with tick boxes and values in on my form. Is it possible to make so only the checked values are showing up and then not display the tick box?
I know I can use a combo box to display several values, but using a listbox like this would be easier on the eye.
Is it possible to use code to get a text box to show the selected items in the list box?
In the attached Database, I have four tables. The purpose of the Database is to track training for employees. A quick description of each table:
Employees: List of employees requiring training
Course List: List of Courses offered
Course Schedule: When said courses are offered (one to many relationship with Course List). this has a Composite Primary key consisting of the Course Number and Section Number
Course Attendance: This is to track which employees attended which class.
Question 1:
In the Course Attendance table, the first field (SOS Course Number) looks to the Course Schedule table. This field uses a lookup to select the course and section number, but only displays the course number. How do I get it to also display both the course and section number (don't care if it is displayed in one or two columns)?
Question 2:
Similar problem, except the second field is Employee Last Name which is a lookup from the Employee table. I want to display both last and first name in two separate columns.
Note, I realize there are spaces in table and field names. Please ignore this for now. It will be fixed later.
Hi,
I have a popup form called Labor that is working perfectly fine, what i mean is that it is getting populated with data from the query I built using a single table called PrimaryBid_Master. However I have had to add many fields to this table before invoking a query on it, now I'm running close to the 255 field max limitation.
So I have created a new table called Labor_Primary with all the fields that I need and took them out of the PrimaryBid_Master table freeing up about 50 fields.
The query I made combines 2 tables: table1=PrimaryBid_Master table2=Labor_Primary, they are linked by a common field called invoice#.
But now when I’m in the PrimaryBid_Master form and click the command button to go to the popup form Labor non of the values that were populating the popup form from the primaryBid_Master form work, they were working fine the only thing I changed was the popup forms record source to the new query I built.
Here is a print screen of the new query I built using 2 tables, and I also show the old query that works fine using 1 table. http://www.roofmart.net/query1.asp
Maybe you can see some thing I did wrong; do I need some type of filter to fetch the fields? When I open the new query there is no data/values in it.
Thanks--I appreciate any help.
Hi,
This query will allow me to view payments that are made between 2 dates. I would like to know how to flip the query around so that it gives me the payments that have not been made. I think this would be described as returning the null values?
The SQL code i have at the momnet is:
SELECT download20060602.Date, download20060602.Description, download20060602.Amount, Members.FirstName, Members.[Mid Name], Members.Surname, Members.[Memb No]
FROM Members LEFT JOIN download20060602 ON Members.description = download20060602.Description
WHERE (((download20060602.Date) Between [Enter Start Date] And [Enter End Date]));
Any help or ideas would be fantastic.
Cheers
Phill
I am very new to access. I have made a database that holds certain company information.
As part of a process a company must fill in and complete form and send to me and once they have I enter a 'yes' to the form and then link directly to said form.
I am wanting to be able to run a report to be able to only see the companies where a certain field has not been filled in.
For example I have a field for doc 698, if I have had this form back I enter a yes in this field, if I havent had this back I leave it blank and these blanks are what I want to pull off in the report.
I have made queries and then just filtered to show blanks but I would like to have in report form.
I've used this guide [URL] .... to only show unique values in a combo box. I can't get it to work, it just shows a load of blank values. If I run the expression builder part from the background, it works but it doesn't work in the combo box. Not sure what I can post to give more details?
View 13 Replies View RelatedI have created a table (data entered/selected via a form) which includes a drop down box, for 'Ethnicity' to pick a value from another table (ie used Lookup wizard to for options from another table).
The row source looks like this:
SELECT [Lookup_Tbl_ethnicity].[Code], [Lookup_Tbl_ethnicity].[Category], [Lookup_Tbl_ethnicity].[Sub-category] FROM Lookup_Tbl_ethnicity ORDER BY [Code];
Setting the ORDER BY [Code] displays the options in the drop down box in the correct sensible order.
The 'Bound Column' is column 3 - Sub-category. I assumed that this would be the 'value' stored, searched and displayed... but the table (and related form) display the Code.
how to change this so that the Sub-category is displayed?
I have duplicate data in a cell, I want to hide duplicate data and display only non-duplicate data.. I changed the property sheet to only show unique values, but it keeps showing data I don't want to see...
View 3 Replies View RelatedI have an unbound combo box with three columns, which get the values from a query. The first column is hidden. When I close the combo box after my selection, only the second column value is shown on the box. Is there any way that both the second and third column being shown on the box after selection?
View 3 Replies View RelatedOne Manifest can have many line items. One line item can only have 1 designation. Each manifest may have many line item with same designations.
For example:
Manifest #0001
Line Item 1: N
Line Item 2: H
Line Item 3: U
Line Item 4: N
Line Item 5: P
Line Item 6: H
Table set-up
CurrentCY
CurrentCYIDPK
WasteCategoryIDFK
LineItemInformation [Line Item 1, Line Item 2, etc]
ManifestDataIDFK
ManifestData
ManifestDataIDPK
ManifestNumber [0001]
WasteCategory
WasteCategoryIDPK
WasteCategory [H, N, U, etc]
I'd like to query the line items for each manifest so the end result has the manifest number (Manifest #0001) in a field and the designations (N, H, P, U) in fields on a report.
I am trying to get a combo box to only show unique values, but I can't get it to work properly - it still shows duplicates in the list.
The Row Source is set to
SELECT DISTINCT Areas.ID, Areas.Area FROM Areas ORDER BY Areas.Area;
And the combo is bound to column 2
I have a Form with multiple comboboxes and listboxes whose selections are assembled into a query. The combo-box selection goes into an IF-ELSE statement for a selection check (IsNull) and if there is no selection made, it is supposed give me all values (Blanks & Non Blanks)
Here is a sample of my code:
Code:
If IsNull(Me.cbReg.Value) Then
RegStrng = " Like '*'"
Else
RegStrng = Me.cbReg.Value
RegStrng = "= " & RegStrng
End If
I have several If-Else statements here and a final query assembly at the bottom of the code page which is as follows
Code:
MasterSql = "SELECT DISTINCT blah-blah-blah" & _
" INTO some more blah-blah" & _
" FROM even more blah-blah-blah" & _
" WHERE dbo_mytable.[Reg#]" & RegStrng & _
" AND the results from other If-Else statements similar to above"
Here is where the problem comes in:
I see the mistake in my If-Else statement
Code:
If IsNull(Me.cbReg.Value) Then
RegStrng = " Like '*'"
Like * means it will show me all rows where there are NON-Blanks. However, it skips all Blank Data.
What should the If IsNull() statement look like if I want to show all the values?
If there was only one combo-box and there was no selection made, then the resultant query should show me all results rather than only the results where there is some sort of data within the column filtered by the combobox.
How to fill values in a new record with data from previous record?
I've total 11 columns in a table and values in 3 4 columns are repeating for few rows before it needs to be changed eventually. I want to fill these rows with values from previous record.
Access 2010 - I would like to use DLookup to show results values from a table and display in a unbound textbox on a form. the results from each column in the table need to be on seperate lines, a break if you may. Here is the code I have so far.
Code: txtKeywords = DLookup("colKeyword", "tblKEYWORDS", "cboCategory = '" & txtcategories & "'")
In colKeyword Column In tblKEYWORDS table match what i select in cboCategory Combo drop down box and populate txtcategories textbox on form
What I would like to do is show All colKeyword results in textbox [txtcategories] and display each result on its own line!
example
entry1
entry2
entry3
entry4