Search results for query: *

Hi All, I have a form that has a mshflexgrid with data populated from ms access database. A combobox with client names populated from my access database during form load. All is working fine here. My problem is: 1) to set the focus of the cursor to the record selected from the combobox and 2)...

Dear All, I have written a database for student profiles and encountered a problem when using mshflexgrid control. I have successfully populated the mshflexgrid control with records from my access database, put one imagebox in the same form where the mshflexgrid is. What I want is when the...

Thanks all for your support. With the tip from all of you I managed to have it done and all is working fine.this is the code that i used. In a separate command I created a procedure that would be used after wards in my main program.This the code: PROCEDURE getconfig gcDatabaseDir = ""...

Hi all, I am currently creating a database and have 2 folders. A production folder and real data storage folder and would like to switch between these folders to access tables to test my project and also store real data. I have created a file called config.cfg in notepad and stored that in the...

Hi all. I have a table which has 20 000 plus records and want to insert values from 1-50 to records which I filter which meets certain conditions.For instance,I want the first record to have value 1,next 2,3 up to 50 in the column name "rowno" given certain conditions. I assume a DO...

Hi All, Thank you for the reply.Maybe I was not too clear.I am sorry. I tried as Mike has mentioned but I think will work well if there are no conditional statements added in the methods but I have,in the first method, included a DO CASE..ENDCASE statement. The second method should execute only...

Hi all, I have written 2 new methods for a form and put them on the same code.I want the second method to execute after the first when the first method completes execution.I know there is a way but couldn't have them work as I expect.Any help would greatly be appreciated.Thankyou in advance.

I have a database which got corrupted.when I tried opening the database, i am presented with this message "Table 'database_name' has become corrupted.the table will need to be repaired before using again". when i tried opening an individual table i am asked to either locate the database or...

I have mistakenly deleted a table from the disk and I couldn't view the table again but the table has a .bak file.Is it possible for me to retrieve the records from the bak file. Your advice will highly be appreciated and thank you in advance.

I have developed an application and is working well.however I have a problem.and that is when i click on the application icon there are two window appearing.one is my own main form which i have set as main with its own menu items and the other is the default vfpro window.below is my main code...

I'm sorry for not making my problem clear to you. What I meant was this,I want double entries to be done for the questionairre forms.there will be two data entry clerks. one will do the first entry of forms and another will do the second entry of the same forms.so that means there will be two...

I have created a menu in a project and want to generate it from the main menu MENU but the generate from the drop down sub menu is grayed out/disenabled. I placed the cursor in my menu item and tried generating it but encountered it. I am not sure where I have gone wrong.Should anyone help me...

I have a sign in and sign out records sheet which I would like subtract to find out how long my staff worked each day. The sign in time is 7:45 am and sign out time is 4:06 pm (which is exactly 8 hours and 21 minutes).However,people sign in and sign out in different times.Some sample data are...

I have an existing table with data and wish to update some fields with new values.So I created a form and add text controls respective to each fields.I want the existing values respective to each fields to populate each controls that are uniquely identified by their 'id'.(ie the id is the unique...

Is there a function in visual foxpro that can be used to get the figures after a decimal point in a numerical field. INT() function obviously is for picking up numbers before a decimal point in a numerical field for example 389.9938.If INT() is used, 389 will be shown but how about the numbers...

Thankyou all for help.The INT() function you have pointed out is very helpful in my situation.Thankyou once again for your support. Yanx

I have created a numeric field(expense (N6.2)) to hold data that involves money both in dollars and cents(like: $234.70).However the requirement is to separate them into their respective fields,like "234" in another field and "70" in another field. I already converted the numeric field(namely...

I am writing a check to ensure that the age of the participant of a clinical study is consistent with the date of birth(DOB) and the enrolment date(ENROLDATE).I tried using substr() to get the year portion of DOB and substract it from the year portion of ENROLDATE but it is not working.This is...

I have created a php form and addaded a text box(name="preidno") to enter id numbers and would like to let data entered to be only numbers. Could anyone help me with this problem please since I am new to php programming? Thankyou in advance.