Search results

I'm trying to get the filter by form filter from a form/subrorm and use it in a query. I'm using the general form: dim genSql,qd as dao.querydef, as string genSql="select * from tablename" qd=currentdb.querydef("nameOfQuery") qd.sql=genSql & " where " & me.filter docmd.openquery...

I am trying to pass the value for the second column of a combobox in a subform to another control (on the same subform) which has a control source from the underlying query. I have: me!testcontrol = me![subform].Form![control].Column(1) in the afterupdate event of a control. It work as I would...

what's the subform holder?

It works for: If IsNull(Forms![duplicate2]![Dupenewchild].Form![SFSP]) Then MsgBox "SFSP information not entered. Please enter SFSP information", vbOKOnly, "SFSP" Forms![duplicate2]![Dupenewchild].Form![SFSP].SetFocus Exit Sub End If I get a prompt and then the control is selected. However...

Here's the public sub: Public Sub Form_afterupdate() Dim stChildLastName As String Dim stChildFirstName As String Dim stGender As String Dim stStreetAddress As String Dim stCity As String Dim stState As String Dim stZip As String Dim dBirthday As Date Dim stGrade As String Dim...

I have a form/subform. The subform is partially filled in and some fields have to be entered manually. This form/subform is based on a temporary table. There is a command button to run an append query to take these values and put them in their final destinations. I'd like to make sure all...

I guess I don't follow. I've tried adding another form based on the second table to both the main form and the subform and I still can't add a record to the original subform. Could you elaborate?

I have a form subform. The subform is based on a query so I can add fields from another table. When I have the query configured with the second table I cannot add new records to the subform. If I take this table out of the underlying query I can add new records. I've tried every join type...

I'm trying to convert some code from early binding to late binding. I've muddled my way through changing outlook from application to object and it compiles (at least it seems to) but it didn't work right so I'm starting over. I have two command buttons on a form. One coomand button is for one...

I have an Access database that is linked to an Oracle via ODBC. I am using the Orahome 92 driver. When I paste an address from a record that is in the database into the thriteria for that field in the query by example grid I don't get any results. I know that that address exists. This field is...

I have a commercial database that was in Access and recently has been upgraded to SQL Server. I also have another linked database that was previously linked to the Access database to do some things that didn't come with the commercial db. I now want to create a linked db to the SQL server...

I'd like to be able to select multiple files from a file control and then import several files at once. I obtained some code awhile ago to select one file with a file control. I'm not familiar with all the things it does. I don't really see a setting for multple files but I do see a line...

I found the problem. I was using some old code and copying and pasting. I had forgotten to change one of the old variable names to the new one. I also found I have another problem. I'm using Access to do a query by form. The actual data is in another database. I think it is in Oracle. A...

I'll check what the SQL statement actually works out to be. I'll also try leaving out the clause where I notice the problem starts and skipping ahead. Maybe there is some sort of field type mismatch SELECT strSQLClause1 & " " & strSQLClause2 & " " strSQLClause3 & " " & strSQLClause(5)...FROM...

I am putting together a long sql string from smaller sqlclaused from user supplied data as part of a search by form form. Basically the sqlstring is: SELECT strSQLClause1 & " " & strSQLClause2 & " " & strSQLClause3 & " " ... FROM... It works with 12 strSQLClauses but if I exceed that (I have...

I'd like to store some variable values into a table so they can be used the next time access is run. What would the vba code be to put the value of the variable "stat" into the the field "one" in the table named var. I've tried: tables!var!one = stat and tables!var!one.value = stat with...

Thanks, I did the second method. There were some issues with getting #s around some dates coming from forms coupled with a typo

I have a long SQL string that I had to piece together over several lines. The code isn't working right so I figured I have done somthing wrong as it works with a shorter simpler SQL string. The string doesn't all fit in a msgbox for viewing and comparing it to what I want. How can I view the...

I'd like to set up a form that allows you to enter a unique number for a record and then automatically change the value for one or more fields in that record. I have a large number of records that I only need to add values to two fields so am looking to make a shorter form with the ultimate ail...

Oops I may have spoke to soon. I tried it just in outlook and if worked fine. Now I am trying it along with code to create the file to send in Access and it doesn't work. The code I am using is: Dim outlookapp As Application Dim outlookmessage As Object Dim Item As Outlook.MailItem...