Search results for query: *

I developed a dll using Delphi 7.0. I call the dll from a Microsoft Access database. On my own machine, running Windows XP Pro and Microsoft Access 2000, the dll works precisely as intended, however when I place it on the server it was designed to work on, nothing appears to happen. The server...

I'm very much a Delphi beginner, so please feel free to tear my poor 'newbie' coding to pieces (good or bad, it will all help). I am trying to write code to close Outlook security dialog boxes. The ultimate intention being to create a dll which I can then call from Microsoft Access using VBA...

I am shortly going to need to incorporate Email functionality into an Access 2003 application. Ultimately this application will become a runtime. I mention that as it may have an impact on possible solutions, though from what I understand, programs such as SageKey can greatly reduce the problems...

I have an application originally designed in Access 97 which I recently converted to Access 2000. Some forms have two pages using a pagebreak. Everything worked as expected in Access 97, however since converting to 2000 there now seems to be a problem related to the use of [ObjectName].SetFocus...

I have a subform object that, depending on user input, will display one of several forms. Two are continuous list-type forms, the others display details of a single record. My problem is that using the SourceObject, LinkMasterFields and LinkChildFields properties of the subform doesn't seem to...

I have continuous forms displaying records that include fields such as people's names, company names, addresses, etc. My problem is that while a person's name ([Surname] & ", " & [Firstname]) can be up to 62 characters in length within my particular database, displaying a text box wide enough to...

In my forms Load event I make a call to a sub procedure which sets the forms RecordSource using the following code Me.RecordSource = "SELECT * FROM MyQueryName " _ & "WHERE FieldId=" & CurrentId The RecordSource of the form is set as expected. If I call the code again with...

I have a speed/efficiency type question that any feedback on would be much appreciated. The question refers to the psuedo-client/server architecture where both frontend and backend are Access .mdb's, one on the client machine holding all non-table objects and one on a remote server holding only...

My problem is the time it seems to take to complete a batch update of 126 records to a Microsoft Access 2000 database connected using OLEDB 4.0. I am using the ADOTable component in Delphi 7.0 I have written code to extract data from an HTML file. My development test file involves extracting...

I recently began using Delphi again for a new project (I'm still a novice). My project involves writing to a local database, and it seems the best approach to that is to use the ADO components. Having said that, it is proving almost impossible to find a comprehensive reference to using these...

If I have a set of Parent/Child type tables like "Order" and "OrderItem", after creating a new record in the Order table, what is the best way of retrieving the OrderID of the record just added so that I can then add the related records to the "OrderItem" table (each of which needs the OrderID...

I want to extract a series of Needles (Sub-Strings) from a Haystack (String). I will always extract the Needles in ascending order of appearence within the Haystack. When I previously did such a task using VBA I was able to work with the same "Original" string, beginning the search for each new...

I'm using Access 2000 with SQL Server 2000. When I run a piece of code (only the transaction part of it is included below) the code appears to complete successfully, but certain tables then appear to be locked and any calls to them result in an "ODBC--Call Failed" type error. If I simply...

I have an Access 2000 application which includes a form to add new records to a certain table. On that form there is a checkbox which has a default of False (I have also tried 0 [zero]). The form has a select query as it's record source, with each object on the form tied to the appropriate field...

I am using Access 2000 front end with an SQL Server 7.0 backend database. I have a table with Orders. Each order record (amongst other things) has a CustomerId, a TypeId, and each Order record has a TotalOrderValue. I want to show a list of Customers, with a sum of TotalOrderValue, plus a...

If I want to do something like the following: 1. Add new records into Table_A 2. Update the value of [Field1] in Table_A to = "SET" 3. Update the value of [Field2] in Table_A where [Field1] is equal to "Set" Can I do all of that inside a transaction, or will it be the...

In Access 2000, if I have a Totals type query of the form SELECT Table1.ObjectId, Max(Table2.FinishDate) AS PrevFinishDate FROM Table1 INNER JOIN Table2 ON Table1.ObjectId = Table2.ObjectId GROUP BY Table1.ObjectId; Let's say the above query outputs the following results: ObjectId...

If I have SQL something like the following ( SELECT Something.SomethingId, [Surname] + ', ' + [FirstName] AS MyPerson FROM Blah Blah Blah WHERE (((Table.SomeId)=1234)) UNION SELECT Something_1.SomethingId, [Surname] + ', ' + [FirstName] AS MyPerson FROM Blah Blah Blah WHERE...

If I have a set of constants named, say, iConst_1 iConst_2 . . iConst_99 Is there a way within code of being able to refer to the values stored by these constants without having to explicitely name each one. Something like... i = 1 Do until i >99 anArray(i - 1) = "iConst_" & i i...

I have code similar to that below to initiate an instance of Microsoft Word from within Access. How do I ensure that if an error occurs, the instance of Word gets shut down? In the early stages of the coding when errors occurred I had to go into the Windows Task manager and manually close down...