Recent content by fastrunr

Hi - I'm trying to use the upsizing wizard. I've upsized a copy of this database before and did not have a problem. I think I"m doing it the exact same way... Anyhow, when I enter the SQL Server to use (local) and check add trusted connection, set a database name, and hit "Next", I get the...

Hmm, what is this DAO help file and how do I access it? (sorry, can you dumb that down a little?)

Anyone know a quick way to copy or export a list of fields in an Access table to Excel? I'm trying to generate a list of tables/fields in a database, but the table design view doesn't allow copy/paste. Thanks! Liz

Hi - I'm trying to export a table to a csv file (via exporting to Excel and then saving as csv), and am finding that numbers are being truncated from 15 to 9 decimal places. Any tips on preserving the decimal places? thanks, Liz PS - sorry if this one's already been covered; I searched, but...

Thanks, Skip. So I have three columns, A , B, and C. For my lookup, if there's a match in column A, I want to start the lookup in column B in the row right below that match. Does that make sense? I put an example of it below, but I'm not sure the formatting will work. Depth to water table...

Hi there, I'd like to know if it's possible to adjust my range for a vlookup using the MATCH and ADDRESS functions. Basically, I'm using MATCH to find the row where I want to start my lookup, and using ADDRESS to convert the MATCH result to a cell reference. Looks something like this...

Yeah, I think the only way to do it is to create a macro to run the function. Actually, it was "naughty by nature", but dynamic by nature could be their cover band.... Thanks, John.

Hi, I'm using the random number generator in excel and want it to calculate only once. The goal is to generate a list of 8 numbers one time using 8 instances of that function, and then to disable the function from re-calculating. I want to be able to preserve both the function in the cell and...

Ah...it never occurred to me that it could be a typo. Thanks again everyone. These tips were *exactly* what I was looking for.

Thanks! So why on the msdn site does it list the range for "y" as 1-355? What is it I'm missing?

Sorry, where do I try that - in the query somewhere? I *did* try just Format(#2004-12-31#, "y") and it works! But I'm hung up on the MsgBox part... Thanks for bearing wtih me!

hey - you're right! sometimes I need it spelled out : ) So my next question is why is the range for the "y" format 1-355 instead of 1-365 or 366 as per: (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vafctformat.asp)

Actually, I'm looking for Day of Year (1-365), not Julian Date. I think Jeff's suggestion will help me though. Thanks everyone! Liz

Does anyone know if there is a canned function anywhere to convert a date (or month/day) to a number from 1-365? I know it would be pretty easy to create something to do this, but I don't want to re-invent the wheel if this already exists. Thanks! Liz

Hi, I have some relatively simple data entry forms set up to update a table. While entering data on one of the forms, I suddenly got an error saying "Invalid Argument" and much of the text in the form was converted to Chinese characters! When I clicked "help", I was given the following...