Search results for query: *

This is a really fun one. I have an elaborate Excel 2003 formula calculation workbook that is saved as a template with multiple Vlookup tables that get their data from an Access database, I have them set to refresh on open. With the one generation of it everything works fine but I have set up a...

I've had the same problem, it happens when you use key combinations with ctrl and shift etc. maybe when you're using the keyboard to cut and paste? In my case it was another one of those "helpful features of Windows" it seems you can set the keyboard into a state where the shift or ctrl key is...

I use a form to enter new records and update existing records in my DB and use a combo box in the form header to look up the record I want to edit. This functions perfectly but what I want to be able to do is to use the same form to also view records in read only mode, I have tried this by...

Thanks Skip and anotherhiggins, Skips first suggestion was clarifed by anotherhiggins second, I now see the error of my ways... The search function did the trick. Thanks to both of you!

Hi Skip, thanks for the reply. I should have mentioned that this functions correctly if the values to match are not found in the cell. The purpose of this is when the user enters a text value in the reference cell and it matches one of the two predetermined criteria it will return one of two...

I am working with a simple IF/OR formula in Excel that I want to return one of several predetermined values based on the content in the reference cell. The data in the cell is text and I am trying to use a wildcard to match the criteria so that if just part of the text string is in the cell it...

Thanks Ed, I'm familiar with the network issues that Access imposes and the use of the Front/back end. Yes I also see issue with Word and Excel at times so I think it's symptomatic of our network usage. The Network Tech (singular) for an operation of over 100 users is the only remaining...

Thanks ed2020, This is a late night reply for me at home so you'll have to forgive me if I'm a bit short. Forms are bound - I'm not a VB programmer, I developed my DB's using the Access development frontend. DAO as far as I remember, haven't delved into ADO unless using the built in wizards...

I'm starting to see a lot of issues with several of my databases (Access 2003) on our network not saving edited/added data to the tables. We used to run on a Novell network but this was changed in the last year or so to a Windows based Active Directory environment. I suspect that the problem...

Thanks for replying HandsOnAccess, Apparently it was in the query I was running, I had edited it in design view several times to try to figure out what was happening but I think something got left behind in the SQL code that I couldn't see, I restored an earlier version of the query and...

Great post mstrmage1768, worked like a charm for me also, another star is due.

I have a data entry form in my database that is based on a query. I want to be able to let the user duplicate the current record to the next record in sequence with a function button to allow them to modify a few pieces of data but not have to re-enter everything. The underlying record set...

Thanks again Skip, As usual "You're The {CODE} Man" and get a star. I'll probbly be back to revisit this one when I get in trouble trying it out. Regards...

Thanks Skip, Your procedure of how to get at the code was a bit different for me but I got it. So... In other words, the actual code is buried inside an internal procedure? To do what I want to do to modify the code I'd then have to assign it to a macro or module and run it with an Autoexec...

I have an Excel 2003 spreadsheet that retrieves data from an Access database and have it set up to auto-refresh the data on open, three sheets in the workbook are set up to pull data over from separate tables in the database. Everything is working fine although I had some fun when I wanted to...

CBasicAssembler, Thanks again, I incorporated your revisions.

Thanks to everyone for putting up with my lack of depth on this subject, I finally got it to work with a combination of several of the posted code samples. Here is the final code that did everything that I needed to accomplish: Sub CopyData1_2() Dim sTemplate As String Dim sNewBook As String...

Skip, Expression "i" now resolves to "0" but I still get the out of range error. I don't have enough hair left to rip out I'm afraid, hopefully you guys won't boot me out of here any time soon. Thanks again.

Skip and CBasicAssembler, Sorry to be so dense on this topic but VB is very new to me. Didn't use the quotes, it was just part of my message. I added the suggested test and astrLinks is coming up Empty in the Locals window initially, after completing the IfEmpty test, expression "i" value is...

Skip, It would be the link between the active workbook, which is "SNewBook" and the original workbook "sTemplate" that I want to break the link to. I tried your suggestion but I just don't know enough about the syntax to get it right, I still get the same error in that section of the code. I...