Search results

Awesome.. Thanks for your help Bob..Worked like a charm.. (well I got another error, but that's unrelated.) Thanks :-)

Thanks for your help Bob, however it now falls over at Set rUsed = objExcel.Intersect(Range("A:D"), ActiveSheet.UsedRange) Compile Error: Sub or Function not defined

Hi, I'm trying to use the following code, however access is telling me that the user defined variable is not defined.. Now I'm assuming that I am missing a reference for this, however I've got all the ones I can think of selected.. Any ideas? Code in red is where the error is flagged Dim...

I have a database that is used for ETL processes, it has a simple gui that just links a few buttons to a bunch of code. It reads from another access database that contains all the tables, plus a few linked odbc tables. This all ran fine under access 2003, but it now runs dog slow, with no...

Hi all.. Long time no see.. I've got a form that sets a flag when opened, and taken away when you navigate away from the form. My issue is that if the form is open and you close Access, the flag is not reset.. This also occurs if my db crashes.. Is there a way to catch this?

You use the docmd.runsql when you want to execute a sql command, such as Delete (Delete button on form for example). The The Select function is for gathering a set of records based on certain criteria, and then using it as the basis of a form or report, such as building a report showing people...

Hmmm, might have to give the IT guys a call and see what they can do.. Don't have high hopes though.. (They still run IE6 here)

Hmmm, looks like no service packs are installed..

Thanks for your help Bob.. How do you find out what service pack is installed?

Just did a compact repair on it and it works now.. The first run gave an error saying it couldn't open the file because access didn't recognise it or it was corrupt, but it worked the second time.. Most odd

Version 2003..

It compiles fine.. And i'm trying to create it in an empty folder.. Nothing happens.. It was working fine until I applied the password to the backend.. I'm really confused about this.. It works perfectly fine as a .mdb file..

Hi, I've just applied a password to my backend file, relinked the tables on the frontend thus applying the password. Everything works fine.. However, I seem to be unable to save a new .mde version of my FE. It says it does it, but no new file is created!?!?!? Anyone know how to fix this?

I'm unsure about this one sorry.. Can I ask why you're trying to do this?

Huh? You want to be able to see it but not click it??

Tools -> Startup, untick Show Database Window.. Search the forums for the method to disable the Shift Key

Are you saying you don't want them to have access to the objects window? (the list of all the tables, queries, forms etc)

Quick question.. If a subform has its recordsource changed, then is requeried.. which sub is called on the form? Is Load run again? or is it the AfterUpdate?

nevermind, turns out I had a typo in the sub name

Hey. On a form, i have two subforms. One displays a list of user id's (listSubform), the the other displays a username (nameSubform).. What i'm trying to get to happen is when a id is clicked in listSubform, I want the corresponding name to be displayed in nameSubform.. This shouldn't be...