Search results for query: *

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

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

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

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

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

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

Hi, I know this is a really basic question... I have a table of results for locations. Each record is assoc. with a date, time, and depth. Some locations have multiple results. How do I select the record (including relevant depth, date, time, etc.) for each location at which the result is the...

Within a make table query, is there any way to create an autonumber field and set it as the primary key of the new table? Thanks! Liz

Hello, I have the following input mask applied for a date (non-required field): 99/99/0000;0;_ and a default value of "NDF" ("No Data Found"). The field is automatically filled in with "NDF" if the user does not enter a date. However, is there any way to enable the user to type or paste in...

Hi, I know how to create an On UPdate event procedure to refine the options in one combo box based on another. However, I have a situation where the first selection limits the second to a single possibility. Sooo, what I'd LIKE to do is change the second combo box to a text box, and have the On...

Hello, I have a subform that has a 1 to 1 relationship with the main form. Therefore, I want to enable the user to populate the subform with only one value. However, enabling "allow additions" causes the subform to appear to allow more than one value in this field (even though the 1-1...

Hi, Can anyone provide me with some guidance in copying relationships from one Access db to another. There was some sample code for this at: http://support.microsoft.com/kb/298174 It appeared to run successfully, but didn't produce any results. Any help greatly appreciated.

Hello there, I am trying to run a fairly elaborate union query in MS Access 2000 and am getting the following error message: "Cannot open any more databases." (Error 3048). I did a couple of google searches that have led me to think it has something to do with the large number of tables being...