Search results for query: *

Thank you TheAceMan1, i tried different thing and did not work, what i did is disregard the Sub Detail_Report() and i added some vars in the report itself and that worked out well. Thanks for trying.

Please disregard if it displays duplicated due to some error messages. Hi all, I am having a problems it seems to be simple but is not. Hi have a report, in the detail section i have coded to add according to a certain conditions if the record is good or bad, the problem is that when i run...

Hi all, I am having a problems it seems to be simple but is not. Hi have a report, in the detail section i have coded to add according to a certain conditions if the record is good or bad, the problem is that when i run the report in the screen it displays the correct result but whn i send it...

Thank you PHV it worked!

i'm about to leave but i'll check the postings on monday morning

...Set rstpath = New ADODB.Recordset 'recordset to retrieve the pot file Set rstmsg = New ADODB.Recordset fsql = "SELECT * FROM Charts order by Chartnumber" fslidenumber = 0 fsql2 = "Select * from sysparam where code=2" DoCmd.Echo True...

Thank you

now can you or anybody help sayin how can i print that word document in access. Thanks

as always thank you

Hello all I have a word document opened from access and i would like to add some text as soon as the Word document is opened so when i print the doc. it will print in the header the instruction ID. Here is the code. (Thank you very much for any help" Private Sub cmdowd_Click() 'Open Word...

Thank you very much to both of you. PHV that is exactly what i wanted. Thanks (here is your start) REMOU the solution PHV gave is what i was looking for so i did not bother trying yours. But i appreciate your help. Thank you

Hello all, I am trying to open an existing word document in access that works fine, but then if the word document does not exist i want to create a word document with a name assigned in a field called instructiosnID. The problem is that when the files does not exist and try to create a new one...

hello all, I am dealing with something that is giving me a headache I have an access aplication that generates charts and transfer automatically to powerpoint, the information used to generate the charts are updated on a daily basis. WHen i run the application it is displaying the previos month...

THanks for replying remou i downloaded the file but the software is not runnig, it may be because it was done on access 97,i'll tried to change it but it did not work, well right now i need the reference for screen.fontcount, what is the name of the reference, in other words what is the library...

Hello all, I need to add a combo box in one of my forms, when you click this drop-down menu should display all available font types, like when you format a text, you can select any fonttype to your text. If anyone know how to do it, please advise, i appreciate your help Thanks.

hello all I have a chart in msaccess, this chart has almost all the features in excel, let me try to explain i have 4 products that were sold since january to december last year the chart is perfect but the legend displays the products in alphatical order insted of by quantity so it goes: Huts...

thanks to all who replyied PHV i did reply to your post, please read message Nº 15 it's nex to the reply to Eupher in the same message. Thanks to all, again

Eupher i am getting an error message in the hWnd, variable not define, what type of data is hWnd Sub mycontrol(TitleBar) If InStr(TitleBar, "SynQ") Then SynQFound = True ghWnd = hWnd 'HERE STOPS AND DISPLAY THE ERROR Exit Sub End If End Sub PHV Thanks...

Thanks to all for replying Hi Eupher i like this idea of checking the title of the windows until access dont find the title in question. I will need a little help to setup this routine correctly I believe that the main function to call is WaitForSynQ, but i dont see any parameter, how does...

Thanks Cornholio Have this happend to you: "when you are manually saving a worksheet, the same worksheet sometimes takes 2 seconds sometimes 30 or even 2 minutes" if excel takes 5 seconds that means that the user has to wait 25 seconds until the sleep returns the control to access and what if...