Search results

No? Its not a matter of explaining what you need help with. We need to work out where you have gone wrong, you've described what you want to happen, not what you have tried in order to accomplish this. I never said you had offended anyone. I was trying to help. Your screenshot doesn't help...

LOL No idea. I don't keep a record. It was just some general advice to Hannainnc. I looked at her past threads and saw people helping out and no response from her. I took a quick look at her question and there wasn't enough info for me to get a grip of it. I generally take a quick look at...

I think you would be better off editing your posts to explain what you want a little more clearly. If you look throughout this forum, people get help without offering money or displays of body parts... its not exactly hard to find that elsewhere on the internet. You could also reply on the...

Which version is that Sergeant? I only use IE at work (its all Linux at home), and of course I am at the mercy of the ICT Department for updates (I think we are somewhere in the 6 region). We may get IE 7 some time next century... Any steps towards standards compliance is welcome with me! :-)

Conditional formatting will allow you three conditions to format a field. If this is enough for you, you're in luck.

Too... much... bait... Must... not... troll...

Use the ALT="" and TITLE="" tags for your images/links. Using both will ensure you get a "Tool Tip" type message in both IE and Web Standards compliant browsers ;-) (The title tag isn't honoured by IE, but the alt tag does the same thing).

Hi kernel, Try this. I created a form with a button on which runs the code in module 1. It should create the HTML pages you need.

Ok Kernel, I should be able to do this for you, but I might not get time today. If you haven't had a reply by tomorrow, just give me a reminder!

Each item should be identifiable by invoice number. You can then group your report by invoice number, and all the items should appear in the items sections. This is provided that you have correctly normalised your database.

Can you post your database? I will see if I can write the VBA for you.

Ah I see. This is slightly more complicated. I am presuming that each page of the report has specific details about one person, and you want a page for each person, in HTML, with their name. The only way to do this I can think of is using VBA. Firstly, you need to filter the report for each...

The HTML page names depend on what you called your report as far as I know. So you can change your report's name to "names", and then it should create the pages with "names1.html", "names2.html", "names3.html", etc.

As long as the previous date stamps are recorded in the table, you can do this. If the field is simply overwritten without an audit trail being created, you are out of luck.

You can put many different names on your report. Again, I'm afraid I don't exactly know what you are asking for. Do you want to have something other than "Page" on the report? You ase the page number in a field, but put something else in front so that you get "Item 1" or "Item 2" or pretty much...

You need to make sure the table you want to update has a primary key for a DAP page to be able to update it.

Newman I am jealous! Sounds like a great job.

Not being a classy guy I wouldn't know ;-) I've heard of that, but in my opinion it doesn't need it at all; its tasty enough. I've only ever once seen it available on draught and that's in a pub in Saltaire, West Yorkshire. Yep, not much change out of a fiver... I usually serve after popping...

Place your cursor over the function with 'd' in it. Press F1. You'll learn allsorts ;-)

It replaces Date - [auditEndDate] so, Me![finalRptCycleTime].Value = DateAdd("d", (DateDiff("d", Date, [auditEndDate])), Date) My VBA builder doesn't have a problem with it.