Search results for query: *

I have a custom menu for an application (VFP6). At one point I pull up at text file with the modify file noedit command. I've added a print menu option under the custom menu's File option and used Bar # and _MFI_SYSPRINT. I can compile the program and execute it while I am still in VFP and...

I'm trying to move an outlook folder with custom forms to another computer. I have a .pst file created for that folder - how do I get it to show up in other systems outlook. We are not running Exchange Server - I'm just trying to get the custom forms developed available to others. Judy Scofield

I have a client who wants users on his network to share outlook items, so they can both access the same calendar, for example. They do not have exchange server - can this be accomplished with two workstations and Outlook? Judy Scofield

I have asked this before and got no response, so maybe this is worded better. I'm trying to set the font attribute of a control in a datareport in code based on user input. If I code, for example, drReport1.Sections("Section1").Controls("Text1").Font.Bold = True it sets...

I'm working on a datareport. The user can select Font attributes for particular fields before the report is run. I'm getting an all or nothing result on the output. When I setup the report, I change the attribute when I initialize the report, moving through each of the controls to see what...

If i have 15 text boxes on my report, is there a way to refer to them one a time with the help of an array? Is there a control array? If they were called Data1 through Data15 for example, could I do a loop throught to set a property based on some criteria set in code elsewhere? Judy Scofield

I'd like to insert into a table from another table, but include a sequence number that increments by one for each inserted record. The sequence number does not exist in the old table. How do I code this. Ideally, {'d like the sequence number to restart each time another value changes. Judy...

I have a datacombo box on a form called dacrules. When stepping through my code, I can see the .selecteditem property. For example it may show 2. I want to set it to, say, 3. When I code dacrules.selecteditem = 3 I get an error, Object Required. What's wrong with my code?? Thanks...

I have a data grid bound to a sql table. If the field length of one of the fields is 25, how do I limit the input in the grid to 25 characters? Judy

I have a VB6 program using SQL2000. I have a screen with a datagrid showing some fields of all records in a table and a detail section at the bottom with a command button to add a new record. This has worked fine until now. I've added a rowguid column with a default value. When I do an...

I've been asked to add a routine in an existing application that searches for a file on the user's machine, then edit that file if it is found. It happens to be an ini file. I know that locfile() finds a file, but only searches in the paths set in set path. How can I search for a file if I...

I want to execute a refresh on a form from code in a subform. What is the syntax for referring to a parent form. The subform appears on two different parent forms, so I can't hardcode the refresh statement. Thanks Judy Scofield

I'm trying to open a recordset in VB against a SQL Server Database. The criteria field is a datetime field in the table. I'm testing with two records, one with a date of 12/20/2002 and the other 1/10/2003. A date is entered in a maskedit box on a form. If I enter the value 01/01/2003 as the...

I have a subreport that is formatted in two columns, down first. I need to keep the records in a limited amount of space, so I limit the number of records selected. The report keeps printing the records down, overlaying the next section of the report. How to I get it to move to the second...

Two things. I need to fill other fields in a tablewith values from a table used in a datacombo box besides the bound field. How to I move to the selected record in the datacombo source table to capture those other fields and move the values into my main table. Also, the other fields displayed...

I have a datacombobox based on a recordset and linked to a field in another recordset. When I drop down and make a seletion, then tab, it stores the proper value in the second recordset, but the display in the combo box goes blank. If I return to the record later, the value in the second...

I have a data combo box based on a SQL statement that is a command in my data environment. It is set to update a field in another recordset. The combo box lists the choices fine, and updates the appropriate field, but when I tab away from the combo box the choice disappears. I would like it...

How do I change the tab order of ojects on a form? The help screens say to use the layout menu, but I don't see a layout menu anywhere on the screen.

I'm getting a 'String or Binary Data Would be Truncated' error when running my code. I have an .addnew command, then fill some fields, and then an .update command. I've tried putting values into the fields that I know are smaller than the field lengths. Other posts have advised to add SET...

I'm in the click event of a command button. I'm trying to insert a record into a table, so I've got: Dim dbs As Database Set dbs = CurrentDb Dim txtFileName as String txtFileName = "ABC.txt" dbs.Execute " INSERT INTO AFCARSCombine (FileName) VALUES...