Search results for query: *

Could someone tell me if it is possible to populate the Subject line in an email with data from two different fields on a form? Can't figure out the syntax to make this work. Private Sub cmdEmailRecord_Click() DoCmd.SendObject acSendQuery, Req_CurRec, acFormatXLS, , , , Me.Requirement_No & "...

I am trying to create a Recordset using a SQL statement. I've done it before but, this time, it seems the SQL statement isn't finding the Table in the db so, it has an empty value for the Recordset. Help please? What am I missing? Private Sub cmdAddToReq_Click() Dim db As DAO.Database Dim...

Could someone please tell me how I would go about requerying a form and subform based on all three columns in a combo box selection. Basically like this: Form has txtbx1, txtbx2, txtbx3, cmbbx.column(0),(1),(2) subform When a user makes a selection in the cmbbx I want the whole form to...

I'm having trouble getting an UPDATE query to pick up values from a recordset. When I run the code, I get parameter requests for the string values in the statement. When I go to Debug and hover over the string = rst![field] , it shows the value being picked up from the recordset but the SQL...

I have a main form named [Program Management] with a RecordSource of tblMPL with a primary key field [Record_No] which is also a txtBox on the form. On this main form I have a combo box where if the selection "ReDirect" is made then a second form opens [ReDirect Reason] which has a RecordSource...

I'm trying to create a recordset with a simple SQL statement. I am then going to use the records in the recordset to do an IF Then statement to change the Enabled property for a control on the open form. I can't figure out why I keep getting no results from the SQL statement. I keep getting a...

Has anyone gotten an audit trail to work in Access 2013? I have tried Allen Brown's, a Microsoft one and one from Martin Green. I cannot seem to get any of them to work. After compiling with no errors, nothing gets populated in the Audit table. If you have made one work please let me know so I...

OK Let's say I have a form that queries 2 tables. One master table called PROJECT with Project_ID field as the primary key and a date table called DATES with field named Date that is related to the PROJECT table by the Project_ID field as well. I want to have a combo box on the form that...

Hello, I'm trying to set the Fore Color (or Back Color) of a Report field based on the value in another. Basically, I have a combo box on a Form say... [cmbColor] that offers Red, Blue or Green to select from. I have a Report that runs off a Query of that Form's underlying Table. I want to set...

I have a form with a drop down Combo box (based on a simple look up table). How would I get the values from 2 columns in one selected Row in the drop down to be saved into 2 separate columns of the table that is the control source of the form? Thanks for any suggestions

Hello, I'm trying to figure out the syntax (especially the date part) to run a DoCmd.Export "TableName" on an automatic daily basis (just once each day). I basically want to send an extract to a shared folder every day. Could anyone give me some pointers? Thank you

Could someone tell me what is actually going on when you get the Invalid Argument message? I was getting it all of a sudden when trying to import a certian file.I tried it on a backup of the db from 1 month ago and it worked. I replaced the newer version db with the backup, tried the import...

I have some code from a cmd button on a form that would normally populate a textbox field with a value from a DLookup value. However, I can't get it to work when I place the form on a tab page which is on another main form. Private Sub cmdFindOldTable_Click() Dim strSQL As String strSQL...

I placed a subform on a Tab control form that came from an existing form I had already developed named General_Processor. The problem I'm having is that the code behind some command buttons on this form that use textbox data on this form can't find this form. In other words, I'll get...

I'm trying to use the data input by a user into an unbound textbox on a form to create an append query in VB event procedure. I can't figure out how to do that since the SQL is looking for a table or query to pull the data from? Anyone know how to do this?

I have a query that looks for null values in 2 fields. The criteria expression I use is: Is Null Or Like "" Or Like ' *' But it still misses some rows with blank fields where the expression should pick them up. Is there something else I could add to the criteria expression? I always thought...

I am trying to have a Textbox auto populate based on a query but I get a error "DoCmd.RunSQL must have argument consisting of a SQL statement"... but there IS a SQL statement. What am I doing wrong? Here's code. The Debug stops at "DoCmd.RunSQL SQLB" Private Sub cmdCreateADdistinct_Click()...

I am trying to write a query to find all the Rows with common data in these fields:[DataSource], [AccessLevel],[AccessCap]. There is another field named [EEID]. It is a text datatype and represents a unique ID for a person. What I'm trying to do is group all the [DataSource], [AccessLevel]...

Could someone please show how I would convert a text string such as "20101021" to a date format and datatype such as 10/21/2010 ? I've been toying with some VB code but not successful. Thanks for any help.

I have a form with a combo box. I have a cmd button on the form that is supposed to use whatever I have selected in the combo box for a string value in some SQL code. However, it's coming up as an empty string but I can't figure out why. I done this hundreds of times before and it worked fine...