Search results

ok, lets try this. The only problem i now have is checking that all 3 fields are filled in. if they are i need to move to a new record to start over again. Thanks Kevin

Good morning all, I have a form used for dataentry from a scangun. 4 field A, B, C, D. A = an unbound text field, where I want all the scanning to go on. I have code to check the value of what is scanned and move it to either B, C, or D, based on a prefix. no problem there. Question 1: If...

any machine w/ an IP is fine, not sure about over a WAN though. Should work fine.

WinXP has a tool called "Remote Desktop Connection". Use it to log into any PC and assume control. The remote PC needs to be setup to accept remote connections. System properties, Remote Tab, check to allow remote connections. launch the program from Accessories, Communications. Kevin

I have seen it before ( and just spent sometime searching) but can't find what i'm looking for. can someone give me a "search" hint to find how to record errors to a table in my DB, so i can view them over time (if they occur)? Trying to figure it myself as I have seen it before. Thanks Kevin

Thanks Pat! (once again) Kevin

I have a linked table ( to a DB from Best SW) that looks like below: RMA# DAte Item SN code Misc 9016877 3/28/2005 TS9000+/433 TSS02351 C001 9016877 3/28/2005 TS9000+/433 TSS02351 RP190 comment1 9016877 3/28/2005 TS9000+/433 TSS02351 I001*...

Thanks EMP, that was it. Its nice to have a pretty good working program, but its even nicer to have something that goes the extra step. Thanks again Kevin

Thank Pat, I selected 3 "RMA's" from my listobx ( 9016390, 9016391, 9016394 ) and strWhere = "[RMA#] IN ( 901639090163919016394 )" I think this is where you were talking about the comma's. I again tried different things with the comma's, to no avail. Here is the code that I have now: Private...

thanks for replying Pat, I am a little confused about this code to begin with, I undeerstand what its trying to do.....just can't get it there. I fooled with the ","'s and quotes but either get a error or no records at all because i get prompted for an input for strWhere. could you maybe give...

Hi all, I have a form w/ a listbox that allows me to select an "RMA#", then click a button to open another form with the RMA details. I wanted to make this a multiselect listbox, and have it open the form and allow viewing/editing of ONLY the slected records. I got some code from a book called...

YYEEEESSSSS! Thanks both of you. This forum has been a great help. never would have made it this far without it. Thanks again Kevin

thanks for replying guys, no, it does not compile. below is the on_clk event I have for a button on a form. I tried changing the module name to something other than the function name....sitstill the sitstill(3) is where i get the error. Private Sub goimport_Click() On Error GoTo Err_goimport...

I have seen a few other posts about this problem, but they don't seem to help me.

I found this post for setting a "pause" in code. Thought this would work great!, but... I created a module with the following code: Public Function Pause(NumberOfSeconds As Variant) On Error GoTo Err_Pause Dim PauseTime As Variant, Start As Variant PauseTime = NumberOfSeconds...

I had tried that but it didn't work. After reading your reply i went back and because the form name had spaces in it, i had to use: Forms![form name]!LabelName.visible = true Thanks

Good morning All, I have 2 forms, FORM1 opens first. when a button is clicked FORM2 opens. When a button on FORM2 is clicked, FORM2 closes and the code runs. The focus then goes back to FORM1. How can I make a label on FORM1 visible ( default is set to visible = no) when the button on FORM2...

seems to have worked fine. Did it in a test DB first. Thanks

I have several buttons on a form used to import data from an ODBC connection. The code turns off warning messages, turns them back on then a msgbox opens stating "import complete". all these buttons do this when each is clicked. My question is: Can i combine all this code into 1 button? is...

Thanks for the tips! Should work quite well.