Search results

Yep, and am fricking loving it! Thanks to an imported US Box Set and good old Bit Torrent, I am up to Episode 7 of Season 2 - the scope and depth of the storylines are awesome! You into it?

Got this info in an email last night - I am sure it is doing the rounds globally, but just for the sheer comedy value, try this try this try this!!!! Go to www.google.com, type in "failure" (without the speechmarks), and press the "I'm Feeling Lucky" button.............some Google IT geek is...

Thanks to the above, I have a working solution. Out of interest, and a being a self taught vb novice, what code is non-essential? Looking at it, I thought that there was minimal code, and some well advised error handling? Cheers for info, much appreicated.

Hello one and all It may seem a rather simple question, though it continues to confound me -and I have searched to no avail :D How do you trigger an event depending on what button is pressed on a msgbox? For example, using a vbYesNo msgbox on a form, how can I assign events to either the Yes...

bump :) Anyone got any ideas on the above?

Hello all I have fell into Data Access Pages (yes, it hurt :p ), and have absolutely no knowledge of HTML or Javascript (though fairly competent with vb), so please bear with me! When you are using normal forms in Access, you can launch a separate form from a command button, and bring up a...

Mmmmm, many thanks for the info, can't remember if I grouped on this or not. Am off-site at the mo, but will check when I get back. Cheers for the help DJN

Hello All Has anyone ever encoutered a problem where when running a query to return a dataset which includes a memo field, the query only returns part of the info contained in the memo field? Do queries limit the return of memo field data to 255 characters? I have run other queries on other...

Have you tried holding down the SHIFT key when you open your db? If the orginal designer has not disabled this function, this should take you to the database window, where all of the tables, forms, queries etc will be displayed HTH

Please ignore the above! Have solved both issues. FYI, to sort 1. I replaced "IntStr" with the "Left" Function to find which tables/querys had the prefix, and for 2., where TableDef is referenced, the references for QueryDef and ModuleDef work in the same way. PJL

Many thanks for this code ghudson, is almost what I am after! I have just got a further couple of questions......... 1. How would one amend it so that it would delete those tables that don't start with/contain a certain prefix? For example, for it to delete all tables that do start with...

Nice one, cheers Brett, will give this a go :D Thanks

Hello Does anybody have any vb code - either as a procedure or function - that deletes all tables, queries and macros, based on wheteher or not the object has a certain prefix? My db has over two hundred tables, and twice as many queries, and so instead of writing a macro and using...

Cheers FoFa Maybe I am misunderstanding the purpose of Dlookup. What I want to do is to return from Team Lookup the name of the area as based on the code provided from the MID value. For example, the Query that contains the MID value has over 3K records, and so for each value the MID...

Fofa Many thanks for the prompt reply, but I am now getting a Enter Parameter Value input box for Area Lookup!Code, and irregardless of the value input, an error message then appears saying that "The expression you entered as a query parameter produced this error: 'Microsoft Office Access can't...

Hey y'all Can anyone see what may be wrong with the following Dlookup syntax? I have a field in a query, MID, and want to return from another table a corresponding name that matches the MID code. I have constructed the below, but the query expression builder does not like it -...

Cheers Rich, sorted :)

Hello all Quick question - is it possible to use a calculated field as a condition in another control? For example, I have a field (text box), called "CurrentHours," that it's control source is an IIf calculation. I want to use the value in this field as part of another calculation - for...

Hello All I have a two tables, one a recordset (2k rows) - "Main" - and one a table of codes and names (15 rows) - Areas". Each table has a ID, which relates to the Name od an area held on the table to codes. I want to return the Name of the Area onto the query grid by looking up the ID from...

This thread is located in the Sample Databases, and is an example I have used to great effect previously http://www.access-programmers.co.uk/forums/showthread.php?t=64532 This may be something along the lines of what you are looking for Regards PJL