• How do you change user password for a separate Access database than you are working in?

    I've built a database (Production) with user level security on it.  I also have built a smaller database (Login) so I don't have to use Access' login.  I'm trying to figure out if there is a way to change the user password in the Production database FROM the Login database.  I've been working...

    McNitro255 pointsBadges:
  • Dir() Function doesn’t find .pdf files in Access 2003

    I've used the Dir() function with VBA several times for different file formats, but for some reason it's not working on .pdf files. Am I missing something?

    McNitro255 pointsBadges:
  • Unlocking VBA project using VBA code

    Can i use vba code to unlock my x-cel vba project protected by password? I need to unprotect my project to add some code and then reprotect it.

    Yves69520 pointsBadges:
  • VBA to separate overlapping times

    I am stuck trying to seperate overlapping times. The situation is that I have 5 devices requiring x amount of material at the differing durations. What I need to do is seperate the durations and add the demands together for the new duration, but there can be as many as 5 overlapping demands; here...

    Jace75 pointsBadges:
  • VBA Excel 2003 Copy and Paste

    I would like to know how am i going to copy a certain range (A1:E500) in File A and paste it in a different file (File B). Then copy a new range in other sheet of File A then paste it in File B without overlapping the data I copied from the first range. Thank you so much in advance!

    Eron09135 pointsBadges:
  • VBA Excel dates

    Why can I not make VBA Excel write me the date I put in the code, rather it shows always 00/01/1900 pls? See I wrote a short code that fills in the woorkbook (sheet), the date (any date) as a responce to a week number. The problem is that the code is only returning one single meaningless value of...

    Biggener5 pointsBadges:
  • Can ACCESS forms be used in EXCEL?

    Can forms created in ACCESS be used in EXCEL (via VBA)

    Jgenterprises10 pointsBadges:
  • Add functioning checkbox or radio button in PowerPoint 2007

    I have a "form" developed in PPT that different people will have to complete to then turn it into a full presentation. One part requires them to select Yes or No for impacting something. I would like a drop down for this but, I don't know how to do VBA code. Can I do a checkbox or radio button...

    Smitstwins5 pointsBadges:
  • Excel 2007 macros

    In Excel 2007: How to make current time/date (static) populate active cell when command button is clicked?

    Mcvla5 pointsBadges:
  • Printing File Dump Path in Visual basic

    How do i write a macro for a PDF print file to be printed to a folder path?

    Bogsy10 pointsBadges:
  • Combo Box Selection Locks Form

    I have a combo box that locks/corrupts all of the controls on a Access 2003 form.  The locking symptom only seems to occur when the list index is greater than 0. The problem control may not be the combo box.  It may be one of two list boxes that are affected by the combo box's 'after update'...

    McNitro255 pointsBadges:
  • SAP Macro

    I have a bunch of data that i need to get out of SAP and put it into a Excel spreadsheet daily. i need to look up the hours on several different parts and operations. is it possible for me to writed a VBA program that will call a SAP macro give that macro data and export run the report and...

    Jtgibson215 pointsBadges:
  • VBA Code for adding a day 14 days after a template is opened in Word 2003

    Hi, I have been asked to create a Word template (2003)that is held ona network drive and will be accessed by numerous employees as a .DOC file. The template has three date fields in the text. The three fields need to have a date that is 14 days after the template is opened as a .DOC. I have a VBA...

    Ianmax4975 pointsBadges:
  • tutorials

    hi all. i wanted to ask if anyone knows any sites where i can download free ebooks or free tutorials. thx.

    Mmm5550 pointsBadges:
  • Edit a text file with VBA

    Cheers, I have large text file that needs to be edited to run a job but I would like to automate the process.  How do I open a file and replace line 132 of (which is about mid of the file) that file? Thanks, Bob

    Rjwilcox45 pointsBadges:
  • Create SQL statement in VBA Access 2007

    How can I create a select Group BY SQL statement inside a VBA module? I've ran actions queries and they seem to take an effect in my tables but I'm having a difficult time creating a Select statement. Please display a couple of samples

    Bostic8620 pointsBadges:
  • ID_NO INCREASE VBA ACCESS 2007

    PLEASE TELL ME HOW TO INCREASE ID_NO THROUGH VBA CODE IN ACCESS 2007

    AnandaDebnath280 pointsBadges:
  • Access VBA Code stops at Midnight

    Why do all my Access VBA scipts stop at Midnight?

    Robert19735 pointsBadges:
  • Web services for windows 7

    Currently I have excel .xla addin with a macro that was created by the Microsoft Office 2003 Web Services Toolkit.  Works fine with XP and Excel 2003.  Now some users in office have Windows 7 and Excel 2003 and I have to remove the references to the mssoap30.dll and msxml6.dll in order to have...

    Smf170 pointsBadges:
  • VBA Excel – paste not working

    I have the following piece of code attached to my Excel worksheet:         ActiveSheet.Shapes("Object 407").Select         Selection.Copy         Range("BP106").Select         ActiveSheet.Paste The code is activated by making a choice in a drop down in the worksheet. ...

    Paustin5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following