Search results

Hey! This person had a perfectly valid question and no one ever answered it! Now I find myself with the same question. Anyone want to shed some light on this subject?

Hi everyone, I'm working on a new and complicated report that has two subreports in it. Everything is linked and set up right but there's one annoying problem. I have a field on my Main Form that is linked to a field in a subform. Not every record on my main form has a corresponding record on...

Woohoo! That worked! I had to make a few adjustments but now my form is working exactly how I wanted it to. Thank you all for your help. I don't know what I'd do without this forum

I guess it would make more sense to do it from the subform, I'm just having having syntax problems with referencing the "Company" Field on the subform from the "ChooseCompany" Option group on the Main Form. I've searched the archives and found some examples but I just cant make my code work...

Anyone have any ideas? The deadline for this project is tommorow at noon. This is the only thing left I have to do. I'm just getting a little anxious Thanks!

Thanks for responding. I'm not sure what's going on. Even when the the focus goes to the new record, it still leaves only the first record with the Company Field filled in. I filled in 5 records just to be sure and only that first one worked. If adding a calculated field will fix this, I'll...

Hi everyone! I'm having trouble with form I'm working on. I have an Option Group on the main form that has 3 options and a subform where I put inventory records. I want the form to fill in a feild on the subform automatically depending on which option is selected as I fill in records. I thought...

That may sound really easy to someone as smart as yourself, but it confuses the heck out of me. I can't figure out what the DatePart feature does, the Access Help file isn't very helpful at all. I bet if you were a little more specific I would catch on. Thanks so much!

Hey Everyone! I'm working on a new report for a new form that I just finished. There's one problem though. I need to use Hours and Minutes on my form but on the report I need to convert the Hours to Minutes. I have it set up so that there is a [StartTime] and a [EndTime]. Both of these have a...

Thanks! That worked perfectly. You're great!

Hi everyone! I have a form with 2 subforms. All of the information that will be entered in these forms includes dates. THere has to be a date with every record, but with so many records being entered at a time, this could get tedious. I was wondering if it was possible to have both of my date...

Hi everyone Ive been trying all day to get a button on one of my forms to work right. Let me explain what i need it to do: I just need it to open a Message box with a place to type in a date and then use that value on it's respective report. You see, I make production schedules through...

I was actually thinking about that. Im a pro with Excel Charts, (Not like they are very hard), but is there anyway to link the information from my Access database to an excel chart? My goal is to be able to push a button on a form and have an updated chart pop up. I guess it doesnt really matter...

I need to learn how to make comlicated charts. Up untill now, Ive never had to make one and none of Access Books go into any detail about them. Does anyone know any credible Web Sites that have information/Tutorials on this subject? Any help would be very much appreciated Thank You

Well thats where the problem is, I repeated the calculations in the footer, but only the fields that were averaging Bound feilds worked properly. Those that were averaging calculated feilds gave me Enter Parameter Value boxes and didnt work right. I must be doing somthing wrong, and there must...

Hi everyone, I have a report that has many calculated fields on it. It is grouped by "Pack#" and has a footer that I would like to put the averages of these fields in. Heres an example of one of the fields: (In Detail Section, the field 'TotalTime') =[Producing_time]-[Total_Change_time] And I...

Ok I took the single quote out so it looks like this now: If caseoptions = 1 Then Me.Filter = "Pnumber = 4" Me.FilterOn = True End If And it still doesnt work Any other suggestions?

Im trying to set up some filters on a form Im creating. I created one using VBA in an option group and it works perfectly, but then when I try to make the other one I get "Enter Parameter" and "Run 2001" Errors. I can't understand how one works and the other doesnt. Here is the Working one's...

Thanks for the advice everyone, Ill try that

Im working on a report that will sort and group items in a specific order. The problem is, these items cannot be sorted by AScending or Descending. I need it to sort them in a non-logical order. For example, here is the order: 32 12 64 9 20 16 All of the products fall into one of these number...