Search results

I've got like 50 databases that are all the same except for the specific data stored in them. I want to compile some statistical data from each database and then combine that data into one table in one database. I wanted to be able to do that automatically without the user having to open up each...

I am trying to automate the compilation of a rather large amount of data. More than one mdb file is to be involved but I would like everything to be controlled from only one of the database files. So I need to know how, if it is even possible, to make functions in other databases run. That is, I...

I'll try and get back to you later, I'm really in a hurry to finish something this week, hope you can wait a day or two.

good call, jim, I admire somebody who likes to cut a function down to as little code as possible.

I'm not sure I understand why you are getting duplicates. What does you original query look like? I don't think you need to worry about the filter not working as long as the recordsets for the form and report are the same. Filter by Form will not let you choose an invalid filter. Oh, and I...

I'm not quite sure I follow you, are all of your problems fixed or not?

Go to the OnFormat event of the detail section, or whatever section has the textbox. Click on the dots, choose code, put the code where the cursor ends up. Or you could write a function like this: Public function FormatAddress(address as variant) as string dim intLen as integer dim i as...

where is the report footer appearing? forgive me, but it sounds rather unbelieveable that the report footer is not appearing at the foot of the report. And let me get this straight, you want the subreport to print as multicolumn but not the main report? You must go into page setup for the...

did that work at all?

One thing that might help you somehow is the NoData event of a Report. That is, if the problem is only when one of the reports has norecords then you could tell the report to close itself or something like that if it has no data. Then, what to do about the other report? I know that you could put...

Is the reason one can't refer to controls with expressions for data because Access will try and compute a value for each field based on it's data source before actually setting any of the computed values to be that control's value? Could one use the AfterFormat (or perhaps BeforePrint is better)...

I'm not the expert on this kind of thing so I may easily be very wrong, but offhand I don't believe Access supports the merging of reports. You're absolutely sure you can't fit everything into one report?

I read your problem perhaps a little too quickly so I may have missed something, but here's my suggestion: Build a report based on the exact same record set as the form. (the report should display the same records as the form when first opened) Put a button on the form that will open the report...

If you need a little more help let me know.

wait a second, if the controls in the first footer all sum correctly, why can't you do what I said? Let's assume you have 3 controls in the first footer named ttl1, ttl2, ttl3. The control in the second footer is named GrndTtl. so you would say: GrndTtl = ttl1 + ttl2 + ttl3 Well, anyway you...

that's right, use chr(13) & chr(10), that works! I had actually tried it in the reverse order, which doesn't work, and then I gave up. Thanks Rich! About Chr$(): I don't know anything about it, I looked up in help of course, but it just talks about the Chr() function. I assume the $ is some...

oh wait, actually I think I see your problem now. See, the second textbox is not receiving the result of the computation from the first textbox, I think. It, I believe, is receiving the value from the first textbox before it is modified by the expression. So, you see, the second textbox is...

by the way, I find it hard to believe that 0 doesn't work but every other number does. I am pretty sure that 0 is not treated any differently form other integers. You must make absolutely sure that 0 is really there and not NULL.

I would help you, however I am adamantly opposed to the tracking of tardies. Nothing personal against you, it's just your job I suppose. While tardiness is vile and disgraceful, I believe it is the teacher's duty to deal with such instances on an individual basis.

what's going on here this is crazy!