Search results

I have been struggling with this problem for quite some time. Everytime the printer changes the margins defaults to 1 inch and Letter size. There has to be an easier way than to use code to change the prtDevMode blah blah blah.

THANKS ghudson! I'll try that.

Yes, where the button is. Maybe saving the form as a report is my only answer and using openreport. ty, Les

I have a database that opens without displaying the database window. I have a button in a form that will print another form. The problem is when the button is clicked the database window shows up. Can anyone tell the command line to hide the database window? I'm using Access 2000 thanks, Les

I don't need to open the form, just print it. Printing is not my problem the database window is. ty, Les

TY Rob... the button prints another form (the whole form... not one record) Private Sub Command1_Click() Dim stDocName As String Dim MyForm As Form stDocName = "Another Form" Set MyForm = Screen.ActiveForm DoCmd.SelectObject acForm, stDocName, True DoCmd.PrintOut...

I'm using Access 2000 ... DoMenuItem doesn't work on this version anymore.

Please HELP! I need to know the command line to hide the database window.

I see... that is the problem, I set the startup to not display the window but when the print form button is clicked.. voila! the database window shows up.

TY for the speedy response. What exactly is the code to hide the database window?

I have a database that opens without displaying the database window. I have a button in a form that will print another form. The problem is when the button is clicked the database window shows up. Can anyone tell me how to keep the database window from showing up? thanks, Les

I'd like to show the dates for the people that update the loan and also make that the base for any late fees that needs to be imposed.

Thank You Rich. I've played with it and was able to create a normalized test db with one-to-many relationship. Customer data on one side and payment detail on the many. Now, Let's say a customer will start payment on jan 1, 2003 and he has 6 months to pay it. How do i go about automating the...

More details Rich thanks, Les

I have fields called [month1] thru [month60]. if i subtract [monthleft] from [months2pay] i get the month number. now i need to pick up the data from the field that corresponds. ' ** TEXT3 has: ="[month"&[months2pay]-[monthleft]&"]" ' ** OUTPUT field...

Thank you soo much Wayne. I had to modify it to: ptr = InStr(1, Temp, ",")-1 If ptr > 0 Then Field1 = Left(Temp, ptr) Temp = Mid(Temp, ptr+3, Len(Temp) - ptr) else field1 = temp if ptr > 0 then Temp = Mid(Temp, ptr+3, Len(Temp) - ptr) else temp = "N/A" if ptr > 0 then more=1 else more = 0...

More Help!

This might help. If Me.check1 = 0 Then Cancel = True MsgBox "You Must Enter bLAH bLAH." DoCmd.GoToControl "[check1]" Else If IsNull(Me.check2) Then Cancel = True MsgBox "You Must Enter blah blah here too." DoCmd.GoToControl "[check2]" Else docmd.openform "Next Form"

Ok, I have a field that combined three different names separated by a comma (Test1 X. Test1, Test2 W. Test2, Test3 Q. Test3). Not all have three names though, some has only one and some two. I need to separate or break down this field into three. so far, i have the following in three different...

this works too. name2 = "1234 Pheasant Street, Wherever CA 94587" les22 = mid(name2,instr(1,name2," ")+1) ? les22 Pheasant Street, Wherever CA 94587