Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. newnoviceuser

    form in a form in a form bypasses the second

    if I remove the third form, evertyhing works fine. All the third form has on it is one label box that says "please wait while the update is performed" and ontimer a close command thats all that is on it if i remove that form it doesnt bounce back so there is no code to search it doesn't...
  2. newnoviceuser

    using an update query with a summed query

    I have a transaction database called rtrans that has codes and amounts the codes determine what type of expense it is. I have a second database called chart that im suppose to put the totals in. I have a query that groups by code and sums them up just like I want. what i want to do is make an...
  3. newnoviceuser

    form in a form in a form bypasses the second

    i tried it to no avail. whatever is causing it comes after form 3 closes. because form 2 is open in the background till after form 3 closes. as soon as it closes form 1 pops up in front of form2
  4. newnoviceuser

    form in a form in a form bypasses the second

    form 1 and form 2 settings are the same pop up and modal are both no for each
  5. newnoviceuser

    form in a form in a form bypasses the second

    yes form one is a menu form 2 is a sub menu form 3 is more less a pop up message asking them to wait until an update is done. while form 3 is up form 2 is behind it when form 3 closes out form 2 form 1 pops up in front of form 2
  6. newnoviceuser

    form in a form in a form bypasses the second

    I tried that.It flashes form 2 then straight back to form 1 I do not understand it.
  7. newnoviceuser

    form in a form in a form bypasses the second

    a form called menu loads at start in this form is a command button called reports when i click on reports it opens the report form this form has a form on a timer. form1 opens fine form2 opens fine form 3 opens fine when timer is up and form 3 closes it doesn't go back to form2 it goes to...
  8. newnoviceuser

    emailing in vba with outlook wont always send

    this is the code Sub email() Dim TextLine Dim appOutLook As Outlook.Application Dim MailOutLook As Outlook.MailItem Set appOutLook = CreateObject("Outlook.Application") Set MailOutLook = appOutLook.CreateItem(olMailItem) With MailOutLook .To =...
  9. newnoviceuser

    ascii format messed up in text file

    thanks for the response i began trying that but some of the reports already have sub reports so things began to get complicated. this was my solution. i will print it because ive seen several people question the subjects here. i used the outputto to rtf files then used the suggestion above...
  10. newnoviceuser

    ascii format messed up in text file

    I had already tried that but in text it continues to be sparatic and in rtf even if i add them together it still only shows the first page. html works but when the reports are big it makes multiple pages. so its much harder to merge them. if i couls merge the rtf's in vba that would be perfect...
  11. newnoviceuser

    ascii format messed up in text file

    the results are the same moves my data all over puts blank lines in it and drops off a couple of my fields. is there any way i can export all the reports to the same file? rather than 4 different files?
  12. newnoviceuser

    ascii format messed up in text file

    im using output to to send a file to a txt file here is the code DoCmd.OutputTo acReport, "rptDailyTransactions", "MS-DOSText(*.txt)", "c:\daily", False, "", 0 DoCmd.OutputTo acReport, "RTRANS", "MS-DOSText(*.txt)", "c:\rtrans", False, "", 0 DoCmd.OutputTo acReport, "rptcashsheet"...
  13. newnoviceuser

    can I use outlook express instead of outlook?

    here is the code im using Sub email() Dim TextLine Dim appOutLook As Outlook.Application Dim MailOutLook As Outlook.MailItem Open "c:\report.txt" For Input As #1 Set appOutLook = CreateObject("Outlook.Application") Set MailOutLook =...
  14. newnoviceuser

    update query using a summed group query

    yes it did work I tried the first time but after a closer look. i realized i did not put the [] around it and the query treated it like text. so it was searching for the code "code" now that I feel very stupid thanks very much for your help. it does what I need it to. :)
  15. newnoviceuser

    update query using a summed group query

    well not exactly what im looking for. see there are 70+ codes and diferent ones are used at different times. if I understand what you are saying I would have to do that command for each and every code every time. when i use a select query to bring up the code balance and sum of amount it...
  16. newnoviceuser

    update query using a summed group query

    Ill explain as best I can I have a table called chart is has primary key called code and a field called balance i have another table called transactions with fields code and amount. i made a query called codetotals to sum transactions and group by code so I have a total of each code. what I...
  17. newnoviceuser

    how to use me.menubar

    ok makes sense how can i review the menu he set up ive looked in his file for it and am unable to find anything under view/toolbars/customize with the name of main.
  18. newnoviceuser

    how to use me.menubar

    I have a piece of code in a file i borrowed from a another program the line in question says me.menubar = "main" when i run the code i get an error saying cannot find a macro named main. what can I do to correct this problem or learn how to use this section of code properly thanks in advance
  19. newnoviceuser

    form to report gets lost

    ok here goes I have a form called frmloaninquiry when you choose the right customer it open a form called loan detail this form has a cmd button called print it prints the contract twice original and copy then closes both forms. before i put the above posted if statement in it worked...
  20. newnoviceuser

    form to report gets lost

    Call SetReportMarginDefault("ContractInstallments", 0.25, 0.25, 0.25, 0.25) DoCmd.OpenReport "ContractInstallments" DoCmd.OpenReport "ContractInstallments" is in a form called loandetail the command posted earlier is in the report

Part and Inventory Search

Back
Top