Search results for query: *

I've built an Access database where everything appears to be working just as expected. Then when I transfer the database to the end user, all of my forms with the exception of any form that contains a sub form will become unresponsive on the end users computer. The strange thing that I’ve...

The solution was to issue the "CALL" command prior to the utilizing the function within my code. The problem that I was experiencing was that I was actually utilizing this command appropriately; however the file did not exist in the specified directory, so the code actually had nothing to open...

RESOLVED. Thanks!

My apologies if I wasn't clear in my original post...What I was really trying to figure out was how to call/execute this function within a sub_afterUpdate()?

Any advice on how to execute / call the following function mentioned here on this message board? http://www.tek-tips.com/faqs.cfm?fid=1971 Basically, I'd like to insert via variables the arguments of this function to execute on an on_update command. Thanks in advance!

Thanks Guys!!!

RiverGuy - Thanks; however i was just using this as an example for the sake of simplicity. I'm getting the same error when attempting to execute dynamic sql in a much larget block of code.

Total newbie question, but i'm having some trouble executing the following dynamic sql statement. The folowing represents an example of the piece of code... CREATE TABLE #Temp([VID] INT) INSERT INTO #Temp VALUES(6565) ALTER TABLE #Temp ADD Counter INT DECLARE @SQL VARCHAR(250) DECLARE @VID...

PercyN - Thanks so much!

I'd like to implement a solution on an access form where a selection in a specific check box field displays a combobox field that a user can enter data into. Again, if the checkbox is selected, I'd like to combobox to be visable...once deselected the combobox would become invisiable to the...

Yep, that's the one! Thanks!

Can someone please remind me the keyboard shortcut combination that will allow me to switch a protected MS Access database to the back-end / design view? Thanks!

Thanks Hasit for your quick response. I have indeed tried adding my logo and text to the header, however, the problem is that the MS Excel header scales along with the report itself.

I have a series of MS Excel reports that display different information each with a consistent Header(Logo Image & Report Description). The problem that I am faced with is each of these reports displays different information, however, they each need to be presented on a single page. I can scale...