Macros and Programming
There is virtually no limit to the things that can be done with macros and VBScript. This forum is a place for Cardbox users to post macros they have found useful, to share their experiences and ask each other's advice.
You can go into any topic by clicking on its title.
If you want to receive an automatic email every time a topic or message is added to this forum, click on Email Alerts.
the macro loop for two linked databases will stop, when a keyword is missing
|2||herman.cbx||21-Jun-2017 13:21 by herman.cbx|
how to make a macro that executes two or three macros ?
|1||TB||2-May-2016 16:29 by bert|
How to duplicate Excel's NETWORKDAYS in Cardbox macros
|2||West Sussex Knowledge||6-Apr-2016 13:12 by West Sussex Knowledge|
Create new sheets based on unique names
|2||SammyJane||4-Mar-2016 13:31 by SammyJane|
opening a folder with variable name
|9||greenkeeper||27-Jan-2016 13:38 by greenkeeper|
Images.Count does not recognise all the image fields in a record
|5||Dreckers||20-Jan-2016 15:35 by bert|
Macro to use a cell value to know how many rolls to copy from another worksheet
|1||cajunman64||27-Dec-2015 10:27 by bert|
Automatic addition of two field output into a third field
|19||greenkeeper||20-Nov-2015 10:24 by greenkeeper|
fault # 80040155
|1||Historisch Genootschap||15-Nov-2015 18:09 by bert|
|14||greenkeeper||29-Oct-2015 13:19 by greenkeeper|
IT Department cannot get the server version working ?
|4||Llewellyn||24-Sep-2015 21:48 by Llewellyn|
Display SelectionLevel on screen
|1||Llewellyn||10-Aug-2015 09:31 by bert|
I need help linking specific dates entered to specific worksheets
|1||hrbhd7||9-Jul-2015 11:37 by bert|
|2||Mary Doyle||13-Jun-2015 09:00 by Mary Doyle|
|0||OLD GEEZER||21-May-2015 19:34 by OLD GEEZER|
|3||OLD GEEZER||1-Jun-2015 13:48 by herman.cbx|
|0||OLD GEEZER||21-May-2015 19:29 by OLD GEEZER|
|1||stuartsimms||24-Feb-2015 16:12 by bert|
Is it possible to avoid the Select event displaying white error screen if search is false
|3||cristoayre||16-Feb-2015 12:49 by bert|
The macro that should start with Cardbox cannot be found, yet plays OK from Window
|1||cristoayre||12-Feb-2015 16:31 by bert|
How to get the data back from an external VBScript
|7||cristoayre||8-Feb-2015 19:01 by cristoayre|
Extracting Data From Another Excel Workbook (Auto populating)
|1||tckelley85||24-Dec-2014 18:29 by bert|
|2||Dubs||11-Dec-2014 16:23 by Dubs|
|3||BillyGoat||3-Dec-2014 08:47 by BillyGoat|
Is there any way of obtaining a list of the profiles in a database or triggering an error handling routine in the macro?
|2||Keith1||2-Nov-2014 09:20 by Keith1|
How to make WritetoBytes work
|6||Charles Welling||7-Aug-2014 08:50 by bert|
Macro that would allow you to enter a Folder name which is numbered and then save it to that folder.
|2||ace83||18-Mar-2014 20:06 by Thomas G Walsh|
|3||RickStewart||24-Feb-2014 10:17 by bert|
|3||Chris H||24-Feb-2014 07:36 by RickStewart|
I like to do a Boolean selection from two different fields
|1||herman.cbx||2-Jan-2014 14:14 by bert|
|7||PeterD||20-Dec-2013 08:39 by Mary Doyle|
|6||PeterD||8-Nov-2013 09:14 by PeterD|
I am trying to combine two macros into one, the first opens the print requester and the second saves and clears the input form of the data that has just gone to print.
|1||Andytymeiz||15-Jul-2013 13:24 by stuartsimms|
|1||SeaCraft||25-Jun-2013 13:02 by bert|
|4||stuartsimms||11-Jun-2013 08:49 by stuartsimms|
Need to create a Macro to enable me to send a Format Page via Outlook. CASH PAID FOR HELP!!!
|1||NickBick||3-Apr-2013 15:17 by stuartsimms|
|8||stuartsimms||22-Mar-2013 11:47 by bert|
|1||nickface||27-Jan-2013 21:16 by bert|
Trying to implement macro on help point 529
|5||stuartsimms||18-Dec-2012 20:47 by Charles Welling|
Looking for service provider and sample macro
|2||stuart||13-Dec-2012 10:39 by bert|
|1||smartsubbi||12-Nov-2012 18:54 by bert|
how to calculate the length of a plant
|3||herman.cbx||19-Oct-2012 10:20 by bert|
Is it possible to save images (pictures) from my Cardbox records to harddisk?
|4||herman.cbx||18-Oct-2012 12:16 by herman.cbx|
|3||pnasher||7-Sep-2012 17:03 by bert|
|2||Lynda-Marie||28-Aug-2012 15:19 by Lynda-Marie|
|3||Lynda-Marie||28-Aug-2012 15:33 by Jelly Belly|
Save as editable Wkbk based on cell selection, also PDF
|1||shootingstarz1225||26-Aug-2012 23:33 by bert|
Control over 'dial' command
|6||Satigny||6-Sep-2012 11:42 by bert|
|1||tonaya||20-Aug-2012 22:13 by bert|
|2||jury||8-Aug-2012 09:33 by bert|
Hi folks, i could really use some help.
|0||Paul T||20-Jul-2012 17:21 by Paul T|
|2||Woody123||22-Mar-2012 13:00 by Charles Welling|
Looking to insert fields to increment by 1 at each record
|3||Woody123||6-Mar-2012 09:52 by Woody123|
Is it poosibel to have a search with drop down box of common spelled words?
|1||Woody123||17-Feb-2012 10:50 by bert|
Button not finding macros
|2||Woody123||17-Feb-2012 09:51 by Woody123|
|2||gmacdaddy89||31-Jan-2012 20:26 by gmacdaddy89|
My Carbox mail-merge run macro fails worked well in WinXP, but fails in Win7
|6||mermayde||1-Nov-2011 12:55 by mermayde|
Bulk email command cannot open outlook.
|3||Voices4Wellbeing||11-Oct-2011 14:14 by Voices4Wellbeing|
|4||HB123||5-Oct-2011 10:27 by bert|
Copy macros from version 2.0 to version 3.0
|1||Omar||5-Sep-2011 17:06 by bert|
|5||TB||20-Aug-2011 20:23 by TB|
|2||TB||20-Aug-2011 13:11 by TB|
is there anyway of setting up a folder on a shared drive which can be added and saved via cardbox
|3||carercentresue||18-Aug-2011 12:44 by bert|
Macro needed to open a mail merge using an existing document.
|0||Voices4Wellbeing||4-Aug-2011 13:24 by Voices4Wellbeing|
I need to be able to attach a document to a bulk email from cardbox.
|20||Voices4Wellbeing||22-Aug-2011 09:34 by Voices4Wellbeing|
Asking for a way to create a relational Database in CardBox wich allows to insert new records in one table, related with records from another one.
|1||Charo||15-Jul-2011 07:10 by bert|
I am trying to take the value of one field and copy it into another field.
|0||Woody123||18-Apr-2011 12:03 by Woody123|
Button not working
|9||Woody123||14-Jan-2011 10:49 by Woody123|
adding today's date to a field without deleting the existing text
|6||TB||8-Jan-2011 10:05 by bert|
...but I have play, pause and stop buttons.
|3||Voices4Wellbeing||27-Oct-2010 09:17 by Voices4Wellbeing|
...and adding fields into it.
|8||Voices4Wellbeing||27-Oct-2010 11:21 by Voices4Wellbeing|
Macro only processing first item in an array when subroutines are called
|3||Mary Doyle (DAF)||11-Oct-2010 11:14 by Mary Doyle (DAF)|
Drop Down list filtered by previous choice - Is this possible?
|1||Jelly Belly||21-Sep-2010 11:49 by bert|
|4||Nickc108||26-Jul-2010 15:45 by bert|
How can I add 21 days to a date?
|13||22-Aug-2011 19:16 by bert|
|5||mandlg||16-Aug-2010 03:42 by jason|
A quick way of using Cardbox's powerful search capabilities.
|3||Jelly Belly||17-Jun-2015 12:07 by bert|
|1||Helen||12-Jan-2010 17:03 by bert|
A Simple Macro to switch between open windows in Cardbox
|5||Jelly Belly||7-Dec-2009 09:23 by Charles Welling|
|1||SHopkin||27-Nov-2009 12:41 by bert|
How many Image fields can I use?
|2||Jelly Belly||12-Nov-2009 15:57 by Jelly Belly|
|4||SHopkin||11-Nov-2009 11:33 by SHopkin|
Small macro to edit fields full-screen.
|1||Charles Welling||1-Nov-2009 19:15 by Charles Welling|
|1||looby||29-Oct-2009 09:41 by Charles Welling|
|0||muruganad||28-Oct-2009 05:47 by muruganad|
|1||Ruud||9-Sep-2009 12:38 by bert|
How to automatically sum all cells next to a cell that has "TOTAL" as text.
|0||gabe17||18-Jun-2009 14:54 by gabe17|
Thanks to Bert and Charles for all their help last week. I am now trying to write a macro with the same result but for one record only.
|2||Helen||20-Apr-2009 12:37 by Helen|
Need to total numbers contained in a series of fields, both for one record only and for a selection of records.
|8||Helen||26-Mar-2009 14:09 by Helen|
UpgradeFractals.cbs stops and gives an error message: advice requested
|1||Christopher_Spry||9-Mar-2009 22:03 by Christopher_Spry|
When I try to export cardbox to excel all the information for each record appears on one line.
|4||fastank||31-Jan-2009 21:45 by bert|
I need Cardbox to count how many records match a search, and put this number in a field.
|16||Voices4Wellbeing||16-Aug-2010 09:20 by bert|
Is it possible to search from a web (intranet) based form/interface?
|10||colm_c||16-Mar-2009 19:47 by bert|
Open existing excel doc
|5||JPARM||14-Nov-2008 11:24 by JPARM|
I need a macro to copy the post code field, open IE, go to www.multimap.com and search for that post code.
|10||Voices4Wellbeing||5-Aug-2011 10:15 by Voices4Wellbeing|
|2||Yvette Waard||28-Oct-2008 23:31 by Mary Doyle|
Macroscript to change a selection of records that match a field of all record in another database.
|2||Saskia Leefsma||8-Oct-2008 07:51 by Saskia Leefsma|
i need help to write a macro to insert a new row after a break in a number sequence
|1||TALON123||9-Oct-2008 14:10 by Charles Welling|
Trying to make my job easier.
|0||Lonewolf187||18-Aug-2008 22:18 by Lonewolf187|
How do I insert a new page command in a record
|1||dogsbody||15-Aug-2008 16:49 by bert|
|8||Mary Doyle (DAF)||29-Jul-2008 22:38 by Mary Doyle|
How do I configure mailto: in Cardbox to open gmail rather than Outlook to compose an email?
|1||Christopher Spry||20-Jul-2008 19:23 by bert|
Use MS Office speller in Cardbox using a macro
|0||bert||9-Jun-2008 10:10 by bert|
|1||chochato||12-May-2008 12:45 by Charles Welling|
|0||adminfreelance||5-Mar-2008 07:45 by adminfreelance|
|0||Charles Welling||10-Oct-2007 15:13 by Charles Welling|
Has anyone written a macro that will convert a 10 digit isbn field to a new 13 digit isbn field?
|10||Alysoun||29-Nov-2007 03:41 by MRB|
|2||Sander||13-Jul-2007 03:52 by Tom Hark|
Macro for researching into several files
|8||Nadjan||11-May-2007 18:57 by Charles Welling|
How can I appply keyboard shortcuts to client machines? I have tried coping the workspace to the server but that doe snot see to have done anything.
|1||.Mark||21-Apr-2007 11:16 by Charles Welling|
Transferring data between Access and Cardbox
|0||UKExporters||19-Apr-2007 08:01 by UKExporters|
....why does now of the macros appear or work.
|4||.Mark||22-Feb-2008 23:20 by Satigny|
|1||DLROI||22-Feb-2007 20:00 by Mary Doyle|
Linkage between 2 sheets in excel
|0||Geetika Arora||13-Feb-2007 13:20 by Geetika Arora|
Test date dans un Input
|1||CDP-Nivelles||27-Oct-2006 14:03 by Charles Welling|
Boucle fin de fichier
|1||CDP-Nivelles||12-Oct-2006 13:35 by Charles Welling|
I need to copy and paste a particular field when the file is saved.
|1||jackrabbit181||11-Oct-2006 15:34 by Charles Welling|
Macro to allow you to print 2 database records both containing a unique reference number, via a pushbutton
|1||Alpha||6-Oct-2006 15:43 by Charles Welling|
|1||jenr1182||6-Oct-2006 15:32 by Charles Welling|
|5||Charles Welling||25-Sep-2006 10:33 by Charles Welling|
|4||CDP-Nivelles||16-Sep-2006 21:12 by Charles Welling|
pick dates from a calendar
|3||Charles Welling||4-Sep-2006 11:58 by Mary Doyle (DAF)|
Problem on Access On Error GoTo
|3||menbere||25-Jul-2006 11:26 by Paul Irvine|
|4||Jamie||28-Jul-2006 09:50 by bert|
|0||CDP-Nivelles||29-Jun-2006 08:22 by CDP-Nivelles|
|1||CDP-Nivelles||30-Jun-2006 08:39 by Charles Welling|
|1||CDP-Nivelles||24-Jun-2006 14:59 by Charles Welling|
|1||CDP-Nivelles||24-Jun-2006 15:05 by Charles Welling|
Labels... with cardbox 3.0
|1||CDP-Nivelles||20-Jun-2006 11:14 by Charles Welling|
problème....erreur (je ne vois pas ou ????)
|4||CDP-Nivelles||20-Jun-2006 06:38 by Mary Doyle|
Problème de sécurité
|2||CDP-Nivelles||19-Jun-2006 12:13 by CDP-Nivelles|
|4||Jamie||15-Jun-2006 12:47 by Charles Welling|
|1||CDP-Nivelles||8-Jun-2006 15:05 by Charles Welling|
Mise en forme avec des soulignements...
|1||CDP-Nivelles||6-Jun-2006 12:48 by Charles Welling|
how to connect a cardbox database from java language
|0||benoit||2-Jun-2006 12:54 by benoit|
Test fichier ouvert
|2||CDP-Nivelles||28-Jun-2006 07:07 by CDP-Nivelles|
envoie une valeur à une macro
|1||CDP-Nivelles||26-May-2006 12:37 by Charles Welling|
Compter le nombre de mot
|1||CDP-Nivelles||25-May-2006 09:29 by Charles Welling|
InputBox Help me
|1||CDP-Nivelles||22-May-2006 08:00 by Charles Welling|
|5||SHopkin||10-Dec-2007 08:59 by Charles Welling|
printer variable in the format
|1||CDP-Nivelles||22-May-2006 07:30 by Charles Welling|
|1||CDP-Nivelles||18-May-2006 13:19 by bert|
|1||CDP-Nivelles||25-Apr-2006 08:42 by cardboss|
We hope we've eliminated an obscure nexus of bugs but we'd like you to test.
|2||cardboss||25-Apr-2006 17:35 by bert|
|1||Charles Welling||24-Apr-2006 10:58 by cardboss|
|2||mjprog||28-Oct-2009 05:43 by muruganad|
|1||mjprog||24-Mar-2006 09:31 by Charles Welling|
Does anyone know what the code would look like if you wanted to search for null values in a field?
|1||mjprog||24-Mar-2006 09:14 by Charles Welling|
Does anyone have a macro written that will either calculate an age on 1 record or all records.
|7||TF||22-Feb-2011 23:00 by Mary Doyle|
We're making a list of people able to give help with Cardbox macros.
|5||cardboss||22-Mar-2006 00:06 by Alex Maines|
|1||mjprog||8-Mar-2006 19:18 by cardboss|
|0||mjprog||6-Mar-2006 11:48 by mjprog|
|1||mjprog||19-Mar-2006 15:12 by Charles Welling|
Suggestions on how an audit log would be created in Cardbox
|0||mjprog||6-Mar-2006 11:03 by mjprog|
How do I get cardbox to add 6 months to a date already in a field, then input this to another field?
|2||batnip||8-Nov-2005 14:33 by batnip|
The update concerned may be KB896688.
|1||cardboss||6-Jan-2006 23:49 by R. Woodhouse|
How can I make a birthday calender
|1||amidatrust||7-Nov-2005 09:10 by Charles Welling|
|1||Herman B||23-Aug-2005 18:01 by Paul Irvine|
Does anyone know how to make a newly added Special Menu visible for other users?
|3||Mara Gerritsen||10-Oct-2005 14:38 by cardboss|
|1||jaap van Tuyl||22-May-2005 20:28 by bert|
Has anyone suggestions about how to make macros that do not run when somebody else is editing a record.
|4||Charles Welling||6-May-2005 20:09 by Charles Welling|
An alternative to explicitly copying the definitions of Cardbox constants when writing Windows Scripting Host scripts.
|0||cardboss||26-Apr-2005 17:35 by cardboss|
Here is an example of a script accessible from Windows that opens Cardbox, performs some commands, and closes it again, all without any user intervention.
|0||cardboss||26-Apr-2005 08:07 by cardboss|
Macro that allows you to send a SMS message to a mobile phone. The mobile number is stored in the "MOBILE" field.
|3||Paul Irvine||30-Nov-2011 09:58 by Charles Welling|