Search results

Given what you want to do, I'm thinking transfertext is not the method you want to use. Read the article at http://zmey.1977.ru/Access_To_Excel.htm and pay special attention to ADODB and DAO techniques. I expect you could put some run time processing into these code samples to alter...

Not knowing exactly what you want it's hard to give sound advice.... But here goes...you could always (1) use a report extract table with a variable for each week (2) the default value for each variable could be zero, or a function could be written to change nulls to zeros (3) use some...

I'm a little confused by your post. Do you want your output as two separate records, or two separate values in a single record? Satal Keto's post forms an elegant method for doing this work, but you will have to edit it a little if you want your output in a single record. ________ PLYMOUTH...

Now that makes sense! Thanks georgedwilkinson ________ Babi mac

Rabbie, I understand how the scope of a code module is different from the scope of a form or report module. I jut find it hard to comprenend why a function within a form module cannot be executed as a private function from a function call from the same form module. <RANT> I'm guessing...

You are a genius! But why on earth would a form module be different from a code module? I always thought that a module was a module was a module.... ________ Glass Pipe Pictures

Thanks - but changing the declaration from a function to a sub does not remove the error. <WISH> I wish MS Access was a little more intuitive - this kind of error drives me nuts... </WISH> ________ Edsel corsair

ARGHHHHH The problem just came back when when adding a new function. This time declaring the function as public does not solve the problem..... Any thoughts would be appreciated. ________ Roor bongs

Thanks Bob, I appreciate the response. In answer to your questions I tried running the function by placing the cursor inside the function code block before calling it from the immediate window. I also tried clicking on the CONTINUE button in the VBA IDE's Standard toolbar. Both efforts...

This works to fix the problem, but makes no sense to me:confused: I typically try to limit the scope of functions to a specific module whenever the function will not be called elsewhere. This addresses accidental function overloading when I'm copying/pasting code from another project into a...

:confused:I'm confused (again) Here is my code...Every time I try to call this functin from the immediate window run it I receive the "Compile error: Sub or Function not defined" I have added lines of code, compiled the database outside of break mode, saved the module, deleted the lines of...

FOLLOW UP: My problem had to do with the function I used to change the sourceobject for the subform. The function that made this change ended with a requery instruction for the subform. The form was opening in data entry mode, but the requery instruction made all records to become...

MagicMan, You have worked magic! This was really getting to me. I appreciate your help tremendously. Regards ________ Extreme q vaporizer review

This isn't what you asked for, but it has proved helpful to me... http://zmey.1977.ru/Access_To_Excel.htm The article explores several different methods for exporting data to MS Excel including an ADO technique using the MS Excel reference library. ________ SUZUKI GS400E

MagicMan, This fails to work for me too. Thanks for the thought though. NOTE: I also tried setting the DataEntry property at the same time that the source object property is set and found that this doesn't work either. ________ Health Shop

Here's a mostly stripped down version of the database - including the problem ________ MERCEDES-BENZ M100 ENGINE HISTORY

BobLarson, I added the following code And am the subform still opening to the first record. I knopw it's redundant, but adding the extra code of DoCmd.GoToRecord , , acNewRec or DoCmd.GoToRecord , , acLast appear to be ignored If it makes any difference, I'm using MS...

Missingling, Thanks for the tip. I checked the properties of the parent form "frmMainMenu" and saw that it has the following data properties: AllowFilters = No AllowEdits = Yes AllowDeletions = No AllowAdditions = Yes DataEntry = No The subform has the following data properties...

Thanks for the suggestion, unfortunately it doesn't work....... Any other ideas? ________ Michigan Marijuana Dispensaries

Did you ever figure this out? I have s similar problem. ________ Colorado dispensary