Combo Box Help (database Included)
Jul 25, 2005
hi All,
I've included an extremely cut down version of my database (33k zip file) with the example I'm trying to do.
There is a Combo Box (three options), I basically want this box to switch to the relevent record. (e.g. if you select Rural, it will switch to the next rural record) Rather, the combo box is changing the field of the current record to Rural which I don't want it do. I also want the ability to "Filter by Selection" too which it does but it just changes the current record :(
Any help would be GREATLY appreciated! It's been driving me crazy for days now.
If you click on "FOCUS OF SERVICE", the combo box in question is called "AREA" that is located up the top.
databasedemo.zip (http://www.deakin.edu.au/~apb/databasedemo.zip)
thanks,
andrew
View Replies
ADVERTISEMENT
May 10, 2014
I have a database with multiple forms and I would like to on close I would assume of the form, save a backup to a specific folder. This will all change once I move the database to the server but for now want a backup on my machine. Here is my code:
Code:
Private Sub Form_Close()
Call db_backup
End Sub
Below is in a module
[code]...
The problem is when I run this the program will give me an error saying: runtime error 438 object does not support this property or method
View 8 Replies
View Related
Mar 21, 2005
I need to build a database to track projects.
There are 10 groups that may work on any given project.
Each group may perform any number of tasks.
I made 3 tables
1. Projects
A. PROJECT_ID
B. PROJECT_NAME
C. GROUP_ID
2. Groups
A. GROUP_ID
B GROUP_NAME
C. PROJECT_ID
D. TASK_ID
3. Tasks
A. TASK_ID
B. TASK_NAME
C. DESCRIPTION
D. TIME_SPENT
E. NOTES
F. GROUP_ID
Projects to Groups is one to many
Groups to Tasks is one to many.
The problem I think I am running in to is how to show all of the groups in each Project even if a given group has not performed any tasks.
View 1 Replies
View Related
Sep 26, 2005
With this code, I can open Word and Excel files, but not PDF. Please let me know what I'm doing wrong. (I tried changing strProg = "C:Acrobat.lnk" including to a .exe file but nothing happens when I click the Open button)
---------------------------------------------------
Private Sub cmdOpen_Click()
Dim sSourcePath As String
Dim strProg As String
Dim objword As Object
Dim strFile As String
Dim XL As Object
sSourcePath = Me.FilePath
DoCmd.RunCommand acCmdSaveRecord
If fIsFileDIR(sSourcePath) = -1 Then
Select Case ParseFileName(sSourcePath, 3)
Case "xls"
Set XL = CreateObject("Excel.Application")
If IsNull(Me.FilePath) Then
MsgBox "You haven't Attached a File"
Else
With XL.Application
.Visible = True
.workbooks.Open Me.FilePath
End With
Set XL = Nothing
End If
Case "doc"
Set objword = CreateObject("Word.Application")
strFile = Me.FilePath
objword.Visible = True
objword.Documents.Open strFile
'--------------------------------------------------
Case "pdf"
'Open File
strProg = "C:Acrobat.lnk"
Call Shell(strProg & " " & sSourcePath, vbMaximizedFocus)
Case Else
MsgBox "File type not recognised"
End Select
Else
MsgBox "File cannot be found. Please check the file path. ", vbExclamation
End If
End Sub
View 1 Replies
View Related
Sep 2, 2004
I have an imported table that I created a form for (containing 400+ entries). I created a subform on it for a new table that I will be entering information to tie in with the imported form.
However, when I try to create a report, the report won't acknowledge any of the information. It's all outlined in the SQL, but nothing appears.
I did discover, though, that if I create a new entry on the imported table, that information appears on the report, but nothing for the existing data that was imported.
Please help!!!!!
View 1 Replies
View Related
Mar 1, 2006
I am working with a normalized database that has MANY tables. Most of these consist of lists of options to select from for the primary table. The primary table is linked to the secondary tables (and those to tertiary tables) by Primary Key ID fields, and the other tables contain additional information.
For Example, the Name list table is related to the Actions table by the SSN field, and the Actions table is related to the PayStatus table by an ID number collected by a lookup field.
When I pull all three tables into a query to display all the information related to a particular individual an his action, there are more records if I remove the PayStatus table from the query. It seems to only pull reports for which a PayStatus has been selected.
How can I get the query to display ALL the records, whether or not the individual has a pay status? Whether or not the individual has one is irrelevant, but I want his name to be displayed, whether or not he has one.
Thanks for any suggestions.
View 2 Replies
View Related
Sep 8, 2006
well i tried asking for help on this earlier, but i wasn't able to find any help so here is my problem.http://img330.imageshack.us/img330/2850/pictureaccessro7.jpg (http://imageshack.us)the sales - net = profit is fine but what i want to do is have a totals at the very bottem. everytime i try to do this, i can only get the totals to show and each individual record dissapears, or nothing shows at all. i've tried using a report but i can't seem to pull it off either. if anyone knows what i'm talking about and knows what i have to do then please help me :)
View 4 Replies
View Related
Dec 13, 2006
I have a basic trouble ticket type database that I built. It records troubles and auto fills the date and time when a new records created. I want a simple query that will display the number of calls that each person has taken today.
The problem being that If I use >Date()-1 I will get calls from this time yesterday until now. Is there a way to round down the time to today only? I don't want to lose my time stamp.
View 8 Replies
View Related
Feb 7, 2014
I have a report that I would like to export to a folder, and I would like to include the FullName within the naming convention of the PDF. When I run the report it prompts for the Employee ID..Here is what I have so far, I'm getting an error of "Run Time Error 424 object required" on the String Report Name,
Private Sub Create_PDF_Click()
Dim myPath As String
Dim strReportName As String
DoCmd.OpenReport "Report_Salary_Worksheet _Finalized_By_EmpID", acViewPreview
myPath = "W:COMPENSPHYSICIANSComp Plans"
strReportName = Report_Salary_Worksheet_Finalized_By_EmpID.[FullName] + ".pdf"
DoCmd.OutputTo acOutputReport, "", acFormatPDF, myPath + strReportName, True
DoCmd.Close acReport, " Report_Salary_Worksheet _Finalized_By_EmpID "
End Sub
View 5 Replies
View Related
Jul 1, 2013
I am currently working on an instrument datebase, I have a mainquery that takes care of user inputs from a form. The main fields that have been queried on are Type, System, and Manufacturer and they are all look-up fields that contain some null values.
On the same criteria row for these fields, I have
Like IIf([forms]![User Interface].[qtype2]="","*",[forms]![User Interface].[qtype2])
Like IIf([forms]![User Interface].[qsys2]="","*",[forms]![User Interface].[qsys2])
Like IIf([forms]![User Interface].[qman1]="","*",[forms]![User Interface].[qman1])
qtype, qsys and qman are the user inputs from the user interface that returns look-up table values.
This works fine when all 3 of these fields are all filled out for a certain instrument. The problem arise when some fields of the instrument are left blank or is null. The instrument won't show up in a query at all. What I wanted it to do is to show everything including the ones with null fields when the user input are null or "". When the user specifies certain requirement I only want to show the ones that are not null. I understand that putting them on the same row means AND, I have tried to OR them and did not have the result i wanted.
View 3 Replies
View Related
May 27, 2014
I've created the following but it keeps coming up with the error message You tried to execute a query that does not include the specified expression 'ICE Team' as part of an aggregate function.
SELECT ztSub.[Master Sheet].[ICE Team], ztSub.[date], Count(ztSub.[Count])
FROM (SELECT [Master Sheet].[ICE Team],[Master Sheet].[Visit Date (planned for)] AS [date],Count([Master Sheet]![Visit Date (planned for)]) AS [Count]
FROM [Master Sheet]
UNION
SELECT [Master Sheet].[ICE Team],[Master Sheet].[Date retasked to?] AS [date], Count ([Master Sheet]![Date retasked to?]) AS [Count]
FROM [Master Sheet] ) AS ztSub
GROUP BY ztSub.[Master Sheet].[ICE Team];
View 5 Replies
View Related
Sep 21, 2006
Operating System: Windows XP Pro
Access 2000 (9.0.8948 SP-3)
Problem Category: SQL query
Greetings:
I have a problem that I cannot solve. I have a form named “ALABAMA ARREST REPORT” on that form in a listbox named “List17” the row source is a query named “List17Query” this query is the problem in that I need its search criteria to come from the value of a textbox on the “ALABAMA ARREST REPORT” named “SSN” . Below is the query in question. When I type in a value (Example 1) it works however when I change it to receive the value from the form (Example 2) it does not.
Somebody please help
Example 1
SELECT [Master Name Index].ID, [Master Name Index].Soc, [Master Name Index].[Last Name], [Master Name Index].[First Name], [Master Name Index].MI, [Master Name Index].MOB, [Master Name Index].DOB, [Master Name Index].YOB, [Master Name Index].[Case #], [Master Name Index].Address, [Master Name Index].City, [Master Name Index].State, [Master Name Index].[Zip code], [Master Name Index].[Home phone], [Master Name Index].[Work phone], [Master Name Index].Race, [Master Name Index].Sex, [Master Name Index].Height, [Master Name Index].Weight, [Master Name Index].Hair, [Master Name Index].Eyes, [Master Name Index].Aliases, [Master Name Index].Status
FROM [Master Name Index]
WHERE ((([Master Name Index].Soc) Like "595-90-0000"));
Example 2
SELECT [Master Name Index].ID, [Master Name Index].Soc, [Master Name Index].[Last Name], [Master Name Index].[First Name], [Master Name Index].MI, [Master Name Index].MOB, [Master Name Index].DOB, [Master Name Index].YOB, [Master Name Index].[Case #], [Master Name Index].Address, [Master Name Index].City, [Master Name Index].State, [Master Name Index].[Zip code], [Master Name Index].[Home phone], [Master Name Index].[Work phone], [Master Name Index].Race, [Master Name Index].Sex, [Master Name Index].Height, [Master Name Index].Weight, [Master Name Index].Hair, [Master Name Index].Eyes, [Master Name Index].Aliases, [Master Name Index].Status
FROM [Master Name Index]
WHERE ((([Master Name Index].Soc) Like "*[Forms]![ALABAMA ARREST REPORT]![SSN]"));
.
Resolution:
WHERE ((([Master Name Index].Soc) Like "*" & [Forms]![ALABAMA ARREST REPORT]![SSN]));
Thank you very much "ByteMyzer"
Mshelley1
View 1 Replies
View Related
Mar 26, 2014
See the Main form of attached file, I would like to see contacts list box is made from drop-down list Customers. dependent
In the main form needs to select one customer, only the contacts 'de Vries' and 'Van der Linden' can be selected in the combo box of contact (in the main form) ..
I do not succeed despite several attempts with macros to achieve this.
Example11.zip
View 9 Replies
View Related
Jun 20, 2006
Friends,
I have created a combo box on a form using the combo box wizard. The combo box is linked to a table, and the combo box user's selection is supposed to be entered into a table so I can use it in reports, etc. The form works great. However, when I go to the table field that is supposed to have the newly entered combo-box selection, it contains only the record number, not the field contents chosen (by-the-way ... the record number and the record ID are the same ... maybe it is showing the ID??) Either way, why won't the table show the correct user choice from the form?
Thanks,
Mike
View 1 Replies
View Related
Mar 26, 2014
See the Main form of attached file, I would like to see contacts list box is made from drop-down list Customers. dependent
In the main form needs to select one customer (for example: Klant1), only the contacts 'de Vries' and 'Van der Linden' can be selected in the combo box of contact (in the main form) .. I do not succeed despite several attempts with macros to achieve this.
View 2 Replies
View Related
Jun 25, 2013
I'd like to create a combo-box in a database which takes its values from a field in a table in another db. Both of the dbs are on my computer.
How can I do that?
View 6 Replies
View Related
Aug 18, 2005
Hello!
I'm still working on this supplier database for my boss and the supplier filter section is still causing me problems.
Let me set the scene for you....
I have a form with 3 combo boxes on it. These are cboProg, cboPPS & cboSupplier.
I need to get the combo's working so that when you select a programme from cboProg it filters the list in cboPPS (Primary Product or Service) to show only products and/or services that are used on that programme. In turn I need to make it so that when you select one of these Primary Product or Service's from cboPPS it filters the list of suppliers in cboSupplier to show only suppliers that provide that product or service.
Essentially, I have a HUGE list of suppliers that I want to filter down to suppliers that work on a programme providing a particular product or service using the combo boxes in the order shown below.
Programme (cboProg) --(filters)--> Primary Product or Service (cboPPS) --(filters)--> Supplier (cboSupplier)
When I have filtered the list of suppliers down to a list that worked on programme X, providing product or service Y, I'd like to make it so that you can just double click on that suppliers name to open their details.
I've based my previous efforts on a sample database called dbcombos that I found on this forum (I've attached it to this post). The only problem with this database is that it’s 2 sets of 2 tiered combo boxes on the same form and not a 4 tiered set of combo boxes as I originally thought.
Any ideas? All help greatly appreciated!
View 1 Replies
View Related
Oct 14, 2005
HI THERE. IM HAVING A FEW PROBLEMS TRYING SORT THIS PROBLEM OUT. I HAVE A DATABASE IM TRYING TO APPLY A FILTER ON THROUGH AN UNBOUND COMBO BOX. WHEN SELECTING THE DROP DOWN FILTER TO SORT THE RECORDS NOTHING HAPPENS. THE CODE IM USING IS
Private Sub Combo??_AfterUpdate ()
'Find the record that matches the the control
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[WARD_AREA] = '" & Me! [Combo??] & " ' "
If Not rs.EOF Then.Bookmark = rs.Bookmark
End Sub
Does anyone know why this filter is not sorting through the records. Any comments much appreciated!!
Attached is the database
View 1 Replies
View Related
Oct 15, 2014
I've attached my database as I have it now. I am trying to create what amounts to an activity log.
I have created my main Subject and underlying related Issues tables, and a table for my daily activity notes. I have created my main form and subforms that should be sufficient (hopefully) for my purpose. Where I am getting hung up now is making the Subject and Issues fields combo boxes and filling them.
For the top-level Subject, I want to be able to type a new one in at any time, but also have the option to choose from a dropdown on the control as well. Then, if I do type one in, the next time I try to add a new record, it would appear in the dropdown as well. I think I have to query the underlying field to drive the dropdown list, but I cannot remember how to do that.
For the second-level Issue, there would also be a dropdown in the same way as the Subject control, and I want to be able to choose from the dropdown or add a new one in the same way... but I need to make sure that the ones that appear in the dropdown are related to the top-level Subject shown in the main part of the form. Of course, I don't want to be able to add an Issue unless it is related to a parent Subject. On these things, I am totally lost.
Finally, I built my notes to show in the subform as a continuous form, which I have used only once before. I'd like it so that the notes show newest at the top. And, I'm thinking about putting a "lock" checkbox on the note record so that I don't overwrite previous notes unless I consciously go back to edit something. I'm not sure how I can make an individual note dependent on an individual checkbox in the continuous form.
View 1 Replies
View Related
Jan 30, 2006
I have four tables with unique records as shown below. I'd like to add a record for a new item to the database by selecting the values from combo boxes for Supplier, Item and Unit. If the values do not exist the user would then type in a new value. SuppliersItemCode and Cost would always be new values. What's the best way to go about this? I am unsure how to add a record to a normalized database where you sometimes have to use / reference existing unique values in multiple tables via foreign keys for the new record.
The logic of the form would be:
1. Select existing or add new Supplier.
2. Select existing or add new Item.
3. Select existing or add new Unit.
4. Enter new SuppliersItemCode
5. Enter Cost
Suppliers
---------
SupplierID (primary key)
Supplier (indexed unique)
Items
------
ItemID (primary)
Item (indexed unique)
Units
-----
UnitID (primary key)
Unit (indexed unique
SuppliersCostsAndCodes
-----------------------
SuppliersItemCostCode (primary key)
Cost
ItemID (foreign key)
UnitID (foreign key)
SupplierID (foreign key)
Any advice or assistance is greatly appreciated, thank you.
View 5 Replies
View Related
Dec 24, 2013
I'm developing an Invoicing database (which I've attached a sanitized copy) where I'd like to have an invoice number combo box show only invoices relevant to the client previously selected in the client name combo box.
I downloaded an example from Microsoft's templates website (which I've also attached), and I thought this would be a simple task.
I'm not sure what I'm doing wrong, but I figure it's something simple.
I'd prefer to use vba; I really don't want to use macros.
View 3 Replies
View Related
Dec 16, 2013
I'm trying to create a timesheet database to keep track of employee hours worked. I have my tables set up as follows...
Employee_T
PK -EmployeeID
PositionTitle
Last Name
First Name
Employer
Projects_T
PK-ProjectID
ProjectNumber
ProjectName
WBS
Timesheet_T
PK-TimesheetID
FK - EmployeeID
FK - ProjectID
Sat
Sun
Mon
Tues
Wedn
Thurs
Fri
WeekEnding
My question is on my input form I want to have the user/employee pick his name once in a header combo box as-well as the week ending date and have it populate to every new record that user input (each employee can charge to multiple projects in a week so I want to eliminate the need for them to pick their name and week ending date everytime they select a different job charge.)
John Doe Week Ending 12-20-2013
M T W TH F
Landscaping 8 4 3 2 6
Roofing 3 5 2 1
Plumbing 1 4 1
View 6 Replies
View Related
Mar 1, 2014
I am new to MS Access. So I am making a database for an automobile warehouse. When a new car arrives at the warehouse, it is allocated a specific parking slot (using a combo box available on the 'New Arriving Car' form).
However, once a specific slot has been allotted, the end-user should not be able to allot the same parking slot to other arriving cars, until the original car has left the warehouse so that the parking slot becomes available once again. Currently, the parking slot combo box shows all parking slots whereas it is supposed to display only unoccupied parking slots. How can I enforce this? (Note that there is a separate form called 'Exiting Car', which is filled when a car is leaving the warehouse).
Fyi, each car is referred to by a unique 17 digit code - so this is the primary key. Also, there are 120 parking slots available in all, with the slot identifiers ranging from A1, A2...A12 to J1, J2..J12 (10 x 12 = 120).
View 5 Replies
View Related
Aug 7, 2013
I've been able to make a normalized relational database with cascading combo boxes, etc.
How to validate a field? The format needs to be according to the following:
<0 AND <=9999 [Optional: followed by a capital letter]
Examples of Valid Data:
7
4A
354
8756G
View 3 Replies
View Related
Jul 29, 2015
I currently have 3 tables within a database with student details of three different classes. I need to create a user form that has a dropdown box which I can select a student from one of these tables with a number of text boxes below which brings up all the students details, then once the student has been selected and the correct details are shown then I need to create a button which allows me to move that student from one table to another.
View 4 Replies
View Related
Sep 5, 2014
Is there any way to list a combo box with all the forms of an Access Database?
View 5 Replies
View Related