Search results for query: *

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...

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,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,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...

I was writing a program about online shoping,when the customer submit the form,we send the email to their email address to confirm their order.does anyone know how to convert the content of web page in email? Thanks for any hints and suggestion.Your help will be appreciated very much.

When I'm trying to import data from access database, the message tell me :&quot;don't have permission for '|' object&quot;,does any know what the '|' object is? pls advise, thank you for your help.

Recently,our access database give me hard time,it corrupted twice. when I open it ,it send message need repair,after repair,the message box show up saying&quot;It's converted from aprior version of access by using DAO Compact database method instead of the convert database command on tools...

Since Access file in multiuser enviroment is easily corrupted,back up is important.But the problem is: 1. When you back up file some one may be working on it(writing or updating data),if you back up at that time the data may lost.you can't asked all the users to close file,and then back up, it's...

In Excel I try to import data from Access file but every time the message saying&quot; ....don't have permission to read access file &quot; actually I have full permission to access file,I think this is related to *.mdw file but I can't figure out where is the problem,Pls give some...

The access database in network is corrupted,I try to fix it but failed. At first I try to use utility tools to repair the database,but It send message:&quot; it's in unexpected state,can't open file&quot; secondly, I made a new blank database ,and try to import the data from old/corrupted...