Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: gibben
  • Content: Threads
  • Order by date
  1. gibben

    Insert => Delphi Array => Into Excel Spreadsheet

    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...
  2. gibben

    TDBGrid: Accessing cell/field values

    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...
  3. gibben

    Problem with "mcrHide", can't view queries and reports.

    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...
  4. gibben

    Date Picker - correct data type

    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...
  5. gibben

    Display query result within a Text Box

    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...
  6. gibben

    Best way to check that data is unique??

    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...
  7. gibben

    SQL within VBA ..... the basics

    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...
  8. gibben

    Query driven list box - Dynamic Query

    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...

Part and Inventory Search

Back
Top