Search results

ah ha, thanks pdx man - this looks just like the thing I need. In fact, I solved my problem by using me!filename which did the trick in that particular scenario, but the DLookUp looks like the function I need for the same reason elsewhere. Spot on, many thanks.

Wahey, we're in business, this seems to be working a treat, so once again a huuuge thanks, Ken, job seems to be sorted! Now, where did I put that cat...:D

ah ha! The crucial thing here is the "me!" bit - this is the address/reference I was trying to establish to tell Access where the variable was. This line now works: DoCmd.OutputTo acReport, "M1", "MS-DOSText(*.txt)", Me!fieldname & ".html", True, "", 0 I'm going to have a further tinker...

Yes, I'm running the code from a button on a form, and the form is tied to data from 3 separate tables. I've tried to address any of the variables from any of these tables, it just won't do it.... [reaching for that stapler to staple my head to the desk again...]

Tried that... didn't work. Presumably I need to address it correctly, so it can find the field within the table, ie something along the lines of: TableName.FieldName.value I've tried so many variations on this, but can't get the syntax for it to work. :mad:

I'm so nearly there.... I just can't find how to define a field's value within a table object. I'm trying to save this report as a .html file, with the filename the actual value within a field: Function M1_Report() On Error GoTo M1_Report_Err DoCmd.OutputTo acReport, "M1"...

Ok - I've bungled along and made progress, but would appreciate someone's assistance in just completing one part of the code I'm having problems with. The function so far: Function M1_Report() On Error GoTo M1_Report_Err DoCmd.OutputTo acReport, "M1", "MS-DOSText(*.txt)", "filename.html"...

Hi Folks My VB is rather rusty so would appreciate a quick bit of help... Aim: I want to save report 'M1' as a text file, to disk, with it's file name as the value in field 'Filename' from table 'Input'. The file name would also need to be appended with the suffix ".html". I've tried the...

Yes very true, Bodisathva, but it's been so long since I've used it, whilst I can remember the basic programming structure, I've forgotten much of the syntax etc. Still, one day when I get off my oversize posterior, I will re-learn... Ken, by the way, a huuuge thanks - I cracked it over the...

Ok thanks Ken, I've made progress doing the Concats in the underlying query, although even that is maxing out eventually. It has at least got me a few stages further - much appreciated for the idea. In fact, this d/b is writing html files; the html code is being written by the database...

Interesting...I like your thinking.... Let me just have a tinker....

[...lays the pussy on the floor] :D

Ok, before I finally nail my head to the desk with my stapler, I would really appreciate some help on this one. Summary: I am trying to produce a report that concatenates approx 100 text & memo fields into one long text string. Problem: The Text Box object seems to have a limit, so I can't fit...

Perhaps a silly question, but it's something I've encountered before and never really managed to do.... I want a drop down combo box that looks up data in a table. Selecting the desired value, then lets the rest of the form display all the other related fields to that value. That's fine, no...

I checked the query's properties etc and it all seems ok. Essentially I have: 1. One data table 2. One form: Input search criteria. Press button to open: 3. Search results form, that runs the query and displays some of the data for each record. Press button to open: 4. Full data form, that...

Thanks...just tried it, but the form still doesn't let me change anything. I think it must be something to do with the form it calls up. I'm completely baffled, cos all the parameters on that form are set to allow edits, I think. If I call up the form on its own (ie not calling it from the...

I'm having a bit of a 'mare. I open a form from a button on another form, linking the two ID fields. However, when the new form appears, it is read-only. I cannot seem to make it editable, which is what I need....I think I've checked all the obvious parameters. Anyway, the code below is what...

Brilliant, thanks. :D

Hi folks What's the code to maximise a form? I'm using code linked to the 'On Current' Event, which I want to ensure maximises the form when it opens. Is it anything to do with me.something? Appreciate the help! thanks

Actually, I think I've cracked it. I needed commas... as in: Case "a", "b","c" line of code line of code etc. Thanks anyway.