Search results for query: *

Thanks Rick: I thought it might not be a piece-of-cake. One other option that I was considering was the entering of remote data in a denormalized form. In other words, making one big table containing all of the data. By doing so, I could simply append a demormalized central database. Then...

Hello: I was wondering if anyone has any experience using laptops to append the main database. I have a group of field biologists that are presently recording thier observations on paper and later (back at HQ) inputing the data. They are recording the movements of tagged animals. The...

The IDs are in a text field -- 160 chars long. They are delilmited haphazardly: some by spaces (203 909 234) or by commas (203, 909, 234) or by dashes (203-909-234) with a number of other variations (#203, #909, #234) and a number of punctuation errors (203 ,909 ,234). There is also military...

I have a rather large table that has ID numbers in a comment field. Some comment fields can have up to 20 ID numbers. Of course, I wnat to feather the ID numbers from the comment field creating a separate row for each ID. Fortunately, the ID's are mostly integers -- so I think that I could...

I may not understand the question, but it seems that workOrder and partNumber should be in separate tables. The workOrder table would contain date, worker, etc. and the partNumber table would contain part number, manufacturer, etc.. By creating a third table for association (workOrderPart) you...

I have a number of XY (Scatter) Chart.&nbsp;&nbsp;I use the charts to plot movements of individuals.&nbsp;&nbsp;The X and Y values are coordinates of a grid.&nbsp;&nbsp;I have the chart divided into 10 major divisions, each division being labeled.<br><br>My problem is this.&nbsp;&nbsp;The values...

The only good reason to lump fields together would be to create a unique record identifier (like last name and the last 4 digits of the telephone number).&nbsp;&nbsp;You might want to think in terms of normalization by creating related tables based on one-to-many relationships.&nbsp;&nbsp;The...

If you are using an ADODC connection JET 3.51 will not work with Access 2000.&nbsp;&nbsp;Change the Provider to JET 4.0.&nbsp;&nbsp;Maybe this code will help:<br><br>&nbsp;Option Explicit<br>' Be sure to set a reference to the Microsoft ActiveX Data<br>' Objects 2.0 Library.<br>Private rst As...

Hi:<br>I am having a heck of a time getting a scatter chart to work using MSChart.&nbsp;&nbsp;All I want to do is chart map coordinates (the X value is East and the Y value is North).&nbsp;&nbsp;I have created an ADODC connection with Jet 4.0 to a table in an Access 2000 DB.&nbsp;&nbsp;Cols in...