Search results for query: *

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...

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.

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...

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...

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...

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...

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...

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

I have linked tables with a numerically coded field. I want to show the text the code refers to in a report. I have several reports and underlying queries where this field appears. Currently, the reports shows "11", for instance, where I want "Oak." I've created a table that correlates the code...

I need to match hardware to windows. There are two suitable hardware types for each window, and many sizes of each. I have a working query for each hardware type. They select the hardware size based on the weight and height of the window. The ranges are not the same between the two, so one...

I have a query with the following SQL statement: SELECT DISTINCT [Double Balances].[Balance #], [Double Balances].[Glass Height], [Double Balances].[Min Weight], [Double Balances].[Max Weight], [DH Consolidate].TSWGHT1, [DH Consolidate].NEW_TYPE, IIf(Int([DH Consolidate]!OATVDLO) Mod...

I created a test form a couple of days ago. I don't remeber deleting it, although its possible. Anyway, after working fine all morning, now I get an error that pops up continuously saying that "FORM1 is misspelled or refers to a form that doesn't exist." It doesn't show in the database window...

I have a query with several fields, two of which are TYPE and QTY. There are several records where TYPE and all other fields are identical, except QTY. I want to create a new query that consolidates these into one record, summiing QTY. Example: TYPE ...........QTY .......... indicates the...

I have a query with the following SQL statement: SELECT SUBQ.NEW_TYPE, Sum([QTY]*[QTY1]) AS FQTY FROM (SELECT IIf(InStr([TYPE],"_")>0,Left([TYPE],InStr([TYPE],"_")-1),[TYPE]) AS NEW_TYPE,QTY,QTY1 FROM [Unit Master]) AS SUBQ GROUP BY SUBQ.NEW_TYPE; If I run it and then change to SQL view the...

Hi, I have a table with fields "TYPE" and "QTY". Typical values for "TYPE' are A, A_2MULL, A1_2MULL, B, etc. QTY are integers. I want to add the QTY for all records with the same characters to the left of "_". Example: TYPE QTY A 6 A_2MULL 4 A1_2MULL 5 RESULT: TYPE QTY A...

I have written code to automate the creation of solid models in Inventor R5.3 from an Excel spreadsheet. The code links the spreadsheet with an Inventor template. It works, but with an error. The code includes a provision to change the parameter source (spreadsheet) of the new part. This indeed...

I have a combo box that lists all tables on form load. How do I have the tables listed alphabetically?

I have a report that uses a single table as its record source. It uses six fields out of 80 or so in the table. Some records have null values in one or more fields. How can I prevent a record from showing in the report if it has a null value in a particular field? Thanks in advance...

I have several queries (Select and Union) that I would like to respond to a combo box selection. Specifically, I need to change the table reference in the FROM statement. I realize that the ususal way to do this is to have all records in one table, then use criteria to select the appropriate...

Hi, I have several spreadsheets that drive solid models (Inventor). I want to link them to Acces in order to produce Bills of Materials. Since design revisions are common, this allows updating the models and spreadsheets at the same time, lessening errors. I have made all the reports that are...