Hi,
I currently have a report that is driven by a combobox. I was wondering if there's a simple way to create a report for each of the entries in the combobox through a "All" combobox entry. (i.e. instead of selecting each entry, one by one)
Any help would be much appreciated.
Hi,
Anyone know how to create a combo box that has unique month and year entries from a table (month in one column and year in another - i.e. 2 columns)?
I've been able to get the textbox of the combobox to output the correct format using a custom format but it does not affect the combobox data. Also, I'm not sure how to separate this by two columns...
Any help would be much appreciated!
The problem I am having is I am using a =Sum([SumOfCountOfUseData]) statement to get a number of instances data is used from a table this works with one exception it counts deleted instances and sums those as well?
View 7 Replies View RelatedI'm struggling to produce a report that pulls out pre defined fields from the active record displayed on a form and attach / embed to an email.
View 1 Replies View RelatedI have a query with various entries, pertaining to various invoices. Each line of the query corresponds to a piece of work done, and there may be several lines in the query pertaining to one invoice. I've written the code to input data to a report.
If there are multiple lines in the query to be added to the one invoice, I don't know how to write code that will add those multiple lines in the detail section. Same type of data on each line, just basically pertains to several different lines of work.
Newbie working in Access 2003. Please forgive me if this seems vague. I have a form that has a combo box in which a record is selected from a table. I have a report, whose record source includes this table. This table has records for two fields-Job Number and Distribution Date. My problem is that I would like the record that I selected from the combo box to be carried to the report. I can get the report to display the last record in this table, but not the one that I select. To recap; I would like to 1) click on the combo box, 2) select a Job Number, 3) click on a command button called 'Preview The Report', 4) see that the correct Job Number and Distribution Date are carried to report, and 5) print the report. It all appears to work up until the preview, where again, the last record, and not the one I selected, is carried to the report.
Thanks in advance for any help that any one is able to provide.
I want to have a combobox in a report ,
In a report using a query with a field named: "plantno" and as criteria" :Like [Fill in the plantno]
I can put in a plantno.That is working Oke!
I want to do the same thing as above but then that i want to see
a combobox with a few plantno,s which are put in a valuelist,so that i dont have to type in plantno,s
but that i only can choose out a valuelist.
Who can help me?
I was wondering is this was possible in access. I've read material on grouping and sorting, but haven't been able to pin down what I need.
I have a combobox field that has 14 entries, beginning with 01 as the first two characters. What I'd like to do is change the order in which everything is displayed on the report.
For instance, show 07 at the top, then 09-13 below that, and so on...
I have a report, rptAllCSCS which is based on a query qryCSCS2...
One of the fields in qryCSCS2 is Status and each record is either "Current" or "Not Current"...
My report is being viewed via a navigation form, so one of the tabs says CSCS and when clicked the user can see the report...
I have added a button in the report header which when clicked opens the report in print preview so the user can print the report. (Done with a macro in the On Click of the button.)
I would like to add a combo box cmbStatus which has the values "Current" and "All" in the report header. (Current will show only when the Status field = Current and All shows all records so Current and Not Current together). This will act as a filter for the user to see the corresponding records and they can then press the print button or just view on screen.
I haven't worked with filters before except when you specify the criteria in the query and point it to a control on a form which then opens the report... As this report is already open I'm having trouble, as well as specifying the "path" when something is in a navigation form being a bit tricky...
I have a combobox that I use to combine the employees first name and id number. So when you pull down the list you can select the employee you want and it is saved in the form. Now I need to create a query so that I can create a report on each employee separately. The query will not let me get the Employee Frist Name/ID from that saved field. I thought that what is saves in that field, you can retrieve it in your queries or reports.
View 3 Replies View RelatedI have one table with some info about my clients, I have a form, where I must choose this clients from combobox and then after clicking button Print must open report with info about specific (chosen from combobox) client and some another texts that doesn't change. Final result must be printed report as invoice.
I can't create report with only specific record information.
I am trying to run a report based on a combobox selection. I have three different reports, each for the three different items in the combo box. I just don't know how to code it so when I run the report, it picks up the name in the combo box and opens the correct report. This is what my code looks like for the button that will run the report:
Private Sub Command7_Click()
DoCmd.OpenReport ("Signers Authorized for Check Writing"), acViewPreview, , WhereCondition = [BTrans] = "Check Writing"
DoCmd.OpenReport ("Signers Authorized for Stop Payment"), acViewPreview, , WhereCondition = [BTrans] = "Stop Payments"
DoCmd.OpenReport ("Signers Authorized for Wires"), acViewPreview, , WhereCondition = [BTrans] = "Wires"
End Sub
The problem is, that as soon as I hit the Run Report button, all three reports open up, so it is not reading what is in the combo box. The quotes, "Check Writing" , "Stop Payments" and "Wires" are the actual selections in the combobox and [BTrans] is the name of the combobox.
I have a table in access which is updated weekly; I need to create two tables from this updated table.
1st table will consist of all the new entries for the current week
2nd table will consist of all the entries from the previous week - an amalgamation of all the entries which are not from the "current week" (table) For example; the table below shows the two entries from last week.
ID
Name
1
Adam
2
Ben
This week I have three new entries New entries
ID
Name
3
Charles
4
Richard
So when I run the same query next week I will get something like this.
Old Entries
ID
Name
1
Adam
2
Ben
3
Charles
4
Richard
[code]....
How do I get a query /queries which divides up the weeks new entries and also all the old entries.
What I have is a single table that I need to create a report from. It has vehicle unit numbers, dates of service, repair details and costs. I am trying to generate a report where I can select a unit from a combobox and enter a date range.
View 1 Replies View RelatedI am trying to use a combobox called Manufacturer to select which table the combobox called Model gets it's rowsource from using the code below.
Code:
Private Sub Manufacturer_AfterUpdate()
If (Me.Manufacturer.Value = "Siemens") Then
Me.Model.RowSourceType = "Table/Query"
Me.Model.Recordset = "SeimensTable"
Me.Model.RowSource = "SELECT Model FROM SeimensTable"
Else
If (Me.Manufacturer.Value = "Samsung") Then
Me.Model.RowSourceType = "Table/Query"
Me.Model.Recordset = "SamsungTable"
Me.Model.RowSource = "SELECT Model FROM SamsungTable"
End If
End If
End Sub
But when I run the form and select Manufacturer. Combobox Model remains empty. tell me what I'm doing wrong?
How would I modify multiple comboboxes in subforms at the same time. For example.. In main form ComboboxA user selects 1992, Combobox1 in subform1 is also changed to 1992, as well as Combobox2 in subform 2.
Whats the best way to do this?
I have 2 comboboxes, the first one is called "activity", whereby I have 3 options to choose from, and the second is called "level".
When I click an "activity", for example Drawings, I want the "level" combobox to list a unique set of options for that category. and if I click on a different "activity" for example Planning, I want the "level" combobox to show a completely different set of options.
If anyone can give me any help on how to do this then I would be very grateful!!
Thanks
Angela :eek:
I've tried searching the forums and haven't found quite what i'm looking for. I would like to be able to change the source for a combobox based on another combobox. The simplest way i can summarize that is i want to be able to choose A or B, depending on my choice i want another combobox to display all the values that A or B can have.
Thanks
Jim
I'm not sure I worded that very well. :(
Hey all,
I've read some tutorials on this sort of thing, but I can't seem to piece it all together to achieve what I want.
I have a table Products that contains the fields Product, Size and Brand. I also have a form, frmProducts, that has a combobox linked to each of the fields in the Products table. I want to be able to select a product from the first combobox, tab to the Brand combobox and have only those brands associated with the product already selected.
This is how I think it should work:
1.ComboBox1 selects productA
2.ComboBox2 takes its options from a query that searches Products table for all instances of productA and displays all available brands. brandA is selected.
3.ComboBox3 get its options from another query that searches for all instances of productA that also have brandA and displays all available sizes.
What I'm having trouble with in particular is passing the data between queries. For example, I can't figure out how to tell the query to search for all instances of productA when its defined by the first combobox. Do I have to store it as a variable somewhere?
I hope I've been clear.
I am looking into a database that has become very large (20,000+ entries) and access only allows me to look at the first 10,000. I am sure there is an easy way to check this out, but I am new to access, any help would be appreciated. Thank you.
View 2 Replies View Relatedis there a way to total up the number of rows i have in a table/query and have that number show up on a new seperate row kinda like the way sums are shown in msexcel. using access2003 btw, thanks
View 2 Replies View RelatedWhen I try to add a topic to my database it adds the topic twice (using Internet Explorer). When I use Firefox it only adds one (as it should).
I realy don't know what's wrong
Anyone an idea?
Code:if Process="AddToDb" then'Add to DBset conn=Server.CreateObject("ADODB.Connection") conn.Open "w002399556_db_new" sql="INSERT INTO tblReview (TopicID, ReviewActiv, FieldName, ReviewTXT, Autor, Editor ) VALUES ('" & PlantID & "', True, '" & FieldName & "', '" & strMessage & "', '" & LoggedInUserID & "', '" & LoggedInUserID & "')"conn.Execute sql,recaffectedconn.closeSet conn = Nothingresponse.redirect(domain & "/db.asp?id=" & topicID)end if
hello,
I have a Database table that was pretty big, there is a little over 18k entries, so many that the form I was using won't display them all, so I had to split it into several tables, and made forms for each, now the database users want to make a mailing list out of all these different tables, they want to be able to display the entries from sertain fields with checkboxes and not others, but I can't figure out how to make a query and/or report that will look into all the different tables and pull information from all of them to make into one.
In case that wasn't clear, basicaly I have:
DB A-H
DB I-M
DB N-S
DB T-Z
and I want to make a mailing list that will look into all the tables and print only those which have the "member" field check box marked.
is there any way I can do this? do I sound stupid for not being able to figure this out? I've tried google but can't get any information that helps me, maybe I'm typing the wrong thing.
if anyone can help it will be greatly appreciated
I have a small access db in a network which has started to crap out far too often lately. The main table records job entries and inserts a date stamp. Every now and then, an entry has a ridicuous ID (auto inc field) and/or a bad date stamp and i can't delete the record (instead i have to output everything to ecel as best i can, reimport it to a table and reset al the fields..)
i don't know what the problem is but i'm wondering if access writest to a log file somewhere (that might help) or if there is a way to make it do this?
cheers
jg
Hi everybody
I have an assesment and need to create a database, I'm just starting with access and I need some little help if anyone has time.
I'm doing the database for an interim managment company and i have problem with the experience category. Basically because every candidate has got at least 3 or 4 different experiences, I don't know how to design the table. All I know is that I probably will have to create a separate table for this.
Thanks to anyone who will help me.
Ilan
Hello, I need help. I have two tables.
horse_entries
ent_HorseName (PK)
ent_entries
horse_information
inf_HorseName (PK)
inf_Ground
inf_Notes
It is a many-to-many relationship. When I open a table and enter a record there is a small + sign that allows me to open up the rows from the other table to enter directly into it. Can this be turned off? Also I can enter more than one record through this way. I only want one entry in inf_Ground, inf_Notes and inf_Entries for each HorseName. How would I do this? As you can tell I am completely new to Access and trying to learn. Thanks :)