Search results

I have a parent form "frmMainMenu" that forms the shell of my user interface. Everything in the database is done through a subform. Command button behavior is table driven similar to the "switchboard" template that comes out of the box, except that I have added additional arguments (e.g. form...

Gemma and Leigh, Your comments about help are well noted. My experience is that the help files are never as helpful as a google search - often with the answers, syntax explanations, and code samples and on web pages hosed in Rumania, Canada, UK etc. I've haven't used Access '97 for...

Thanks greatly! This is exceptionally helpful. ________ Weed vaporizers

putting information into an array in a code module is the less secure option and makes maintaining data a hassle ________ Magic Flight

I don't know MS Access 2007, but..... It sounds like you have linked tables and the path to the linked table might not be correct. In MS Access 2000 there is a utility TOOLS ==> DATABASE UTILITIES ==> LINKED TABLE MAMAGER that can be used to reestablish links between tables. Simply check...

I have been asked if I can provide support to a select group who need to use MS Office 2003 for mission critical collaboration with external partners. Unfortunately I have never seen MS Access 2003 and the IT group that supports the business I work for refuses to provide any support to...

Thanks KenHigg, this is helpful. I guess I misunderstood how IIF works. I thought IIF would return values, and that value could be an expression. It makes some sense that IIF only returns discrete values, but is a little disappointing. Your thoughts are appreciated. ________ Subaru...

Sometimes this error message is generated if the query length contains too many characters and the semicolin is truncated from the end of the query at run time. You might want to save the output of each section of the UION query to a separate query, then write your UNION query something like...

thanks for the response. This might have been a better solution if there were not so many dependent queries..... I could write two queries and call them alternately, but I was hoping to do it all in one query. Do you know why it fails to evaluate properly? All options I have tried are...

:confused:This query is driving me bonkers. :confused: I just quite cannot figure it out. I have a form with a radio button that stores the value of 0 and -1 This radio button indicates whether capital expenses should be included in the query output. If the radio button [opt_w_Cap_Exp] = -1...

Hmmmmm - I was attempting to do the same thing with MS Access 2000.....I'm having rendering problems. Each carriage return and line feed is displayed on the report as a box within a text string. Here is the background info: (1) I attempted concatenating values within an unbound text box on...

You can have references within Personal.XLS and within the open document. If someone has references within Personal.XLS they will be applied to all open documents on that computer, regardless of whether the references are made within a particular file. Hope this helps ________ Ford model a...

pbaldy is right (1) Build an event that will make a function call. Fot demo purposes I have imagined a form named frmParameterWindow that contains a command button named cmdUpdate and a text box named txtParameterValue Next write the function that the click event calls. I named this...

Craig Dolphin just posted sample code for this ... http://www.access-programmers.co.uk/forums/showthread.php?&p=742348#post742348 ________ Rebel

content is bogus Here's my working code. It seems to be working for me now, thought it is a bit clunky fnTEST generates the MS Excel export If anyone sees a way to make this better, please let me know, alternately I hope this will server as a reference for others ________ S-10 Blazer

silly me - I needed to replace with "Selection" was not defined within my MS Access VBA code. Selection is understood within MS Excel VBA code. ________ Vaporizer volcano

BACKGROUND: What I have already done is export data to MS Excel (via ADODB). What I want to do now is draw a box around the selected range. How do I do this. GOAL: Draw a border around the output range in the MS Excel export SUMMARY OF EFFORT: I can draw a border around each cell within...

You may not like this solution - I don't have a code snippet for you either but.....here is a piece of pseudocode (1) Create a recordset of all records "rst1" (2) loop through "rst1" and count each record with a loop counter (3) based upon an evaluation of the loop counter value, write records...

I think you are having a locus of control issue. Try explicitly indicating where AppStatusID is located within your OnCurrent event. You may have to write something like this to get it to work correctly. I'm assuming that your subform is called "frmSubform" in this snippet...

I've never quite figured this out, but can tell you that string lengths greater than 255 characters can be problematic. Sometimes building your SQL string so that it builds upon values already stored in memory lets you call an SQL string longer than 255 characters, but this will also fail at...