Search results

One last thing? snf? I googled, but my google-fu failed me.

I think it's the most beautiful thing...

Thanks! I'm actually exporting a query to a text doc to import into a graphing software (as Access cracks up when I try to make these plots), so I think I need the VBA collection? I'm still struggling with this one. I feel a bit like a little kid who was handed a pile of strings & told to play...

I need to output a text CSV file with a consistent table format to another program. This table contains a page number column and must contain a sequential numbering column. I currently generate a row number using method #3 from Access Experts...

Thanks, all. I don't know why I didn't think of applying a timer. I'll try that when I get a second. (hyuk, hyuk) Doc_Man, I did nearly implement a select case, but I couldn't think of a way to apply it that didn't include it in each If statement, so it didn't seem that it would add much to...

General looping efficiency question for building a collection of controls; Do you think I'd be more efficient evaluating all of the property tags that I want to add to a collection before moving to the next collection, or would it be more efficient evaluating each tag & adding it to all of the...

Thanks everyone! As isladogs says, I've increased the processing before updating. I now connect the data using Select queries and write the new auto-number IDs to the incoming tables. THEN I run the update queries using the IDs as my only join. No more DISTINCTROW troubles. It took me all day...

I think all of these responses together have put an idea in my mind. It's not a one-time deal, it's a process I need to store for other users. I am already importing the data into a temporary table & then modifying it before appending new data. I was so hung up on figuring out the update...

Hi all, I'm working on import and update queries to bring data from an older format database to a newer, better model. There were a few things about the original that made it not perfectly normalized, so I'm addressing that in my latest version. Most of my update queries have worked, but one is...

Sadly, I had to go to a 64-bit installation for the Geotech software I'm interfacing to work, so my computer won't run your code unless I figure out how to modify it. I'm not doubting that it can be done, I'm just at a bit of a loss for what I'm doing wrong. Also not sure about the exports I...

Thanks, Micron. I actually had the same thought, since I was using step 5 as my reference, but Access wraps the brackets when I build the query in visual mode. I messed with the SQL after that- with, without, without the 'Is Null', removing extra parenthesis that Access created, with & without...

I'm working right now on making his fake yes/no fields. I haven't ever set a programmatic property like that before, so I'm still figuring out the checkbox. Based on your page (thank you, so helpful!), I think my mistake was in assuming that the values would be 1, 2, 3... etc. That explains...

Okay, I know all of the reasons one should not use a multi-value field, and I'm ready to admit defeat. However, I can't for the life of me figure out why this didn't work: I'm working on Update queries for merging old database records into my new format. I have one field in the whole dang...

Roger that. Now that I'm done panicking about missing properties, I'll do some better reading on import procedures. I had a more brute force approach... Thank you, everyone!

Do you run into problems with relationships, Giz? I have a number of queries that were created with specifically-crafted constraining relationships, and that didn't seem to carry over well. There were still relationships in my queries, but they seemed to have lost the settings. My relationship...

I'm going to cry. "No," she says. "Of course not, isladogs. Mine doesn't look anything like that, it's three inches wide. See - if I grab this spot right here and... drag... a bit..." It can't have been that the whole time? How the H did that even happen? I definitely tried resizing the...

Cats are always helpful on projects, D-L. I think I'm back to where I was 24 hrs ago and haven't corrupted anything, so soldiering on. Thanks, all

This file and all backups of it for the past three days have this problem. If I go back to an earlier version, it works fine; can edit properties. New databases work normally.

So, I used the FMS article you linked and ran into trouble with the command prompt method. I get the attached error message. I tried a few times, and decided it was possibly a system admin access limitation? However, I was able to make a shortcut. I can launch with the target: "C:\Program...

Sorry, didn't mean to make it sound that way. I did try compiling. I wasn't sure at first that I was doing it right, but forced it to find a code error, so now I'm confident it was working. It just didn't have an effect, apparently. Except that my file size got larger, even after compacting...