Search results

str2 is DIm'd as string txtSQL is a text box .....

Hi all, I've got this line of code under my form_current() envent (frmEmails) str2 = Forms!frmMain!txtSQL.Value but when I start the DB I get the Invalid use of Null error, now, it seems that I need to define my txtSQL.value = "" but am not sure where. I've tried under frmMain_load event but...

I have a quesion now...is it possible to add one more subform which would respond when you hit a record in the first subform, and not in the main form. That is what I'm stuck at right now..

guys...That was it...now everything seems to be OK...thanks a lot Minkey see ya around

maybe that's it...I know I had some issues with alg.exe before, when I was putting another firewall up...I'll try that...thanks a lot

Thanks...that was what I needed...I was wondering...how come that in Excell VBA there is a application.DisplayAlert and in Access isn't ?!?!

put this code on your checkbox...so that it goes on when you select the check box

One more question...is there a way to execute SQL with docmd.RunSQL but without the confirmation dialog box... I need to insert some data into table and I'm sure that I want to do it...how can I skip to answer "I'm about to append 1 row..." Thnks

I've tryed what U suggested but still without results... I did visit MS page and did that few days ago...but still with no results...there has to be something simple...just think off people who are web designers who tried to upload their sites after installing SP2...weird...

Well, I've tried through IE, FireFox, I had CUte FTP as well, and now I0m using ftp through Win Commander...The thing is that all worked well before I reinstalled my Xp, so I supposed it has to do something with SP2 which I didn't had before... and what seems funny is that other PC on my network...

NOpe, ntohing new...I've looked into Microsfot web but it doesn't help.... I've tried to open my port 21 manually but still nothing... any ideas? D

Never mind this one...I somehow found the solution for my problem...thanks everyone... D

Oh, oh...I did it...with all your help, of course...thanks a lot guys... well, it seems that my SQL string had a small incosistence...I had an ORDER by tbl.userID and my SQL SELECT statement didn't have that part at all... anyways..thanks a lot everyone...I've learned a lot Daniel

Well, I'm not checking for Null because you can have a recordset with no check box selected and it would still be a valid entry. My rpoblem isn't in building the SQL string, as I said, I is done (and it is a good one, I am getting the right results in all possible ways combined)...the thing is...

Still, thanks a lot for the info...I'll search out the microsoft support site...it seems I may get it to work... D

well, windows firewall is enabled...but even if I disable it, no change..and I have given perrmision for the FTP service for the port 21...dunno D

I'm not really sure if that is what I need...I may try if I don't get any progress..the thing is I had it all up and running 2 months ago...then I had to reinstall my PC. No I have XP with SP2 and the other one is still XP with sp1...could be that something in sp2 is not set up right... both...

Hi... I'm having a weird problem...I'm having two computers connected over UTP crossover cable. Mine has an internet connection (shared, firewalled) and the other one is sharing that same connection. How is it possible taht I can't connect to ftp and the other pc can, since it is on the same...

So far I had several Subforms which would open in a mainForm depending on the combo box value. My combo box values were exactly the same as subform names so that I can easily change subform.recordsource = combo.text and it would show the proper form. Now, I'm thining, instead of having all those...

Usually it asks for parametar values when you loose your recordsource...check that one...