Search results

why not try using the IsNull function Try something like this You can now assign a recordsource or rowsource property to strSQL and be good to go. Please let me know if this was at all helpful. ________ HOT BOX VAPE

The URL link apprears to be broken right now ________ Of Indiana Automotive, Inc.

pbaldy, Thanks immensely! This is exactly what I needed to know to fix all related problems. As follow up, I discovered that though I had bound a form to use the FieldList to initially build form controls, I failed to unbind the form after unbinding the individual controls. I also...

TROUBLESHOOTING: The best way to troubleshoot is to step through the code line-by-line by using breakpoints (set breakpoints by clicking in the left margin of the code development window. When you have it right you will see circles in the margin. When you run the code execution will stop at...

Perhaps a copy of the DB will help Any assistance would be appreciated ________ Subaru 360

you could also write code (OnCurrent event perhaps) to perform a test (to see if the value is greater than zero) and then dynamically set the forecolor property of the text box control using an if...endif or select case...end select statement ________ Alaska Medical Marijuana Dispensaries

I don't know MS Access 2007, but with older versions sometimes toolbars stop changing. This has happened due to either 1) memory leak - fixable by a cold reboot 2) code that deliberately turns off toolbars I hope this helps guide your thoughts. Sorry I cannot be more specific. ________...

Here's the code block used to save an edits ________ Health Shop

[entry was accidentially posted twice] ________ New Jersey Marijuana Dispensary

I explicitly set the recordset to nothing before the scope where the recordset is created is desctructed. Please accept my appologies for not fully documenting the code. ________ MAZDA NAGARE HISTORY

I have a form with an unbound text box that holds a primary key from a table. I use an OnLoad event event to build a recordset that looks up the values associated with the record referenced in the unbound text box in the parent form. I use the values of this recordset to populate field values...

just for giggles, have you tried using a different path e.g. "c:\temp" to see if it makes any difference? if this fails, I'd start thinking about using a different transfer method... www.zmey.1977.ru/Access_To_Excel.htm ________ MAC GAMES

Thanks! this code now works ________ Honda Cbr600F

Have you tested the code on another computer? This will help you determine if your installation of MS Access is corrupt, or the code is not being handled well. ________ TRICHOMES

OBJECTIVE: I am trying to figure out how to create text files using VBA. PROBLEM: Unfortunately none of my books address FileSystemObjects. Code samples I have seen on the net don't work for me and I wonder if I need a special library reference to make this work. FUNCTION OBJECTIVE...

Thanks! This is very helpful. I wish the best to both of you. ________ VAPORIZER VOLCANO

I'm having difficulty breaking a While Wend loop and can't seem to recall the keywork necessary to do this elegantly. I initially tried "Exit While", then "End While", before reviewed reference materials and google. I find that "Exit While" is the keyword most often cited in these sources...

This code is used to handle an empty recordset. If you have an empty or null recordset the recordset object does exist, but many recordset methods will cause runtime errors (e.g. .movefirst, .movenext, move previous, .movelast) This line of code is checking and if the recordset is not null...

nIGHTmAYOR Thanks for the post. I'm guessing that Danz013 is constructing a make table query out based upon a crosstab query. I agree with you. Either using recordsets with values initialized to zero, or a join to a virtual dates table should work for Danz013. I've used both methods...

As you get deeper into recordsets, you will be able to use your knowledge of SQL to define the data that will populate your recordset. You can also use APPEND and UPDATE queries within VBA to write/edit recordset data back into a table. ________ Honda Gy6 Engine History