Search results

I have a table called "TBL_EMAIL" with two columns (State & ROM_Email) I have a combobox called "CBO_Prop_State" on a form called FRM_Request_Main. Here's my code: Dim TestThis As String TestThis = DCount("[ROM_Email]", "[TBL_EMAIL]", "[State]= " & Forms!frm_request_main!CBO_Prop_State &...

I have a column of part numbers (Column “A”) that is protected from the user to select them. This is so they don’t alter them as well as only make the cells they can edit assessable. I would like to give them the ability to search for a part number using the “Find” function but since the cells...

I knew I was missing something. It works perfectly now. Thanks!

The db is fairly large. Here is the code for the button as it stands right now: Private Sub CMD_Update_Click() Dim CDB As Object Dim RS_CPT As Object Dim PropertyName As String Dim ActivityStatus As String Dim RTM As String Dim Address As String Dim City As String Dim State As String Dim Zip...

No dice. I'm still getting the Runtime 3022 error. I did run the sql from the immediate window and paste that sql in a blank query. When I ran it it seemed to work. It displayed the correct single record. Not sure why I'm still getting the error.

Dim MySQL as String MySQL = "SELECT Com_MDU_Table.* FROM Com_MDU_Table WHERE (((Com_MDU_Table.Property_Name)=[forms]![frm_update_prop]![txt_prop_name]));" I still receive the same error with this.

I tried it with the SQL and had the same error. Any idea how to adjust my code to get it to work?

I'm attemping to update a record in a table "Com_MDU_Table" using a form with a bunch of txt and combo boxes. The record is based upon the Property Name. I have it set as the primary key in my table so it does not create duplicate records of the same property. I've attached the error I'm getting...

Thank you. So it now appears in the Sripts however I don't think my code is correct. Here it is below: Sub ODB(MyMail As MailItem) Dim LPath As String Dim LCategoryID As Long LPath = "C:\Email Attachments\Test.mdb" Set oApp = CreateObject("Access.Application") oApp.Visible =...

Is there a way to open a database (C:\Email Attachments\Test.mdb) when a rule in Outlook is triggered? I've seen you can call a Script but I don't know where to input one, nor how to write such a script. So basically a few questions: 1. Where do I input the script? (The vba editor?) If so I...

For what I'm trying to do, I can't have part on the network and part on my desktop (at least I think I can't). I have a database that I setup as an autojob so it runs daily. I used to have the database on my local drive, however when I was gone and it failed I couldn't have anyone on my team run...

I have a database located on a network drive that I would like to compact on close. I know how to do that, however when it does this on the network drive it renames it to db1. Is there a way to do this and maintain the name of the database?

It's already in there. ".HTMLBody = StrBody & RangetoHTML(rng)" If I'm missing something can you show me in the actual code please?

Here was my attempt at putting it into access: Option Compare Database Sub Mail_Selection_Range_Outlook_Body() Dim rng As Range Dim OutApp As Object Dim OutMail As Object Dim StrBody As String Dim MySheetPath As String Dim Xl As Excel.Application Dim XlBook As Excel.Workbook Dim XlSheet As...

How would you do a recordset with this? I thought you only use a recordset when you are referencing access data.

I'm trying to figure out how to paste a selection of cells into the body of the e-mail and can't figure out how to do it in Access. Below is the code I use to do it from Excel and it works perfectly however I can't get it to work in Access vba. I've tried working with different code posted but...

So now I'm recieving the error "Cannot import data because a connection to the database could not be established" and highlights the same section of code. Sub mapData() Dim objApp As New MapPoint.Application Dim objDataSets As MapPoint.DataSets Dim objDataSet1 As MapPoint.DataSet...

I tired the code and map point opens but then I recieve an error "The parameter is incorrect" and highlights "Set objDataSet1 = objDataSets.ImportData(zDataSoure, , geoCountryDefault, , geoImportFirstRowIsHeadings)" Any ideas?

I'm trying to figure out how to take a table in access an map it as a territory in access. I've done some searching and and found some articles on MapPoint Articles - MP2K Magazine and in these forums but have had no luck with what I'm trying to do. Here's what I have: -A table called...

Here is what I have: A Form called "Main" A Combo Box called "cboOffice" On the form 4 text boxes: "txtFSS1" "txtFSS2" "txtFSS3" "txtFSS4" I also have a table called "Point_Lookup" It has 3 fields in it: Office_Name: Which has the same values as the combo box on the form Tech_Level: Which I...