-
- VFP: need help in getting the no. of weeks in a month (1st to 5th week)
by Eumir
- 3 Replies
- Last post
by Markish
- Hi Everyone, I am newbie here and trying to learn VisualFoxPro. I was hoping that you could help me out on this. "How do I get the number of weeks in a month as well as the dates inclusive in that week " Any help would be greatly appreciated. Thanks in advance! Regards, Eumir
-
- Problem with Vista Windows mail
by JackChiou
- 14 Replies
- Last post
by Naomi Nosonovsky
- Hi everyone,
We have this foxpro 8 program that getting email from Outlook 2000, 2003, 2007 with MAPI32. It works fine until we try it on Vista's Windows mail. Everytime it runs "fetch" and get the meesage, the program will just break and pop up an error message saying
"An error occurred communicating with your MAPI message system. If you are using Microsoft Outlook try ch
-
- My exe does not running other PC
by mezofi
- 14 Replies
- Last post
by mezofi
- Hi! I built a project and I have a big problem. It is run only my PC, and if I put it on a pendrive (exe). But if I put it on an other PC , this program show only main page. Then when I click someone button, the program show an error message: Command contains unrecognized phrase/keyword (Error 36) It is very strange, because if it is on my pendrive the program good have not got any error. Mez fi f
-
- vfpoledb.dll access violation
by abhinaw
- 14 Replies
- Last post
by CetinBasoz
- We are using a COM+ VB component to access data. It uses Fox Pro DLL ( vfpoledb.dll dated april 2002 ). we are getting intermittent access violation errors in our application. I am posting event logs at the end. The interesting line is the last line ( vfpoledb!DllCanUnloadNow + 0x2144e ) . It shows that vfpoledb.dll thows error while trying to destroy a resource ( DllCanUnloadNow). It looks l
-
- image from webcam
by NILKAMAL
- 5 Replies
- Last post
by CChalom
- hello!
i am new in vfp and i have vfp6.0 now i create database include ole object field i need to tab skip image field and create one cmd button call take picture and i connect my web cam so image come from webcame and store in pic foleder also delete button so cancel only image not record
thanks
-
- Printing Query Results
by Dohko
- 9 Replies
- Last post
by Naomi Nosonovsky
- Hi
I have a table that has one column with numbers 1 to 51.
I would like to know how can I write a statement that will let me Count the frequencies of each number and store it in another column in the table.
I would also like to access this data with a variable for example
n=1
for n=1 to 51
numbers
frequencies
endfor
Thanks
-
- ignoring view modifications
by RavindraPatil
- 3 Replies
- Last post
by MarciaAkins
- friends,
i have a grid on my master- detail form. grid is used for details section. grid is based on a view. everytime when records are fetched in view i slightly modify records in it just for display purose. These changes are not to be saved. but when i jump on any other record in master, messagebox appears informing that the view contains uncommitted records.
i wan to avoid ths messagebox.
-
- Accessing Data from a Query
by Dohko
- 10 Replies
- Last post
by Naomi Nosonovsky
- Hi
How can I access the Freq variable
In this code
SELECT State, COUNT(*) as Freq; FROM sample; GROUP BY State; INTO CURSOR Counter
If i write
Freq it prints all 1's.
I would like to have access and be able to do Math with that column
Thanks
-
- Drop MS Outlook emails on a foxpro control and save it to a .msg ??
by LeoLems
- 3 Replies
- Last post
by dni
- Hi everyone,
I am hoping someone can help me with this one...
I am looking for a way to save a dropped MS Outlook email message to a .msg file
The drop will be on a visual foxpro control (doesn't matter wich one)
I just want the .msg file and nothing else.. But I want it in a drag & drop kind of style.
It is similair to a drop of a email message on the desktop (
-
- Adding the _msm_windo to my menu.
by Aleniko
- 9 Replies
- Last post
by Naomi Nosonovsky
- Hi all; I'm trying to add the functionality of the 'window' menu bar into my own menu. I need to let users switch between windows open. I've tried adding pad name "_msm_windo" to my menu using foxpro's menu generator. I've also tried sys(1500,"_msm_menu","_sysmenu") Both didn't work. I've used menu pads under Foxpro2.6 with no problems but this is the first time I'm t
-
- how do i disabled a mouse and esc at runtime?
by Madix_t
- 2 Replies
- Last post
by Madix_t
- good day to the experts...
i have just recently discovered this error no matter how i plug it still works...
my form has a text field for typing a message and a send button for the message to be sent to the server, but when i hold down the button key and press ESC at keyboard, it got an error message ( "execution interrupted" 'CANCEL, RETRY, IGNORE' )..which-ever i press natur
-
- Still "File is in use"
by Victor BA
- 4 Replies
- Last post
by Victor BA
- I started programming in VFP, and i'm having a bad time running forms, each time i run it can work or not, but after i stop running it and try to open the form for designing purposes or modifications, sends the message "File is in use"...everytime..
I have to close VFP an reopen it so i can use it again
I tried the CLOSE ALL command, but still when i open the project again and choo
-
- Field validation rule.
by AlexBB
- 13 Replies
- Last post
by CetinBasoz
- With my new approach to VFP DBs trying to retrieve data into .NET via OleDb I am facing a few issues I previously ignored. I need to set validation rules for some character fields. The only reqirement is that there should be no blank fields.
I used the VFP Management studio Table Designer. I tried a few clauses I thought would make sense but they all failed. MSDN does not give any examples
-
- do form and wait
by VFPNewbie
- 6 Replies
- Last post
by AndyKr
- I have a program that scans through a table and when it hits a condition will call a form. The problem is that it runs the form and then continues scanning when I need it to wait for the user to complete the form before moving on. I'm calling it with the DO FORM method and can't find anything on it, please help.
-
- Combo Value
by Ahsan Amin
- 6 Replies
- Last post
by CetinBasoz
- I have to compare a db value with the values/listitems of the combo box control. When found it shoudl be selected. At the time i am tying with this
thisform.cboCourse.Value = a_Courses.CourseName
does not work
-
- How to copy one column to another
by gdtrfb
- 4 Replies
- Last post
by CetinBasoz
- Hi all,
I would like to copy a column that has prices (fprice) for parts in it to another column within the same table. Then I am going to do a replace on the original column (fprice) to increase the price by a fixed amount (I know how to do that). The table has a column that is not used for anything (by us) within the application. It is a User Character 3 field (fcu
-
- Textbox value does not seem to change
by Hans L
- 13 Replies
- Last post
by Naomi Nosonovsky
- I am in a form which shows, i.a., an address and a billing address (in textboxes; record A). I skip down a few records (to record F), and the "skip" buttons (Previous, Next) have ThisForm.Refresh in them. So I figured that the textbox Value property would be updated. And the address textbox surely shows the correct address from record F. But, when I click on a checkbox that moves the add
-
- Dot matrix printers with Visual Foxpro
by Farhat Fakih
- 14 Replies
- Last post
by Lakshmi N
- Hello all,
We are in the process of converting an old Foxpro 2.6 (DOS) software into VFP, the problem that we face is that the printing is very slow on dot-matrix printers We cannot shift to laser printer as the stationery is pre-printed and has to be multi-part.
Can anybody offer the solution
Thanks in advance
-
- How to check if a local printer is shared in VFP at runtime.
by ControlNode
- 11 Replies
- Last post
by ControlNode
- I'm looking for a way of determining if a local printer is shared. I've looked into APRINTERS(), ENUMPRINTERCONNECTIONS of WSCRIPT.NETWORK and a couple other places/things and not found a way of doing this. I know there has to be a way of checking, but again time limits are preventing me from looking for an extended period for a fix and again I turn to asking.
-
- RLOCK on a DBF file on a Windows Vista Shaded Folder
by Stefano Alderotti
- 13 Replies
- Last post
by dni
- Hi,
I have problems on some functions [at first RLOCK()] when i try to access on a DBF file on a Vista Shared Folder from another Vista PC.
If I try to access or execute Rlock() function, from XP on Vista or from Vista to XP, i have no problems.
When i try to execute Rlock() on this file from Vista i have an "Error Reading File" only when another used already use this file.
-
- Textbox value does not seem to change
by Hans L
- 13 Replies
- Last post
by Naomi Nosonovsky
- I am in a form which shows, i.a., an address and a billing address (in textboxes; record A). I skip down a few records (to record F), and the "skip" buttons (Previous, Next) have ThisForm.Refresh in them. So I figured that the textbox Value property would be updated. And the address textbox surely shows the correct address from record F. But, when I click on a checkbox that moves the add
-
- field number
by Mochalatte
- 3 Replies
- Last post
by Tamar E. Granor
- Hello,
How can I return the field number to a variable This sounds easy, but I can't figure out how to do it. For example, I want to write some code that says something like "look through columns 10 through 20 and if the value matches column 1 then return the column number of the match". Any help is greatly appreciated. Thanks!
-
- Summary band in reports - VFP9
by Aleniko
- 5 Replies
- Last post
by Aleniko
- I am trying to add a 'disclaimer' at the bottom of invoices. The thing is that the disclaimer should always print at the bottom of the last page. If the last page has only one item, the disclaimer should still print all the way at the bottom. The disclaimer is not a single line but a bunch of lines, and it may change. I've added it to the summary band and I've tried to set the 'field position' to
-
- MS Access importing visual foxpro tables
by Dave Mosby
- 14 Replies
- Last post
by Dave Mosby
- Win XP Pro - Access 2003 - current ODBC driver for VFP
Set up an ODBC connection via control panel/admin services using a free table directory
- the target directory has many dbf files that are visible in the "browse" window -
- I then try to use the Access link table "wizard" - choose ODBC connection -
- select the ODBC link I created -
- the "wizard&qu
-
- Validations on Textbox
by Ahsan Amin
- 14 Replies
- Last post
by Phil Brammer
- I am trying to implement validation on textboxes placed on a form using ISNull function. I placed the code in a procedure and calling it on the click event of a button but does not work. I want also want to check for numeric and character data. here is my code
IF ISNULL(thisform.text2.Value) then MESSAGEBOX("Please enter customer name") ENDIF