I have a list box control on a form which is being populated by a query. It is showing bookings that are placed on three shifts (AM, PM, Night shifts)...the list box is working fine...
- what i'd like is that the output in the listbox is seperated by shift (maybe having a blank line when shift changes, or different text color for different shift, or different background colour for different shift? )
i'm not quite sure if this can be done...or maybe there's another way out ? any ideas?
Hi every one. i want out put records into a list box with 3 column headings named as playerno, initials and name. The way i created the list box is by putting list value for the row source type and name the list box as lstPlayers. But unfortunately get all the the records Fields one after one not one row at a time. I be happy if some one tell how to fix this .Thanks
Private Sub cmdSelect_Click()
Dim cn As New ADODB.Connection Dim rst As New ADODB.Recordset cn.Open ("Provider=MicroSoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:db.mdb")
rst.Open "select playerno, initials, name from players order by name, initials", cn rst.MoveFirst
Do Until rst.EOF lstPlayers.RowSource = lstPlayers.RowSource & ";" & _ rst("playerno") & ";" & rst("initials") & ";" & rst("name")
rst.MoveNext Loop 'TextBox = lstPlayers 'MsgBox (playerno) rst.Close cn.Close End Sub
Morning - I have been searching a bit but to no avail. I have a query (qryTopTenList) set up in a database that selects the Top Ten "Classes" from a table with a key field of "insclass".
I have a multi select list box (LstInsClass) that allows end users to select multiple insurance classes. What I would like to do is set up a standard button that when clicked, will loop through all of the insclass in the query "qryTopTenList" and then select those same insurance classes in my multi select list box. So the end result is that 10 records in the List Box would be selected.
This is helpful b/c it prevents the need to go through the entire list box to select the top ten classes.
I'm writing a simple job scheduling database, so I've got resource availability (by week) and job list (by week). I've written a single-column query whose only output is a unique list of weeks with resources available, and another single-column query whose only output is a unique list of weeks with at least one job allocated.
How do I join these so that I can get a single-column list of weeks that have either (or both) of resources and jobs?
So Query1 returns: 25/08/2014 08/09/2014 15/09/2014
while Query2 returns: 01/09/2014 08/09/2014 15/09/2014 22/09/2014
I want query3 to return: 25/08/2014 01/09/2014 08/09/2014 15/09/2014 22/09/2014
I know I am being particularly stupid, but I can't work out how to do the following: I have a table in which is recorded information about orders for customers. These fields are for orders of meat and poultry. As customers may wish to order more than one Turkey, I have created three fields called Turkey, Turkey 2, and Turkey 3. The data that is input is the weight of the Turkey e.g. 22 (lbs), 16 (lbs).
When it comes to ordering the turkeys, I need to produce a report which shows, by weight, the number of turkeys needed. This will need to add the number of turkeys in each of the 3 fields and order them by weight.
I've just got lost, trying to work out whether I base my report on the table or on a query based on the table. Help!!!
I'm setting up a small EPoS system for a shop and was wondering if you could help. I want a stock number to be entered (i.e. a barcode) and then the item name and price to automatically be entered.
I have the fields 'StockID, Description, RetailPrice' in tblTransaction and basically want the StockID to be enetered and the description and retailprice to be automatically be read from tblStock and placed in tblTransaction.
Any ideas? Hope this was clear enough...its really hard to describe!
I have an Access db that schedules the sending of emails with attachments. I run a query on the table that returns all active users I then need to create a separate file for each active user - in the format as shown below. Each file is called "ddmmXX.epe" - where dd=day,mm=month,XX=sequential number starting 01. The file needs to be formatted ascii text file. The file extension must be .epe
:confused: I've created a form within our company database which will track hardware/software requests. I'd like to create a macro, or add code to output the data entered into a notepad file. Nothing extraordinary. I'd like for it to be like this:
Ticket: XXXXX Employee: xxxxx Reason for Request: xxxxx Quantity:xxxxx Part Number:xxxxx Price:xxxxx Shipping:xxxxx Total:xxxxx
Those are the headings of the fields and x's denote entered data. I'd like to keep the headers and have the entered data as well. Is it possible?
i have a database and i need to be able to read all the records from table1 modify the data and output the data to table2 and I would prefer this to be done via just one button in a form so im guessing VBA need to be used.
table1 consists of an ID field, firstname field, lastname field and date field.
table2 has ID field, full name field, date field
so i want to read the first and last name and date from table1, merge the first and last name and then output the merged names and date to table 2.
ive googled around and all ive come up against is recordsets but im having a hard time actually getting them to even work.
I've been working on creating a database for a Physical Therapist that will store patients information and information on past appointments (including the amount of money paid per appointment). I created a form that he can then easily select the patient and their D.O.B. and insurance carrier will show up.
But I need to create a way that when he then selects the treatment received for the appointment that the correct payment amount will show up and be recorded as well. The reason this is an issue is because for each insurance there is a different cost per treatment.
Whenever I export reports to PDF, the output appears zoomed and clipped. No extra pages are generated as they would be if I'm going over margins, it's just the report is clipped.
The report looks perfect in preview mode, and it looks perfect when going to an actual printer. However, when using OutputTo to save it as a PDF, this is when the report content is clipped.
I open the report in preview mode first so events are fired that show/hide various objects based on fields in the recordset.
I've tried reinstalling, and I've tried this on two different machines, one running Windows 7 and one running Windows Server 2008...both with the same results.
I'm working with Access 2010 and am trying to use the transferspreadsheet command to output data in a query to an Excel 2010 format file. Here is the line of code:
It works fine and produces the output file but when I try and open it with Excel I get an error saying the format is incorrect. If I change the extension to .xls it opens with no problem but I need it to be an Excel 2010 format with correct extension.
I've got two tables, Properties and Valuations. Every six months the properties are revalued. I want to have a datasheet list of all the properties with a blank field for the new valuation so that the user can just go down the list and enter the new amount without having to select every property individually. Can I do this?
I have a form called CreatePL which is made up solely on List Boxes that the user must choose from. After all the choices are made, I have a button to save the information to a table called PL.
I noticed that after clicking on this button, that record stays active so when you try to create the next record, it is actually changing the previous record. As I was testing this a bit further, I also noticed that the one of the names in one of the list boxes got erased (I'm not sure how yet).
Is there a way to lock the information but still be able to make selections and save it to a table? When I choose the properties so that you can't edit, I loose the ability to make choices also. All of the list boxes are set to "limittolist".
Ok access noob here and a first post as well...I have to filter a table that has children and teachers.I made a form with a combo box of teacher names then filteredon the teacher name.in the subform I have to create a matrix of the children thatare assigned to that teacher.it would be something like thisteacher date child name start endthe teacher and child name are in tblmainthe date start and end values have to be in tbldata1so the beginning they want to choose a teacher and a dateso I shifted and put the teacher in a combo box and tied it to nothingbut the subformso combo box teacher and field datelinks to subform are teacher;datecombo box(teacher name)==> Ms. Eve text box(date)==> 01/01/06but they want a filtered list on teacher so the subform would have to beteacher date child name start endMs. Eve 01/01/06 mary lamb Ms. Eve 01/01/06 billy bullMs. Eve 01/01/06 bob jonesthen they could put in start and end for each childI don't see how I can get the child names filtered thru a query (thisI can do) BUT then to be able to edit the fields and put this datainto a new table.IS there a way to do this?a big help for any ideas or pointers as I am lost on this
I have a phone number field defined in a table as text and use the input maks !(999") "000-0000 for entering and editing data. Is there a way to use a mask when using this field in a list box? It would be nice to be able to show (555) 123-4567 instead of 5551234567.
how do i click on my data in a list box (4 fields unbound)) on my (main form) so that it goes straight to my subform fields (same 4 fields from the list box), this will save me on data entry and i can just enter my quantity and it will calculate a total for me.
i don't want a combo box in my field on the subform.
I am trying to create a database to create a purchase list of parts for a final assembly. There are several subassemblies that make the final unit. There are also subassemblies within subassemblies.
I want to be able to create a list of parts for purchase for the completed unit.
I have a table of part numbers that assigns part numbers to parts as ewell as subassemblies. in this table there is field that designates what type of part it is, System, assembly or base part. I am trying to query the "system" to get a quantity of all base parts contained in it. The feils in the table are part number, part name and what type of part it is.
I am having trouble with the queries or what should be in the table.
Can anyone help me? I am trying to add new records/data entry on a Form from a list of drop-down options.
I have a database of vendors with names addresses etc. I will be selecting a specific vendor from the pull-down menu and then add data entry comments. Please help!
I have a listbox call lst with two columns, what I want to do is to populate this two column with "firstdata" and "seconddata" respectively. What I do is: Me.lst.RowSource = """firstdata""; ""seconddata"""
But I see nothing appear, what is the corect way to achieve in vba?
I have a table for experiments - tblexp. Each experiment can have one or more projects within it. So I have a drop down list of the various projects in a separate table - tblprojref with fields project no (projno) and project title (protitle).
When I am setting up a new experiment I am entering the information into a form. Along with other information that populates the underlying table, I would like to have a multiselect list box which allows me to pick the projects linked to the experiment. These would then either populate the same tblexp or another. I can only achieve this if I am only selecting one project from the list.
How can I get the several items selected into different fields and linked to the one experiment? I am new to this and although have found various threads relating to this they include a lot of code which I don't understand. Is there a step by step easy way to achieve this?
I have a database with a form. Form has a list Box. I write a code for sorting data in list Box and it is worked but sorting in one of the column in list box does not work.I think the reason of it that this column is a combo box with multiple values.
Each company has a director (I choose from a list that's bound to "person" by its ID field)
Each person lives in a city (I choose from a list that's bound to "city" by its ID field)
So:
- a person's city is stored in "person" as the ID of "city", so I only have numbers (1, 2....) - there can be two persons in "person" with the same name (the only thing that differs them is the city they live in)
The problem is:
When I try to choose a director in "company" from a list, it shows me the name, surname and the ID of the city the person lives in, all from the table "person". The trouble is, since there can be two persons/directors with the same name, I really need to see their cities (the real city name, not just its ID). But I still want the city in "person" to be stored as ID of "city".
I attached my database so you can see what I'm writing about.
i just to know how to list the all data at subform that same thing that i selected at combobox..
ok for example..
i want to list all car part that purchased in nov 2005 at subform... date(nov 2005) selected from combo box... then if i change other date (ex: dec 2005) it update n view new parts..
I am looking for a way to use the dblClick function to move the current row of a list box to another. The idea is that users can look through data and pick certain rows to be printed in a report. I am not sure how to go about doing this and am not sure if it is the best way. The second listbox is so the user can review their selections before printing a report.
I am an Ms Access newbie and need some help on how to update 2 fields from a drop down list.
The drop down list has 5 columns. The first column is the partname that is bound and updates the table with that partname. I want to take the listprice which is the 5th column and update a field in the table with the listprice that corresponds to the part name.
