Search results for query: *

In VFP 7, I how do I check for the existence of a cursor called curEditlist and then reinitialize it? Thanks.

In VFP 7, I have a spinner control that will only let the user enter a 1 digit number but not a 2 digit number as it should. Using the spinner buttons works fine. There is only a problem when keying 2 digits manually. Format: RK Input Mask: 99 Increment: 1.00 keyboardhighvalue = 31...

In VFP 7, a user reports that on a spinner control when he tries to manually key in a 2 digit number, the spinner displays a decimal. I can not reproduce the problem as when I try to manually key in 2 digits it will only accept 1 number(but should allow 2 digit entry). The KeyboardLowValue...

In VFP7, how do I add a property to an existing object called oFormData?

In VFP 7, I have a combo box where: boundcolumn = 2 columnlines = .F. DisplayValue = Dealer name = cboPayeeType rowsource = Dealer,D,Manufacturer,M,Distributor,R rowsourcetype = 1 - Value I want Dealer/ D to be the default value but it is currently blank on the screen even though displayvalue...

In VFP 7, I have a combo box called cboAcPayeeType. In the valid event I have the following code. When it tries to execute the first CASE statement, it bombs and says: Property TEXT is not found. There is a value in display in the combo box on the screen. Any ideas why it does not recognize...

I have VFP 7 with an Oracle database. In the following scenario, how can I set Mytable1.field1 as the default value for MySpinnerControl? Mytable1.field1 MySpinnerControl

In VFP 7, I have a program spec that says if the spinner control on the form doesn't contain valid data to reset the control's value to it's previous value and setfocus to the control. VFP does not allow you to call setfocus() from the VALID event. Any idea how I can set the focus? Thanks.

In VFP 7, I have the following spinner control with an initial value of 31. When I change the value manually to a different number say 25 and access the value property of the control in the Save button click event, the value still shows 31. THISFORM.BCPageFrame1.Page1.SPnBillDayNbr Any idea...

I inherited a project that has "quick start" enabled. How do I disable or turn off this option? Thanks, -Russ

Most of the visual development experience I have is Access. I have a newbie type vfp question. I've inherited a project that has a radio button group of report names (the user wants this format). I need to create an OK button to check which radio button (report) was selected and print the...

Any idea why I'm getting a syntax error on this statement? Thanks for you help, -Russ Forms!casedatabaseform![Child215]!Model.RowSource = "SELECT edge_model_no, lowes_sku, description, edge_item_number,AVG_PRICE " & _ "FROM ITEM_MASTER_VIEW " & _ "WHERE [CUSTOMER_NUMBER] = " &...

I'm getting runtime error '2465' Claims Main Menu can't find the field '|' referred to in your expression. The first DoCmd is highlighted. Any idea what's causing this? Thanks for your help. Private Sub Delete_Click() On Error GoTo Err_Delete_Click DoCmd.DoMenuItem acFormBar...

I get a compiler error expected: expression when executing this dlookup statement. Any idea why? Thanks for your help, -Russ ? = DLookup("[avgprice]", "LOWESAVERAGECOSTWITHLABORVIEW", "[edge_model_no] = '" & [Forms]![customer_claims_detail subfrom]![model] & "'")

I'm getting the following error: The expression On Open you entered as the event property setting produced the following error: Label not defined. Any idea what's causing this? Thanks, Russ Private Sub Form_Open(Cancel As Integer) Application.SetOption "ShowWindowsInTaskBar", False...

I have a text control "Text922" that is located on tab control tabctl1 page index 0. I added a new page (index 6) and now the "text922" from page 0 is showing up on the newly inserted page 6 as well. I'm using Access 2003. How do I resolve this? Thanks for your help. -Russ

I have a form and I want to update an existing record if onc exists or add a new record if the primary key doesn't exist. Currently when I save the form, it tries to add a new record and gives me a primary constraint violation on the primary key instead of updating the existing record. I have...

I have a continuous form and am trying to show different controls based on the model_no of the current form. Of the 4 forms (detail records) currently on screen, 1 record has a model_no of 601 and the txtGroutSerialNo control should be visible and the txtMFGDate control should be invisible...

How does one activate the delete menu option for a table? I have Access 2003 with a SQL Server 2000 back end.

I have a hyperlink (FrontPage 98) pointing to Lunch_Menus/menusfeb05.htm It is an Excel spreadsheet containing 2 worksheets saved as html. It works fine locally but when I upload it on the server and click the link it generates an error saying it can't find...