Recent content by Tarnish

Thanks for the reply, lameid-- Thought about the access forums, but wanted to check here first. I think access' best answer for me is probably just to unbind the form and build the insert sql from the form controls, but I was hoping not to have to do that. If that's the best answer I can...

Not really sure where I should ask this, and I'm sure the answer is already on the forums somewhere, but... I am converting ms access 2003 split f.e./b.e. to ms access 2010 f.e./ms sql 2012 b.e. I'm deploying to win7/64 bit desktops running 32-bit office 2010. I've run into a number of issues...

Thanks a lot for your great responses. I'm all set now! T

Thanks for the quick reply! That works, but I'm a little confused still. Is the problem specifically related to my use of Null? I thought if I put a column name after Case (without anything else like I did above) that I could then use potential values after 'when' keyword. I saw an example...

Hi, I'm new to sql server and I'm using sql server management studio to help me convert some queries for use on sql server 2012 in the form of views. I'm trying to use functions to create some columns in the view, and none of them seem to work properly. Specifically, this fails: CASE...

-Thanks for the replies. When I import the actual xml file, access (2003) ends up making like 5 or 6 tables out of it and the tables don't seem to relate to each other very well in terms of me being able to look at them and see any common field I could use as a pk. I'll look at the...

Hi all, I'm looping through a folder and pulling xml files (one at a time, obviously) into a variable in a procedure in vba. I've tried importing the xml files but each file produces multiple tables and the tables simply don't work well together. I've also tried applying a transformation file...

Rats, Meant to change the title before I submitted it. As the post indicates, I don't really need to make a table...

Hi all, I need to setup something where I can go to a folder, loop through the files with a certain extension, and search them for a specific url. When I find the url I need to be able to return the filename it's in. The folder is known, as is the file extension. I've looped through a folder...

I think I got it now. Sorry for the wasted bandwidth. T

Hi all, I'm rusty with Access but if I could just get an idea how to proceed I think I could figure it back out. I have a table of data I've imported from an excel spreadsheet. There is no primary key (other than one I added during the import that I don't think helps here). The table is...

Got the # to work in a query for a field in a form set to be a hyperlink. Thanks for direction, PHV!

Thanks for the reply, PHV. So is this a solution where I'll create a recordset in the form's module and use that instead of a query feeding the form? Thanks, T

Hi all! My Access is rusty and this seems like it should be simple.... I have a hyperlink field on a form, which is based on a query with a field that contains local file addresses (one per record, of course). When you click on the field in the form (datasheet), it opens the document at the...

Nevermind. Finally found what I was looking for. Thanks anyway, T