Get A Field Only If It Equals What I Asked
Sep 18, 2005
I have a table with data of people, in which table two fields contain two (not necessarily different) jobs.
I want to build a query (and later a report based on that query) which will return the name, address, phone of the person, plus only the field of the job that I asked for it.
when executing the query, the user should enter the asked job in a popup-box using the below formula.
Like "*" & [job] & "*"
Note, that there may be records containing in both job fields the same job. I want to get the field only if it contains the asked job.
Any ideas?
Thanks
View Replies
ADVERTISEMENT
Mar 11, 2014
I have a form (PostProductionForm) which is used to input data about finished goods which come off a production line. There are three possible outcomes which can occur after the production: Passed, Reprocessed, Failed and the numbers for these are entered in 3 text boxes on the form (QtyReprocessedTxt, QtyFailedTxt, QtyPassedTxt).
These text boxes are auto populated with a 0 from the table (PostProductionTbl) so there aren't blanks.
What I am trying to do is use an IF function (I think) which says that if Quantity Reprocessed is equal to zero when the submit button is pressed, the "Reason for reprocessing" combo (RPReasonCombo) must have something selected (i.e. can't be blank) or it won't go to a new record.
View 5 Replies
View Related
Mar 26, 2014
I am in the process of making some changes to an inherited database. One of the things I need to do is to fix an issue with the reports. The reports have a field which asks for the data range (from xx/xx/xx to xx/xx/xx) as soon as the report is opened, but then the query that fills that report also asks for the same data range so you end up entering it twice.
What do I need to do to enter the data range only once and have it show up on the report and also be used on the query?
View 3 Replies
View Related
Mar 17, 2012
I have a form, which i use to book in products received. What i want to do is if the quantity received is equal to what was ordered then i'd like to update a yes/no field (Order Complete) on a separate table to true.
View 8 Replies
View Related
Feb 15, 2007
Small project for the local police dept. They want an easy small program to track overtime and who gets it, got it, doesn't want it, etc.
All good, but they want to be able to generate a list (report or on screen) of all those who has received OT and their balance to date, with he/she with the least OT first and ascending from there. In a report I can easily use the sum function in the section footer but how can I sort by that? Or, harder yet, how can I add the numbers in a column in a table/query since the field which contains the "OT hours assigned" will be for each assignment?
So, I guess I need to add a given field value to the other values for a running balance (of coarse this will need to be seperated by each employee).
Thanks
Jim
View 2 Replies
View Related
Jan 9, 2008
Ok, I reckon there's a gremlin in this damn db...
For a form, i have a series of check boxes. One of these had a & symbol in the name, i originally had this working, but with some extra functionality added it no longer became possible, as it recognised it as a special character. The checkbox, and relating table reference was Inform_Q&FS I changed all references of it to Inform_QFS. However, im getting a parameter window pop up asking for the original reference. I've tracked it down to a point between a button being clicked and the begining of the following forms load Sub. The point of the button method triggering the parameter window is the line where the button changes the subform to the new form.
Here is the db..
Could somebody please take a look and see whats going on... im starting to get really frustrated with databases. :(
Also, any general comments regarding the db are welcome, as i'm assuming im doing things the right way there. and excuse the messy coding
View 4 Replies
View Related
Sep 11, 2007
Hi,
I have had a look at quite a few threads, but cannot find what i need. I am looking to show a command button if the value typed into the text box equals one of the values in the query. I understand how to show/hide a command button due to another post, but it is getting this to happen IF the text box matches one or more of the values in the query.
I have txtCustNo as the text box to type a number into
I have qryCustNo as the query name
i have cmdFindCust as command button
Should i have the code under the "after update" part of the text box also?
Thanks for your time,
Emily
View 4 Replies
View Related
Aug 19, 2004
When you run an Update Query using RunSQL, it always comes up with a box telling you the number of records you are updating and if you want to update. Is there a way to stop this box coming up and just perform the query.
Ed
View 1 Replies
View Related
Jul 28, 2005
I'm not looking for your expertise in "how to" do this (not yet, anyway) but a friend asked me if Access could do certain functions. Like "automatically fill-in some of the
more routine letters/forms such as basic letters of
representation, medical bill/record requests"
(routine for his biz) and "basic calendaring
functions, such as keeping track of monthly deadlines, reminders, and other
important dates."
I figured that if so, the app would have to be running in order track deadlines and such.
So, are these things that are Access able functions?
Tx
-Jim
View 3 Replies
View Related
Nov 13, 2005
Is there a way within this forum I could view all my questions/posts asked at the same time?
Thanks.
View 1 Replies
View Related
Feb 1, 2008
This is probably blindingly obvious but I'm unsure about it.
We'll refer to three tables, call them Table X, Table Y and Table Z.
Basically, I have a database with 10 tables. Table X links to Table Y via the Primary Key. Another field in Table X has a relationship with the Primary Key in Table Z (a foreign key).
Now, does the field in Table X that has a relationship with the primary key in Table Z need to be the primary key as well?
Put another way, does Table X need two primary keys?
View 1 Replies
View Related
Mar 13, 2014
I have my Jobs form which has a sub-form for all the different parts used on that job which then calculates the total charge and displays this on the main jobs form. Now how would I get this value to be stored in table tblJobs on the record where the ID = JobID on Jobs form. I need to do this to display the total on a report.
Looked around and couldn't find what I was looking for, is there a visual basic command to set it then I can use docmd.saverecord after or what would I need to do?
Or is there an SQL statement to do this I could execute on a button click or something similar?
View 9 Replies
View Related
Sep 12, 2005
Trying to fix a simple problem with some tables.
In my department, we recently switched servers and from Windows 98 to Windows 2000. We had a database that got converted somehow during the transition. One person didn't get their computer switched until about a month later.
In essence we had 2 databases of the same information going for a while. Now everyone has the same database. Problem is the following:
Simply put:
We have 10,000 records autonumbered in one of the databases. The other database has 9,500 with the last 100 or so being information that the 1st database does not contain. How can I update my main table to have all 10,100 records? I have tried an append query and it doesn't seem to be working right. I have also tried to 'find unmatched' but can't seem to make that work either. There has to be an easy solution to make it work in one step.
Any help would be great. Thanks in advance. :confused:
View 1 Replies
View Related
Jul 12, 2013
I want to ensure that employees submitted expenses that were actually valid. In table 'Payments', I have the employee ID and amount paid to that employee's account. In table 'Expenses', I have the employee ID and then the individual expenses the employee submitted. How can I create some VBA to find combinations of the employee's records in 'Expenses' that equal the total amount paid for that same Emp ID in table 'Payments'? My ideal end-result would be a report showing each employee IDs with the expenses and then the amount paid beside it. The below is a good start but I need to make it loop through every unique Employee ID.
remove spaces from URL
[URL]
View 8 Replies
View Related
Mar 11, 2013
why =listboxname.column(0) in the control source of a textbox will give me the value "#name?" ? I've used it successfully on another form..but for some reason its not working for me.
View 6 Replies
View Related
Nov 15, 2014
I have six fields in a record that look like Median.University1, Median.University2, Median.University3, Median. University4, Median.University5,Median.Unive rsity6. How can I create a calculated field that counts where values equals 4 in the fields . I have tried Dcount and Count with no success.
View 7 Replies
View Related
Aug 9, 2012
I have a macro that needs to run repeatedly until the number of records in a query =0 but I can't seem to get the Repeat Expression set properly.
My query is called sqMatchCount:
SELECT Count(sqCompare_Parts_Matched_1st.BRP_Entry_Num) AS MatchCount
FROM sqCompare_Parts_Matched_1st;
The theory is if I don't have any more matches then I do not want the macro to run any more. In other words, MatchCount will = 0 when there are no more matches.
I have tried a variety of syntax using DCount in the Repeat Expression:
=DCount("*","sqMatchCount") ...... Macro runs in a continuous loop
DCount("*","sqMatchCount")=0 ...... Macro does not run (although I thought a couple times it actually DID run with this syntax)
DCount("MatchCount","sqMatchCount")=0 ...... Macro does not run
=DCount("MatchCount","sqMatchCount")=0 ....... Macro does not run
=DCount("MatchCount","sqMatchCount") ....... Macro runs in a continuous loop
What IS the proper way to write this Repeat Expression for the RunMacro Action if I want it to run as long as sqMatchCount.MatchCount>0?
View 14 Replies
View Related
Jul 18, 2013
How can I get the value from a field in one table (in the sub form) to copy/insert into a field in another table (in the main form) when adding a new record?The main form and sub form are linked using parent/child linking, and the sub form is in a tab.I have table A (Visit Dates) in the main form which is used to record the date of a visit to a church. Table B (Quarters and Peals) is used to record an event that took place at that church during that visit. Note that not all visits in table A require a record to be created in table B - but half or more do.
In tables A and B I have a field called "QuarterOrPealID" and these are both primary keys, though the field in table B is set to 'no duplicates' and in table A it's set to 'duplicates allowed', as table A has its own auto number/pk. They are both linked in the relationships.
So, when I add a new record to table A using the main form, I might then need to click on the tab in the sub form to create a new record in table B, which has to be linked to the same record in table A. When the "QuarterOrPealID" auto number/pk is generated in the sub form (table B), I need that value to update to the "QuarterOrPealID" field of the main form (table A), so that when I'm viewing these records the form pulls all the information nicely together.
View 10 Replies
View Related
Oct 24, 2013
I want to filter my subform data, to only show records where field A is a higher value than field B.
Code:
Me.MySubform.Form.Filter = "A > B"
Me.MySubform.Form.FilterOn = True
This way it doesn't find field B.
Code:
Me.MySubform.Form.Filter = "A > " & MySubform.Form!B
Me.MySubform.Form.FilterOn = True
This way it seems to filter all record to the field B value of the first record.
View 5 Replies
View Related
Mar 4, 2015
Here is what I am trying to do. I have a query with 2 fields. "Time In" & "Time Out". What I would like to happen is this. Whenever a character, let's say a "t", is entered into that field I would like the current time to populate that field. Right now we are actually typing in the time. I have the fields set up as DateTime fields currently.
View 10 Replies
View Related
Nov 23, 2005
Hey all,
I have two fields 1 & 2
field 1 is a simple combo list of user defined values ie A, B, C or D
Field 2 relates to a attribute of the data in field 1 and is not always the same for A, B, C and D. i.e
A could have a,b,c,d or e
B could have c,e,f,g or h
C could have a,g,h,i or j
D could have v,w,x,y or z
I would field 2 to have a combo box which only displays a,b,c,d, or e when A is chosen in field 1; c,e,f,g or h when B is chosen; etc
How do I do this?
Cheers all,
Matt :confused:
View 2 Replies
View Related
Mar 21, 2013
I've just returned to work after kids and started managing a large Access database related to health, back-tracking over many years.
Currently in filling a form we physically enter:
Apples 2.2
red apple 2.4
red apple cut 2.45
Oranges 5.6
Cucumbers 8.5
Is it possible to get field 2 to automatically fill with a number code due to the text typed in field 1?
FWIW, I'm confident at more basic Access e.g making follow on default value = Dlast("field""table") type stuff but the more complex stuff I haven't touched since Uni over a decade ago and you will need to be gentle while I blow away the cobwebs
View 3 Replies
View Related
Feb 28, 2013
Within my table if Field 1 has an answer of Self (from drop down), then, I would like Fields 6-12 to auto populate; however, if Field 1 does not have an answer of Self, then leave Fields 6-12 blank.
I am not quite sure how to lay this out. I am using Access 2010.
View 8 Replies
View Related
Aug 19, 2015
I am currently stuck on set focus property. I have a main from with nested subform. I am trying to move the focus from last field of the subform to another field on the main form.
Customers(mfrm)....>Addresses(sfrm)...>Orders(sfrm Add)......>OrdDetails(sfrmOrders)
Now I have a field name [Securedesign] in frmOrderdetails and I want the tab order to navigate to field [CustomerID] in frmAddresses which is a subform to frmCustomers.
View 2 Replies
View Related
Jun 30, 2015
I have my Assets form and the primary key is the ChargerID, in this form I have an "Add New Job For This Asset" button, which opens up the Jobs form at a new record.
How do I make it so that the ChargerID field is automatically filled with whatever the previous record was instead of being blank.
For example if I have Charger12345 open in the Asset form, I'd like to click the Add New Job button and it automatically have Charger12345 in the ChargerID field of the Jobs form.
View 5 Replies
View Related
Feb 16, 2014
I'm pretty good with setting up a very simple database such as inventory, profiles, etc.. However I'm creating a database to keep track of a football (soccer) team's players and match statistics.What I have so farsample attached)
Tables:
* Players - PlayerID, Fname, Lname, position, goals, assists, etc (all details regarding a player)
* Position - Positons (Table containing positions eg: defender. Data is selected in player's form as a combo-box)
* Competition - Competition types (Cup, League, Friendly. Data is selected in Match's form as a combo-box
* Venue - similar to Competition table
* Opponent - Similar to above two tables
* Match - MatchID, Competition, Venue, etc (form corresponding to table attached)
Forms:
* Player form
* Match form
Now as shown in the sample, I choose players using the combo-box. Then whatever stats they had during the match are entered on the fields provided. How to link the player (selected using combo box) to the stat fields (goals, assist, YC, etc).
View 1 Replies
View Related
