Cardbox > Forums > Macros and Programming
Macros and Programming
Current user: [none]
Register / Log In ·
Email Alerts ·
Help
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.
Topic | Replies | Originator | Last Post |
---|---|---|---|
in edit mode jump back to field after savingHas anyone an idea how to make a macro that remembers the field that you just left after saving | 3 | herman.cbx | 23-Dec-2017 12:10 by Charles Welling |
loop problemsthe macro loop for two linked databases will stop, when a keyword is missing | 2 | herman.cbx | 21-Jun-2017 13:21 by herman.cbx |
nested macroshow to make a macro that executes two or three macros ? | 1 | TB | 2-May-2016 16:29 by bert |
Calculating elapsed workdaysHow to duplicate Excel's NETWORKDAYS in Cardbox macros | 2 | West Sussex Knowledge | 6-Apr-2016 13:12 by West Sussex Knowledge |
Help writing MacroCreate new sheets based on unique names | 2 | SammyJane | 4-Mar-2016 13:31 by SammyJane |
variable foldersopening a folder with variable name | 9 | greenkeeper | 27-Jan-2016 13:38 by greenkeeper |
Missing a image field on exportImages.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 worksheetMacro 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 fieldAutomatic addition of two field output into a third field | 19 | greenkeeper | 20-Nov-2015 10:24 by greenkeeper |
Windows10fault # 80040155 | 1 | Historisch Genootschap | 15-Nov-2015 18:09 by bert |
postcode macro across multiple records | 14 | greenkeeper | 29-Oct-2015 13:19 by greenkeeper |
Cardbox ServerIT Department cannot get the server version working ? | 4 | Llewellyn | 24-Sep-2015 21:48 by Llewellyn |
Display SelectionLevel on screenDisplay SelectionLevel on screen | 1 | Llewellyn | 10-Aug-2015 09:31 by bert |
Data entry automation with datesI need help linking specific dates entered to specific worksheets | 1 | hrbhd7 | 9-Jul-2015 11:37 by bert |
Sort Cardbox database using external program | 2 | Mary Doyle | 13-Jun-2015 09:00 by Mary Doyle |
Edit or Delete Duplicate Topic | 0 | OLD GEEZER | 21-May-2015 19:34 by OLD GEEZER |
Launch a Macro with a Radio Button in a Record (or field) | 3 | OLD GEEZER | 1-Jun-2015 13:48 by herman.cbx |
Launch a Macro with a Radio Button in a Record (or field) | 0 | OLD GEEZER | 21-May-2015 19:29 by OLD GEEZER |
Error messages not displaying | 4 | stuartsimms | 28-Mar-2018 23:59 by Justin G |
Avoiding search "White Wall"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 |
Startup macro problemThe macro that should start with Cardbox cannot be found, yet plays OK from Window | 1 | cristoayre | 12-Feb-2015 16:31 by bert |
Returning value from extrenal VBScriptHow to get the data back from an external VBScript | 7 | cristoayre | 8-Feb-2015 19:01 by cristoayre |
Extract Data From Another Excel WorkbookExtracting Data From Another Excel Workbook (Auto populating) | 1 | tckelley85 | 24-Dec-2014 18:29 by bert |
Unique ID per record using cardbox.interop.dll | 2 | Dubs | 11-Dec-2014 16:23 by Dubs |
How would I send a copy of a cardbox database to a non-cardbox user? | 3 | BillyGoat | 3-Dec-2014 08:47 by BillyGoat |
ProfilesIs 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 |
WritetoBytesHow to make WritetoBytes work | 6 | Charles Welling | 7-Aug-2014 08:50 by bert |
Macro to save to different locationsMacro 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 |
macro to lookup data and delete row containing that data | 3 | RickStewart | 24-Feb-2014 10:17 by bert |
Using contents of fields as look-up table for entry into other fields | 3 | Chris H | 24-Feb-2014 07:36 by RickStewart |
Boolean search in two fieldsI like to do a Boolean selection from two different fields | 1 | herman.cbx | 2-Jan-2014 14:14 by bert |
Blank Fields | 7 | PeterD | 20-Dec-2013 08:39 by Mary Doyle |
Date Search | 6 | PeterD | 8-Nov-2013 09:14 by PeterD |
Combining two macro'sI 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 |
Transferring Marcros to a new computer and Carbox 3.1 | 1 | SeaCraft | 25-Jun-2013 13:02 by bert |
Text hyperlinks in screen format | 4 | stuartsimms | 11-Jun-2013 08:49 by stuartsimms |
Sending Email Format via Outlook - CASH PAID FOR HELP!!!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 |
Cardbox fatal error when running macro | 8 | stuartsimms | 22-Mar-2013 11:47 by bert |
help with Macro | 1 | nickface | 27-Jan-2013 21:16 by bert |
Sending single email from Outlook 2003Trying to implement macro on help point 529 | 5 | stuartsimms | 18-Dec-2012 20:47 by Charles Welling |
Sending SMS from Cardbox macroLooking for service provider and sample macro | 2 | stuart | 13-Dec-2012 10:39 by bert |
Macro: Need to know the count of emails in a outlook folder and sort it for last 24 hours and 15 hours any help plx | 1 | smartsubbi | 12-Nov-2012 18:54 by bert |
calculation problemshow to calculate the length of a plant | 3 | herman.cbx | 19-Oct-2012 10:20 by bert |
macro to save pictures to diskIs it possible to save images (pictures) from my Cardbox records to harddisk? | 4 | herman.cbx | 18-Oct-2012 12:16 by herman.cbx |
Help converting Cardbox2 macro to Cardbox 3 | 3 | pnasher | 7-Sep-2012 17:03 by bert |
How do you put bullet points in macros? | 2 | Lynda-Marie | 28-Aug-2012 15:19 by Lynda-Marie |
Hyperlinks or Email Addresses in Macro | 3 | Lynda-Marie | 28-Aug-2012 15:33 by Jelly Belly |
Save as SelectionSave as editable Wkbk based on cell selection, also PDF | 1 | shootingstarz1225 | 26-Aug-2012 23:33 by bert |
Control of TAPI dialer programsControl over 'dial' command | 6 | Satigny | 6-Sep-2012 11:42 by bert |
Help with macros! | 1 | tonaya | 20-Aug-2012 22:13 by bert |
bulk email macro not filling in To: field | 2 | jury | 8-Aug-2012 09:33 by bert |
MacrosHi folks, i could really use some help. | 0 | Paul T | 20-Jul-2012 17:21 by Paul T |
Search over multiple databses | 2 | Woody123 | 22-Mar-2012 13:00 by Charles Welling |
Incremental NumberingLooking to insert fields to increment by 1 at each record | 3 | Woody123 | 6-Mar-2012 09:52 by Woody123 |
Search Macro with spelling dictionaryIs it poosibel to have a search with drop down box of common spelled words? | 1 | Woody123 | 17-Feb-2012 10:50 by bert |
Macros missingButton not finding macros | 2 | Woody123 | 17-Feb-2012 09:51 by Woody123 |
New to Macros...Need Help! | 2 | gmacdaddy89 | 31-Jan-2012 20:26 by gmacdaddy89 |
Mail-merge macro fails in Win7My Carbox mail-merge run macro fails worked well in WinXP, but fails in Win7 | 6 | mermayde | 1-Nov-2011 12:55 by mermayde |
Macro Works on Some Machines, but Not on OthersBulk email command cannot open outlook. | 3 | Voices4Wellbeing | 11-Oct-2011 14:14 by Voices4Wellbeing |
HELP with writing a MACROMACRO | 4 | HB123 | 5-Oct-2011 10:27 by bert |
Transfer Cardbox 2.0 macros to Cardbox 3.0Copy macros from version 2.0 to version 3.0 | 1 | Omar | 5-Sep-2011 17:06 by bert |
changing date and time to -12 h (astronomy!) | 5 | TB | 20-Aug-2011 20:23 by TB |
macro to change state of checkbox | 2 | TB | 20-Aug-2011 13:11 by TB |
adding client folder to cardboxis 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 |
Mail Merge to Existing DocumentMacro needed to open a mail merge using an existing document. | 0 | Voices4Wellbeing | 4-Aug-2011 13:24 by Voices4Wellbeing |
Attaching Documents to Bulk EmailI need to be able to attach a document to a bulk email from cardbox. | 20 | Voices4Wellbeing | 22-Aug-2011 09:34 by Voices4Wellbeing |
Relational DataBasesAsking 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 |
Copy and paste from fieldsI am trying to take the value of one field and copy it into another field. | 0 | Woody123 | 18-Apr-2011 12:03 by Woody123 |
Macro Button Help!Button not working | 9 | Woody123 | 14-Jan-2011 10:49 by Woody123 |
adding today's dateadding today's date to a field without deleting the existing text | 6 | TB | 8-Jan-2011 10:05 by bert |
No 'Record Macro' button......but I have play, pause and stop buttons. | 3 | Voices4Wellbeing | 27-Oct-2010 09:17 by Voices4Wellbeing |
Opening an Existing Word Document...and adding fields into it. | 8 | Voices4Wellbeing | 27-Oct-2010 11:21 by Voices4Wellbeing |
Problem processing array calling subroutinesMacro 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 FilteringDrop Down list filtered by previous choice - Is this possible? | 1 | Jelly Belly | 21-Sep-2010 11:49 by bert |
Check if database open, if not then open it, if open then next step | 4 | Nickc108 | 26-Jul-2010 15:45 by bert |
Adding 21 days to a dateHow can I add 21 days to a date? | 13 | 22-Aug-2011 19:16 by bert | |
Function keys to run macros | 5 | mandlg | 16-Aug-2010 03:42 by jason |
Quick Search MacroA quick way of using Cardbox's powerful search capabilities. | 3 | Jelly Belly | 17-Jun-2015 12:07 by bert |
adding file attachments to bulk emails | 1 | Helen | 12-Jan-2010 17:03 by bert |
Switching between windows in CardboxA Simple Macro to switch between open windows in Cardbox | 5 | Jelly Belly | 7-Dec-2009 09:23 by Charles Welling |
Cardbox Capabilities ? | 1 | SHopkin | 27-Nov-2009 12:41 by bert |
Image Fields in Build 4285How many Image fields can I use? | 2 | Jelly Belly | 12-Nov-2009 15:57 by Jelly Belly |
Help with MACRO | 4 | SHopkin | 11-Nov-2009 11:33 by SHopkin |
Edit a field using Extra TextSmall macro to edit fields full-screen. | 1 | Charles Welling | 1-Nov-2009 19:15 by Charles Welling |
pop up list of codes | 1 | looby | 29-Oct-2009 09:41 by Charles Welling |
How to Set the default value of a drop down list. | 0 | muruganad | 28-Oct-2009 05:47 by muruganad |
How do I sort on the last word in a field? | 1 | Ruud | 9-Sep-2009 12:38 by bert |
Sum cell values to the right of "TOTAL"How to automatically sum all cells next to a cell that has "TOTAL" as text. | 0 | gabe17 | 18-Jun-2009 14:54 by gabe17 |
Macro for adding field totals in one record onlyThanks 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 |
Macro for adding field totals.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 |
Macro fails trying to convert fractal images in a CB databaseUpgradeFractals.cbs stops and gives an error message: advice requested | 1 | Christopher_Spry | 9-Mar-2009 22:03 by Christopher_Spry |
Problem Exporting Cardbox to ExcelWhen 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 |
Counting the Number of RecordsI 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 |
Search from web interface?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 using a macro buttonOpen existing excel doc | 5 | JPARM | 14-Nov-2008 11:24 by JPARM |
Opening up an internet mapI 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 |
calculating in macro's | 2 | Yvette Waard | 28-Oct-2008 23:31 by Mary Doyle |
batch updates in relational searchMacroscript 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 |
insert a new row after a break in a number sequencei 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 |
System Idle and variable addition scriptingTrying to make my job easier. | 0 | Lonewolf187 | 18-Aug-2008 22:18 by Lonewolf187 |
New page command in formatHow do I insert a new page command in a record | 1 | dogsbody | 15-Aug-2008 16:49 by bert |
Using Internet Explorer for Cardbox message - how to give focus to IE window | 8 | Mary Doyle (DAF) | 29-Jul-2008 22:38 by Mary Doyle |
mailto: to use gmailHow 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 |
Speller in CardboxUse MS Office speller in Cardbox using a macro | 0 | bert | 9-Jun-2008 10:10 by bert |
Needing help with autofill macro.. | 1 | chochato | 12-May-2008 12:45 by Charles Welling |
Freelance.eu outsource your programming and webdesign projects | 0 | adminfreelance | 5-Mar-2008 07:45 by adminfreelance |
pick a name for email | 0 | Charles Welling | 10-Oct-2007 15:13 by Charles Welling |
Macro for conversion of isbn 10 to 13Has 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 |
How to convert cardbox database to excel for editting/copying? | 2 | Sander | 13-Jul-2007 03:52 by Tom Hark |
Interface macroMacro for researching into several files | 8 | Nadjan | 11-May-2007 18:57 by Charles Welling |
Keyboard ShortcutsHow 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 |
Automating CardboxTransferring data between Access and Cardbox | 0 | UKExporters | 19-Apr-2007 08:01 by UKExporters |
Upgrading from Version 2.0 to verison 3.0........why does now of the macros appear or work. | 4 | .Mark | 22-Feb-2008 23:20 by Satigny |
Totalling fields when editing a record (some fields are empty) | 1 | DLROI | 22-Feb-2007 20:00 by Mary Doyle |
AutomateLinkage between 2 sheets in excel | 0 | Geetika Arora | 13-Feb-2007 13:20 by Geetika Arora |
Test date dans champ inputTest date dans un Input | 1 | CDP-Nivelles | 27-Oct-2006 14:03 by Charles Welling |
Boucle ???Boucle fin de fichier | 1 | CDP-Nivelles | 12-Oct-2006 13:35 by Charles Welling |
Macro for 'On Save'I need to copy and paste a particular field when the file is saved. | 1 | jackrabbit181 | 11-Oct-2006 15:34 by Charles Welling |
Printing 2 Database records with a pushbuttonMacro 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 |
phone number macros | 1 | jenr1182 | 6-Oct-2006 15:32 by Charles Welling |
Test for presence of field | 5 | Charles Welling | 25-Sep-2006 10:33 by Charles Welling |
Espace entre mot | 4 | CDP-Nivelles | 16-Sep-2006 21:12 by Charles Welling |
date utilitypick dates from a calendar | 3 | Charles Welling | 4-Sep-2006 11:58 by Mary Doyle (DAF) |
Access On Error GoToProblem on Access On Error GoTo | 3 | menbere | 25-Jul-2006 11:26 by Paul Irvine |
How to macro 'New Window'? | 4 | Jamie | 28-Jul-2006 09:50 by bert |
Test fichier urgenttest fichier | 0 | CDP-Nivelles | 29-Jun-2006 08:22 by CDP-Nivelles |
ouverture fichier avec mot de passeouverture fichier... | 1 | CDP-Nivelles | 30-Jun-2006 08:39 by Charles Welling |
sos macrosos macro | 1 | CDP-Nivelles | 24-Jun-2006 14:59 by Charles Welling |
SELECT CASEselect case | 1 | CDP-Nivelles | 24-Jun-2006 15:05 by Charles Welling |
Labels... version cardbox 3.0Labels... with cardbox 3.0 | 1 | CDP-Nivelles | 20-Jun-2006 11:14 by Charles Welling |
problème....erreurproblème....erreur (je ne vois pas ou ????) | 4 | CDP-Nivelles | 20-Jun-2006 06:38 by Mary Doyle |
Problème de sécurité avec un fichierProblème de sécurité | 2 | CDP-Nivelles | 19-Jun-2006 12:13 by CDP-Nivelles |
Complex Database | 4 | Jamie | 15-Jun-2006 12:47 by Charles Welling |
effacer un fichiereffacement fichier | 1 | CDP-Nivelles | 8-Jun-2006 15:05 by Charles Welling |
METTRE DES SOULIGNEMENTS...Mise en forme avec des soulignements... | 1 | CDP-Nivelles | 6-Jun-2006 12:48 by Charles Welling |
cardbox from javahow to connect a cardbox database from java language | 0 | benoit | 2-Jun-2006 12:54 by benoit |
Test fichier ouvertTest fichier ouvert | 2 | CDP-Nivelles | 28-Jun-2006 07:07 by CDP-Nivelles |
envoyer une valeur à une macro ???envoie une valeur à une macro | 1 | CDP-Nivelles | 26-May-2006 12:37 by Charles Welling |
Compter le nombre de mot dans un champ (computer a number of word in the field)Compter le nombre de mot | 1 | CDP-Nivelles | 25-May-2006 09:29 by Charles Welling |
InputBox HelpInputBox Help me | 1 | CDP-Nivelles | 22-May-2006 08:00 by Charles Welling |
Opening Word using a Macro in Cardbox | 5 | SHopkin | 10-Dec-2007 08:59 by Charles Welling |
Format printer variableprinter variable in the format | 1 | CDP-Nivelles | 22-May-2006 07:30 by Charles Welling |
Format decimalFormat decimal | 1 | CDP-Nivelles | 18-May-2006 13:19 by bert |
error calculationError calculation | 1 | CDP-Nivelles | 25-Apr-2006 08:42 by cardboss |
Help wanted in testingWe 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 |
AddRecipient | 1 | Charles Welling | 24-Apr-2006 10:58 by cardboss |
Set Default values for drop down lists and option groups | 2 | mjprog | 28-Oct-2009 05:43 by muruganad |
Searching in a particular format | 1 | mjprog | 24-Mar-2006 09:31 by Charles Welling |
Searching for NullDoes 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 |
Calculating AgeDoes 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 |
Macro helpers wantedWe're making a list of people able to give help with Cardbox macros. | 5 | cardboss | 22-Mar-2006 00:06 by Alex Maines |
Creating a user interface | 1 | mjprog | 8-Mar-2006 19:18 by cardboss |
Printing from more than one database | 0 | mjprog | 6-Mar-2006 11:48 by mjprog |
Searching and Positioning of database windows | 1 | mjprog | 19-Mar-2006 15:12 by Charles Welling |
Audit LogSuggestions on how an audit log would be created in Cardbox | 0 | mjprog | 6-Mar-2006 11:03 by mjprog |
Cardbox & DatesHow 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 |
WARNING: latest Windows Update may cause Cardbox macros to stop workingThe update concerned may be KB896688. | 1 | cardboss | 6-Jan-2006 23:49 by R. Woodhouse |
making a birthday calenderHow can I make a birthday calender | 1 | amidatrust | 7-Nov-2005 09:10 by Charles Welling |
Checking for already opened database | 1 | Herman B | 23-Aug-2005 18:01 by Paul Irvine |
Adding Special MenuDoes anyone know how to make a newly added Special Menu visible for other users? | 3 | Mara Gerritsen | 10-Oct-2005 14:38 by cardboss |
Simple macros | 1 | jaap van Tuyl | 22-May-2005 20:28 by bert |
Macros and editing of recordsHas 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 |
Windows Scripting Host and Cardbox constantsAn alternative to explicitly copying the definitions of Cardbox constants when writing Windows Scripting Host scripts. | 0 | cardboss | 26-Apr-2005 17:35 by cardboss |
Using Cardbox from outside CardboxHere 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 |
Sending SMS macroMacro 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 |