Search results

I did that, but when a user on a different PC opens up the reports, it goes back to letter size :( ???

I've done that a thousand time. Works fine on my PC, but when other users from other PC's open the report, it opens up Letter size. Pretty sure its an A2K bug, but was hoping that there was a way to get around it... ??????

It doesn't like the .printer part :( Any other idea?

Is there a way to make a macro so that when a report is open, it will automatically open to 8 1/2 X 14. The access 2k bug is killing me! Thanks a ton!

Is there a way to make it always open to legal paper. I have changed it in page setup, unchecked the autofix button or whatever it is. But access 2k bug is killing me. There has to be a way to make this work! Any help? A Macro maybe?

The name is going in between some standard text. The form will be used for each person, but the name will be different for each one obviosuly. But I want the spacing and everything lining up to look ok too. Make sense?

I guess I said that wrong. Here is what I want. I have a form that the user enters information. Then on the report it has standard text, for example, the report might say: "The borrower on this loan is" then I want the field from the form with the borrower's name to show up next, then after that...

How can I do this. I have a label that I type information into. In the middle, I want to insert some information from a text box on a form. Is there a way to do this without having to put an actual text box in there with the label or something, because that is a big pain. Thanks a ton!

Bingo, thanks a ton as usualy :)

I'm confused. What does "Name" represent. And how does the code know which text box is for fax number and which is for phone? Thanks alot!

I've searched but I cant seem to find the right code I need. I have a table that stores a persons name, fax, and phone number. On my form I have a combo box that has the person's name. When I pick the person, I want the phone and fax text fields to automatically fill in. I've looked in the...

This gives me an error: "reserved error" Weird, I don't get it

No prob... DoCmd.OpenForm "gfe form", , , "[Borrower] = """ & Me.combo2 & """"

Numeric Code: DoCmd.OpenForm "FormName", , , "[Borrower] = " & Me.cboBorrower Text Code: DoCmd.OpenForm "FormName", , , "[Borrower] = """ & Me.cboBorrower & """"Date Code: DoCmd.OpenForm "FormName", , , "[Borrower] = #" & Me.cboBorrower & "#" I am trying to get the Text code to work

ok...actually that isnt' working for me. it is opening up a blank record that is filitered? am i doing something wrong? thanks!

The forms and everything work perfect. The only problem I am running into now is that when I use a button on a form to open a report, the report opens, but does not let you see it? Simple solution I'm sure, but I don't know it... Thanks alot!

thanks once again guys!

you guys rock! thanks a ton guys, don't know what i'd do without this forum!

I hope I didn't break my DB... I was searching the forum and found someone's code that said you could hide the whole access window so that it looked just like a normal program. A zip file was posted called hide_accessv2000.zip. I downloaded this and did what they said to do, imported files...

Nope, it's a last name