Recent content by benny7

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

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

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

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

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?

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

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.

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?

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

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?

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

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

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.

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?

How do you do it then? Please