Search results for query: *

Hi thanks for your reply, A little tweaking for my application and it is working great, I was trying to see if there was a commands to save and close the workbooks .... but have not found any info on that. You wouldnt happen to have that info?? Thanks for your help, it is appreciated. Here...

Hi there, I am having a few problems with the context to insert the data from an array within delphi into an excel spreadsheet. I have a couple of snippets of code that I have been playing with from an online tutorial but I can't seem to get them to behave in the way I want ..... The first...

Yes thanks this did answer my question, I am now getting my data in directly from the datasource and ignoring the grid .... Thanks for your help

Hi there, I am fairly new to delphi so please bear with me .... I have an application that I am working on that has a TDBGrid that is querying an excel spreadsheet, I now want to access the individual data for use within the programme. I am having problems with finding the correct properties...

Hi there, For those that are familiar with this macro I am using it to hide the database window to keep users out from behind the scenes. All is working well except that I have some pre-prepared queries that users can run, problem is when the database window is hidden the query results can not...

Thanks for the quick reply, That was the little snippet that I needed to fix my problem. Thank You

Hi there, Just a bit curious on using dates in a database, I am using dates a lot through my database with the MSComCtl2.DTPicker object and within the tables I have the datatype set to date/time with the default value being date(). All works well except for when I try to compare a date in the...

Thank You .... that worked brilliantly

Thanks for your help so far anyway ..... No solution so far so if anyone can help me it would be much appreciated ... Basically the short question is: How do I display the result of a query in a text box on a form when the datasource for the form is not the query in question.

Thats what I am actually trying to do ... get a text box to display the value instead of using the list box. The form has a Table as the datasource, the list box is driven by a query that takes a tally of a percentage value and displays that to the user. It is purely there as a reference for...

Hi there I have a query that only returns one value, I am currently displaying it in a list box ...... The problem I have discovered is that until it is physically selected I can not use the value in there as a part of the data validation routine. How would I go about using the query as the...

Thanks a lot scriverb, That code was just the trick and everyones help is much appreciated. Is it possible to modify this so that a combination of fields can be checked or will it work with only one field at a time ?? EG: rs.FindFirst "[Field1], [Field2] = '" & variable1, variable2&...

I am looking for the best way to ensure that a recordset is unique before writing it to the database?? I was considering setting up composite keys within the tables but would still rather capture it at the forms level before it reaches the tables. I have been trying to create a function the...

Well I have that part of the problem solved, just having a few problems getting my code to work as it should. I am tryin to create a check for existing records, this is so that I can prevent certain duplicate combinations from being created (starting simple with one hardwired value). This is...

Thanks ... that solved the problem with the compile time errors

Hi all, I am just trying to get the basic hang of using sql within the VBA attached to my database ... without a great lot of luck. This is the basic format I have so far: Public Sub DoSQL() Dim SQL As String SQL = "SELECT Breed.Sub_Species " & _ "FROM...

Thanks a lot guys, Got it working .... really appreciate the quick replies

Hi all, I have a list box which is populated through a query, what I would like it to do is have the list only show values based upon a dropdown value within the form. The theory works as far as if I add in a button to run the query it will take the value from the dropdown and produce the...