Tricky - Highlight Listbox Pre-Loaded From Master Highlighted From Saved
Feb 13, 2006
Hello Everyone :D :
I have a reporting interface providing users with a multitude of reporting options and capabilities. One aspect involves utilizing the ability to allow users to save their settings on the interface due to the number of options provided. One of the aspects revolves around working with listboxes.
Each listbox is pre-loaded every time with a list of items from a master table pertaining to the listbox. The user selects their desired choices, saves*, etc...Once loading a setting, I'm looking to have the listbox pre-loaded (easy) but then auto highlighting the items selected or rather pulled from the user settings table (each listbox has own table for user saving of options). So, if a user selects items Alpha, Beta, Delta, and Falcon from a list of 100 choices, then those 4 items would be saved under that user setting, within the code table (user specific). When they load the setting back onto the user interface, it should pull the 100 choices and auto highlight the 4 items. Hopefully I've explained that properly.
*A user is able to save, save as, load settings, unload settings, etc...from the reporting interface. When a user saves settings, these settings are saved within the user settings tables. Each table varies depending on the nature of the values within the reporting interface. Listboxes have their own tables connected to the primary settings table.
Any ideas anyone? :rolleyes: :D
View Replies
ADVERTISEMENT
Jul 13, 2005
How do you get the highlighted value to move with the keystrokes in a list box(ie. hit the b key and goes to first b in the list etc)
scratch
View 1 Replies
View Related
Jul 25, 2005
How do i apply a query that i want to execute only on a highlighted record in a listbox.
If there is a link, sample database or lines of code could you please assist.
Currently everything is being executed on all of the records in the query.
Also Does Access 2000 support codes for drag and drop forms?
View 2 Replies
View Related
Jul 2, 2014
I am using Access 2010.
I have a form with three listbox. My issue is this, when I go from listbox to listbox the selected item in the previous listbox is still selected.
I would like it so when I go to the new listbox, then the previous listbox selection will no longer be highlighted.
I use the follow code, which works but the user has to double click on the listbox with the focus to make a selection.
Code:
Me.listbox.listindex = -1
I have the code in the lost focus event of the listboxes.
Is there a way to prevent the double clicking?
View 7 Replies
View Related
Aug 11, 2014
I have a trouble to save data from Listbox to table. I can select mutiple data from Listbox, but the data cannot be saved on the table.
Here is the detail infor:
FORM name: Attendance
FORM record source: TBL_Attendance
Listbox Name: ARR_Result
table for Listbox to use: TBL_ARR
I want to these multiple records which come from Listbox (data on the TBL_ARR table)to be saved in table TBL_Attendance.
View 8 Replies
View Related
Oct 3, 2013
How can I pass two (2) values to a saved query ? These values are in a form that has a listbox with two (2) columns. The name of the form is 'Previous Evaluation Form'. I'm able to retrieve the values from both columns of the listbox in the form and I've already created the query. Both are working fine, but can figure out how to pass the query's criteria to select records for 'Name' and 'Date' columns of the query. Below is what I had in the 'Criteria:' of the query. What wrong with the code that is placed in the query's 'Criteria:' ?
Forms![Previous Evaluation Form]![Individuals].Column(0)
Forms![Previous Evaluation Form]![Individuals].Column(1)
View 3 Replies
View Related
Feb 17, 2006
Hi all,
I would like to set the filter property in some forms that are not loaded. Does anybody now how these forms and their properties can be accessed via VBA?
Cheers
View 1 Replies
View Related
Apr 23, 2013
I have a db that I added a switchboard to; it has 6 buttons, the first 4 work correctly. The remaining 2 buttons, Btn5 and Btn6 load forms "Gallery" and "Beginner_Pics" that display pictures. These 2 forms work perfectly when I load them directly. These Forms do not pause for a comboBox selection to be made; they act as though a selection was made ending with my error message display. No subsequent ComboBox selections work thereafter. At first I thought the Switchboard was loading old Forms, since the Switchboard was developed before the last two forms were totally debuged, but all old Forms have all been deleted. I do not know where to look for the problem Switchboard or the errant forms. Is it possible I need an "On Load" Event Procedure to force a ComboBox selection?
View 4 Replies
View Related
Sep 21, 2006
Can anyone please help or advise where I can look for help on this problem.
I have a subform which shows all my outstanding orders. Below it is a calculated field which shows the total weight of all the orders. (Steel Beams)
I would like to be able to highlight the weights on certain orders & show total weight for only these orders. (Similar to the way it can be done in excel)
I have been trying to do it via a query with a Yes/No check box & when I check the orders required the total weight changes. But I cannot get it to work properly as this puts a Yes in the field & the record disappears.
I only want it for a quick reference to save doing mental summing up so don’t want to change or add anything to a field to get answer.
Can anyone give me any ideas please?
Tks
View 4 Replies
View Related
Mar 28, 2007
I have created a variety of mail merged documents that are opened by a visual basic procedure using VBA from within my database system. e.g. the document is selected in Access from a drop down box in a dialogue box. The 'OK' button is clicked and visual basic loads up the document selected, my code is below:
Option Compare Database
Dim objWord As Word.Application
Private Sub cmdGOletter_Click()
Forms!frmLetter.cmbLetter.SetFocus
Set objWord = CreateObject("word.Application")
objWord.Visible = True
Select Case cmbLetter.Text
Case "Clients"
objWord.Documents.Open "d:computing projectLettersClients.doc", , , False
Case "Funders"
objWord.Documents.Open "d:computing projectLettersFunders.doc", , , False
Case "Volunteers and Staff"
objWord.Documents.Open "d:computing projectLettersWorkers.doc", , , False
Case "Everybody"
objWord.Documents.Open "d:computing projectLettersEverybody.doc", , , False
End Select
End Sub
**This code loads the correct document fine, but however disables the mail merge top toolbar on load - something that does not happen when the document that is being opened is opened directly from file.
It is important that my user can navigate between the records of the mail merged document otherwise they will only ever be able to do a personalised letter for the first person in the list!
Read only is not an issue as I have tried it with and without. at the moment I have set them to edit protection, so that the user can open in read only to print off, and a technical analyst can use the password to alter it.
Any help would be appreciated
View 4 Replies
View Related
Feb 2, 2014
I have two related forms.One is a list of transactions and the other is used for both inquiry and adding new transactions. If the Inquiry form is just sitting in Add mode and the List form tries to open it in Edit mode, it won't open. Is there a way I can tell from the List form that the Inquiry form is in Add mode and either close it or tell the operator about the issue?
View 1 Replies
View Related
Nov 19, 2004
I have a training database in which I want to make a text box that data only needs to be entered once for 50 records (not once for each record). But I need to include the information from that box in a form that is already getting its info from another table. When I try to do this with a second table I get this- #Name. And if I include the needed field in my query I'll have to update each record rather than just one time. I have a different database that does this, but I inherited it from someone else, who locked out design view, and I can't contact him to find out how he did it. PLEASE HELP!
Thanks,
Scott
View 5 Replies
View Related
Jan 31, 2014
I have a numeric value in table A followed by its form, i need to highlight the filed at form if the numeric value becomes same for table A & B this i want to do with the form of table A no matter what the color of highlight is.
View 1 Replies
View Related
May 5, 2015
I am simply trying to find text on a Web Browser Control htm page.
Using MS Access 2003, I have a form that includes the activeX Web Browser Control. On load of the form I initialize the web like below:
Code:
Dim strURL As String
strURL = "http://www.justice.gov/eoir/profcond/chart.htm"
Me.WebBrowser0.Navigate strURL
Me.WebBrowser0.Silent = True
The page loads fine.
Now, also, on my form is an unbound text box I call: [txtFind] and a command button I call [cmdFind]. I want [cmdFind] to find the first occurrence of the value in [txtFind]. My code below doesn't do anything when I click the [cmdFind] button.
Code:
Public oRange As Object
Public myfindFirst As Boolean
Public intTextLength As Long
Private Sub cmdFind_Click()
Dim sSearch As String
Dim strText As String
[Code] .....
View 9 Replies
View Related
Sep 12, 2014
is there a way in vba we can check the status of Insert key if it is on or off when the form is loaded?
i want for the insert key to be on, where the key strokes write over the existing entry.
i do set the key preview to "yes" in the form, and it works fine, but i wanted it only on a specific object.
View 2 Replies
View Related
Jul 26, 2005
I do not know if I'm shooting for the moon here (I haven't seen anything like this yet). I have a database that keeps track of different flights for screw conveyors. The part number on these flights are based on many fields in the database, with a couple characters that aren't. I am trying to make a validation rule that checks to make sure the feilds that are a part of the Part Number match up, or if there is a way to have it auto-fill everything except the 2 characters that have to be entered manually. I don't even know if what I'm saying makes sense (Story of my Life).
Thanks to anyone who can help, and those who wish they could.
-Brian
View 1 Replies
View Related
Jun 18, 2007
im creating an error reporting database.
for this the hardware/system items need entering
they will have a unique id
to assist identification i would like the unique id to start with a 3 letter code refering to the type of hardware/system/periferal followed by the number
e.g a printer will ahve the id "ptr 00000" and a computer will have the id "cpu 00000" with the 3 letters automaticaly comeing from a combobox field in the same table (form to the user)
i have allready been able to get autonumbers with 3 letters before when i created the tecnitian id they are "TEC-00000"
any help thanked. im an A2 student so i know all the code stuff.
thanks in advance
Jimmythemadman.
View 14 Replies
View Related
Sep 7, 2006
I have an insurance policy database keeping track of insurance policy details for household and commercial shops and businesses.
Tables I have are tblPolicyHousehold, tblPolicyCommercialS (Shop), tblPolicyCommercialB (Business).
They each contain the following fields (the other fields they contain aren't relevant to this)... SumInsured, extCover1Desc, extCover1SumInsured, extCover2Desc, extCover2SumInsured, extCover2Desc, extCover2SumInsured
I want write a query to list all the policies with the building sum insured. Easy enough... Heres the catch.
In some of the extended cover fields it will say in the description...
"Building of 123 AnyStreet" so I want to get the value of that extended cover item where the description for it contains building...
So I want to get extCover1SumInsured where extCover1Desc LIKE "*Building*" and adding that value to the SumInsured field...
Any ideas?
View 2 Replies
View Related
Oct 2, 2006
I have one query that shows a NAME for each day.
Every day each NAME must have one and just one SITUATION.
So I'm trying to make a query that shows which have NO SITUAITON yet and other that shows which HAVE A SITUATION already.
View 4 Replies
View Related
Feb 19, 2008
Hi All,
I have attached a file which I need a help from, I need the subform to be populated based only on the Employee Code and the Dates where the employee logged-in a Job Order.
I dont have any code on the cmd button for I am lost on what will be the query statement to update the subform datasheet.
Thanks.
View 2 Replies
View Related
Jun 22, 2013
I am interested, is it possible to read currently selected (highlighted) row in table?
I know that this is possible to move cursor on concrete field in table via VBA but is it possible to read record number when we move cursor manually (via arrows)?
View 13 Replies
View Related
May 18, 2015
when i generate a report i intermittently get a page that has the detail section highlighted. The report generates an invoice for each customer selected, a new page for each invoice with a repeating header on each page. I have used the vba to some of the formatting on the page. Usually there are between 20-40 pages generated with each report, or there is an option to print just one invoice. I get the highlight on 1 page on some set of invoices, and other everything works fine.
I can not for the life of me figure out what variables are causing the detail section to be highlighted. Does not repeat on a specific customer, place in the report, or any specific that i can tell. What settings/variables/triggers/events would cause the detail section to become highlighted blue.
Right now i can generate the report, see a blue page(usually after its printed), and the regenerate it and its not there or on a different page. The invoices uploaded are for the same person generated right after each other..
View 3 Replies
View Related
Sep 23, 2013
Access 2003
I have a rather complex form with an ODBC connection to data that takes some time to load.
The Form has a continuous subform I am using in place of a listbox to select records (I need more functionality than a listbox)
The Form's Record Source is a query
When the form opens, I does so in pieces as it populates
I'd like to either keep the form hidden until it completely loads
View 1 Replies
View Related
Nov 5, 2007
In Access 2003 we use an mdw file (unfortunately named system.mdw) that people are joined to (by using Workgroup Administrator) when they become a new user on the system. This works well except that it is time consuming to go through the process for every new user. I am aware that you can create a new mdw file using the user-level security wizard however I have extra problems. This was set up originally when access 97 was in use and the no of users was about 4, there are now 50 plus and growing. We have numerous databases that are all secured through the use of the same mdw file, however as people are only joining this mdw (by using the Workgroup Administrator), when we get someone with a little computer savvy they will figure out that by creating a generic system.mdw file they can escape all security levels that are in existence in the system.mdw file that we want them to use.
Is it possible to somehow get a database to associate itself with an mdw after the mdw has been extensively modified?
I am aware of short cuts that have the mdw file in them but they are easily bypassed. Furthermore as we have numerous probably 100 databases all pointing at the one mdw file is it possible to get them all associated with the same mdw file? I have looked through the forums and various others but have not found an answer that will help me. Can anyone help?
View 5 Replies
View Related
Jan 10, 2008
Hi all,
My boss has asked me if I could take a look at the following problem and whilst I've searched around and tinkered with it myself I'm not making too much progress!
Here is an example:
I have forecast data for working weekdays Mon-Fri. For the weekend I need to replicate data from Friday across the Sat/Sun rows. This is just outside my remit! The data is then exported to Excel where imbalance costs etc. are calculated.
Background: The result will be that management will be able to tell what value *weekend* work will have. At present I already have a set of results for all DF activity. If we take that figure and subtract THIS result we'll be able to see how much benefit working on the weekend has.
Something management are very keen on looking into :)
Any suggestions on where to start would be much appreciated.
Thanks.
View 3 Replies
View Related
Feb 3, 2008
Ok, I have a table that contains a number of yes/no fields depending on location.
There are two main parts of my db that use this, one is users (for their departments) and the second is changes (for secondary locations)
I want to have two fields in the table used to reference a set of locations. Meaning i can reference the table and get locations where userID = 3 or alternativly where ChangeNumber = 6
Can somebody help me in making this work. Im currently having issues with duplicate values etc
View 3 Replies
View Related
