Search results for query: *

I am using data from oracle to draw a diagram. When I need to know is the vba code to group shapes. They also want the grouped shapes to be surrounded by a dashed rectangle. Anyone?

Dim db as database Dim rst as dao.recordset Dim strSQL as string Dim lng as long Set db = currentdb strSQL = "SELECT * FROM [tblName];" Set rst = db.openrecordset(strSQL) rst.movelast lng = rst.recordcount

Possible solution would be to print to file (i.e. *.txt) first and then load from txt file.

The setfocus command is for run time. That is why your getting the error. What are you trying to do with the copied object?

I would trigger any requerying other controls on a form in the AfterUpdate event. The bound controls are coming from the forms record source.

Try Format(CCur(Value),"$ 0.00") Or CCur(Format(Value, "$ 0.00")

In the Form_Open event type Docmd.Maximize

Try the requery method in the Form event (Me.Requery)

Does anyone know what the vba shell command is to unzip a file? Any other alternatives would also be appreciated.

NewValues Property You can use the NewValues property to specify how AutoNumber fields increment when new records are added to a table. Note The NewValues property applies only to AutoNumber fields. Setting The NewValues property uses the following settings. Setting...

Hey Instructor, First, do a manual import of text file. On the advanced tab, import the names of the fields you use in your access tables. Then save it. When you want to call in code, you refer to the import specifications that you saved. (i.e. DoCmd.TransferText acImportDelim, "New...

Hello, Looking for the capability in VBA to unzip a file to *.txt Any clues... Henaniy