I have created a query which allows me to schedule daily events. But I want to automate this. Let me explain what i am trying to do.
Every morning at 7 am I want this query to run and the output of which to be mailed to myself. All this without me having to hit any button of sorts.
I have a long shot but very inefficient answer to this - which would be - having to leave my MS ACCESS running all night with an infinite loop checking to see what the system time is. When the infinite loop equates to 7 am it runs the query. But I think this would be a massive memory guzzler and I don't like this solution. Is there something else I can do?
How can I send an automated email notification everytime a new record is created. I have a macro set up with the send object completed, I just can't figure out how to tweak the logic so it will do it everytime a new record is created.
With ColdFusion and MSAccess 2003, the following query :
SELECT A.*, B.entry_id FROM A.blog_entries, B.blog_subscriptions WHERE B.blog_id = #variables.blog_id# AND B.user_id = '#variables.userInfo.user_id#' AND A.user_id = B.user_id
returns this error :
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not find file 'C:WINDOWSsystem32B.mdb'.
I'm trying to run a make table query, and I'd like to automate it. Is there any way I can do this through a script so that I don't have to answer Yes/No to any of the pop ups? I turned off the notifications, but I still get the odd pop up.
I have a query that may have 6 - 7 different records for example each record contains a different email address, i need to get the first email then send and email to that address then go to the next record get that email address send an email to that email address until its gone through all the records...
I use this code to send an email, dont know how to loop through records and get the email...
Code: Dim appOutLook As Outlook.Application Dim MailOutLook As Outlook.MailItem Dim strPath As String Dim strFileName As String Set appOutLook = CreateObject("Outlook.Application")
I have spent a few days coding a database search page consisting of various comboboxes and textboxes. the user can select or enter data in these and when he/she clicks the search button an SQL select statement is generated on the fly and updates an existing query and this is used to query the database. I want to be able to give the user the option to save the query he/she generates and reuse it. How can I prompt him for a name and turn the SQL string strSQL that he has generated into a query and save it for later use?
I am trying to create a sequential number field in a query. I cant use an auto number for the fact that i am combining multiple tables. Any help with this would be greatly appreciated.
SELECT PreStatus.Operator, PreStatus.Mode, Sum(PreStatus.CountOfMode) AS SumOfCountOfMode, IIf([SumOfCountOfMode]>=3,"YES","NO") AS [Current], PreStatus.Rate, PreStatus.Last, PreStatus.First, PreStatus.DET FROM PreStatus GROUP BY PreStatus.Operator, PreStatus.Mode, IIf([SumOfCountOfMode]>=3,"YES","NO"), PreStatus.Rate, PreStatus.Last, PreStatus.First, PreStatus.DET HAVING (((PreStatus.Rate) Like "*" & [Forms]![Status]![Rate] & "*") AND ((PreStatus.Last) Like "*" & [Forms]![Status]![Last] & "*") AND ((PreStatus.First) Like "*" & [Forms]![Status]![First] & "*") AND ((PreStatus.DET) Like "*" & [Forms]![Status]![DET] & "*")) ORDER BY PreStatus.Operator;
When I run Query a dialog box request for SumOfCountOfMode appears. Is there anyway I can turn this MsgBox off?This Database is used for the user to find out if their personel are current in said data. The user will be running this query through a Form and will get their results via a report if they put anything in this MsgBox it could possibly skew the data they are looking for.
I am trying to set up something to be able to take me to a folder that holds various forms for personnel. I have a query that generates the link for each person. I have tried to set it up as a hyperlink in ACCESS 2013 and it displays as one but doesn't act like one.
I want to be able to click the link and have it open up a personnel folder for that individual. I can't find a MACRO that I can create to do it. Example of my query is that it creates a link K:Main BreakdownSection BreakdownPersonnel FoldersName and the name is the variable part.
My next problem will be to have it create that folder when we have new personnel arriving.
I would also note that I have not worked with ACCESS in many years and much of what I was able to do with 2002 and 2003 doesn't work with the newer versions of ACCESS.
I need to use various activeX controls in MsAccess2003. I downloaded a few activeX controls but I am having a problem with licensing. I registered the controls and the registration succeeded but when I try to add this ActiveX control on a form in MSAccess, I get the message that I don't have the license required to use this ActiveX control and that I should obtain the appropriate licence from the company that provides the licenced OLE object or ActiveX control. Any ideas on how to overcome this problem?
1/ I occasionally run into this error: "The instruction at "0x77fc823" referenced memory at "0xfffffff8". The memory could not be "read". Click on OK to terminate program."
Do you know if this error message occurr ONLY on certain computers using Access 2000? Since this error popped up on one of my co-worker but NOT on mine. I even tried to re-install Access 2000 again, but the error message still pop up when tried to open a report. Also, the last three digits of instruction number "0x77fcZZZ" change everytime. Please help!!
2/ For some reason, I was coding VBA on one of the procedure on Form_Load, then certainly Access 2k does NOT let me go in the code of any control. WHY!! I am frustrated!! I tried to go in different way, but does not work
I am a newbie in ms access. I am ask to do some coding to help me with massive duplicate datas in my database in access. But i do not know where to start from? Im very confuse. As i do not know if ms access itsself can be program using codes? or am i suppose to use SQL? or VB? or VBA?
I'd like to know when a user has modified their records on my site. Is it possible to include code to stamp the datelastmodified per record? And if so, how?
the compact and repair on Access enable us to compact or database bec when we delete records the space consumed is not removed. in ASP my Access is increasing rapidly almost 10MB and sometimes downloading this file takes a lot of time for a slow internet. is there a script i can use to automatically compact the database?
my table have a a text field F1 (data ex:25%) and number field F2 . I have a query which contains a new number field based on the above fields i.e F3=F1*F2.My query is not able to retrieve the data.My data is been filled with error#.How i can convert the data types in order to get the multiplication of those two fields.
I'm trying to import a tab delimited text file into MSAccess and its driving me nuts!! How hard can this simple thing be? I have a text file thats rather large (300Meg in fact) and it has a field that is a date/time but msaccess refuses to import it as such. If I import as text and then change the field to date/time it will work but I can't do this on my file because access reports that its run out of memory in converting the field type (2.5M rows).
I've tried setting up the table prior to importing the data and setting the field type but it make no difference. Any help here appreciated because this should be simple!!!
The format of the data that I'm trying to import is.
28/08/2005 10:31:11 PM
You can even make this a single row and try importing it and access drops it so obviously I'm very dumb!!
I am using msAccess to develop a small application. I have 2 tables, student and course, and I need to create a form with 3 fields - by_id, by_date, by_course_id
This form can generate a view only table according to the field the user entered.
Can anyone help me on this? What's the step to do so?
How I can store scanned object in Access. Becuase I have a employee database. I have to store all employees signature in the database Also I have to verify thier signature with the previously stored in database when they are trying to log .
