Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. VRoscioli

    Want to place a 0.00 amount for a field that does not have a value

    You will want to use what is called an "outer join" (Google this). I can't tell exactly which tables you want to use this on, as the labels you used in your description do not match anything from the query. -V
  2. VRoscioli

    Importing .csv file into Access 2007, Numbers Rounding Automatically

    It is possible that the data is not being imported correctly and the field is being filled with the "Default Value" (which is 0 by default). Are all values "rounding" to zero or are they rounding to other integers as well? If they are rounding to other integers, make sure that the decimal...
  3. VRoscioli

    Compare Two XML Schemas

    I am looking for a library within Java that would allow me to read in two XML schemas (via XSD files) and decide whether they are equivalent, up to changes to whitespace or reordering of child nodes. Does anybody know of any such utilities? Thanks. -V
  4. VRoscioli

    Comparing Interfaces via IDL

    I have a situation in an application where I want to see if two interfaces are compatible (that is, have the same methods, fields, but possibly defined in a different order) by looking only at the IDL files for these interfaces. Is this possible, and if so, is there a utility to do so within...
  5. VRoscioli

    Form Locked in Access

    I did check this when it occurred and it was not the case; no LDB file existed. -V
  6. VRoscioli

    Form Locked in Access

    Update: I've fixed the symptom by changing the form's RecordSource to null, saving and then setting it back to the table. However, I would like to understand why this happened in the first place rather than just treat the symptom whenever it happens. Does anyone have any ideas? -V
  7. VRoscioli

    Form Locked in Access

    I've designed a database in Access 2000. It has been working fine for the past two weeks. However, this morning when the database was opened, one of the forms seemed somehow locked. No data could be updated within the form. No new records could be added using the form. The form has a table as...
  8. VRoscioli

    AfterUpdate event does not fire when combobox is cleared...

    Have you considered the LostFocus event? -V
  9. VRoscioli

    Returning specific value for null

    You could try making a change to: IIf(Nz(tbl_AllSLMastr!Town,"")="" ,"Unknown",tbl_AllSLMastr!Town) AS TOWN -V
  10. VRoscioli

    Reporting question

    It may not cause problems, per se, but normalized tables such as Remou's will be easier to extract data from. You should be able to normalize your data with a UNION query. A slightly modified version of a query found here could help: thread703-1394788 -V
  11. VRoscioli

    hasta mañana

    Er... wow... not sure how I managed to typo that TWICE haha. Yes, the alt key, not the shift key. Thanks, Greg -V
  12. VRoscioli

    Create Excel Application by VBA

    You need to put: ... End With Exit Sub Error Handler: ... -V
  13. VRoscioli

    Sum three fields "on the fly" & place results on form

    Create a textbox, label, etc. and set its ContorlSource property to =[Field1]+[Field2]+[Field3] -V
  14. VRoscioli

    hasta mañana

    Be sure you have NumLock enabled. -V
  15. VRoscioli

    export data to multple work pages

    I suggest disabling your error handler and seeing what error is being thrown, if any. -V
  16. VRoscioli

    hasta mañana

    AS you can see from http://www.goascii.com , the ñ character has ANSI code 241. If you are on a PC, you can create this character by holding down the shift key and typing 0241 on the numeric keypad and then releasing the shift key. This can be done for any ASCII or ANSI character. -V
  17. VRoscioli

    Loop through List

    You use three different list boxes in your code but only indicate one list box in your explanation. Please be more clear. -V
  18. VRoscioli

    Aligned text on right in list box?

    You are looking for the Text Align property of the text box. It is on the Format tab in the Properties Window. -V
  19. VRoscioli

    Combo Box, Subform, Text Box - Relationships/Filter

    And the control source for the text box. -V
  20. VRoscioli

    Combo Box, Subform, Text Box - Relationships/Filter

    What do you currently have set as the sources, etc. for the form, subform, and textbox? -V

Part and Inventory Search

Back
Top