Looking For Help With List Boxes In Access 2000
Nov 26, 2007Hi, I am trying to create a button that upon click it moves the slelected item in list box one to list box 2 but i am not sure how to go about it, cany anyone help?
Dominic
ADVERTISEMENT
Needing Help With List Boxes - Access 2000
Nov 27, 2007Hi, I am trying to create a button that upon click it moves the slelected item in list box one to list box 2 but i am not sure how to go about it, cany anyone help?
Dominic
Access Related List Boxes
Apr 29, 2005I have a music database created in Access.
I have lookup fields for CD Group and CD Name
Do I need a autolookup Query or Syncronized combo box to perform the following function.
Filter by Form
CD Group
Select from List box
CD Name only Display CD's related to that Group
Mormon Tabernacle Chior Cd Group
Only display CD's related to the Mormon Tabernacle Chior
NOT ALL RECORDS IN THE DATABASE.
I've bent my self backwards on this and get no were I know it might help me with some visual basic coading.
The only resources I have is some books on Access
I Live in a Rural Area and there are no computer coarses near me that fit my time.
This following procedure I think would be done for example with any Products Database let's Say like Bakery Items
NAme of Company
Nabisco
NAme of ITems
Crackers
Cookies
Only display products by each item Name
NOT ALL RECORDS IN THE DATABASE WHICH ARE BAKERY ITEMS IN THE LIST
wHEN I FILTER BY FORM
PLease email me at
mikevds@optonline.net
So somebody can get back to me on this
I can even send you some screen shots if you don't get what I am getting at.
Access 2000 Security - Authenticate With Windows 2000 Server Credentials
Oct 24, 2005Hi
I have a database that currently has security in place so that users input their own usernames and passwords to access the database. The users have recently been added to a windows 2000 server and I want to be able to use their windows 2000 server logon credentials to provide them with automatic access to the database. Is there anyone out there who knows how to set this up? It is a rather urgent request if you could get back to me either on this forum or via email
chris@ctbjs.co.uk
many thanks
Chris
Opening & Closing Excel 2000 Workbooks From Access 2000
Jun 2, 2006I am opening and closing a series of Excel 2000 Workbooks using Access 2000 VBA and want this sequence to be able to complete without any human intervention.
However, there are 2 instances when this stops and waits for a human option to be selected:
1. When the spreadsheet is password protected
2. When the spreadsheet has automatic links I get the message:
"The Workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook?"
How can I code it so that in situation 1 it skips this file and in situation 2 it automatically defaults to do not update?
Any help most appreciated.
Dalien51
Link/Transfer Data From Access 2000 To Excel 2000
Mar 27, 2006If I have a report in MS Access 2000 generated based on the criteria selected of a project with work order "9999" with the labor costs, materials costs and the Totals of each crew1, crew2,... and I would like to have those expenditures populated in corresponding cel in Excel for each crew, HOW would I do it?
To think it out loud, could I create a button on a form, so when I select the criteria for the work order, and when I click the button, it should refresh/update the Exel file with the new data...?? How do I write VBA code for that...?
Please help...Thank you so much....
Access 2000 & MSSQL 2000 Multiuser Problems
Aug 20, 2007Hi everybody,
I have recently been doing a conversion for my boss for a access 2000 database (both front and backend) to a MSSQL backend.
I finished the conversion today (as quite a lot of the code / queries ran slow due to access running the queries locally rather than on the server). And tested it on my and my boss's machine with no problems so he gave the go ahead to update everybody to our new mssql 2000 backend with the modified frontend.
This is when the problems started; We had two different sets of forms for accessing one of our databases systems - the log system, one is the original dynaset based form, and the other is a newer set which uses snapshot views and preforms updates via queries. Nobody uses the old dyanset system apart from my boss and one of the administrative team as they have things on that window which they need to see. About 30 minutes into the release of the new database the system frooze up on my bosses computer and nobody could create a new log (the server was timing out). I assumed this had something to do with the old dynaset's creating locks on the table.
I offlined the database and kicked everybody out of the front end, turned it on again and tied again, this time banning everybody from the dynaset system. Within 10 minutes another computer frooze up, again with a timeout on the insert query. I discovered that after you had added a new log to the database it would timeout on all subquent additions (something it hadn't done during testing) . Further investigatiion showed it was the snapshot list window causing the error, so coded the add log window to close the list before preforming the insert query and then reopen it afterwards. This allowed my machine to make multible additions without flaw. So I released a new client to everybody. 15 minutes later it was timing out again, but this time there you could not even make one new record.
I checked for locks on the table though the server management table and couldn't find any for the Log table. I have restarted the SQL server box and with no avil. So I reverted our backend to the access mdb file and told people to use the old client.
I am at a complete lose to why this is happening, if anybody has had any expericences like this or knows the cause please tell me.
Some information on the database in question.
It was made as an access 2 database all intergrated into one file, then it was seperated into two files (frontend and backend). Upgraded to Access 97, then to 2000 before this final update to MSSQL 2000.
The log system has two main tables. The first is the log title / info table which links (one to many) to a log entry table. This problem only occurs on the main log table and does not appear to be reoccurring anywhere else within the database. The main log table has just under 18,000 rows in it.
Thank you in advance for any help,
Dom
Modules & VBA :: Multi Select List Boxes With Multiple Columns In Access 2013
Oct 22, 2014I have a listbox set to Multiselect property of Simple. The listbox is populated by using a table. There are 4 columns in the listbox
Code:
1 3/23/2014 4/5/2014 2014
2 4/6/2014 4/19/2014 2014
3 4/20/2014 5/3/2014 2014
The columns are PayPeriod, StartDate, EndDate, FiscalYear
What I want to be able to do is highlight a chunk of dates and have the first selected StartDate and the last selected EndDate populate two hidden text boxes so I can use them for my queries/reports.
I've tried a couple different ways. Each time what happens is it only uses the last item I have selected in it's calculations.
Code:
Dim ItemIndex As Variant
For Each ItemIndex In Me.lstPayPeriods.ItemsSelected
If Me.lstPayPeriods.Selected(ItemIndex) And Me.lstPayPeriods.Selected(ItemIndex - 1) = False Then
Date1.SetFocus
Date1.Text = Me.lstPayPeriods.Column(2, Me.lstPayPeriods.ListIndex)
End If
Next
In this example I tried to have it go through each Item of the listbox. I wanted to check to see if the current row was selected and the row before it wasn't. That way I could determine it was the first item selected in the group of selected items. It would always only use the last item I had selected.
Code:
Dim CurrentRow As Integer
Dim FirstDate As Date
For CurrentRow = 0 To Me.lstPayPeriods.ListCount - 1
If Me.lstPayPeriods.Selected(CurrentRow) Then
Date2.SetFocus
[Code] ....
I tried to do something similar with this code. Again, it only uses the last item I have selected.
Replication Between SQL Server 2000 And MS Access 2000.
Nov 15, 2006Is it possible to have the master datebase in SQL Server, the replica in Access format and still can sychronize them?
Thank you in advance.
Forms +List Boxes +Text Boxes With Formulas
Nov 8, 2004I have a form with a List Box (List BoxA) that returns a value from a query. I then have a Text Box (Text BoxB) that uses the value from List BoxB and multiplies it by let's say 2. It works giving me the correct value but only becomes visible after I click inside List BoxA. How can I make it visible as soon as the form is opened? I tried refreshing the form data, didn't work and I tried a requery macro which didn't work either.
Thanks,
Lester
Use Multi-select List Box To Filter A Report With Two List Boxes
Nov 20, 2013Allen Browne's "Use a multi-select list box to filter a report" solution, in particularly with two multi-select list boxes? The code works fine for me for either box so long as I code it for one box alone. Combining the two into one code results in a type mismatch error. I'm trying to use the code to pass the contents of both multi-select boxes as Where conditions to a report. Both boxes are based on number fields. To try to isolate the problem, I've removed Allen's setDescription and OpenArgs conditions. We're unfortunately still on Access 2003 as the company desires to squeeze every dime by using until end-of-life next year.
Code:
Private Sub cmdPreview_Click()
On Error GoTo Err_Handler
'Purpose: Open the report filtered to the items selected in the list box.
Dim varItem As Variant 'Selected items
[Code] .....
List Boxes And Combo Boxes
Feb 28, 2007Hi everyone,
I have been making progress with customizing a
MS Access program, but one major problem is that
I have been trying to make a List Box or Combo Box
that I can use to enter data in the TABLE, but I
find that I get a pull-down list that has the list of
values from only the parameter that is primary key.
More specifically, the program is set up as follows:
I have two tables in this program: One that is called
"invoices" and one that is called "items". In both of
these tables, there is one common parameter, which
is "Item Number". Item number is the primary key,
and I used the "relationships" function to tie this
parameter to itself between the two tables.
I was successful in setting up a list-box for the
"Item Number", but when I try to set up a list-box
for another parameter that is supposed to display
a person's initials, the pull-down list displays the list
of item numbers instead of the list of people's initials.
In fact, I don't know if there is an extra step I need to
take so that the database stores a list of people's initials.
Instead, I just fill in the initials in the field for each
record for which the "Item Number" is the primary key.
How can I get the list-box to pull down a selection of
different people's initials, or in other words how can I get
all the people's initials to be stored so that the list of
initials can be looked up. Just so you know, I have tried
different choices of entries in the "Lookup" tab in the
Design mode of Tables, including Display Control,
Row Source Type, Row Source, and Bound Column,
but the outcome is that the only parameter that I
get get in the pull-down list is the primary key, which
is Item Number.
I appreciate any help you can offer in explaining how
to correct this.
On a separate note, one of the parameters is "Date", and
on the reports, I'm trying to figure out how to filter a
specific date range so that I can limit each report to a
specific month. Please advise me on this procedure as well.
Thanks.
ABC List Boxes
May 26, 2005How would I create not only a list box but a Cascade combo box in Acess could you help me out on this thread?
So when I selct J for J Richard Szeremany the next ABC box only lists the CD's by that Artist then I click on the Name of CD and the song onfo comes up.
mikevds@optonline.net
List Boxes
Aug 4, 2006Im having a problem with a listbox/query/label. My DB is based on one that was posted in the sample database are of this forum. In itself it works really well. Clicking on the labels at the top of the list box applys a sort to the list box, each one of these sorts is based on a query. My porblem is that I want to be able to produce and print a report based on those queries. I know I could put a bunch of buttons on the form and do it that way. Or put a list box with all the my reports in and do it that way. I would prefer though, to have one button with one report reading the information from the different queries depending on what label is selected. Hopefully thats clear, the DB demonstartes it better. Any help appreciated. Thanks!
View 7 Replies View RelatedList Boxes
Sep 8, 2006I am struggling to create the "hidden" control. I'm assuming it should be a text box? Where should the code given on the above page go in the text box properties? Do I need to do something to activate the code after selections are made in the list box?
View 2 Replies View RelatedList Boxes
Oct 18, 2006Im tryin to move data from one list box to another ive seen some sample datebases and how they use command buttons to move the data back and forth from the list boxes (usually have <, >, <<, >> on the command buttons)
Does anyone know how i do this?
List Boxes
Oct 14, 2004I have an unbound list box with it's row source a query whose select criteria comes from another list box once selected. When the form first opens the list box is empty until the user makes a selection. How do I prevent access from running the query in the first list box when the form first opens. It slows everything down.
View 1 Replies View RelatedList Boxes
Jun 24, 2005I want to be able to specify the site of a disease. I had a combo box with pre-defined options (linked to a LU table) but now i find out there can be multiple disease sites. I changed it to a list box and chose multi-select (extended) but this does not retain the values in the form or record them in a table (even when I use the wizard and tell them what field i want the results in). What am i doing wrong or have I missed the whole gist of what a list box is for? Cannot find anything on line to help me here
View 5 Replies View RelatedHelp With List Boxes
Oct 19, 2006I a list of data in a list box and i want to be able to choose diiferent pieces from the list. How can i ref an individual record in the list box do you use
ME.Listboxname.value something like that im lookin to move pieces of data from one list box to another for printing
i can move all the records by using
Private Sub MoveAll_Click()
Dim strSQL1 As String
strSQL1 = "Update projects SET projects.Selected = Yes Where projects.Selected = No"
DoCmd.SetWarnings False
DoCmd.RunSQL strSQL1
DoCmd.SetWarnings True
Form.Refresh
End Sub
and i can move them all back by using
Private Sub RemoveAll_Click()
Dim strSQL2 As String
strSQL2 = "Update projects SET projects.Selected = NO Where projects.Selected = Yes"
DoCmd.SetWarnings False
DoCmd.RunSQL strSQL2
DoCmd.SetWarnings True
Form.Refresh
End Sub
Any idea on how to move an individual record?
Locking User Access To Database Objects (MS Access 2000 And 2003)
Apr 15, 2007I have two database applications and they are:
- the (A) application is for administration use.
- the (B) application is for normal users use.
the idea is that: I made the (A) application for administrators who have full control over the database objects (tables, forms, queries, and so on ...).
the (B) application I have created for normal users who will have only to use forms to insert some data and display data only.
but the two applications has a respective table called "vacation request" table. where I linked them, so the both administrators and users can share the data.
The real question is that: How can I prevent the users from seeing the database objects in their application. I used the database options which have helped me in hidding the database objectives when the users open the application, but unfortunately they managed to access to the database objects by pressing the special keys.
I would like to have an access to the (B) application when I want to make some modifications to the forms and then lock it from users where they only have to use the forms for requesting vacations and view the vacations.
Multiple List Boxes!
Mar 2, 2006Is it possible to control the options available in one list box with an option made from a previous listbox? If so how do I do this?
Thanks
List Boxes In Forms
Dec 21, 2006HI hope you can help me!
I'm wanting to create drop down lists that are filtered as a result of a previous field, but not having much luck!
I've tried using a query to do this, but not having any luck! am i going down the right path?
Do i need a new query for each list, or can they all run off one query?
How can i refresh the list if a previous field is updated?
Additionally where there is only 1 option (similar to a lookup in excel) how can i set this without using a list box?
Hope that in the xmas spirit, my job is safe!!
Merry xmas to all.
Andrew - Hull
List Boxes Fed From Queries
Jun 25, 2007Hi peeps
I have a list box that contains 4 fields and the list box is located on a form.
One of the fields on the form is [Date logged]. This is also colum 2 of the list box.
I am trying to write some code to say that if the Date logged on the form is different to the one in the list box, run an append query.
Basically, the principal behind this is to have an audit trail of when records have been ammended. The first time a record is created, a base record is created. It is this base record that will populate the list box along with all other record changes that occurr from that point on.
I am trying to say that if the [Date logged] does not match the last record in the list then it knows it needs to append the record to the history table again as a change has been made. I would really appreciate some help here folks. Thanks so much! :-)
List Boxes On A Table.
Apr 26, 2005Hiya guys,
I have got what seems to be a pretty straight forward task i need to do!
I have got a table named tblInput, with four fields Type, Collection, Value and Reason.
I need to give the Type field two possible options "a" or "b", i then need the Reason field to display a list of values depending on whether "a" or "b" was selected in the Type field.
Values for "a" need to be "Success", "Failure" or "Rejected"
Values for "b" need to be "Status Change" or "Amendment"
I have been playin for a couple hours now trying various differnent methods but i am commin up short, its this something i am able to do from a table?
Many thanks
Tim
Dependant List Boxes
Feb 26, 2005Hi, im kind of new to access and im not sure whether this is possible or not, but i have a problem which needs to be solved by 4 list boxes on the same form.
The first list box will have 4 choices in it and depending on which one is chosen the second list box will be updated. This continues on to the 4th list box, which when a choice has been made a new form will open with the relevant information from the tables.
I hope this is enough information to enable someone to aid me with my problem, thankyou very much for your time.
Craig.
Help Updating List Boxes
Mar 28, 2005I am working on a database for a bowling tournament. I'm currently working on a form where the user selects from a combo box bowlers' names for doubles pairings. I thought that as a helpful tool I would also display a list of available remaining bowlers once the combo box information has changed.
I'm trying to write a module for the combobox_change trigger. What I'm having trouble doing is pulling the updated recordset from the base form and using that to update the availability box -- in other words, how can you query data from the recordset underlying an open form before the form is closed and the data is saved to the tables. The only way I can do this now is to temporarily close the form, manipulate a recordset from the table, then re-open the form. There's got to be a better way. Maybe I'm just missing something here.
Thanks in advance for any help.