Recent content by zhongwei

Hi, there I'm trying to write code in VBA to break a line and insert a block at this break point.I look at the methods of acad object i didn't find any method to do that.if some know how to do that pls let me know. Thanks in advance.

Hi, friends I have a problem about Axtivex.I put activex-datetime picker in two forms.but they work in different way. In formA, every time I open form ,the Active control display the current date.It's dynamic In formB, every time I open form, the Activex control display the date when I...

I'm writing code to copy a table(named table1) to another database(C:\db8.mdb),and new table's name equal to variable T the coding is like: Dim T T = "1234" DoCmd.CopyObject "c:\db8.mdb", t, "acTable", "table1" every time I run it the error message pop up...

Hi,all I had planed to link my local database to a remote database,since the remote database is in multiuser enviroment if it corrupted (it has corrupted twice before) it may affect my local database.I change my mind ,I try to add query in remote database when it send data to database,it also...

I have a mdb file in my local drive ,we also have another mdb file in our network,I plan to link the tabale in my local database to the table in the network.Since the other table in multiuser enviroment, It has more possibility of corruption. Could someone tell me what will happen to my local...

Hi,cmmrfrds & Randusoleis After reading your message,I also check the online book about input parameter,then I redo a new access data project, It worked ! Thank you very much!

Hi,randusoleis following your instruction, I tryed ,still failed. I'm confused that in store procedure,I just declare the parameter @idnumber int. if in input parameter property I just type [forms]![formA]![text1],how they know each other ?how they're related? I think I should put...

Thanks randusolies & cmmrfrds Actually as I mentioned in my first message,I already tried to pass parameter by using input parameter property,but i failed. every time a message box pop up to ask for the value of idnumber. in the input parameter property I type in like...

Hi,Cmmrfrds Thanks for your reply. I'm trying to pick up data from form,but Where should I put these data: @beginDate=forms![formA]![text1] ,@endDate=forms![formA]![text2] Looking forward to hearing from you! Thanks again.

I'm trying to upsizing access2000 to SQL and make a access project,but I face some problem about transproting data from form to store procedure,eg: in access 2000 we have Query like this: select * from table1 where id=forms![formA]![text1] after upsizing to sql it's like this: ALTER PROCEDURE...

Hi,paul thanks for you suggestion,it fixed the problem,but i'm still confused why command object works well with another Query,but for this query it fails? thanks a lot

Hi,everyone In ASP I'm trying to run a Query in Access, here is the code: <%set conn = server.createobject(&quot;adodb.connection&quot;) conn.open &quot;WEBORDER&quot; set cmd=server.createobject(&quot;adodb.command&quot;) set cmd.Activeconnection=conn cmd.Commandtext=&quot;Qlist1&quot; set...

Hi,everyone ,thank you for your suggestion,I think I didn't make myself clear,so I put further detail here: the Query3 based on Q1 & Q2. if Q1 & Q2 whitout any condition,just execute Q3 in ASP is ok.but Q2 has &quot;having&quot; clause,While execute Q3 we need to pass parameter to Q2 in ASP,This...

Hi,gsc1ugs Actually I'm new in ASP,i can't follow your idea,could you write some detail about it?Thanks.

Hi,everyone,I have some problem in ASP,I need help. Our database is Access2000, we have Query1,Query2,base on them we made Query3. Query3: SELECT Query1.JobNum, Query1.launchDate, Query2.Company, Query2.MaxOfIssueDate FROM Query2 INNER JOIN Query1 ON Query2.Jobnum = Query1.JobNum; If I want to...