Search results for query: *

ok, i have a few tables that i joined to get the data that i need (customer orders). i need to split the data into several reports based on the salesman that shows only there sales for that day. here is the code thus far, which does bring up a list with all salesman together. is there a way...

Thanks Tony, but i've tried the .show with the same resaults. The .display will let you process the document also, if you push publish it will save a pdf in the folder and name you select.

thanks, but that's just it, regardless of the button in the dialog pushed, it goes to the next line, if i put the goto statment in, it would goto that label if ether button is pushed. is there a way to get the 'Selected' button value? i've tried, and it gives me the same value regardless. (the...

i have a doc that i am trying to convert to pdf using a button. it works, but i'm trying to get the cancel button int the dialog box to jump to a spot in the code, as it is now, no matter what button you push in the dialog takes you to the next line of code in the VBA. i can not find a way to...

i have another question. if you don't mind. is there a way to set the form onclose to log the user out of windows?

Thanks again for all the help

lol.... typing the answer at the same time lol

ok i answered my own question.... when i split the db, i used a folder on the original pc, instead of the network path. i resplit the db using the network path and all is working. :)

MajP, sorry to bother you again. i have moved a copy of the front end off the server, i run the db and Form1 comes up and i type in the username and password then press the "go" button. i get the following error "c:\servername\foldername\dbname_be.mdb is not a valid path. make sure that the...

thanks MajP for all the advice. you have been most helpful.

the db is split, back end is on a network server, front end is on a terminal server, where users will use a secured vpn and login to the network. on their term server desktop is a shortcut to the front end. should i change the short cut to an actual copy of the front end?

Thank you all for your help. here is what i did and it is working. in Form1 Private Sub btnGO_Click() Dim sPswd As String If IsNull(Me.txtUserName) = True Or IsNull(Me.txtPassword) = True Then MsgBox "Please enter both a userid and password" Exit Sub End If...

Hello all. I was hoping someone could point me in the right direction. i have a login form where a user inputs a user name and password, and it is verified in the db table. what i'm not sure how to do is use that username to populate another form with records from another table. ie i have...

Thank you all for your help. MajP. i used a variation of your code, and it is working now. thank you again.

i'll try it, but my query is stated in the vb statement. i'm using word and trying to pull this item into word from access db.

hello again. i am having a issue getting the results of a vba query into a veriable or to be displayed. i have a form, that i need to insert a item from a access db. i can get it to query, but how do i display the results. strSQL2 = "select SIG_IMAGE FROM tblPHYSICIAN WHERE PHYSICIAN_NAME...

ok, so i've spent the last 2 days looking through the treads here, and have found alot of interesting stuff, but i have not found an answer to my problem. I have found things that are close, but will not work for me. if some one could point me in the right direction.... my problem is i have a...

Thanks skip, i guess i was using the wrong box to search in.

Hello, i am looking for some help in pulling a image, stored in an access database, into a word doc using VBA. anyone have any idea?

i got it now thanks :)