Mike D

Hey,

I have an access DB that runs reports on a data dump from a web-app. The extract from the web-app comes as an xls file with a few lines above the heading row that need to be deleted from the sheet before importing in access. is there a way to do this in access rather than having to open excel and delete manually the rows that arent needed?

hey all,

I am writing a game, Guess Who, in VB.net that i want to be multiplayer over a LAN. I need a guide (or some guidance) on how to program sockets in a way that i can send simple objects back and forth between 2 clients. What is the easiest way to do this? Or can you point me in the right direction?

THANKS!

Hi

I need to write a cryptography program in java that sorts the output or a character count analysis. I have a 2 column, 26 row array that has an index and a count in the form:

int[][] counts = new int[2][26]

so counts[index][count]

I need to sort the array by count ascending. How can i sort a 2 dimensional array? What is the easiest way?

Else, maybe you can help me simplify. I count the occurrences of all the letters in a string, which are all uppercase. i place this count into the array at counts[char ascii value - 65][x]

then i need to sort it ascending

thanks!

Ok i have an access database that is used to run reports off extracts from excel. I import the extracts from the main db, and run macros in access on them to fill tables. I am getting data type conversion errors on a text field that holds a number because there are accidental letters in the field on some records. the excel sheet and the access database are set up for those fields to be text anyway, so why is access thinking they are all supposed to be numbers? any ideas?

hey all

I just got a macbook to go with my imac g4. Now i want to set them up to work together as seemlessly as possible. Here are some things i want

1) Share my external drive from my imac to the macbook. i have already acomplished this by setting up SMB and softlinking the volume into my home directory. is there a more elegant way of this?

2) use the same itunes library, located on the external drive.

3) keep some folder synced

any ideas?

Ive been having issues with Yahoo's domain service. Basically, i changed my nameservers to use my own host rather than Yahoo, and i also set up my MX records and a CNAME to use Google Apps with my domain. I just called yahoo small business again, and i got the runaround. i am being told the following

- I am told that If i change my nameservers to point to anywhere but yahoo, (such as ns1.8tt.org), any changes i make to the MX records and CNAMES through Yahoo will not work.

- The supervisor told me that they lose the ability to update and control my DNS records when i use a host other than Yahoo.

- They told me i need to contact my HOST and have them set up the DNS for me.

Now it was my understanding that I could point my nameservers to any host, and still control my DNS through the registrar. Am i wrong, or is this just a complete load of crap? I know that in the past i have done this exact thing with other registrars with no trouble whatsoever

i have a database of research information that i have gathered and formatted in a way that "should" support searching the database fields to count the number of times an issue comes up.

The research is based on web pages, so for example i have entered into the DB each occurrence of a PDF link on a page not having a "warning link" with NWL: blahblahblah. Now my first question is, is this the best way to do this? Basically there are many issues that can be wrong with a page, i have separated those issues into 4 categories which are now text fields that i enter the data into. I figured if i tagged them with identifiers, i could pull out the info later.

Now for my query. Assuming what i described above is logical, then a simple query should work. However, i do not know the syntax for Jet, so how would i do something along these lines?

SELECT

FROM

WHERE textBox CONTAINS "TAG"

Hopefully you can understand what im getting at :)

TYIA

Hey all,

Just wondering if someone can tell me how to do this. I have a bunch of Planet Earth epi's and they are xvids, i want to be able to fit a few on a dvd, so they would need to be compressed or something. Right now, toast will only put one on the dvd and its almost full for some reason. thanks

Home router > iMac > Server

I have internet on the server, shared through an ethernet cable (automatically crossed over internally - thanks mac!), but im not sure how i would alter the setup to allow me to serve to BOTH the LAN outside of the mac and the internet. Any ideas?

Ok heres my question.

I have a java assignment to read in a binary file with Pet data strings(which were written out by ObjectOutputStream, the professor notes), parse the strings which are on one line in this format

" Name: Fido Age: 5 years Weight: 10.0 pounds "

into data (int age, double weight, string name) and then find out various things such as largest smallest etc. I can read the file and get the string using readObject, and i can do the last part, but i am having trouble parsing the strings into data. How would i do this? Meaning how would i take multiple strings like the one above (undetermined number) and pull out the data from them all one by one in a while loop.

how would i do something like this (just laying out logic below, not actual code obviously)

temp = readObject

while (readobject != null)

tokenize(temp) ( int age=stok.nextToken, double weight=..... etc)

----do what i want with data---

temp.readObject

end

thanks!

Ok, i have a project i am working on where i am anylizing websites and taking down info on what is wrong with them. I need it to be searchable and to pull other info out of it, that is why i chose a DB. I have had a class in DBMS, and i believe this is an ok setup. Im not sure if it is optimal though.

2 tables, Page_t and Site_t. The Site is the main site and the pages are individual links and pages on that site. The tables are joined on SiteID, and the way it works is there are may pages per Site, so there are 2 navigations on the main form. One controls the site, and the for that site, you can change the pages. This seems to work ok, other than being a bit thrown together. I am using checkboxes to denote that there is an issue with content, usability, etc, and then memo boxes underneath to describe the problem.

Now, again, i dont know if this is the best way to do it, so i am open to suggestions.

I know i probly didnt explain this well so let me know if you need more info

Hey, i have a java lab for a entry level java class, i believe i have it partially correct but i have a feeling im going about it the wrong way. Any advanced coders want to take a stab at it? its straightforward and relatively easy. i just cant get it right. ill post my code tomorrow when i get to my terminal.

here is the PDF

http://www.megaupload.com/?d=B8KID2JO

thanks