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!

  • Congratulations Wanet Telecoms Ltd 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: benny7
  • Order by date
  1. benny7

    Converting Foxpro Tables to MySQL

    This has currently been put on hold. Will come back to it. However thank you all for your assistance
  2. benny7

    using a variable for a filed name

    I have 15 field with similar names. These just differ by the number at the end. Currently I am using case statements to populate these fields. Is it possible to use a variable name as a field. If so I could use something like m.type_ + nvar = ... Is there anything like that I can do? for...
  3. benny7

    Convert Foxpro Tables into MySQL

    Is is possible to convert foxpro tables into mysql. If so how would we do this?
  4. benny7

    Converting Foxpro Tables to MySQL

    Is is possible to convert Foxpro tables into a MySQL database. If so how?
  5. benny7

    Count items in a column

    Hi I have an Excel spread sheet with some fields in a column containing from 0 - 3 crosses (x). I want to count these crosses(x) and put a total at the end. Can this be achieved?
  6. benny7

    skipping records in a child table

    I have two tables with a one to many relationship. Currently I've linked them as below: select 0 use shares && child set order to client select 0 use client && Parent set relation to client.sysref into shares set order to sysref seek 101 The shares table can have many records associated with...
  7. benny7

    Touch Screen Application

    I have done lots of work on touch screen EPOS systems and hospitality systems. The hardware we use is mainly, but not soley TEC ST70 or ST60. I use the TEC OPOS drivers to run printers and cash drawers etc.. Lots of info can be located on the TEC web site.
  8. benny7

    Create an XML activex program

    Hi, I have little experience of XML, and little experience of creating ocx files. However I wish to create an ocx program which can read, and populate xml files. Is there some example code of ocx files, for xml or can someone offer me some assistants?
  9. benny7

    Using Access Database on Macintosh or Linux

    Well initially I'm trying the tables, didn't really think about the screens and forms, is this possible?
  10. benny7

    Using Access Database on Macintosh or Linux

    I have a database which we currently use on a windows system. How easy it would be to port the database to an Apple Macintosh system, or a Linux system. Or is this not possible?
  11. benny7

    Distributing a databases

    I've created a database, along with forms, reports, and querys. I want to distribute these, how do I do it so they can only view the database via the forms? Basically I just want them to be able to run the databases and see the switchboard, nothing else. They can then select the forms...
  12. benny7

    Auto Number is higher than total number of records

    Hi I've got a table which is has a key auto number field. It appears that some corrupt entries may be in the table as only 1 record shows but the auto number is now currently at number 7. How do I remove the other entries. I've tried compact and repair databases, no luck. Thanks
  13. benny7

    Having a button to select a picture

    Hi, i'am allowing them to display an image for the current record. The next record will have a different image which they can also set.
  14. benny7

    Having a button to select a picture

    I have a ole picture control on my form. Can I have a button or a text box so the operator can select a jpeg or bmp which will show in the picture frame?
  15. benny7

    Validating two fields against each other

    How do you do it then? Please
  16. benny7

    Showing one-many tables on a form

    I'm new to access, so this question might sound simple. However I have two tables, one parent and one child. I want to show the contents of each table on a form. How do I do this? ie: Film Tile Film Description Duration etc .... Above fields in the parent table Copy Number Avaialble DVD...
  17. benny7

    Validating two fields against each other

    I have a table which holds a number of fields, one of these being password, and one being password hint. I do not want the operator to be allowed to put their password in the password hint box. Is there a way I can use the validation rule to check passwordhint does not equal password?? Thanks
  18. benny7

    Case insensitive fields

    Is is it possible to create a "chr" field in a table which is case insensitive when performing a select statement, e.g: select descr from temp where desc like "%jam%" Would return all instances of jam regardless of case e.g: jAm Jam JAM etc..... I am not looking to change the select...
  19. benny7

    Convert Foxpro table to Mysql

    Is there an easy way to convert foxpro tables into mysql. Or perhaps create a mysql tables from a csv file as I could create a csv file from foxpro. I'm a novice at mysql thanks
  20. benny7

    Convert Foxpro table to Mysql

    Is there an easy way to convert foxpro tables to mySql tables?

Part and Inventory Search

Back
Top