Search results

krij, thx very much 4 your hlp. it did not work 4 me. i am not using recordset to get any data and i am not using any bookmark in the template. I tryed to fit your code in to mine, but it did not work. Also, ii looks like my db do not recognise a few lines from your code. ex Dim Wordobj As...

more info.... i change the code by: Private Sub poppreview_Click() strFileName = "W:\Documents and Settings\mdaniel\Application Data\Microsoft\Templates\QANTAS AIRWAYS.dot" Dim objword As Object Set objword = GetObject(strFileName, "Word.Document") ' Make Word visible. Dim...

hi guys, this is the situation I have a form where the user enter data. I would like to let the user press a preview button and open a word doc containing the info entered in the form. I created the doc and insert all the necessary fields coming from 3 different tables (wine,supplier and pop)...

sam, thx for your time and try to hlp me. i saw the references and the "VideoSoft vsOcx Controls" is there. the sure form works perfectly if you call it from a form. But the problem here is that i am calling it from a subform. thx, max.

thx, sam and pat. great ideas both. now it is working. max.

could you attach the db again pls. thx, max.

guys here is the db to look at the error. thx, max.

hi guys, new situationfor this forum...... I have 2 forms(addponumber/sure) and a subform(ponumber subform). addponumber: It has the ponumber subform and an exit button. ponumber subform: it has a list of records (continuous. form) coming from a query. It shows 4...

niktoo, is there any reason for having a list of drugs in a table and another table with a list a drugs + costs? couldnt be in the same table? The combo and the text box will be in the same form than the form where you want to add the drugs and costs? anyway try this, For the forst combo...

king, thx for your hlp. I added the: me.parent.refresh command before closing the form B, but i got the following error. "run time error 2452 the expresion you entered has an invalid reference to the parent property" thx, max.

well ...... i could refresh the data with a refresh button. But i still trying to understand why it doesnt do it by itself, like in the access 97 db. thx.

hey, guys.......this should be very simple, but i am missing something. i have 2 forms, 1 subform and a query in a 97 access DB. The query was designed to show records where the status is Submitted only. IT WORKS. The subform gets the data from the query. IT WORKS the form A, has the subform...

king, i gave you an example in the other thread. thx, max.

i hope this hlp you. i found it in a thread in this forum...

king, when you call the calendar form write the following: Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmCalendar" DoCmd.OpenForm "frmCalendar", , , , , acDialog, Me.name & ";<your date field>" then, in your calendar form write...

Solved SOLVED. thank you all

hi guy....i need more hlp. I have a form (ranking) with a combo winecode. when i selected a wine the subform(rankingsubform) is populated from a query. Also i have a table with 2 fields (ponumber, qty). the subform has two fields (winestatus, ponumber). what i would like to do is to fill the...

lagbolt, your code worked beutifully but only if i change the RECORD LOCKS to no locks. Otherwise, it shows me a violation error. is that 'cos the data in the subforms comes from a query? thx, max.

Hi guys. Here is my problem... I have a form called ranking. It has a subform with a list of wines where each wine has a ranking number. What i would like to do is to change the ranking of a specific wine and then rerank the rest of the wines. example: wine rankink a 1 b...

solved problem solved with the solution from the above problem opened by curious..