Recent content by ray00

Skip: Thank you very much for your help. I have sent you the workbook at you email address. Let me know in case it didn't go through. My email is cxde2000@yahoo.com

I am a newbie in Excel. I needed a solution to this problem. I tried Skip's advice. It works but I am having trouble selecting the value in the cell. When I click on the value in combobox, it doesn't show up in the cell. Its just blank? what am I doing wrong here? Thanks in advance,

Here is an ecample from my code. I put this code in the "On change" event of my combo box which is cboSName. txtLName is the name of the textbox that I want to populate with the look up function. Dim varS As Variant varS = DLookup("[Implementation Area Long Name]&quot...

John: Where did you put this Dlookup code? You need to have it 'On change' and 'after update' of the combo box event too. I use this type a lot to show records in a form based on a value selected in the combo box. in Access 2000, when I create the combo box with a wizard, it asks that do I...

Hi! I want to turn the db window off and access special keys off in the startup options so the users cannot access the tables. But I don't want to go through the security/ permissions issues. Is there a way to programatically open the dbwindow with the click of a button? If so, what is the...

Yes, this can be done. Just make the textboxes unbound. And then update the tables with code (using SQl statements)after the user enters data. Hope this helps! Let me know if you need more help!

Thanks for the responses! As Craig mentioned, we can open the dbwindow when the correct password is entered. But can you please let me know what the code is to open the db window? I tried docmd.opendbwindow, etc....Nothing works! Thanks again.

I used ERWIN (data modelling tool). But you have to enter the data again. When you print it, it will give you the option to enter if you want to fit in in one page or not.

How did you disable the shift key? Where did you put the code? I need some help here! And also is there a way I can open the database window by clicking a button. Thanks in advance.

Could you create a run time version and if yes, how did you do it? Thanks in anticipation,

I think its AppActivate Shell(name of the app). Check out the help on AppActivate and you should find it.

Can I get a copy of it please? My email is cxde2000@yahoo.com. Thanks in advance.

What procedure did you use to upload the files from the database to the FTP server? I am trying to automate a similar process in Access. Any help?

I am trying to automate the process of sending a query result to a FTP server? Can it be done in access with a macro (transfer file action) or do I have to write a code? The user just wants to click the button and the file should be transferred. Any help will be appreciated! Thanks in advance.

Thanks Skip! Appreciate your prompt reply. It worked.