Recent content by threeo2

I have a split db using access 2002. The FE's are mde running ny various machines on my network. My BE is MDB. On each machine the user starts an .exe file that i wrote in vb6 that checks the Server version # of the mde FE and then copies it to the local machine if it needs to be updated. This...

jvangils, forgive my ignorance but I'm a newbie. Where would I paste the above code? Thanks for the reply.

Is it possible to disable the "Resize" or "Restore Down" buttons in the Access application. In other words, not the form's controls but the main Access window? Any suggestions?

I am currently making some changes to our company db. One of my biggest requests is to change the default "MATCH" setting in the edit/find function to search "ANY PART OF FIELD". You can do this through tools>options>edit/find and set the behavior to "GENERAL". The problem here is that doing...

I am giving my db a facelift and trying to set it up in a "web style" format. I need three frames as shown below. I am using 3 forms for the "frames" and in each form's ON ACTIVATE property i have the code DoCmd.MoveSize with the respective locations to place each form where i need it. Frames 1...

YES, matter of fact I just tried that and it works great. I made a public sub that I call from both forms. THANKS GUYS!

Andy, I have some measures in place that keep users from editing old orders. So the ENTER NEW ORDER Button sets the AllowEdits property of the form to true. When they finish the order the user hits the FINISH button that sets the AllowEdits property back to false. I have a similar scenario for...

Thanks Andy, that did the trick on opening the form, now I need to know how to call the sub from another form.

I have a form for entering new customer information, "Form 1". when you click the finish button on Form 1 the code closes Form 1, opens Form 2 so you enter the customer's ordering info. What I want to do is after Form 2 is opened remotely from Form 1 run the ENTER NEW ORDER button's private sub...

I have searched the forum but couldn't find an all-in-one fix. Since this should be a common problem i thought someone must have some code they keep handy for this. String functions like Left, Mid, Right and Instr will be find, I just don't know how to write them yet because i'm a newbie. Thnx.

I have a field on a form that contains city,state,zip,zip+4. example: New York, NY 01341-1111 This is all in one field on one line. I need to hit a button and strip the data from the one field, then copy to the appropriate fields on the same form. example: [City] = New York [State] = NY...

Figured out a way to do it from several other posts. Works pretty well. Thanks to all. Mystring = [CustInfo] MyArray = Split(Mystring, Chr(13), -1, 1) Me![Name] = MyArray(0) Me![Address] = Mid(MyArray(1), 2) Me![City] = Mid(MyArray(2), 2) Me![State] = Mid(MyArray(3), 2) Me![Zip] =...

Thanks Pat, We're getting rid of old customers in the db and at the same time trying to convert to seperate fileds for their info.

I have a field [CustInfo] on a Customer Information form with control source to a memo field. It looks like this: NAME ADDRESS CITY STATE ZIP I want to be able to press a button that will copy the individual lines of this field to their respective fields on the form. example: .Name = Line1...

Thanks for the suggestions guys. What i need to do however is just have that report print to a specific printer & quantity set by the code. I don't want the user to do it. Here's what I have now to specify the qty. It works fine but you see the form open for a split seccond and the whole process...