I have an access database. I am using a send email macro to automatically send an email when a condition exists, but I cannot reference a related field in a related table.
I keep getting a message in the log saying "The identifier '[tbl Job References].[YR Number]' could not be found."
Can this be done?
38 results in 0.0045 seconds.
-
Corwin Moyne started a topic How can I reference a related table when using a send email macro. Microsoft Access.in AccessHow can I reference a related table when using a send email macro. Microsoft Access.
-
Has the macro language of Excel changed since version 2002?
Has the macro language of Excel changed since its version 2002? If yes, where can I see a list of most important changes of its VBA?
TIA
Frank -
I want to make python script in abaqus 6.10
Hi all.
I try to make the python script with the macro.
As you know, the funtion of macro manager can record the every acticvity in python script. But this script work on the macro manager only. I want to make this script work on the run script menu.
The error message was done when I try to run the macro script.
Message says "C:/Temp/abaqusMacros.py :56: SyntaxWarning: import * only... -
Is there an elegant alternative in PHP for '#ifdef'
I'd like to use Macros to control what functions/variables are used in order to test my PHP file. But I know PHP doesn't do Macros, so what would someone suggsest is an elegant way to do this? The reason for having the macros is so I can easily switch between one themeID and another while still having full control over each theme! Please ignore the fact that I've used some C constructs and others PHP!
For instance:
...Code:#define
-
Bill Mochal started a topic VBA (Excel macro) Import Data From Webpage Error-handlingin Visual BasicVBA (Excel macro) Import Data From Webpage Error-handling
I have a VBA macro that imports data from a long (600+)series of web pages into an Excel 2007 workbook.
There are occasional errors each time the macro is run such as: "The Web query returned no data. To change the query... etc." or "Unable to open... etc."
When these occur, a dialouge box with an "OK" button pops up and the macro waits until I click OK.
I'm looking for a modification to... -
Automation error
Hello everyone I have this code but i keep getting Automation error. what Im tritng to accomplish is a marco that will copy worksheets into a summary and not remove the source in the orginal file
All my workbook have data all on sheet one all have the same headings all. and all in the same folder Someone please help...
Option Explicit
'Combine Workbooks
'By Tommy Miles
'This sample goes... -
Looping Marco thur url
Hello, I have create a marco that will go on a site and extract data. thru a web query.
I would like it to keep looping through the column that has all the urls. and stop at the last row containing a url...
SO....
Column K has the URLS starting at K2 these urls come in because a rss feed
...Code:Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+Shift+L ' With ActiveSheet.QueryTables.Add(Connection:=
-
Help with the "BrowseTo" command
I could use some help with the BrowseTo feature in access 2010. I have searched for and read everything I can find on the web... which wasn't much.
Can browseto be used on a form other than a navigation form, if so, how do you set the file path? I have tried to follow the examples given here: http://blogs.office.co m/b/microsoft-access/archive/2010/02/23/access-2010-browseto-docmd-and-macro-action.aspx and I can't get it to work. ... -
Browse for a file from a Form
Hello, using some VBA I was able to find online, I created a form that displays an image who's file path is stored in a table. The form works great, but I have to manually type the file path into a text box on the form. Is it possible to create a button (and macro??) that opens the normal windows browse for file feature and forwards the file path of the file selected to my text box so that it will automate the process? This seems like something that... -
Extracting File Name
I am writing a macro to preform processes on an excel spreadsheet. I'm trying to use the file name string to input into cells. I have tried the following code:
The workbook I am working out of is called "2008 02.xlsx", but when I run this code the variable "MyName" returns "PERSONAL.X LS". It my be something about the version of excel I am using (2003 version)....Code:MyName = ThisWorkbook.Name
-
Getting error from OnClick Macro
i am very new to access.I have created this macro by watching few examples from different sources in form frmPendingPropo salsUpdate. Getting error when I clicks “new” in field “open” of frmPendingPropo salsUpdate. kindly help me where is problem or if this macro is right
...Code:Action: OpenForm Arguments: frmContributionRegister, Form, , ="[RegisterID]=" & Nz([RegisterID],0), , Dialog Condition: Not IsNull([RegisterID])
-
Saving excel with VB
Hi,
I have a java code that populates data on my XLSM file, the problem is, the java code can't handle the execution of Macro, so what I'm just doing is to populate the excel file with java and then open the excel and save it manually and then the macro will be invoked.
I wanted to do it automatically, so I created a VB script that will open the file and will save it as well but the problem is, even though it saves and... -
C - Macro problem with nested structures
I define a macro like this:
and later,when I try to use that macro,Code:#define L(p) ((p).value.len) typedef struct node { int dimension; int position; int size; union { long len; float f; } value; struct node *prev; struct node *next; } node, *np;
I have this error:
... -
How to force macro to end based on certain conditions?
We have a Macro that runs many queries and we want to force it to abort based on the values we find in the database. Any ideas on the best method for doing this?
More details: The database is being populated by another system so we want to make sure that their update finished. If we set up a table with a status value in it then we can just read that table and see if their update finished properly. If so then the macro can run all of... -
How to copy sheet in workbook to another copy of it?
I am trying to build a vb macro in excel 2007 that will allow me to copy the 4th sheet in my workbook and then create a new sheet from that copy with today's date as the label. I am still learning VB so I am not quite sure how to do this. Help please.
