Recent content by hstreff

When doing an import, in our case from dBase, is it better to make a new table or link to the table? If you link to the table how does it effect the performance of Access? Also, I like the idea of viewing all my tables in that left navigation pane. But I'm not sure that I want all of my...

I hope this is the correct place to post this. We currently use dBase for all our databases and programming. We were curious how difficult it would be to start converting everything over to VBA. Or if VBA is even the right route to take. We may be way off... Just from poking around in Access...

My boss and I were just talking about our route with Access. We are coming from dBase and are trying to find where we fit into Access. He was just saying to me that VBA may not be the real power but SQL may be the way to go. I told him that you gave me the SQL command for what we were trying...

Actually I figured it out, it did update in the correct table, I was just viewing all the records and didn't see the value. Thank you so very much for your help. This ended up being really quite simple. I was thinking it was going to be very complex possibly requiring some VBA. As I learn...

Thank You! I have been searching all day for an answer. But now I have one more question. The field I want to update is in Table1 rather than Table2 SET Table2.Field2 = "*"; I made the changes accordingly. When I ran the query, I only see the dup field. If I go back to design view and add...

I have 2 tables. I want to find all the records between the two that match and then replace the contents of another field with a value such as "*" to signal the matched records. If I were using dBase I would set a relationship between the two and repl all "fieldname" with "*" for seal = seal...

Moving On... Well. I don't know what I did the first time around, but this time, it was 1,2,3. I think I may have picked the wrong field to "display". So now I have a table that has all my missing numbers. Is there a way to now take those numbers and summarize them so to say. So I can see...

Almost there OK...I figured out the leading zero. I made the field numeric for this purpose. I'll figure out how to convert back to text and repad with zeros later (inless you know an easy way). Now I ran the Find Unmatched Query and now I am stuck again. It runs but it doesn't display...

No, I just thought it may be some kind of seperator... I tried the code you provided. And it created the table, now I am just reading up on the unmatched query. Will it matter that my seq_no is padded with zero's? Will the unmatched query still work? Can I create a field and replace it with...

The code that I posted, after the changes I made did work, kind of...I walked away and let it run. It returned a count of how many records were missing. It also listed a bunch of "0000000" with a square (space char??) in between each. So it seems to be on the right track just not totally. So...

My boss had posted this same basic message so I am sorry for the repeat it actually may have not been in the right spot. I am very new to Access so please excuse my lack of knowledge and terminology. And the length of the message. I just want to try to explain as best I can. I have a database...

What if?? I was looking over the solution you guys came up with. (Thank you very much for your help!) I just have 1 question. Will this still work if the field is not an autonumber field. The field is called seqno. It is a sequential number that we assign to records inhouse. In dBase right...

Thanks Wow! Thanks for the quick responses. I truly can't imagin how long it is going to take me to get everything designed so by the time I am ready I am sure the run-time will be out. (If not a new version!) I will keep reading and researching and I will watch for this release. Thanks...

I have done a lot of searching and reading here. (I could probably do it all day...) I hope this question isn't too general. I am using Access 2007. If I create an application or module or form (not sure which one is correct term) that will be used for data entry on a network; does each user...

Well, the file is a dBase file. I have tried to open the dbas file in Access but as soon as I select the file and hit open, my Access immediately closes itself. No rhyme or reason. So the work around I came up with, was to open the file in Excel, save it out as an excel file then import that...