Search results for query: *

Hello, I am working on developing a utility that imports two spreadsheets into two tables and runs a series of queries to compare the two in order to find any changes or new records. Each spreadsheet/table is identical in structure. They are a list of orders that get sent to us by our primary...

Hello, The business I work for maintains hundreds of documents that all have links in them linking to various other documents on our file server. A while back, we had some issues with Excel breaking the hyperlinks, but we fixed that (or so we thought) by using the Hyperlink() function directly...

Hello, I have come across an odd issue that I cannot figure out how to fix. Hoping someone here can help me out. I got a request earlier to add a couple of fields to an export query in one of our access databases. Easy request, figured it'd take a couple minutes tops. Most of our programs are...

I am working on designing a database to manage tool calibrations. This task was previously handled by a very unwieldy spreadsheet. I have created a master table for the tool data and a linked table to store calibration data for each tool. This is a one-to-many setup. This all works fine for...

We have a large spreadsheet here at work with lots of hyperlinks to files on our network. For some reason, on one particular computer, when the user clicks a hyperlink, it opens the related file as read only. On other users computers, it doesn't. I've already checked the security permissions on...

We maintain a massive spreadsheet that has hundreds, if not thousands, of links to files all around our server document tree. It crashed during loading this morning, and it broke all of the links. They now all refer to a C:\users\... type link. Something like this happened once before, and I was...

I've written code like this quite a few times, but all of a sudden this code is throwing an error message. The error message is this: Run-time error '-2147217900 (80040x14)': Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. The code generating this is as...

Hello, One of the employees here has recently taken over maintaining a spreadsheet that has a bit of an odd problem. There are three rows that have missing row labels. The numbers go like this: 24 25 (blank) (blank) (blank) 29 Also, none of the data in those three rows is visible. It shows up...

I am trying to write a bit of error proofing code in one of our databases. We receive a spreadsheet regularly from our primary customer that we import into a table and run various reports on. One of the fields on their spreadsheet is "Purch#Doc#". Part of my error proofing is to run an SQL...

Hello all, Is there any way to use the ALTER TABLE/DROP COLUMN combo to drop a column by reference number? For instance, can I instead "drop the first column" rather than "drop column XYZ"? If there are any other ways to do this besides the SQL statement, then that's fine too. What is going on...

I have been working on setting up a new computer for one of the people in our office. I've gone through this process a hundred other times with no problems, and I can not for the life of me figure out what is going wrong this time. We use Outlook 2002 as our email client. We have a pretty...

I have a form which lists labor ticket transactions (clock in time, clock out time, etc) for our employees. I have added a button in the continuous form which updates the employees efficiency to 90% for the day. However, whenever I try to click the button, it always runs the query for the first...

I have a user who has outlook XP installed. Had some issues with his outlook so I recreated his user profile. That got outlook working again. I recreated his accounts and pointed it to his old .pst file. Outlook loads the folder tree he had set up, but doesn't show any of his emails. Anyone have...

Several months ago I was promoted and given charge of the IT department here at work. I have been slowly but surely getting things organized and straightened out. We have quite a few copies of Office XP laying around, all authentic. I am pretty sure that not all of them have been installed, and...

I have recently taken over the IT duties here at work. Our network spans across a 90,000sf facility that is split between two physical locations. Everything has been thrown together in a relatively haphazard way, with switches here, hubs there, cables through random holes in the walls, all sorts...

I recently spent quite a chunk of money upgrading the RAM in a lot of computers on our network. Everything went smoothly on every box except one. Box Specs: Dell Dimension DIMC521 Athlon 64 x2 Dual Core 3600+ Running XP Pro SP2, automatic updates enabled. I bought 2 1 gig sticks of 800mhz...

We have a database that we have been using for several years now that generates a simple report of what we are shipping that day for a certain customer. This is exported to an .rtf file and emailed to our customer as well as several of the managers here. However, one of our managers hasn't been...

Quite a few of the applications I have developed over time are used in a multi user environment, quite often with multiple users logged in and using the database at once. This can be rather annoying when I need to make a quick change to something in the DB. Access warns me that I do not have...

I have a function that I wrote that takes a clock in time and a clock out time as paramaters and is supposed to return the amount of break time that is allowed between those two times. That function, while tricky, is done, I think. However, I need to test it thoroughly. I decided to write a...

I know this must be possible, but I am drawing a blank on how to go about it. I have an employees table that, along with other data, contains what shift and team they are on. The shift is just a 1, 2 or 3, while the team code is something like "QT", "DT", etc. I also have a report that is a...