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?
483 results in 0.0072 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.
-
Not a Valid Password problem Access
I am doing an append query that takes data from a table(TIMESHEET )from data base "A" and appending that data to the same table in database B. Database B has a password and when I try to run the Query I get the not a valid password message box. Below is what access gave me when I ran the Query Wizard. I found other similar questions online but none of the solutions for those worked.
For reference "bmi test.mdb" would be... -
Disable Office and Minimize buttons in an Access Form
I am using an Access program in an secure area and don't want anyone to mess with the screen. For a amateur user how can I do this? I don't find anything in "Options" other than disabling tabs, navigation and full menus. Thanks. -
Form showing up blank
Hi all
Having had such great help from you guys in the past I'm hoping that someone could shed some light on this issue I've been unable to solve.
I have diluted my database down to the objects nescessary to establish the problem which I believe is a relationship/key issue. For your information though, the relationship should be one-to-one.
From the StudentInfo form you can open up the MedicalForm for... -
Error 91 - Object variable or With block variable not set
I am running a simple excel app within Access. I am opening a new workbook, adding data, formatting the sheet ect. It works quite well the first time I run it (click event). The next time it fails with "Error 91 - Object variable or With block variable not set". Here is the first part of the code and the location where it fails on the second try:
Private Sub CalcPercent_Cli ck()
DELCLARATIONS:
... -
Marc Brown started a topic How do you prevent access from showing error dialog box (Runtime error 2501).in AccessHow do you prevent access from showing error dialog box (Runtime error 2501).
I keep on getting the same error message and I don't know how to either solve the problem or prevent it from showing the error. I have set up a switchboard item that opens a report. When the report opens it will call a form so that the user can change parameters in the report and filter the information before the report is generated see below.
...Code:Private Sub Report_Open(Cancel As Integer) DoCmd.OpenForm "CostCodeFilter",
-
Sql - insert into
I have an sql statement which I was hoping someone may be able to help me with. I'm getting the following errors:
1 - runtime error 3346 (Number of query values and destination values are not the same
2 - Runtime Error 3075 syntax
...Code:strSql = "INSERT INTO tblConversation ( " & _ "RecordID, LeadID, Conversation, Subject, DateEntered, ContactDate, ContactTime, FollowUpDate -
Updating Access using Excel spreadsheets used to distribute Access info
The volunteer organization I work with maintains an Access database of its members. Periodically, geographically specific member lists with portions of each member’s information (the balance is confidential) are distributed to geographically specific coordinators in the form of Excel spreadsheets. While using their member lists, the coordinators learn of updates to the information about members in their area and make changes to the spreadsheets... -
DLookUp function doesn't want to work with my code
...Code:Private Sub Command11_Click() Dim strSQL As String Dim criteria As Integer Dim ete As String Dim row, place As Integer ete = Me!etenduse_nimi row = Me!Rida place = Me!number criteria = DLookup("[broneeringu_id]", "BroneeringudQ", " etenduse_nimi='" & ete & "' AND rida=" & row & " AND number=" & place & " AND Toimumisaeg=" -
I Can't select the fields i need in the query result!
I have this query and it works fine however i need the query to display the forename and surname and currently it only displays the max value of the sum it performs
Does anybody know what i can do?
Thanks
...Code:SELECT MAX(Intermediate.Total_Amount_Of_Likes) AS Total_Amount_Of_Likes FROM ( SELECT Forename, Surname, Sum(Likes) AS Total_Amount_Of_Likes FROM Instructors, Exercise_Class_Type, Exercise_Class_Staff,
-
User access and permission for .mde access file
Hi,
Could anyone help with setting up user access and permission for access database?
I am using 2007 and I have an .mde access file.
I would like to set up groups (admin, read only & read-write). I would then like to assign users to this group.
For users, I would like to create specific login names for them and passwords.
I would like to know how can I do it.
... -
DSUM with fields from different tables?
I am trying to add a calculated field in my query to sum the payments up until the date of the entry. There are two tables involved. I have a table for the dates and amounts of wired payments ("KYOWAPayments ") as well as a table of invoice# and shipping information ("AP statement log"). The two tables have no relationship.
I wanted to make a field that will automatically calculate the sum of all wired payments up...Last edited by asmodea; Apr 13 '12, 06:27 PM. Reason: Saw a potential cause of confusion in question. -
Moving Access 2010 tables to SharePoint
I am trying to move my Access2010 database to SharePoint. My database tracks project and because more than one person can work on a project and a person can work on multiple projects, I have a ProjectPerson table that essentially as a ProjectID field and a PersonID field. When I try to send it to SharePoint, I am being told that table ProjectPerson is dependent on table Project which is not allowed in SharePoint. Hwo do I set up my tables to get... -
Bryan AZ started a topic DoCmd.TransferText acImportDelim is appending data; I need it overwrite...how to do?in AccessDoCmd.TransferText acImportDelim is appending data; I need it overwrite...how to do?
I am using DoCmd.TransferT ext acImportDelim to import a number of text files. I thought this command would overwrite current table data with new, but instead, it is appending.
How do I get this command to overwrite the current table with new data each month? -
Working with SQL Servers From Access VBA
I am just starting to work with a connection between SQL Servers and Access using vba. I was wondering if anyone knows of some good sites that show the basic functionality as well as how to connect and set up recordsets from the SQL server.
Thanks for the help.
