Hi all, I seem to be having a brain fart as I can't figure my way around this without using a series of update queries. I know there has to be a better way. Here's the scenario:
I have a customer that needs an order number for invoicing purposes. They issue blanket orders once per month and...
I have a flat file, 52 lines long, that needs imported into my database as a workable file. There will be multiple text files of varying length - this is an EDI 204 and we receive a couple hundred per day. I was able to create the outbound EDI using a file parsing program. The problem is the...
I have a mixed OS environment - Win2K and XP pro & home edition. I have a runtime app with a frontend/backend setup. I have a search form where a user enters data in field1 of the main form and the subform, linked on field1, pulls the appropriate data. Of the 10 users, one get's a white screen...
I have a continuous form in 03 version. Based on the value of bound check boxes, 2 fields will have formatting set using conditional format. When this is run on my development system, the continuous form works flawlessly. When I distribute to runtime machines, the continuous form constantly...
W2k server - dedicated VPN
Test machine WinXP pro
VPN setup according to wizard and Microsoft docs
2 network cards, 1 attached to local network, 1 attached to hub that is directly attached to WAN rounter. I changed the default Routing and remote access Input/Output filters temporarily to allow...
Is it possible, using a front end/back end setup, to allow users to customize a form with a subform that's in datasheet format? Let's say a user opens the form the first time and takes the time to arrange all the columns in the subform the way they like it, which is not quite the way I like it...
Hi, I have an unbound form comprised of at least 7 subforms but only 2 are visible.
This is for timesheet data where a time shouldn't exceed 60 hours over 7 days or 70 hours over 8 days(trucking operation)
Data is pulled from these based on data entered in subfrm1. Subfrm2 shows data for the...
I have a subform (details) in a main form (header). The detail form is in datasheet view. My users want the ability to input data in the detail form & when they press Enter from any field it should add a new record. I have the code that will trap the Enter key and go to a new record in the...
I have a subform (datasheet view) on an unbound main form with combo boxes & command buttons. The subform has to be in datasheet for my picky users, but there has to be command buttons & unbound fields to update data that's why the main form is unbound, basically to act as the datasheet's form...
Is it possible to write code to create a table with the database object names & description dumped into it? 2 fields - Name and Type - run the code to populate the table with "Table" & tablename, "Form" & formname etc. Any help would be appreciated.
I have a database in a multiuser environment, some use Terminal Services to access the database. The main table is cleaned out each time billing is run to keep the record count low. However, on occaision a record becomes corrupted & chinese characters & blocks show up as record values on forms...
Hi all. I'm relatively new to VFP7 & am converting old 2.6a code. Was wondering if it would be possible to take a main form with command buttons, pass parameters to those buttons & save the old values so when the user exits the routine, the buttons are reset to their original values. I have...
Please help! I'm looking for a way to create a dynamic button bar. The code is old 2.6 calling a browse window or calling @...say, @...get screens. The code pushes do statements onto function keys. I need a way to create a button bar that will allow me to pass parameters to it from the prg...
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.