Recent content by VRoscioli

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

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...

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

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...

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

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

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...

Have you considered the LostFocus event? -V

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

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

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

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

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

Be sure you have NumLock enabled. -V

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