In the report I am trying to generate I want every possible option for a specific field to show. I have it set up now as accessing its options from a table but can change it to a value list if that will be easier. I have listed a sample of what I want and what I am getting to explain what I mean by this. If anyone can help me go from one type to the other I would appreciate the help!
** I put dashes between the columns since this forum doesn't exactly show things in a column.
What I want
Locality-Count1-Count2-Count3-Count4-Sum
1-0-0-2-0-$23.34
2-3-2-8-1-$845.36
3-0-0-0-0-$0.00
4-4-2-0-0-$40.12
5-0-0-0-0-$0.00
6-0-0-0-0-$0.00
What I get
Locality-Count1-Count2-Count3-Count4-Sum
1-0-0-2-0-$23.34
2-3-2-8-1-$845.36
4-4-2-0-0-$40.12
I have a subform, which contains only one text box, which works normally, until I set the startup options to hide the menu bars, database window etc...
Can anyone think of any reason why this should be!?
I need help with something (i attached a database). I need to run a report based on user's options so i created a form. There are two comboboxes and 2 checkboxes on the form. If the checkbox is checked i want to consider the choice of the user on the particular combobox. If no, to ignore that column. The second problem is when the user choose "no choice" i want the query to run for all choices without filtering the combobox.
On this form, there is a text box for Quantity...At the end of the form, there will be a button that when pressed:The current record the data on the form is entered for is saved,A report is printed on a specific printer,I do not want the report to actual display,The number of copies it prints should be equal to what the quantity field indicates.I do have the report already created and the Quantity field is on the report (just not visible).Once this all happens, it should return the user to the form, that is blank, waiting for a new record entry.
I have a form with 2 buttons on it, I'll call them button 1 and button 2. When I click on button 1 it calls a class that will go through and calculate some totals and then write them back to a table, all access to the table is managed through ADO. Then I can go over to button 2 and pull up a report displaying the totals. Although when I click on button 2 the report will be about half empty, only displaying 0's in most cases. If I close the report and open it again using button 2 all the data will be populated. What is going on here???
Don't Kill me folks... I know this has been asked and answered, but I'm not able to get it to work. I'm using Access 2000.
I have an image in the Report called ImageFrame and the following code:
Code:Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) On Error Resume Next Me.ImageFrame.Picture = Me.PhotoEnd Sub
What am I doing wrong? Is there something else to set? I don't get an error, but it only shows the image I chose to place the image control in the first place...
I am using Access 2007..I have created a main form and have inserted a subform. When I open the main form, the subform displays correctly. However, when I go to create a Report from the main form, the subform information is not displaying.
I run a Query based on some data in a "drop-down" box. It works in just datasheet view, but when I print it on a report, it displays the position that the data is in the drop-down box. How do I display the data, not the position on the report? Here's an example: My drop down box contains: apples oranges bananas
My query returns apples, but in the report view it displays the number "1" instead of my data "apples". If the query returned oranges, the report would display "2" instead of "oranges" and so on.
I have a form in which I want to retrieve images from a folder. Each record contains a txt field where the path of the image is located. Not every record contains a path to the image file as some records does not have images. I have created an image field in my form and used the following code: Me.Image129.Picture = Me.imagetxt to retrieve the image. I would like to display an image containing the words "No Image" whenever the imagetxt field is blank. How would I do this. I cannot go back and fill in the blank imagetxt field with a path as I am pulling the data from an external source. Also, would this be the same method if I am creating an image field for a report? Any help would be greatly appreciated.
I have a report, which opens a dynamic search form (built off of John Big Booty's code from this site). The form opens, and works as expected.During the dynamic search form testing, I created an 'OK' button that opens another form to display the record, but the dynamic search was opened first.
I would like to reprogram the button to display the selected record in the report which opened it.How can I get the selected record to display in the already open report?
I have a field in a form which displays the Sum of 10 values from other textboxes. I want to display the values of that calaculated field in a report and somehow I am stuck. I am running the report based on a query. How would I get those field calculation values to display in a report?
Hi. Back again with a badly designed number of tables that I inherited. Anyway...
I have 20 tables each with an ID field and a dozen-or-so text fields. - (I planned on using a master report with sub-reports, but perhaps I am ahead of myself here.)
I need the user to enter the ID and a value which would only appear in one of the dozen+ fields for that record, in that table. I set up queries with parameters for the ID and the desired text value. However, when run, I get the correct client record, but also all of the fields for that record... Not only the field with the desired value.
Is there a 'simple' way to do this knowing ho wmany possible fields froma ll of the tavbles would have to be searched? And not all tables have the same field names!
I have a crosstab query which returns values in a range of categories. I have 5 categories. My problem is that sometimes a category may not return a value in 1 or more of the categories. This means that when I am displaying this data in my report I haven't got the data in the correct columns.
In the underlying queries for this I tried using a LEFT JOIN forcing the category, but when I executed the crosstab I got errors in all fields.
I have a report that generates the position of certain items. When I produce this report it doesn't put the data in order. All associated data with that position is correct, it is just not in numerical order. The attached screenshot shows the issue I am having. In the position column it should read 1,2,3,4 but in some cases the positions are not in order.
I have a report based on a query. There is a field "comments" that is a memo type however on the report it does not display all of the text. I have the property "Can Grow" set to "yes" however it still only shows partial text. Any ideas? thanks in advance!
One is a list of fishermen with all their info. I used a Code as the primary key.
The 2nd is a fish ticket sheet with fish tickets entered and the code in there as a foreign key in the relationship between the two.
I create a report listing the fish tickets and prices perfectly for the 4 fishermen I have entered fish tickets for. (I have 140 fishermen in the main table)
I added a 3rd table for payments made to the fishermen. There are two payments for 2 of the fishermen.
then, I go into report design view and drag in two of the cells from that 3rd table into my report.
The problem is the report then prints JUST the fish tickets and payments for the two fishermen that have payments...not the info for all 4 fishermen. I need to print out settlements for all the fishermen whether they have payments or not?
I can't get my reports' unbound field's to display the criteria parameter I enter when report is opened. I have done this before but not in Access 2010.
In my parameter, I do have a long string inside the brackets (e.g. =[Enter START Date "1/1/14" or Leave Ranges Blank to show ALL]). I am wondering if this or the quotes inside the brackets are causing it not to work.
I was using access 2000 to build a small office app. It will be on a network and will generally be used by only 2 or 3 people(max). I was wondering if the default jet technology would be good enough for this. If it isn't, what should I use? I looked at other options such as msde and ado but it's a bit confusing when you're new to this stuff.
I'm trying to create a database for a taxi-type service that runs on thursday, friday and saturday nights. My question is: Is there a way to save the database at the end of the night separate from the previous nights, and so that the database is empty for the next night, but reports can be viewed for all of the nights combined?
ok I have an access db which is all on access. the dbase has been operational now for 3 years and working well however, do to business needs and changes I'm trying to figure out a better way to collect and share data. So the backend of the database is stored on our local office server when users log on to enter or review data they must be in the local office. We now had the need to access the database remotely from customer sites. Now the way this works is we use a local dialer to connect to our company's network and then are routed to our local server (you can imagine how slow this is) it is impossible to operate the current database this way. So I have been reading different posts and different options (front page, sql, asp etc.) What I would like to do is convert my dbase to a program which can allow input and review of data both remotely and locally without a huge speed loss. What is the best approch for me?
I unticked all the boxes in the Tools > start up window. I closed my database then reopened it. Now, I can't put these settings back again as I can't see the Tools tab.
I'm by no means an expert when it comes to using access and its many controls that are avaliable to use on forms. Thats why I've come here to seek your help.
I have a database that has been created by someone who has now left the company and it needs a little work done to it.
The ideal thing we would like to get working on form, is that we would like a number of options to be greyed out and only accessable when another option is ticked.
I'm not sure how to group these options together, nor an I sure how make them active only when an specific tick box is ticked. Any help would greatly appreciated on this matter.
