I have 2 tables
Main table called Site Details
and another table called expense codes
On the form I want to use a combo to look at the expense Number 52, 53, 54 ect
the in the next field to show the description of the code it relates to
How do I do this?
New to the navigation form: I need several forms in the navigation form to all relate to the same client ID field. I have this information on the main form but the form with in the navigation form will not pick it up.
I have tried =[Forms]![Frm Client Information Navigation Panel]![ClientID] But just cant get it to pick up that information...
I would like to have something like the master link fields and, child link fields but when I add a form to the navigation form this option in not available.
What I would like to do is create a list box that will only display the information from another form that is related to the current form.So I have a form call Equipment Catalog and that form is related to Equipment features 1 to M relationship and the Equipment Features is related to a Features form M to 1.
So what I want to do is display all the related equipment features in a listbox that is related to the current PK of that form.So if there is only one feature on one form the list box will only display that one item however is there is 6 features on another it will display all 6.I have been trying SQL and Queries but I still can't get it to work.
I have a form that is used for data entry; from there I want to create a new form where I can select a field from a combo box which would generate the amount associated.
Example on the first form it has a Carpenter that has a calculated output of $1000, on the second form I would want to click on the combo box and pick carpenter and I would like the calculated field to be shown next to it.
I tried making an if statement on an unbound box but I found it difficult
=IIf([Combo2]=Building Service Engineer, =[Forms]![Estimate]![Text787],IIf([Combo2]=Carpenter,
=[Forms]![Estimate]![Text788],IIf([Combo2]=Custodian,
=[Forms]![Estimate]![Text789],IIf([Combo2]=Custodian - Shift Pay (5am - 6am) ,
=[Forms]![Estimate]![Text790],IIf([Combo2]=Drafting Technician,
[Code] ......
[Text787]-[Text805] are fields from the first form, these are calculated fields that multiplies wages quantity etc.
Also [Combo2] wont let me pick any data that I typed in.
I've established a many to many relationship using a junction table.
So I have 3 tables (A for "materials", B for "batches", and J for "junction")
Form A is linked to table A, and contains a subtable linked to a query from table J. This allows me to input materials into table A and then list all of the batches it may be used in that are in table B. I successfully got this to input all the batches and materials combinations in table J.
Now on form B, which is linked to table B, displays the batch information, with the subtable J.
My problem, is that only the materials primary key is showing, not the other information that should be linked from table A.
I have a unique "CustomerID" that is an auto number (this is how I link tables, forms, etc.), and "CustomerNumber", "CustomerName", "CustomerSubNumber" that could be null and could have duplicate values.
The first form I have is a Contact Info form where users will enter the contact information such as customer numbers, names, addresses, phone numbers, etc. This then links to an order form. My order form has a place to carry over the "CustomerNumber", "CustomerName", "CustomerSubNumber" values from the ContactInfo table. I would like these fields to automatically populate based on the CustomerID unique number as well as only show the information for that customer ID (including listing out any previous orders).
I have a database of experimental products. The database allows test technicians to input test information as well as product information (obviously in separate tables). Therefore before a tech logs test information, they have to first make sure the test product is in the database. They can do this by looking up the products that are in the database, and if the current one isn't they can input its information. In the lookup section you can also click on an individual product and lookup its test history.
What I am looking to do is add a button in the product information screen that allows the tech to open the test information input form with the test product information already loaded into the form. The product information portion of the test input form, is two combo boxes, one indicates the test products group and the other is the product number.
Looking up information on Google looks like i might need to use the OpenArgs function, however I have never used that before.
The database I have created is to produce product description sheets. From the switchboard, the user clicks a button that opens a form on which they can enter about 5 bits of information , then select the product they wish to produce the product sheet for and when they click a button, the product sheet is produced. The product sheet is a report with a subreport. The information entered on the form is included with more information from the database on the main report and the subreport is based on a union query which combines information from 2 tables to list the items included in this product. (the information the user inputs into the form is information that changes depending on the situation and is not stored in the database.
Now comes the next step in this process. Just as the information input into the form is temporary information, there is also one bit of information that needs to be input on a temporary bases for the items that are listed on the subreport. Each of the items on this subreport needs an assignment of AAA or BBB that needs to appear in the subreport on the line with that particular item. There can be one item in an product, or there can be many and the listing of AAA or BBB can be different from one item to the next or they could all be the same. The assignment needs to be made on an item basis.
My thoughts on this were to have a subform appear once the user selects the product on the form which would list all of the items and allow them to select either AAA or BBB in a column on this form. Then when the click to open the report, those assignments would carry through to the report.I have been able to create a continuous form displaying all of the items based on the union query but that's as far as I can get. Not even sure if that is the way to go.
Is there a way to reference the AAA and BBB input on the subform I described so that it displays in the report.
Trying to pull information from a text box on double click to populate a combobox on another form...
keeps coming up "type mismatch"
I call lngAccount as recognised on mouseover... ("Business Account" is the value I want)
I can't get it to work!
For info, the form I'm calling from is a subform located FrmMainMenu/FrmAccountsMainMenu and the control source is [Account]
the form I wish to populate in on FrmTransactions (it is a main form only) and the combobox is cboaccountselect - **I've seen the obvious mistake with no reference to this whatsoever, corrected it, and still not working**
I am attempting to create a patient tracking database for a clinic I work in and I am stuck at one small but major part.
I have a parent form called frm_Patient_index. On this form you can enter patient details such as personal details, observations ect. I need to create a lab request form for certain tests to be performed.
I want so that a button on the frm_patient_index form opens a subform where the relevent tests can be requested via tick boxes. Now here is my problem I have managed to create all of that except for the information to be entered into the frm_lab_request automatically and get SAVED to its corresponding table. It will not save for me.
I can get the information such as Badge Number, First Name, Surname and DOB to all enter into the fields automatically but getting them to save to the table is not happening.
When entering information into a blank form, I would like to be able to continue entering information to another additional blank form after my last entry. Is there a way to continue to a blank form after entering information into the previous blank form? I would just like to continue without having to close the entire form and then reopening another form.
View 7 Replies View RelatedI am creating a new form and right now I only have 3 controls: Employee name, Employee ID, and Hire date.
How can I type in an Employee's Name and when I hit enter I get the info in the other boxes to show up?So what I am wanting is to be able to type in a name and hit enter and have all the other boxes populate in the form?
Is there a way to set up a keyword search within a form and use it to look up information in a backend table?
View 3 Replies View RelatedI have a subform and I want to save the username to the bound table in this subform.
I've tried creating a textbox (CompBy) and then setting the default value to = Environ("UserName") but this doesn't work.
I've tried placing the following in the afterupdate event of the subform:
Me.CompBy = Environ("username")
DoCmd.Save
But this doesn't work either.
Our software was purchased with a volume license, so I want to make a combo box with all of our volume license purchases and when the person selects the volume license number all of the PCs that have software purchased with that volume license are displayed.Below is my code
Private Sub cboVolumeLicensing_AfterUpdate()
'Moves to Volume Licensing field and
'finds records where "Volume Licensing" matches whatever is selected in the combo box
DoCmd.ShowAllRecords
Me!cboVolumeLicensing.SetFocus
DoCmd.FindRecord Me!cboVolumeLicensing
'Set value of combo box equal to an empty string
End Sub
The Query is Volume License Query and it is composed of Main Table and Volume Licensing Table connected by serial number on the main table and volume license on the volume licensing table..The combo box is volumeLicensing .And the form I am trying to do this in is called Volume License Form
Hello all - Working on a form that is supposed to display order approval information. In the database I'm working with, people are stored as in the approvals table by a reference to an autonumbered value. However, I want to display their name, which can be obtained normally through an SQL or DLookUp Command. This tabular form style though is giving me a problem. If I put new textboxes on the form and load it as I normally would, like:
ApprovalName.Value = DLookup ("[UserName]", "Users", "Users.UserID =" str(ApprovalID.Value*))
*ApprovalID is a hidden textbox that stores the number that is used to represent a particular user.
The problem becomes that using an OnLoad or and OnCurrent Form function, the boxes only load one value. I want them to load the different values for the different entries, but I am lost as to how to do this. Any help would be appreciated.
A similar issue that I've been having with reports is that I don't know how I would do this at all... I want to do the same thing (retrieve the Name or whatever that is related to a numerical value) and put it on the report. I'd appreciate any info on how to do this.
Thanks
I'm not a complete Access beginner, but I'm also far from an expert and not much of a programmer. So I feel that there's a chance this might be a relatively simple issue I'm merely making more complicated than it should be. But hopefully someone can at least point me in the right direction. (For the record, I'm using Access 2007.)
I've created a form to which I've added three tabbed pages. Each of these pages contains a subform the user can use to enter data into three different tables. The tables' relationships look to be set up properly, and there doesn't seem to be a problem with typing the information into the subforms. However, I want a single button press to update the information across all the tables and clear all the fields in the subforms so that the user can then go about entering the next person. I can't seem to figure out how to do this.
I downloaded a number of template databases from Microsoft, and some of them have exactly the kind of functionality I'm looking for: a "Save and New" button that inputs all the data across the tabbed pages and then lets the user start over from scratch with blank forms. I've spent a fair amount of time studying the various forms in the Student template, but I'm having absolutely no luck replicating that functionality. I basically want everything to work almost exactly the same as that, except with different field and table names (of course).
Can someone please explain what I'm doing wrong and how I might fix things, or at the very least how to look at the Students template database to get the information I need on how to do this myself? I'd be very grateful for any help on this matter. Thanks.
I've created a query called "JobHistoryQuery" and a form called "JobHistoryMultiForm", this displays all Jobs related to an Asset and all the information about that job. There are some fields (BilledMonth, BilledYear, BilledValue, Parts Required, PartsUsed), however, that I would only like to see if I need to see them (as there is quite a lot of information on the form and ideally, I'd like to be able to see the key information from each job from that asset with ease). What I would like is to create a button that says "Billing" and "Parts" for each job and it brings up a pop up window displaying that information.
View 11 Replies View RelatedOn my form I would like the user to be able to select a company, and once the company has been selected I would like a box to display all the contact information for the specific company. I would also like this box to record the contact information onto my database along with the other information that will be gathered on the same form.The Contacts and Companies are linked with the COSYSNO and CoSysNo fields.
View 1 Replies View RelatedI am working on setting up a loop that will get information from a query. I can handle the rest of the code once I get the primary piece of information. Which at this point I can not get. I am trying to get to the next record of my query. For some reason I am stuck on just the first record and it is repeated the exact number of times equal to the number of records in the query. Here is what I have so far.
Code:
Dim FSO As Object
Dim FromPath As String
Dim FromPathCheck As String
Dim ToPath As String
Dim FinalDestination As String
[Code]....
Yes I do know that I am doubled up on the
Code:
rs.MoveNext
The reason is because with out this added rs it goes into an infinite loop. Need generating each value in the TRNumber field in the query.
I created a vehicle database that includes a sevice subform to track service history. The main form is bound to the vehicle table that tracks the vehicles we have. (Vehicle_ID). The service history has its own table that stores its history and is link to the vehicles table. I created a report that shows my vehicle and its last history item. When i click on it, it will bring up the vehicle form where you can add information. Is there a way to create the form, so when i enter the latest information and i click on it, it will bring up my main form, and in my subform svc history, display the lastest information.
View 1 Replies View RelatedMy idea is to have a field in my table that have ratings for example - 1,2,3,4,5,6,7,8,9,10. How can i make one star.jpg image to appear when I've entered rating 1, two stars to appear when I've entered rating 2, 3 stars for rating 3 and etc.... Is that even possible? If it isn't is there any other way i can make this?
View 14 Replies View RelatedI have a database I'm creating for DVD/blu-ray sales. I currently have a order system in place in a subform, which uses a combo box to find the customer and fills in all the information in the rest of the subform. One piece of information is the date of sale.
I need to be able to have the ability to change the price of the DVDs and have a history of sales with the right price. The easiest way to do this seemed to be by Date of sale. So the price is linked to the date of sale, when the price changes, all orders before that change use the old price, after use the current price.
I was wondering if there is anyway to have a second subform on the same page and us the date of sale from subform1 and have it display the price in the second subform?
Retrieval of data from a query and putting it into a textbox on a form. I currently have a form where I would like to put in a Job Number, and then hit an "Update" button and it will show some of the data fields associated with that Job Number. I have a table called "All Jobs" and each Job Number is unique. Where I'm really having issues with is in regards to Dates and Boolean fields.
In one form, I put in a job number and it will bring up the Company, Motor type, Received Date, and Quote. I have been able to retrieve the Company, Motor, and Quote with a DLookUp expression using a query. The expression looks like:
CompanyName.Value = DLookUp("Company","Approved Job Form - Find Job Info").
CompanyName would be the name of the textbox on the form, with "Company" the field within the "Approved Job Form - Find Job Info" query. The query itself uses the job number entered onto the form and returns the other data fields associated with that job number. Running the query by itself returns the correct information. My issue comes with using the Date Received field. It seems that because that field type is a Short Date, my DLookUp expression keeps prompting the debugger in the code. Currently I have:
RcvDate.Value = DLookUp("Receive Date","Approved Job Form - Find Job Info")
This will not bring the date from the query into my text box like the others.
In another form, I'm also having issues with a Boolean data field. I would like to have a query that looks up a job number, and if my data field (Job On Hold) is checked (True), I would like it to return a value of "Job On Hold / In Progress" into a text box. If it is unchecked (False), I would like it to return "Job Approved". I've tried a bunch of different ways to make it work, but I'm really stumped. The makeshift code I last tried (I've tried this numerous ways, so I'm not sure if I was closer before) is:
Dim jobstatus As Boolean
jobstatus = DLookup("Job on Hold", "Job Status Form - Search Status")
If jobstatus = False Then
Status.Value = "Job Approved"
Else
Status.Value = "Job On Hold / In Progress"
End If
I've tried using the vba to have unbound forms information pasted to a table. The Vendor, Channel and Department are unbound fields in the form and I can't, for the life of me, figure out how to get them to append to the table.
I've tried using solutions provided prior but I must be missing something. Here's my database. I'd like for it to append to the table then ready the form for the next entry.
I have attached a portion of my database. if you go into the form called frmtest, select a branch from the very top drop down, select a detail and click the Edit button.how to have the information populate all the fields for editing. The Cost and Quantity fields work but my combo box fields don't properly work. The top combo box populates but when the record is updated it doesn't save the id. The second combo box doesn't even put the data in the data box.The main table where IDs and fields are is the BRANCH_EXP table, it's a linking table which links tables with many to many realationships.
View 3 Replies View Related