Search results for query: *

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

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?

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

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?

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

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

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

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

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

I know I can open tables with an alias name and I know I can open a table using a varible name, i.e. use table1 alias tablename or tablename = "table1" use (table1) Basically I've got two tables with similar information. Circumatances will determine which table I want to use. Say I open a...

I want to select certain items from a table and put these into a csv file. The code below puts them into a txt file but has the heading and comma seperating the fields. Is it possible to send data straight to a csv file, with no headings from a table? select barcode, Descr from plu to file...

Hi Using VF 6, I want to write a simple program to search a table for certain contents. This I can do. However I want this program to be used in a different program written in different language. Can I write a dll or anything similar in Foxpro. Thanks