Search results for query: *

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...

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...

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

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

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

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

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...

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 =...

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...

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...

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?

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"...

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 =...

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. :)

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...

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...

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.

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

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...

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