Search results for query: *

Bear with me on this. I am having a brain freeze and can't move forward with this one. I have a table something like this: IDField SaleDate CustomerID 1 1/1/08 552 2 4/3/07 552 3 12/1/07 552 4 4/3/08 444 5 6/3/07...

I have tried several times in several ways to use an Insert Into Statement which includes a CASE WHEN in a select statement to insert into the table. I have gotten errors that there weren't the same number of fields in the select as the insert. I tried altering it and can't seem to get it...

HELP!!!! My frustration level is rising. I have tried to import all of the worksheets into a table in Access, but for some reason when I change active sheets, it doesn't change...I have traced the value of the active sheet ,but it isn't changing. I have tied iterating through all...

Hello: I loved the following article, but I need to do something different and I'm new to SQL programming. http://tek-tips.com/viewthread.cfm?SQID=859372&SPID=183&newpid=183&page=1 I am trying to take the items in the temp table and instead of sequencing them consecutively I would like to...

Can anyone give me some idea of how to fill a list box with the captions and names of all reports. I want to use this listbox as a selection of reports for printing. Any help would be appreciated!!!! Karen

Can anyone tell me how to enumerate through all of the files in a directory and rename them. For example I have a directory with files such as 1.bmp, 10.bmp, 200.bmp. I want to rename the file respectively, DMS1.bmp, DMS10.bmp, DMS200.bmp. I haven't worked much with file objects. Any help...

Hello Everyone! I was hoping that someone might have the answer to a question. I have a search form with a listbox, a text field, a combo box and a button. Usage: 1. Select a value in the combo box, e.g. First Name, Last Name, ID. 2. Next, there is a text box to enter the search...

Hi Everyone:<br><br>I hope someone can help.&nbsp;&nbsp;I have built a form based on a view which combines a few tables and a query.&nbsp;&nbsp;Maybe I'm thinking too much like Access.&nbsp;&nbsp;&nbsp;I have a query which determines the &quot;Last&quot; year (i.e. 99-00) in a...

I've searched through help files in VFP6 to find some way to use &quot;sub-forms&quot; as access permits.&nbsp;&nbsp;I found the grid control used in one-to-many forms, but I was trying to use more of a form in a form type of format.&nbsp;&nbsp;Any help, as always, would be appreciate.<br><br>Karen

I am new to Foxpro.&nbsp;&nbsp;I work in Access normally.&nbsp;&nbsp;It has confounded me that there is no way to easily open a screen with a &quot;button&quot; on another screen.&nbsp;&nbsp;Can anyone help!!!