Search results

Hi, I would like to know if there is a way to show if a record in a subform is filled with any data. For example: I got a form with a subform and linked records from different tables. We recognize this as a 'plus-sign' in front of the main record. I would like to show these records bold or...

Could the problem be the header and footer in the rtf ?? thnx

My files exceed maximum file sizes for uploading as attachments edwin

OK thanks, Is there a way to add text to this file ? Or a way to remove such a terminator ? The oldfilecontents are read from another .rtf file edwin

I still don't get it ... The first Print is done, The others aren't Only oldFileContents is written to the file, Addtext and newfileContents2 are not written. I am positive they are not empty. Open FileName & "_" & Bestelnummer & "." & fileExtension For Output As #nextFileNum...

Hi, I'd like to read a label on another form. I thought it would be easy to just read controls(Forms!form!subform!label1) gives me an error the control does not exist. any help would be appreciated. edwin

Thnx for replies ... I could use a proper error handler, only.. there is no error. text is just not appended. I will try the write variant. ...

thanks for your help vbaInet, Did you try that with the same lines of code ??

Yes i am sure it contains text (debug.print helped me there) Should be some way to manipulate text in a word/rtf document. I can replace text in this document, but whenever i try to add or replace a string with more characters than the original text i get stuck.

If have no "On error resume" anywhere ... no errors are shown ...

Hi, I'd like to add text to an existing (rtf) file. I tried the following, which does not work, no text is appended: nextfilenum = freefile Open FileName & fileExtension For Append As #nextFileNum Print #nextFileNum, newfilecontents Close nextfilenum any...

thanks for your reply. Do you have suggestions for "a telnet library"??

Hi, Is there a way to interact with a shell from vba code ?? Like opening a telnet session, send userid, password, and other commands ? if command returns ok then send next command ?? thanks in advance edwin

Worked great for me ! Thanks a lot edwin

Hi, Is there a way to check how the form was opened ?? meaning: From form "main" I open up form "sub" with command docmd.openform(sub"),,,,acDialog WHen the sub form is open, can i check if it was opened by form Main ? thanks in advance Edwin

hi there, I like to fill a recordfield with type attachment from vba. should be something like With table .Addnew !field1 = something !field2 = somethingelse !field3 = [here i want to point to a file on disk] .update End with any ideas ? thanks in advance edwin

hi there, I like to fill a recordfield with type attachment from vba. should be something like With table .Addnew !field1 = something !field2 = somethingelse !field3 = [here i want to point to a file on disk] .update End with any ideas ? thanks in advance edwin

Worked super, Thanks a lot Freshman!!

In a form, i would like to open the connection manager, so the user can select which tables to reconnect. The user should not rightclick the tables for the connection manager to open. How can i accomplish that ? thanks in advance.. Edwin

Yep, that solved it. Thanks a lot !! edwin