Search results

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

This is possible by buying additional MS Access Developer Software, which enables you to create "Runtime" versions of your databases for distribution to users who do not have copies of Access installed on their machine

I've faced a similar issue with regards to .bak files, and the most succesful way I have found is to restore it into SQL Server, using Enterprise manager - as suggested above. I believe you can get SQL Server 2K (for a single desktop) license free, and SQL Server works fine running on a normal...

Hey Len I was not having a go, honest! I too am guilty (on very rare occasiosns :) ) of posting before searching. I was just reiterating the existance of the search facility incase you were unaware of it. I hope that you have found a workable solution PJL