Search results

What if my combobox shows all the reports I made? I want my reports to be in alphabetical order so it is easier on the user. This is my code to list all of the reports: Private Sub Form_Load() Dim ao As AccessObject For Each ao In CurrentProject.AllReports Me.Combo9.AddItem (ao.Name) Next...

Nevermind. I figured it out. For anybody's future reference: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.Level1.Visible = (Me.Category_ID = 1) Me.Level2.Visible = (Me.Category_ID = 1) Me.Level3.Visible = (Me.Category_ID = 1) Me.SugFleetW.Visible = ((Me.Category_ID =...

So far for my code I have: Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer) Me.Level1_Label.Visible = (Me.Category_ID = 1) Me.Level1.Visible = (Me.Category_ID = 1) Me.Level2_Label.Visible = (Me.Category_ID = 1) Me.Level2.Visible = (Me.Category_ID = 1)...

Success!!! Big Thanks!!!

Thank you proving me wrong, I did have options left! I have not tried that yet, and thank you for putting it in terms that even I could understand. I did what you said and it still did not work.. Maybe because it was my first time doing that, I did it wrong. Here is what my SQL part of it looks...

Well, it is a customer table, so when I make the query, I make the customer ID number equal the customer I want to create a report for. I also use expressions like: Level1: Sum(IIf([dbo_qry_CustomerTable]![Level]=1,[dbo_qry_CustomerTable]![Price],Null)) Other wise, I don't use any other tables...

I have a Master Table that is linked in from SQL. The Datatype of the column I am having trouble with in SQL is Text. I link the table into Access and when I look up the datatype of the troublesome column in Access, it is Memo (some fields go up to almost 800 char). I then make a query using...

Also, Haley, I couldn't open your sample so that didn't help

Hi, I have a very similar question to trackmedic's. I am using the latest version of Access and am new to Access. I'm not sure how trackmedic's is, but I have a table that I pull from SQL. From this table I create reports for every customer. Because the reports aren't all straight forward, most...

Your sample cleared a lot of things up. However I think I know what the problem is. The labels are located in the page header and the text is located in the detail. (to avoid the labels repeating) Also, the labels may still be visible because in my query, all the labels have data with them, but...

When I put "Me" Access says it can't find that object. And then I put a report name in it and it still can't find the object. I'm working with the latest version of Access if that helps.

Could someone explain this a little more please? I did the steps ansentry explained, however, I think I messing up what I put in place of 'Me' and 'MyMemo.' For example, if I had a report called "Apples" and I wanted to manipulate the "Price" label would I put Apples.Price_Label.Visible = Not...

I use the master price table to create a query.. Directly from the table I have the customer name, category, product, weight, etc... and then I have "Price1: Sum(IIf([dbo_qry_MasterPriceTable]![Level]=1,[dbo_qry_MasterPriceTable]![Price],0))" and I have that for all the price levels.

You're right except for the category of products. So let say my products are foods. So my first category is fruit, so all the apples, bananas, oranges, etc go by the price level you explained above. But the vegetables go at a different price. So fruit is <5 is $1 each, but <5 for Vegetables is...

Ok great. I figured that part out. I made a query based off the master price table and its good. But now I have run into a different problem... In my report I have grouped based on the "category" of product and there is a price break after that. But every page does not include all of the...

Yes, I'm using sql server. The information isn't imported, I did that because the goal is to export the information. I've only worked with Access a couple times and it was mostly data entry stuff, so I'm not sure how to work my way around it yet.

I do have a price levels table but it just defines the level with a corresponding number. I have a master price table that has the number and the level description along with the products and their prices. I linked all the subtables I made in Access in SQL and then linked the master table back...

Hello and thank you in advance. I have search the forum and have found people with similar issues, but I couldn't find an answer that could help me.. I'm sorry if I'm reposting an already asked question. I am attempting to create a pricing report. I have different products and different prices...