Barcode scanner that dumps into text file
Hi, I’m going to try to implement a barcode system to keep track of inventory. I was wondering if anyone can suggest the best handheld scanner to get that will let us scan several barcodes and then dump the scans into a text file? Or if anyone know of another better way to accomblish this. [...]
Answer Question
| April 1, 2009 6:26 PM
Barcode, Barcode Readers, Barcode scanners, Microsoft Access, VBA, Windows XP, Windows XP Professional
Hi, I’m going to try to implement a barcode system to keep track of inventory. I was wondering if anyone can suggest the best handheld scanner to get that will let us scan several barcodes and then dump the scans into a text file? Or if anyone know of another better way to accomblish this. [...]
Answer Question
| April 1, 2009 6:26 PM
Barcode, Barcode Readers, Barcode scanners, Microsoft Access, VBA, Windows XP, Windows XP Professional
Excel 2003 Help: How to delete duplicates from specific colums and criteria
Hi I have already sent my question here: http://www.vbforums.com/showthread.php?p=3477514#post3477514 But I will ask the same again: In my Excel file I have several columns and lots of rows. I want the macro to check the column named REF (let say it’s in the B column). And it will check if other data contains the exact [...]
Answer Question
| March 24, 2009 11:02 PM
Excel 2003 macros, Microsoft Excel 2003, Microsoft Excel 2003 macros, VBA, Visual Basic for Applications
Hi I have already sent my question here: http://www.vbforums.com/showthread.php?p=3477514#post3477514 But I will ask the same again: In my Excel file I have several columns and lots of rows. I want the macro to check the column named REF (let say it’s in the B column). And it will check if other data contains the exact [...]
Answer Question
| March 24, 2009 11:02 PM
Excel 2003 macros, Microsoft Excel 2003, Microsoft Excel 2003 macros, VBA, Visual Basic for Applications
Macro toolbar buttons
what format are they and how do i use them
Answer Question
| April 7, 2009 1:12 PM
Macro toolbar buttons, VBA, Visual Basic for Applications
what format are they and how do i use them
Answer Question
| April 7, 2009 1:12 PM
Macro toolbar buttons, VBA, Visual Basic for Applications
Application.FileSearch no longer exists (in 2007)
My company is migrating to Office 2007 – I have VBA code that works wonderfully in “older” versions of Access, but will not work in 2007. One in particular is “Application.FileSearch” – what can I use instead? (And why was it removed??)
Answer Question
| March 18, 2009 7:26 PM
Access 2007, Microsoft Access, Office 2007, VBA
My company is migrating to Office 2007 – I have VBA code that works wonderfully in “older” versions of Access, but will not work in 2007. One in particular is “Application.FileSearch” – what can I use instead? (And why was it removed??)
Answer Question
| March 18, 2009 7:26 PM
Access 2007, Microsoft Access, Office 2007, VBA
Visual Basic code
how to copy data to another sheet using visual basic
Answer Question
| March 27, 2009 9:19 PM
VBA, Visual Basic, Visual Basic for Applications
how to copy data to another sheet using visual basic
Answer Question
| March 27, 2009 9:19 PM
VBA, Visual Basic, Visual Basic for Applications
Need Help With Multiple Conditions and Constraints for Access 2007 VBA Event
Hi, I’m working with VBA for On Click Event procedures in Access 2007. My knowledge of Visual Basic is rudimentary and I’ve come against a business rule I can’t even begin to figure out how to code. I work at a college and was asked to build a database for a student conference we’re hosting. [...]
Answer Question
| March 17, 2009 4:11 PM
Access 2007, Microsoft Access, VBA, Visual Basic, Visual Basic for Applications
Hi, I’m working with VBA for On Click Event procedures in Access 2007. My knowledge of Visual Basic is rudimentary and I’ve come against a business rule I can’t even begin to figure out how to code. I work at a college and was asked to build a database for a student conference we’re hosting. [...]
Answer Question
| March 17, 2009 4:11 PM
Access 2007, Microsoft Access, VBA, Visual Basic, Visual Basic for Applications
Looping to create new workbooks using a set “transaction” number
I’m playing around a bit and can’t figure out why the following code does not save a total of 5 files in My Documents(default) The files should be named in a sequence of 1 – 5 (In my Excel spreadsheet (A1)=1 and (A4)=5) The code works once through, but when “.SaveAs Filename:=Start” comes back around [...]
Answer Question
| August 12, 2009 10:49 PM
Excel VBA, Excel workbooks, LOOP statement, Microsoft Excel 2003, Sequence number generation, VBA, Visual Basic for Applications
I’m playing around a bit and can’t figure out why the following code does not save a total of 5 files in My Documents(default) The files should be named in a sequence of 1 – 5 (In my Excel spreadsheet (A1)=1 and (A4)=5) The code works once through, but when “.SaveAs Filename:=Start” comes back around [...]
Answer Question
| August 12, 2009 10:49 PM
Excel VBA, Excel workbooks, LOOP statement, Microsoft Excel 2003, Sequence number generation, VBA, Visual Basic for Applications
MS Access Tools References…
Cheers, Does anyone know where I can get a list of what a specific reference in Access can do. Specifically, I have VB.NET code that Imports System.Web.mail that I would like to use in my vba code. I have had luck with similar .NET code: I used the reference Microsoft Excel 12.0 Object Library instead [...]
Answer Question
| March 4, 2009 5:38 PM
.NET, Microsoft Access, Microsoft Excel, Microsoft Office, VB.NET, VBA
Cheers, Does anyone know where I can get a list of what a specific reference in Access can do. Specifically, I have VB.NET code that Imports System.Web.mail that I would like to use in my vba code. I have had luck with similar .NET code: I used the reference Microsoft Excel 12.0 Object Library instead [...]
Answer Question
| March 4, 2009 5:38 PM
.NET, Microsoft Access, Microsoft Excel, Microsoft Office, VB.NET, VBA
How to convert VBA decimal DataTypes
I need to figure out how (if possible) to remove decimals from numerical data, and add zeroes to the front/back end of data so that I can concatenate several cells into a single strain. Ex: Actual value = 14.37, needs to be converted to 14370 Actual Value = 4.3, needs to be converted to 04300 [...]
Answer Question
| March 4, 2009 10:02 PM
Concatenate, DataType, VBA, VBA DataType
I need to figure out how (if possible) to remove decimals from numerical data, and add zeroes to the front/back end of data so that I can concatenate several cells into a single strain. Ex: Actual value = 14.37, needs to be converted to 14370 Actual Value = 4.3, needs to be converted to 04300 [...]
Answer Question
| March 4, 2009 10:02 PM
Concatenate, DataType, VBA, VBA DataType
Excel 2003 VBA drop down list and discontinuous ranges
I am attempting to populate a drop down list in excel using data validation and data contained in two discontinuous ranges. I have used the Union command in vba to create a named list which seems to correctly concatenate the two data ranges but when I validate the cell which is to contain the drop [...]
Answer Question
| February 27, 2009 3:43 PM
Excel 2003, Excel 2007, Microsoft Excel, VBA, VBA EXCEL 2003
I am attempting to populate a drop down list in excel using data validation and data contained in two discontinuous ranges. I have used the Union command in vba to create a named list which seems to correctly concatenate the two data ranges but when I validate the cell which is to contain the drop [...]
Answer Question
| February 27, 2009 3:43 PM
Excel 2003, Excel 2007, Microsoft Excel, VBA, VBA EXCEL 2003
Microsoft Access AutoNumber
Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as “Auto Number” and save the same it automatically gets changed to Text type.Please suggest.Also, the requirement is modified and now the serial number has to [...]
Answer Question
| February 25, 2009 12:01 PM
AutoNumber, Database programming, Microsoft Access, Microsoft Access auto increment, VBA
Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as “Auto Number” and save the same it automatically gets changed to Text type.Please suggest.Also, the requirement is modified and now the serial number has to [...]
Answer Question
| February 25, 2009 12:01 PM
AutoNumber, Database programming, Microsoft Access, Microsoft Access auto increment, VBA
Can any one correct this Microsoft Excel VBA code?
ANY ONE CORRECT THIS Sub fill_series() Dim myrange As Range Set myrange = ActiveCell.Offset(0, 5) Range(“N9″).FormulaR1C1 = “Apr-2008″ Range(“N9″).Select Selection.AutoFill Destination:=myrange, Type:=xlFillDefault End Sub
Answer Question
| February 22, 2010 9:47 AM
Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications
ANY ONE CORRECT THIS Sub fill_series() Dim myrange As Range Set myrange = ActiveCell.Offset(0, 5) Range(“N9″).FormulaR1C1 = “Apr-2008″ Range(“N9″).Select Selection.AutoFill Destination:=myrange, Type:=xlFillDefault End Sub
Answer Question
| February 22, 2010 9:47 AM
Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications
How to update data using Microsoft Excel VBA?
I HAVE A CELL “A1=NUMERIC VALUE” & “A2=NAME OF PARTY” WHICH IS UPDATED EVERY MONTH AND I WANT TO SAVE IT WITH “DATA” SHEET WITH EACH PARTY NAME(CELL A2) AND ITS MONTHWISE VALUE(CELL A2).HOW CREATE DATA SHEET WITH MONTHLY COLOUM NAME I.E : DATA SHEET: NAME OF PARTY APRIL08 MAY08 SURENDRA KUMAR AGRAWAL 25000 50000 [...]
Answer Question
| February 24, 2009 9:46 AM
Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications
I HAVE A CELL “A1=NUMERIC VALUE” & “A2=NAME OF PARTY” WHICH IS UPDATED EVERY MONTH AND I WANT TO SAVE IT WITH “DATA” SHEET WITH EACH PARTY NAME(CELL A2) AND ITS MONTHWISE VALUE(CELL A2).HOW CREATE DATA SHEET WITH MONTHLY COLOUM NAME I.E : DATA SHEET: NAME OF PARTY APRIL08 MAY08 SURENDRA KUMAR AGRAWAL 25000 50000 [...]
Answer Question
| February 24, 2009 9:46 AM
Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications
File referencing in vba
Hi All. I have a user form in Word that populates a doc, saves as a temp file, emails as attachment and then kills the temp file. I am worried that with momre than one user at any one time one person’s code might kill another person’s temp file before they have sent it. Any [...]
Answer Question
| February 12, 2009 3:58 PM
Microsoft Word, VBA, VBA Referencing
Hi All. I have a user form in Word that populates a doc, saves as a temp file, emails as attachment and then kills the temp file. I am worried that with momre than one user at any one time one person’s code might kill another person’s temp file before they have sent it. Any [...]
Answer Question
| February 12, 2009 3:58 PM
Microsoft Word, VBA, VBA Referencing
VBA/VB code to edit hyperlinks in PDF files
Hi, How do we read the content in a pdf file. I have some sample pdf where I have to edit already existing hyperlinks . Thanks in advance.
Answer Question
| February 21, 2012 12:16 PM
Hyperlinks, PDF, PDF hyperlinks, VBA, Visual Basic, Visual Basic for Applications
Hi, How do we read the content in a pdf file. I have some sample pdf where I have to edit already existing hyperlinks . Thanks in advance.
Answer Question
| February 21, 2012 12:16 PM
Hyperlinks, PDF, PDF hyperlinks, VBA, Visual Basic, Visual Basic for Applications
Outlook 2003: trim leading spaces from email subject with VBA macro
Hello, some email clients send emails with an extra leading space added to the subject. As a result message sorting on subject in outlook 2003 does not work correctly: these messages are considered to have a different subject and so the entire conversation is split in two seperate conversations, which is very annoying. I already [...]
Answer Question
| January 30, 2009 11:37 AM
Email, Email management, Macros, Outlook, Outlook 2003, VBA, Visual Basic for Applications
Hello, some email clients send emails with an extra leading space added to the subject. As a result message sorting on subject in outlook 2003 does not work correctly: these messages are considered to have a different subject and so the entire conversation is split in two seperate conversations, which is very annoying. I already [...]
Answer Question
| January 30, 2009 11:37 AM
Email, Email management, Macros, Outlook, Outlook 2003, VBA, Visual Basic for Applications
rolling average VBA code MS Access
Hi All Anyone know how to create a VBA function and or SQL statement which will work in Access to find the rolling average as per example below + see excel file for working example in excel. Should work for a unknown amount of records. Not an easy one I think . If it can [...]
Answer Question
| January 22, 2009 1:24 PM
Microsoft Access, MS Access VBA, VBA
Hi All Anyone know how to create a VBA function and or SQL statement which will work in Access to find the rolling average as per example below + see excel file for working example in excel. Should work for a unknown amount of records. Not an easy one I think . If it can [...]
Answer Question
| January 22, 2009 1:24 PM
Microsoft Access, MS Access VBA, VBA
Writing vertical data to a flat (unfortunately!) table
I have an application that I need to update (written by someone else) that requires that I take data from a nice, vertical table and write them into a pre-exisiting flat table. Column 1 of the vertical table is the PK for the flat table, while there are up to 35 entries that must be [...]
Answer Question
| December 15, 2008 8:34 PM
Access 2003, ADO, Microsoft Access, VBA, Vertical Data
I have an application that I need to update (written by someone else) that requires that I take data from a nice, vertical table and write them into a pre-exisiting flat table. Column 1 of the vertical table is the PK for the flat table, while there are up to 35 entries that must be [...]
Answer Question
| December 15, 2008 8:34 PM
Access 2003, ADO, Microsoft Access, VBA, Vertical Data
SpinButton linking to an occupied cell
Can a spin button be linked to the cell that it is located in? I have about 100 spin buttons that I need in this sheet and don’t want to individually link each one! Thanks!
Answer Question
| January 11, 2009 12:00 AM
SpinButton, Spreadsheets, VBA, Visual Basic for Applications
Can a spin button be linked to the cell that it is located in? I have about 100 spin buttons that I need in this sheet and don’t want to individually link each one! Thanks!
Answer Question
| January 11, 2009 12:00 AM
SpinButton, Spreadsheets, VBA, Visual Basic for Applications
VBA to print to specific printer with print button
In Access 2007 how do I use VBA code in my print button to print to a “specific printer” for my report.
Answer Question
| December 12, 2008 1:05 AM
Access 2007, Code, Microsoft Access, Microsoft Access 2007, VBA, Visual Basic for Applications
In Access 2007 how do I use VBA code in my print button to print to a “specific printer” for my report.
Answer Question
| December 12, 2008 1:05 AM
Access 2007, Code, Microsoft Access, Microsoft Access 2007, VBA, Visual Basic for Applications
