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...
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?
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.