Search results

I had added a mockup of what I am trying to do on a form. It is in excel only for the mockup. I am trying to do this on a ms access form. Trying to get more than one sub totals to display on a form. Hope someone can walk me through this. Thank you in advance.

I have a question, and I hope that I explain it well enough. Okay, I have paperwork that we are scanning and saving in a file. I would like to say build a table/form where I would log the scans in, like the date, and add the attachment field where the copy of the paperwork would be. We will...

I have created a form that takes data that has been entered and put the calculation into the proper field. I have one that says: Total All Scrap : [HiddenTA]-[GP12] For some reason, I am getting a "The expression cannot be saved because it contains a circular reference." Not sure why I am...

Okay, cool. Thank you ridders.

Hi Ridders Yeah, I would like to see the demos. Could you recommend any youtube sites that might also help. I haven't did VB coding before. So this is probably more advance, but willing to try and learn. Tony

You got to teach me in how to do this. This is so cool, and would the database much more friendlier. Please, you got to show me step by step. Tony

Hey that is really cool. So I can have it so that they choose basically what that want on their report? So the only thing that I would really have to have in the background would be the queries right? Do I have to write code for this, or is it simple to do. Any step by step on how to do one...

Hello, Not sure if this is possible, or even where to start. I do many reports for different parts. Each report give the same information that relates to that part. That part is simple. Now the hard part, because I have over 200 or more parts, is there say a way that one form could pop up...

Thank you everyone every one for your help. The update query did work. Thank you again. It feels good to know that there are smart people who know MS ACCESS so well, otherwise I would be lost. LOL. Tony

Hi CJ_London Thank you for responding. Would I do that right in the form, then the property?

I am stumped. When I worked on a formula first in excel: IFERROR(Min(100%-(H8/G8)),0) This did first gave a 0 if there was not number, but the main part that I want to use in my access database is the part that it uses the min so that the percentage will not go over 100%. I have the...

I had to add a new field to my form, which is part of my pull down menu. I got everything to work like it is suppose to. My question is, is there away that the past data that is already in the database would automatically up date that information that I had added. I can do it manually, but...

Figured it out. Had to go to properties to make it work.

Help, Not sure what is going on. I would make a qry with the data that I want for a chart. Then in report, I would create a line chart the same way always, and it would give me my data on the chart. Been doing this over a year now. Now, I went to create another chart, using the same method I...

I really would like to learn my MS 2010 Access real well, does anyone recommend any great books that would walk a very simple beginner to advance. Also, I would love to learn VB to work with my MS 2010 Access, does anyone recommend any great books that would walk a very simple beginner to...

Thank you plog That did the trick.

My table fields (columns) are as follows: ScrapDefect ScrapCauses ScrapRemidies Photos So what i am asking is that in a different form, where I have the names of each scrap. I want to be able to press the button of that scrap name, so that it would go to my other form and bring up just that...

Hi Plog, I not trying to create a report, I just want it so that a person could hit a button, and it would go to the scrap table and go right to the right scrap. Tony

HI Plog I actually do have it set up that way in my table. My table fields are as follows: ScrapDefect ScrapCauses ScrapRemidies Photo Tony

Thanks again jdraw. This is really cool. I put another challenge in Form. Thank you so much for your help. Tony