Search results for query: *

Thanks for the reply, missinglinq. There are no records in the recordset. Allow additions is set to yes. RecordSet Type is Dynaset. The query comes from 3 tables. This is the SQL that the wizard built: SELECT tblArticles.ArticleName, tblArticleProduct.ProductName, tblArticlePublisher.PubName...

Sorry, not familiar with box.net. Try these.http://www.box.net/shared/tzugtcqzus, http://www.box.net/shared/h1y7qf2aid

I have an Access 2007 DB with 8 tables, see attachments. I created a form, using the wizard, to enter article info. I want to capture info for all the fields in tblArticles and the product mentioned and the publication. I chose the ProductName field in tblArticleProduct and the PubName field in...

Works lika charm, tricky syntax. I never would have thought to try it. Thanks!

No, but tblTable2 = cbxType, which has a value list of sheet names.

Thanks to both! This solution works well, but i would like to have the sheet specified by the value in a combo box. When i try this i get the message tblTable2$ is not a valid name. error 3125. Here's my code: Private Sub cmdLink_Click() Dim tblTable1 As String Dim tblTable2 As String If...

Is it possible to link some but not all excel sheets from a workbook to access using the DoCmd.TransferSpreadsheet method. I use Access 2002 DAO. Thanks in advance.

The data source for the query is another query, who's data source is a linked Excel SS. The field in the table and both queries displays to the appropriate number of decimals. Changing the format in Excel has no effect.

I'm using 2002. I have used this query for a couple of years with perfect results. This anomaly has just occurred.

I have a simple expression in a query: [FW]-2.5. The values for [FW] have up to four decimal places. They display this way in the query, but the results of the expression, regardless of the decimal display, drop any values after the first decimal. For example: [FW]=40.375 Expr=37.800 If I...

Thanks PHV, I tried every combination of [ ' " & but that one! Works like a charm.

Hi All, I have a form that uses combo box choices to populate the WHERE clause of an SQL string. For example: If Not IsNull(chkAddressee) Then strWHERE = strWHERE & " AND qryTableConsolidate.Addressee1 = " & cboAddressee End If When I execute this, I get Error 3075: missing operator in...

Thanks PHV, Still getting an error. Here's my code. Not sure if I'm using the correct method. The record does save but the report doesn't open. Private Sub Preview_Click() On Error GoTo Err_Preview_Click Dim stDocName As String Dim db As Database Set db = CurrentDb...

I have a form that records information to produce a transmittal cover letter. After data entry I would like a command button to save the record to a table and open a report populated with the current info, ready for printing. I have a parameter query that asks for Date and Project. I've tried...

Ken, Sorry I wasn't clear. I have different reports for each condition, DH or CAS. They are seperated into Groups in the Object pane of the database window. For example in the following, I need to have strReports "look" only in the DH group of reports. For Each rpt In objCP.AllReports If...

I have the following code that loads cbxCutSheet with all reports in the current project: Dim rpt As AccessObject Dim objCP As Object Dim strReports As String Set objCP = Application.CurrentProject For Each rpt In objCP.AllReports strReports = strReports & rpt.Name & ";" Next rpt...

Thanks Rick, worked like a charm!

Not sure if i should post here or forms forum, but here it is: I have a form that populates a cbx on load. The code works well, except that i would like to limit the type of table displayed to only linked tables. Currently i have an IF clause that excludes SYS and TMP tables, but some tables are...

No, I just would like the ability to add some notes to a report. The text doesn't have to become a record. It would just print on the report. Ideally, upon opening the report, a msgbox opens that says, "Would you like to change the Global Specs?" It should display the current text and allow the...

How do I add user inputted text to a report? Thanks in advance.