Recent content by Lotruth

A friend of mine is having a problem where when he tries to type the @ sign, his computer types 2 colons. He can type the number 2 and no other keys are malfunctioning. What could this be? The computer and keyboard were purchased brand new 2 weeks ago.

I dont believe this is possible. Guess I will have to look for a work around. Thanks.

Is there anyway to do this?

Thanks. It's 5:00. I'm going to my other job now.

No, like this Line Table LineID Description 26 John Doe Budget Table ItemID LineID Amount CostcenterID TransactionID 11 26 $20,000 27 28 Personnel and Salary are just the headings of the columns in excel file. They correspond to description & amount in the database.

The budgets table is a collection of IDs that link lineID, CostcenterID, and TransactionID with a primary key field of ItemID. In the lines table, the primary key called LineID is 26 and the description of that line item is John Doe. In the budgets table, the primary key called itemID is 11...

Ok, here's the excel file A B 1 Personnel Salary 2 John Doe $B2 3 Jane Doe $B3 4 Total $B2+B3 Here is the database ItemID Amount 11 $20,000 22 $30,000 What I need to do is put the amount of itemID 11 ($20,000) into cell B2. Currently, I do this by navigating...

It would be nice if I could send you the files, but I think you understand the sensitivity of financial data. Beyond that, I dont know how to present the issue in a way that you can understand. I think I will go in a different direction. Thank you for the time you invested in trying to help.

In access, we have a lot of data separated into tables. We have to put this data into preformatted excel workbooks that dont have the same layout as the access tables.

I am trying to populate an excel file with budget data that is stored in access. The structure is different, otherwise I would just put the would database table there. I am not sure what you mean by the data range.

Thanks, That is what I meant my link. I query the table by going through all the clicks from data/import external data/new database query/selecting database type/selecting database/selecting table/selecting fields/etc... I am trying to avoid doing all of this for each cell.

It is too much to ask to start from scratch with my questions here on the forum, so I am asking for a good intro reference or tutorial that someone may have run into online. I do have one question though. I am able to link one cell at a time using Data/Import, however, I was wondering if there...

I replied on Thu, 31 Mar 2005 14:51:37 -0800 (PST) I will forward it to you. Thanks.

Here is the soultion I am currently using. I use windows task scheduler to open the browser every hour with the page needed set as home. Then the screen capture tool copies the page into a jpg. This works wonderfully except of one flaw. I cannot get TS to close the browser after the screen...

Works wonderfully except of one flaw. I cannot get TS to close the browser after the screen capture. When I try, it terminates the task altogether so that it does not run on the next hour. Currently, it opens a new browser window every time and this works perfectly as far as the screen capture...