Search results

mark, thx 4 your time and hlp. more info: when you open the issue list form, in the sample db, and then select issue number 454545, u will see 2 records appearing. The only thing with your suggestion is that instead of 1 form with 2 records, i get 2 forms. One with 1 record only and a second...

Hi guys, here is my problem. i created a report which shows a form. This form works like a receipt. It has a header, details (variable quantity of records) and a footer. my problem is the space between the details section and the footer section. i need to join both sections. i am attaching a db...

here is the form thx, max.

Pat, thx for your hlp. I am trying with a report. I created a report and then tryed to send it to word. The only problem with this option is that only the text is transfered, the lines do not appear in the word doc. anyway, here is the doc that i need to fill as an output. I think that looking...

sergeant, the previous code was an example of how i am using the mail merge. I am trying to use the same method for this new form but i dont know how to do, because i need to send to the word doc, 1 record from one table and one or more records from another table. ex. If i sold 3 wines, i...

Here is the code that i use to create a merged doc ... 'Create a Word instance Set appWord = CreateObject("Word.Application") appWord.Visible = False Dim dtMyDate, MyStr dtMyDate = Date MyStr = Format(dtMyDate, "ddmmyyyy")...

i am not using bookmarks. i am just adding the fields next to the title of the field. thx, max.

hi, guys, it has been a long time without solving this problem by myself. Perhaps you can hlp me. I need to send info to a word doc. That's easy. The complexity comes because it's like a receipt. I need to send info from the receipts, which is always there and details from the receipts, which...

guys, thx for your advise and suggestion. i had forgotten to set the popup property to yes in the report. So, now the report is on the top. However, i try to chg the popup value via vb code and it fails. here is my code: forms!formname.popup=false thx, max.

in the properties of the first chk box, tab events. in the on click event, you could add some code to assigne a specific value to the second chk box. ex: Private Sub Check0_Click() If Me.Check0 = -1 Then Me.Check2 = -1 Else Me.Check2 = 0 End If End Sub good luck, max.

hi guys, i have a form with a button. when i press the button it opens a report : DoCmd.OpenReport "popreview", acViewPreview, acWindowNormal the problem is that the report is in the backround and i cant use it until i close the form. the form is setup as a popup. is there any way to use the...

keithg, thx 4 your suggestion, but i did not find the answer i was looking for. thx, max.

gelliott, i 'd like to ask u something. if you have an access db on a citrix server, and the application has to send emails via outlook. Should i install outlook on citrix? can users use their own outlook installed in their computers? thx, max.

john, excelent alternative. thx vey much, max.

hi spnz , the following code worked for me: strfieldname is the name to be used to save the new word doc. in the with appword section, merge a template with the sql in a new doc. Then, closes the template without saving it and after that, it saves the new file and closes wrod...

hi guys, i have a question for the experts.. i have a form and a button on it. The button merge data from a table into a new doc. , save it and close it. At this point everything is ok. But, what i really want is to be able to open a preview and let the user to close it ONLY, deseabling...

solved here is the code that i get from another treath... 'Create a Word instance Set appWord = CreateObject("Word.Application") appWord.Visible = True 'Open the selected merge document strWordDoc = "W:\Documents and...

Hi guys, i am burning my brain with this...... I have a db located in a citrix server. There is no lotus notes client or outlook client. Only the computer's user has Lnotes or outlook installed. I would like to login into the citrix server, and send an email from access. is that possible? thx...

ok, lets start again. i have a form with a button called pop previewed. i would like to populate a word doc and save it as a new doc with the name of the main field in the form. what i have done so far is the following. created the form (works) created a templated. This template has fields...

1234567890