Ok, there is one main form and a subform which is linked directly to a table. A VBA routine checks entries and flags certain rows for errors. We want to highlight specific cells that are out of tolerance.
Been playing around with the Me.ActiveControl.BackColor = vbYellow
But if this can be done to a particular cell on a table, and if this can be done using VBA.
Hi
i have a small access program set up and it all works except one item, there is a sub table that we would like to add in information relating to the order number etc:
order number 1
sub table would have j number 12345
allocation 5
and j number 56789
allocation 25
order number 2 (new record)
could have j number 148
allocation 1
j number 2143213
allocation 12345555
j number 86868
allocation 34
etc
then when you move between each order the information in the table will show the specific information relative to the order number
at the moment when you move from record to record it clears the fields but enters the information into a table
hope this makes some sort of sense
any assistance would be gratefully received
best regards
kev
p.s.if it would i could attach a copy of the database
Hi all!!
I've inherited a new db that was created by folks fresh out of school.
I've been looking through it, checking to see how they built it, trying to scope out any neat and nifty new tricks they've used, before something goes wrong and I have to work on it.
They have a table that displays grouped records, and I'm not sure how they did it.
For example:
In the PRODUCTS table, the first record is for [Product Type] "Sticky Stuff", [Product Name] "GooGoo", [Manufacturer] "XYZ Co.", etc, with a + sign in front of the record.
When you expand the record, you get what looks like a sub-table listing all the transactions having to do with "GooGoo".
While trying to figure out how they got this effect, I checked out the Inventory Management sample db that's available on-line. They also have this type of grouped records in a product table.
Is there a simple explanation of how this is done, or do I need to invest some serious study time?
As always, thanks for any guidance you can give me.
Froggiebeckie
How do we create a subtable in access. When you open a table. First column come with + singn. When you click the + sign you get another sub table. How do we creat that table. What is the purpose of this table?
regards,
- Mahen
Employee Record table:
Name
Department
etc...
ICU Required Inservices:
Name
Conscious Sedation/Analgesia (Yes/No)
Intraaortic Balloon Pumps (yes/no)
Inservice 3 (Yes/No)
Inservice 4 (Yes/No)
I am trying to build a query or table that will pull all Employees
in the ICU and include the required inservices so that I can
track who has attended and who has not.
This is a huge database I built for the entire hospital.
I need a relationship between the two that won't require me to
have EVERY employee record (all 850 of them) in the related table
so that I can pull just the ICU names.
Any ideas???? thanks!
Hi,
I'm new to Access and am having trouble designing a database that houses application details.
All applications have a list of unique wrap id's but have different tables housing different details for these wraps.
I have a main table which is for data entry and lets me input whether or not a piece of software is Vista compatible (yes/no) etc.
I also have a field in this table showing which analyst is responsible for researching compatiblity of an application.
I have another table with different regions i.e. london, manchester etc that has the region/city listed as the field heading and then contains a list of wraps used in that city under the relevant field.
My main entry form is linked to the main data entry table that holds specifics for an app, name, vista compatible etc. This form is used for data entry. I want to add a subform on this form which shows a list of all applications, in table format, but I want a drop down list so I can select an analyst name / region so that analysts can update details for a specific area assigned to them. In the table I want all of the records based on this criteria to be displayed.
I guess I need to make a filter button on my subform but do not know how to do this. I put in a button control for apply filter by form but then dont know what to do.
I'm new to access and don't know much VB - e.g. the only thing I can do in VB is a make a message box that says hello world on the screen.
Any help is sincerely appreciated. Apologies for the Essay.
Kind Regards
Bal
I have a sub table that acts as a revision history for the items in my main table. I've just finished uploading all the records into the main table and now I want to insert one record into the subtable for each record in the main table to start the history with the record creation.
The sub table looks like this:
tblRevisions
- RevID (auto Number / primary Key)
- RevDate (date of revision)
- RevName (Who made the revision)
- RevDesc (What revision was made)
- RevAuthorized (Who authorized the revision)
- RevLabel (Foreign key to the primary table)
The info I want to insert is:
RevID - Auto Number
RevDate - 11/27/2013
RevName - 3
RevDesc - "Added Label to database"
RevAuthorized - 1
RevLabel - (One for each record ID in tblLabels)
I suspect that I want to start with an insert into statement, something along the lines of:
Code:
Insert into tblRevisions (Revdate, RevName, RevDesc, RevAuthorized, RevLabel)
Values ("11/27/2013",3,"Added label to database", 1, ?)
I'm not sure how to indicate that there should be one label for each Record in tblLabels or that revLabel value should match the ID from tblLabels though.
i have a table of articles. A field in the table is ArticleSubject
the ArticleID is made up of 3 letters then 3 numbers. i want the 3 letters to be something according to the subject
for example i want the first 3 letters of the ArticleID to be MAT*** (* is a number) if the subject is Maths
or ENG*** if the subject is English
the subject is picked from a listbox in the same record
how would i do this in a table . i am reluctant to use append or update queries.
but will do so if its the only way.
All seemed to be working well, however, I noticed that all my subtable records in the database are exporting with each Primary table record. In my output, I'm looking to see each primary table record followed by one or more subtable records from a one to many relationship.
(Office 2010) Access/Word
Private Sub cmdPrint1_Click()
Dim objWord As Word.Application
Dim docm As Word.Document
Dim db As DAO.Database
Dim rstLandSales As DAO.Recordset
[Code] ......
I'm sub-novice when it comes to Access I'm trying to get calculated data in a field in a sub table to autofill in a field in a related table. So all of the data in 'total hours' column is calculated by the variable inputs in the 'hours' fields. Once there, I want it to feed itself into the 'total hours' field on the main table. Is that possible? Also - the 'total hours' field in the sub table won't calculate anything unless a value is placed in EVERY 'hours' field in the same sub table (e.g. 0).
View 14 Replies View RelatedHello ,
I have a problem , I need to highlight a row in a table .How can I do it ? can i make it using query ?
Is their a way to highlight a feild. I am using the duplicate function but after the record is duplicated their are certain feilds that have to be changed, how can i highlight them somehow. ANy ideas??? The feild is Price???
Thanks Very good forum
Pete
I have a form with data in formview. When I select a record I want it to highlight with a specific color.
How can I do that?
How do I turn off the highlight feature when a control on a form obtains focus?
Fen
Good Day All,
I have a wild card search query (Like "*" & [Forms]![search]![Text0] & "*") that works very well. I want to be able to have the phrase that user types in highlighted when it returns the search results on a form. I found the following thread that asks the same question using Conditional formating, but the suggested answer doesn't work. Any ideas?
http://www.access-programmers.co.uk/forums/showthread.php?t=73845&highlight=highlight+search
Code:
Private Sub Combo1309_AfterUpdate()
If Me.Combo1309.Value = "Yes" Then
Me.Text1307 = Environ("UserName")
ElseIf Me.Combo1309.Value = "No" Then
Me.Text1307 = Environ("UserName")
End If
End Sub
I am using the above code to capture the login information. Is it possible to add a second criteria to the Me.Combo1309.Value = "No" that also highlights the Textbox (Gender) Red? Ideally, the value in this textbox would be switched to the opposite, but this option might be more trouble then its worth.
How would I go about writing some code to highlight the current day if a day field in a form matches.
i.e. I have a schedule form that has a field that has the day manually entered, so Monday, Tuesday etc.
And on the top of the form I have a text box set to =Now() and the date format set to dd mmmm - dddd
And what I want to do is make it so what ever the current day is, any records in the form that match the current day will be highlighted.
How to I can Highlight key search result.
View 14 Replies View RelatedHello all,
This is my first post. I have been trying to find a solution for the following issue. I have a Continuous form and I would like to highlight the record by clicking on any of the fields in that record, tried everything with no luck, any ideas?
Thank you
Hi guys
I just built a tracking database (I can't post it because it contains PHI, and I do hope I don't have to) and it's been giving this issue starting today.
When I am in a field the cursor automatically goes to the end and highlights everything between the end and where I click. So if I mistype the third character I need to delete everything from the end to the third character to edit it.
It just started doing this when I loaded it up. Does anyone have any idea?
Thanks
When tabbing through a form is it possible to highlight the field you have tabbed to?
View 1 Replies View RelatedI have a form that I need to update whenever a chosen business name changes. This is tied to a search function that updates/changes the business name, and this works fine. What I now need it to do is when the name is clicked on the table (which updates the respective business name) I need everything else to update with it.
I have tried refreshing the business name, the form, even the records themselves with onClick and onChange functions, but it still doesn't work.
Re-reading this I realize it doesn't make much sense, but hopefully the attached database will clear things up. When you type in the info in the search box, all the stuff in the right corner changes accordingly. If you click and highlight anything in the box in the center instead of using the search function, the business name at the bottom changes but everything in the right corner remains unchanged.
I have a form that acts as a search form where the user inputs a string of text which then updates and filters a list box. For some reason when it does this it highlights the 2nd row on that list, even if there is no data there. How can I get it to automatically highlight the first row? The database is attached and the form in question is FRM_SearchMulti.
View 1 Replies View RelatedI don't even know how to ask this question! Is it possible to do something like this (dotted line is not part of the data):
DNA Primer Set............Reagents.............Initial....... ........Final
COMBIII.....................Template DNA.........50.....................7
................................PCR Buffer.............10.....................1
................................Nucleotides....... .....10.....................5
I would like to be able to get the the Reagent, Initial, and Final information for each DNA Primer Set without having to create a separate record for each line of information:
COMBIII Template DNA 50 7
COMBIII PCR Buffer 10 1
COMBIII Nucleotides 10 5
Thanks
Here's one for you guys:
My vision-impaired staff are having trouble seeing the blinking caret when they tab over to the next field in a form. Is there a way to highlight the newly-selected field instead of just having a thin blinking caret to guide the way?
Hey guys
it's been a long time since i've been here
but i again need your help
my job asked me if it's possible to have keywords highlighted in search results in report
am i clear?
meaning, when you search for keywords in one of the fields, and then your results come out in the report, can they be selected, like in Word, or in searches on the Internet, like when doing a search on Monster, all your keywords will come out in red, that way you can easily read the results
so can this be done in Acess?