Search results for query: *

I got this sample function from Microsoft knowledge Base Article - 210331 http://support.microsoft.com/default.aspx?scid=kb;en-us;210331&Product=acc2000 I did exactly that and I got error 3029 which returns its custom message "The account used to create the workspace does not exist&quot...

I have a OLE Object field named oleFile. It is used to store all kinds of application files (I know it is not a good idea to store file in Access, but it is business needed) I have a button(command 14) when click it activates the file. It does well with all Microsoft products(Word, Excel...

Can someone show me how to convert this into ADO. Thank you very much! Dim db As DAO.database Dim sSQL As String Set db = CurrentDb()

I wrote the following codes to linked a table from another Access database. Dim db as DAO.Database Dim TD as TableDef Set db = CurrentDb Set TD = db.CreateTableDef("TableNameAfterLink") TD.Connect = ";Database=" & "G:\folder\target.mdb" 'Path to target database...

One table in my Access database is used linked to an Excel spreadsheet on the network. The Excel spreadsheet is updated by another department. Today, the linked table doesn't display the information exactly except the one date field. Every other fields display only one or two characters that...

I created a textbox Name txtCount in the detail section of a report. The data Control source is set to "=1" and Run Sum = "Over all" to count the number of records of a grouped records. This runs OK How do I retrieve the final count value from txtCount to be used in the...

I have the following expression in a query column to count records: NumberRecords: Dcount("RecordID","RecordTable","[IssueDate] = Between [Enter Start Date] And [Enter End Date]") This doesn't work. What did I do wrong? Thanks!

I would like to diplay only the last 3 visit records of each patient in the subform or subreport. Is it possible to do this in a query, or a VBA must be written? Does anyone have an excample for this? Many thanks!

I am using a query to group an ID# field (multiple ID# allowed), and select Max to show only the last record of each group. This is working OK. I would like to show the rest of the fields that related to this "Max" record. If I just choose the fields, the query return all the...