Search results

Hi everyone! Thanks to the forums help, I've made considerable progress on my latest project. As usual, however, I'm having another problem. I have a calculated control on my report that does exactly what I want it to do. Here is the control: =DLookUp("[Vouttotal]","Main","[ID#]= " &...

Hi there, I'd hate to be a pain, but I'd like to know how you got your DB accessable over the Internet as well. If you could offer me some insight, it would be very much appreciated. My email address is: Soniczap@earthlink.net Thank You Ben

Why is it that people rarly answer questions about Access charts? Could they really be That bad?

Now That's a report

I'd like to see this article too. Ive had a similar problem for a while now.

Great, Thanks all

Hi Everyone, I was just wondering if there was a way to query the data on a form to only show records from the past 7 days. Thanks! -Ben

Great, Thanks so much for replying. I'm working on a Database that keeps tracks of product line efficiencys. I work at a vinegar manufacturing plant. Information is recorded daily concerning the previous days Line information. Stuff like [Bottles per Minute], [Cap Changes], [Start Time], [Stop...

I had a similar project, this is how I did it. Copy all of your fields from the Detail section that you want averages of. Paste them into the desired group footer, (By Major or group or whatever). Now create a Text box in the Detail section and set the Control to =1 Change the Running Sum...

Hi everyone, I'm still having troble with my lastest form. I have a main form with 3 functioning subforms that work perfectly. The only thing left to do is to have a Combobox, (Or Something), that filters all of the information by date. I tried making one, but I couldnt find any way of relating...

Shoot! I just tried what you said but I dont think it'll work. My report is too complicated having muliple subreports. I don't know how to make a single query that can hold all of the data and coding that is involved with the report itself. Is there a way to export this information to Excel and...

Thank you, Thats extremely helpful

Ok then. But how do you put calculated feilds from a report onto a query?

Hi everyone, I'm trying to make a simple chart from 2 calculated controls on a report. Since the charts in access can only be made from a table, I was wondering if there was any way to save the results of the totals feilds into a table. I'm not even sure if it's possible but it would be really...

I'm working on a complicated form that has three subforms in it. Multiple records are added everyday and I have it set so that only the records entered on that day show on the form. (To avoid the clutter of 100's of records building up). The problem is that some people who use this DB need to...

Woohoo! I fixed it. It turns out I had the Combobox bound to the feild it was looking up. I changed it to unbound and now everything is working fine

I'm confused too. The only things I'm adding records to are the three subforms. The main forms is only for selecting the Product. Now my product list is all messed up. I found out that it hasnt been adding new records, just changing the [Name] feild on the ones I have. So I have 3 things in my...

Thanks for reading this post. I'm not sure what's going. I thought I had finished an application that I have been working on for a few weeks. It has 4 tables and 1 form The form is based on one of the tables that is simply a list of the different products I'm keeping track of. It then has 3...

I tried putting calculated feilds into a Query but it didn't work. Maybe I'm not doing somthing right. Any other ideas?

Hi everyone! I'm working on a report and I'd like to put a chart on it. The report is very complicated with tons of calculated feilds but all I need to use is just 2 of those feilds to make this chart. It seems like it would be really easy, just a basic line graph showing inventory going up and...