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

Just wanted to let you know this approach works perfectly. It now behaves exactly as desired across all records. Thank you so much! Brooks Tilson Database Development Tilson Machine, Inc.

Thank you both very much! The form and subform record sources are indeed queries, so I will try this approach. Brooks Tilson Database Development Tilson Machine, Inc.

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

CJTyo and everyone else, I haven't found a solution to this problem, but I DID figure out how to make the backup copies work correctly. For whatever reason, they have to be in the same location as the original corrupt file for the hyperlinks to work. Initially, I was copying the file to my...

Something like this should work, although it may need to be tweaked slightly to fit your needs. =IF(C1=111,IF(D1>50,RANDBETWEEN(40,49))) This is written assuming your data starts in cell A1. Take this same line and modify the values to get your second request. Hope that helps! Brooks Tilson...

Well, I found and ran the repair, but it made no difference whatsoever. I am utterly mystified as to why this is happening. We maintain "versioned" backups as well, and I pull a copy of this document from over a month ago, just out of curiosity, and when I opened it, the links were broken. Not...

Unfortunately, from what I can tell, the office diagnostics was removed in 2010 (the version we have). If I am wrong, please feel free to correct me though! Brooks Tilson Database Development Tilson Machine, Inc.

Skip, I alone am our "database development group", but this spreadsheet was created entirely without my input and has been in use for years. The links aren't query references or cell references, but literal hyperlinks to other files. Sometimes they're excel docs, but most of the time, they're...

No luck. It did the exact same thing. I used the VBA code that MakeItSo suggested. Brooks Tilson Database Development Tilson Machine, Inc.

We do indeed have more backups. Going to go dig into that now and see what I can make happen. Thanks for all the help! Will update with how it goes. Brooks Tilson Database Development Tilson Machine, Inc.

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

Thanks everyone! I just took the space out of the name and it fixed it right up. Brooks Tilson Database Development Tilson Machine, Inc.

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

I have no idea, as I just went to check it out and the guy had just deleted the rows entirely and remade them (even though I specifically asked him not to). So I really don't have anywhere to go from here regarding this. I appreciate your efforts though, and apologize for wasting your time...

Hello, yes I did indeed check the font color, formatting, so on and so forth. Thanks for the suggestion though. Any other ideas? Brooks Tilson Database Development Tilson Machine, Inc.

Sorry, forgot to mention, we are using Office 2010 Professional. Thanks! Brooks Tilson Database Development Tilson Machine, Inc.