Search results

First off, I'm not a programmer so please bear with me. Maybe I'm asking for too much here but what I’m looking for is some routine to assist in importing data from an Excel spreadsheet. I can do this all manually but have no idea where to begin to automate this. Here's what I do manually...

Excellent, Thanks Bob, SKK

I have a few Access2K DB's that open to a startup form with the database window closed. I'd like to add a button to the startup form that opens the DB window (like pressing F11). Is this possible? Thanks, SKK

Excellent Thanks, SKK

I’m trying to add a number and a hyphen (i.e., 123-) to the values in all cells in a column. Under the old Lotus 123 DOS days, my macro code would read something like: {edit}{home}123-{down}~ However, now with Excel, and VBA, I’m having a real problem do this. Any ideas? Thanks, SKK

I have an Access-2K database setup as frontend/backend with numerous linked tables. One of the tables is linked to a laptop (which logs on in the evening to update other data) - all others are linked to the backend DB which is always online. My problem is it takes >30 seconds to open any...

That did it. Thanks again, SKK

It may, I just not familiar with that. I'll do some more research and see how this works. Thanks, SKK

I have a form with three yes/no check boxes - the user should only select one of the three. Is there a way that once one of the three boxes have been selected, the other two become inaccessable (i.e., grayed out or dissappear)? Thanks, SKK

Let me try these guys. I'll keep you posted. Thanks, SKK

I’d like some assistance on the following if possible: I have a database where I want to update a field (Agree_ID) based on the data input in a second field (Pond_ID). Agree_ID uses only a portion of Pond_ID. I’d like some routine (macro or VBA code) to assist. Example: Pond_ID – keyin...

Hey all... I think I got it. I have an update query: Right([Par_Addr],(Len([Par_Addr])-InStr([Par_Addr]," "))) It may not be correct but it appears to be doing what I want. Thanks again, SKK

Great - will try (it's actually for someone in planning). Thanks Alastair, SKK

Of course. My fault... I have a query for other items. SKK

If possible, I'd like to some help with a macro that strips the address number from a Parcel Address and leaves only the street name left. Before: 1234 Somewhere St. 321 Crossing Meadows Dr. After: Somewhere St. Crossing Meadows Dr. Thanks, SKK

I'll have to try linking the spreadsheet. Probably won't happen till next week. Thanks, SKK

I’d like to import ADDRESS field into a cell (or cells) in an Excel spreadsheet based on the DATE keyed-in a specific cell. There may be numerous addresses for the same date. Example: Spreadsheet Cell B7 = 6/12/06 Returns from the tblConstDate Access Table into a cell (or cells) in the...

Thanks Ted, SKK

I too am looking to a way to test for existing of a table. However, I want to test the location of a table in a remote network database. Where in the code found in http://www.mvps.org/access/tables/tbl0001.htm do I place the path, database name, and table name? Thanks, SKK

Excellent idea Chris. Thanks again, SKK