Replies

The way the fields in a query is ordered is based on OrdinalPosition property. Hope this is what you are trying to do.

Check this You Can Do That with Datasheets? out.

Check CreateRelation Method in Access Help.

It happens to me as well. I use Dir() or Script Runtime instead.

Try on Current of the form like this.

Private Sub Form_Current()
If Len(Me.StudentID) > 0 Then
Caption = “Course completions: ” & Me.StudentName & “, ” & StudentID
End If
End Sub

I guess the db is 2000 format as you can see on the database title bar something like this.

: Database (Access 2000 file format)

You have to convert the db to XP format. Just goto Tools menu>Database Utilities>Convert Database>To 2002 File Format.

Then try again.

Check if you can insert the scanner activex in your form. When you are in Design view of your form, go to Insert menu>ActiveX Controls…>look for the scanner activex and insert it in the form. Then view this post out.

Check this out in Google.com, http://www.google.co.th/search?q=set+taskb…&oe=UTF-8&hl=th%5B/url%5D

And this, http://www.utteraccess.com/forums/showflat…on&Match=Entire Phrase&Searchpage=0&Limit=25&Old=1week&Main=113279&Search=true#Post113403[/url] for the screen resolution issue.

Hope you will come up with sthg. for your problem.

Check this KB acticle, http://support.microsoft.com/default.aspx?…kb;en-us;202099%5B/url%5D out.

You can also use the FollowHyperlink method to open a given file.

FollowHyperlink “C:Program FilesFirstClassDownloadRAD.pdf”

Re-install the previous printer and see if the error disappeared or not.

Check this page, http://home.clara.net/tkwickenden/codeex/7.htm%5B/url%5D out.

Tried Format() and it worked out for me.

ConCurr: Format([MyCurr],”Standard”)

This, I guess, forced the value to Standard format. The previous suggestion only hid the currency format but the currency still there.

Just change the Format property of the field in Query to Standard. Click the currency field, go to View menu>Properties> select Standard in Format property.

I don’t know what you really want to do with the control. But you can modify the code below to fit your need.

Dim ctl As Control
For Each ctl In Me.Controls
If ctl.ControlType = acTextBox Then
If Right(ctl.Name, 4) = “Name” Then
MsgBox ctl.Name
Else
End If
End If
Next

The code searches thru the Text Box controls in the form. If the controls’ name ended up with ..Name, then display its name in the Message Box.