• how to create autonumber

    while press enter on cell (b1) the cell (a1)= 1 while press enter on cell (b2) the cell (a2)= 2 and so on i tried functions : =row() and =OFFSET(A2,-1,0)+1 i don't think its an autonumber because i used manualy so, hlp pls

    Army125 pointsBadges:
  • Access 2007: VB code to make a button press link to a specific record in another form

    The database is for a set of components. One of my forms shows details about each component on a separate record (the property "Default View" is Single Form). The other form is a list of all components by component number displayed all together (the property "Default View" is Continuous Forms). The...

    VinDibo5 pointsBadges:
  • Printer Orientation Control using VBA Code

    I want to print excel UserForms automatically using VBA proceedures.Some should print in Portrait and others in Landscape. How can I control the printer page orientation from VBA code?

    KingsITI50 pointsBadges:
  • “Automation Error Invalid Advise Tags” What is an advise tag?

    I have a visual basic module within Access that seems to compile fine; when I select the Debug function in the visual basic editor, I receive no errors or messages.  However, within my Access form, when I try to click the button associated with this module, I receive the error message, "Automation...

    Siggy5 pointsBadges:
  • DoCmd.OpenReport not working right with WHERE clause

    I have looked all over and seen hundreds of questions about this command, but no answers. It seems like the most basic thing you can do with combo boxes, so I'm baffled that it doesn't work. Here is my VBA Code: Option Compare Database Private Sub cboFundNumbers_AfterUpdate() Const strFormName As...

    Pubfin15 pointsBadges:
  • 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:

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