Search results

Actually, to save lots of time and trouble, I just realized something. The report I need to generate is really only for records with something in both the INST_NO and SERIES_NO fields. Would there be a simple code to allow ONLY files categorized as Instructions to open a specific report and...

Paul, Yeah, I set that up because I wanted the report to be specific to each record displayed through the form. Is there a way to still use the critera and have it work correctly?

Ok, I know you guys are trying to help and I sincerly appreciate it. I was reluctant to post a sample of the database simply because I didn't want to have to pull all the data I had on it. I've trimmed it all down, created a couple dummy records, one for each different type and trimmed the...

Now whenever I run the report it says it can't find two fields used in the expression, even though I have them bound to that report.

Leigh, I don't have bound controls on the report, I will try doing that and post the results.

Leigh, Did that and even returned the fields expression to the one Paul previously posted, still no dice. Kinda going off the subject here, but I was wondering if I would be able to have a drop-down set up so that whatever value I select from the drop-down will populate two other fields with...

That returns the same error, still only on records without an entry in the SERIES_NO field.

See the thing is is that INST_NO is also an integer. So when there is something in both INST_NO and SERIES_NO, it works perfect. When there is something missing from the SERIES_NO field is where it messes up.

No, that returns the same error.

Ok, I'm at work now and removed the brackets, tested it, still receiving #Error on records without an entry in the SERIES_NO field, below is what expression is in the report: =[DIRECTIVES.SHORTPLA] & "" & [DIRECTIVES.SHORTDIR_TYPE] & " " & [INST_NO] & ("."+[SERIES_NO]) What is really driving...

I can't post a sample, but I'm kinda confused, because looking at the entries that HAVE something in the SERIES_NO field, they show up without any problem. The entire expression goes something like (I've got it at work and I'm at home right now): =[SHORTPLA]&""&[DIR_TYPE]&" "&[INST_NO & ("."...

Actually, I take that back. Instances on a report where there is nothing in the SERIES_NO field, returns an #Error in every field supplied from the form. Using the expression you posted. Of course, that is when I combine four different fields in one box. That might be my problem, correct?

Ok, yeah, I just figured it out. Thanks again!

Actually, now I've got a problem. I'm needing to use what was inserted into the merged field in a report. I know I don't know a lot about Access, but I'm beginning to think I don't know anything about Access.

PERFECT!! Thanks man!

I'm trying to set up a field to pull from two separate fields in the current record. One of the fields is simply titled INST_NO, the other SERIES_NO. I need to separate the two with a "." and that part I have no problem, but in the instance there is nothing supplied in the SERIES_NO I need...

I'm trying to generate a report unique to each record inputted into a form. I am also trying to set it up so that certain data that is used with the Lookup wizard, will change from short form to long form on this specific report (ie., ST changes to STREET automatically when the report is ran)...

This might not be what you're looking for, but if you're using Access 2003, on your toolbar, there should be a Sorting and Grouping button. Once you open that, you can have it sort all your active first then your unactive, etc. Make sure that your "Group On" option is set as "Each value"...

I've been using Access for a little while, but I still consider myself a newbie when it comes to all the things that can be done through it. This is a two-fold question, the majority dealing with Reports I've got a database with a Hyperlink base, and I'm trying to set links up through the...