Search:

I have the following problem. I have to copy files to other computers with the following code:
If Dir(Alex) <> "" Then
Kill Alex ' this is the path to the computer
End If
StrDest = Alex
FileCopy...

Can i create a link by code to the destops of different computers having a path in the main computer for example "C: Mansions dorns.mdb

I have succeeded ! Thank you !

The table orders in my database uses only one autonumber and the same database from the other company uses a different autonumber in order to differentiate. The last number in our autonumbers is...

In that case I should not append the order at all. Since it will create havoc in my database.I think the way to do it is to create a new order and then update and not append order 142929 to this new...

I have an appended order from a foreign database with an autonumber that does not follow the autonumber of my table. In my example my last autonumber is 142929 while the appended row is 142929. I...

Thank you for your reply. I suceeded to make it having only one order in the table.So because of your message i discovered my error and now it is ok

kind regards
Markus

I have an update query that diesnt update. it gives no error, but updates 0 records. Why is it so ?
UPDATE Customers1 INNER JOIN orders1 ON Customers1.Customerid = orders1.customerid SET...

And of course it works.Thanks a lot !

your grateful Markus

Yes thats what i want. In my example i want items5 from 22 to be changed to 2. Which is the result in qry3.Due to reasons you have explained Access does not accet my critera and puts them into...

I get an error named "operation must use an updatable query" in an effort to build an update query from one query an one table.I want to use the result from the query to update a field in the...

Thank you so much Hans. That is us exactly what i wanted

Of course i will begin studying your help but before that i want to thank you really for your prompt and professional attention you have given to me and to everybody else in this site.Just to...

Yes, thank you, it shows only those records selected.As to your question,I want to begin the calculations from the order which has audit = True.In my example this is order number 142914. There is...

Yes there are no records for which audit = true and suborder= true.Only one record must exist with audit = true since the calculations begin from that point.But there exist also records where...

I want to make a query with two conditions : to include all the orders having orders.Audit = > True and also all the orders where orders.Suborder = true. I want to exclude the orders that have no...

How can i remove the syntax error in my sql ? I want to make a table called Customers1 with only one customer, whichi get from my recordset, used for other functions too

Dim dbs As DAO.Database...

How can i open a form with a password ?

Thank you Hans, thats really great !

I need to carry out commands to change a macro in 9 databases. The paths are called FETa,FESz, etc. i want ti simplify the code and write the paths as argumnets for example
PrivateFunction...

I have a function to rename a macro in remote database.Is it possible to use this function also to delete the table calls and the form frmCalls in the remote database ?
Public Function...

Yes, thank you! it works great !

Yes,i have copied and pasted:
Public Function RenameMacro()
Dim strPassword As String
Dim app As New Access.Application
On Error GoTo ErrHandler

strPassword = "secret"
...

Dear Hans

when i tried the code i got the folowing error with pointing to the line
OpenCurrentDatabase
Compile error : wrong number of arguments or invalid properrt assignment
maybe it is...

Thanks Hans really grateful for that it was a great help for me