Search results

Hi everyone, I'm continuing to struggle with this project. I "think" it can be done but maybe it can't and I'm wasting time and effort in trying to figure it out. Anyone?

Good afternoon, It's been years since I've been on the forum and just as long since I've used VBA so I'm starting from scratch on a project. I'm looking for a way to use VBA and Active X check boxes to move info from one worksheet to another in the same spreadsheet. In my example I'm taking...

Yes, that is it. Thanks, it helped me rescue the Access Developer's Handbook form resizer .zip file. I have used it forever but didn't have the accompanying documentation.

There used to be a site that basically took snapshots of websites so that even after a website ceased to exist you could sometimes find it on there. Anybody ever seen it, know what it is? Thanks

Happy BDay Tess.

The form I am using is "Hose Cut Query Form". It is two subforms, "Hose Data Display 3way" and "Hose Data Display 4way". I can have a hose in the table twice with the only difference being "Tension 1" or "Tension 2" fields with the field "Function" being the deciding primary key with entry of...

I've created a query by form such as Jon's example here http://www.access-programmers.co.uk/forums/showthread.php?t=103312&highlight=query+form but whenever I open the form I get parameter boxes asking for data AND one past that after I input the data on the form and run the query I get the...

Does anyone here know PHP in depth? Any good PHP forums out there?

Sorry, but I have not a clue as to how to do this. Care to take a look at the posted example spreadsheet and apply an example to it?

I am turning the maintenance over to another person who has to have access to the mdb.

Damn it, I turn one of my databases that uses GHudson's hide code over to another employee this morning and in 15 minutes he is able to get the Menu and toolbars lost. I dislike handing over my babies to hackers. I'm all good but I wich I know how he did it so I could protect the db from him...

This is the first time I have looked at this so please excuse my ignorance and the many questions that are sure to follow. I also know that this would be better suited to a db of some sort but due to manpower cutbacks we can't convert this at this time. I need to look up data related to a key...

Thanks for the IF. Works perfectly now.

Works perfect BUT (isn't there always a but!) how can I get this to return blank if the cell is blank? I tried """","MP","MP10",...;"""","User1","User10"... but that didn't work. Any ideas? And thanks for letting me know arrays had to be in sorted order!

That explains it! Who would have thought that? Not me!

Either works but ; did not solve the error.

=LOOKUP(A1,{"MP ","MP1 ","MP2 ",...},{"User 1","User 2","User 3",...}). I have to work with "MP#" format as being a 6 character field as it is imported from another source. For some reason MP3, 6, 5, 8, & 9 are all returning the last User instead of the correct one. Now I have to find...

I am trying a Lookup but getting 50/50 results and can't figure it out.

Got it! Now how can I test for more than 7 conditions (MP1, MP2, MP3, ect.)?

I still cannot get this to work. You say you had it working?