Search results

I think your problem is with long file names Basicly you need to enclose your shell command in quotes or use the dos 8.3 name for the path. try shell """c:\some long dir\batch.bat""" or shell "c:\somelo~1\batch.bat" its something like that anyway :cool:ShadeZ:cool:

if you dont know what a nOOb is then you are one.... :D :D nOOb = Newbie = New to something = You :D :D :D :D :D :D :D :D

LOL:D :D Dont confuse them mission2java, nOObs dont know what pointers are :p But yes i have to agree iif is easy... Nz is the best access function ever.......

thanks Mile-O;) Saves me having to dig one out. :D

hmm tricky (not realy) How detailed do i need to go??? Use vba to create your find criteria ie dim firstname as string dim Surname as string dim findStr as string firstname = mid(SearchTxt,1,instr(1,searchTxt," ")) surname = mid(searchtxt,instr(1,searchtxt," ")+1) if surname <> "" then...

hmm i wouldn't use the line method i mentioned to do that, Access will just crash. in my experiance any picture or clever graphics jus kill access in the end (It jus eats up access memory, which it doent release) the best way i can think of doing it is to use api calls (not done this myself)

:D :D :) :) :D :D

ok its not the Err, But from ur code i think i c a bug. ur error handler is using GoTo No_rstData to return from a handled error. This turns the error handler OFF!. (Creating the problem you see) To Keep the error Handler going use Resume No_rstData like you did for DONE. To turn the...

hmm i think i c ur problem... Edit:Dam beaten to it :( err is a function and your also using it as a error call, try just changing the name of the error handle ie ErrHdl instead of Err are you turning the error handler off when you leave the sub? Post ur code here for a more detailed...

ADO is easy to add a record to a table i tend to use currnetproject.connection.execute "insert into TableName (field1,field2,fieldn) values (" & SomeVal & ",'" & SomeStr & "'," & SomeThinElse & ")" Note u can use the query builder to create the query and then copy and paste into code...

End users see what you want them to see..........

homer2002, I dont think you can draw on a form(U can use that method to draw on a report) stupid access!! the only method i know of to draw a line incode is to open ANOTHER form in design view DOCMD.OpenForm "someform",acdesign then create line objects on the form...

I dont know if this is relaited to your problem(cant seem to recreat it) the only date issue i know of is the stuped American MM/DD/YY thing. ie if u use 01/08/3 - access would read it as 8th jan 03- not 1st Aug 03 is suggest always using format in string dates to remove this problem...

Heres somthing to try in VBA dim rs as adodb.recordset rs.open "Select * From Table",Currentproject.connection if not rs.eof then 'is there any data open "Somefile" for output as #1 put #1,,rs.getstring(,,,"|",vbcrlf) close #1 end if rs.close I suggest u look...

Where do you want me to start?????????? 1= you cant ask if something = NULL use ISNULL(something) instead 2= NULL is not a function, (ie. something = null(somthing) 'wont work) You might want to look up IIf, NULL, ISNULL and NZ in the help? I think this is what you were trying to do...

I dont c anything wrong with what you have done. You can try registering the control from inside access >>Tools:>activexcontrols:>register the problem your seeing could be another missing OCX problem, chk you have everything the only other thing it could be is there isnt enough memory on...

think what your looking for is called a 'UNION' query ie select * from someTbl UNION select * from someOtherTbl its something like that, cant remenber exactlty. Look it up in access help :cool:ShadeZ:cool:

Just a suggestion if you want to chk for null and and "" at the same time use, If nz(tbPhone,"") = "" And nz(tbName,"")= "" Then :cool:ShadeZ:cool:

I think i might know your problem, (Its an access bug!!!) your record set is stored in a global module, and all the functions around your recordset are in different modules. this is fin in VB but access VBA is a pig and loses the reference to the records set. i would recomend placing all...

Soz, been bussy this weekend Have you solved ur problem yet or do you require more help, :cool:ShadeZ:cool: