Search results

Please recommend a solution or commerical software for installing a FE/BE Access program to a network drive for the BE and one or more local PCs for the FE. Of course, BE tables will have to be linked to the FE. Detailed instructions for same are quite tedius and requires a comprehensive...

I using Access 2010 (Enterprise) on Windows 7 Enterprise PC. In the course of executing VBA code, I open an Excel workbook in Access using Dim xlAPP As Excel.Application Dim wKb As Excel.Workbook Dim sNewxlsx = {a valid path and "xlsx" file} Set xlAPP = New Excel.Application...

I have complex A13 reports each of which has multiple complex subreports whose various control properties are programmatically modified in the report's design view and then closed along with the report itself immediately prior to a report is opened in "preview" mode. Why? The various subreports...

I have 10 complex A10 reports which originated from forms which now need to be converted back to forms. The new header & detail section controls, control spacing, sizing, borders, top, height, width, etc. of the various controls are needed in forms. I could save the various properties of each...

My client has a complex pdf file which it desires to use as a bound report source object to display data from the report's record source.:banghead: More succinctly, bind a pdf report to a table so that report is populated with data at run time. :banghead: Of course, I can manually build the...

Litwin, et al's Access Developer's Handbook, 2 volumes. There's 97, 2000 & 2002 editions. New on Amazon they're several hundred dollars. Used, they're reasonable. Of course, the 2002 edition is best. I consider them "the Access bible" for learning anything about Access. The sections on...

I have inherited forms, some of which somehow lock the Navigation Pane. For those that do I cannot find how the Nav Pane is locked. Is it a form property? If so which? "acCmdWindowHide" is not used in the program. This issue prevents me from viewing form properties or Form VBA when such an open...

I have an A2010 - SS database program that is generally macro driven (I inherited it) with comlex and simple queries having form control criteria which will not work. With hard coded criteria, the queriesd work. I found an early 2012 article indicating that this was a known bug and that SP1...

I'm letting users specify the name for a table to be created. Can those names be easily parsed to eliminate special charactes, e.g. "yyy&&" is convertred to "yyy", or does the name have to be parsed character by character. I tried to catch the error fired, but none fired and the table was...

How can I reference the name of the (single) table being queried in a column field with the table anme as a function argument? I'm using multiple tables names in a complex function and in multiple queries. I don't want to hardcode the table name.:banghead::mad: I can generate a series of same...

I have an Access pass thourgh query which trims data and reformats a column which timesout after 3 minutes. That same query runs in 30 seconds in a SQl Analyzer. It has previously run numerous times in the 30 second range. My ODBC connection is correct. Any ideas?

I have a 100M row SQL Server table (SStb) joined against 2K local Access (Atb) table top update 3 fields in 100K rows of SStb. Atb is a lookup table. In Access, the query takes 1.5 days to run. I'm charged with optimizing same. With DAO, the parsing takes about an hour, cycling through the...

I'm using the Soundex algorithm (free on the Internet at http://allenbrowne.com/vba-Soundex.html) which does a phoenitic "fuzzy" comparison of names. Unfortunately, with this method, multiple distinct names produce the same result. Examples of which I want to match are ABC, INC. ABC CO...

I have a passthrough query which will not generate what I want, i.e. using UPDATE dbo.tdw SET manifest_date = CONVERT(varchar(11),[manifest_date],101) WHERE report_state='IL' AND report_year=2012 AND report_month=1; manifest_date, initial text 'Jan 1, 2012 09:33AM', and returns 'Jan 1...

I want to create an MS Access pass through query which joins tables in 2 different SQL Server databases, i.e. SELECT a.seller_name, a.seller_PAR, b.SAP_Cust_PAR FROM a LEFT JOIN b ON a.seller_name = b.SAP_Cust_Nm WHERE (a.seller_PAR Is Null Or a.seller_PAR Like ' *') AND...

I'm developing an Access FE SQL Server BE database and have the following passthougfh query which generates and error: UPDATE top (100) x SET CARRIER_NAME = LTRIM(RTRIM(CARRIER_NAME)) WHERE report_state = 'il' AND report_year=2012 AND report_month=1 and schedule_code = forms!switchboard!Y and...

I'm trying to a VBA docmd.TransferText statement (properly formatted) to import and append "csv" data to an existing table, e.g. DoCmd.TransferText acImportDelim, "Import Specification", "tbImportedData", strPathAndFile, vbNo. The VBA code creates a new table with an identical name, while a...

I'm creating table relationships with VBA, which works fine except for tables which have ForeignKeys with no corresponding PrimaryKey in the linked table. My code is as follows: Dim db As DAO.Database Dim Rel As DAO.Relation Dim Fld As Field Set db = CurrentDb() Set Rel =...

I am charged with accessing all Excel applications on a server programmatically checking for code and hard links to SQL Server and Oracle with hard coded passwords, i.e. looking for connection strings to external databases with hard coded passwords. I've done this before using Access to check...

I have text data containing a single quote ("), a tic mark (') and/or a # and must fileter for same. Example data might be: the string 2.5" x 4.0' x 12'. The only way I can filter for this value using a vba string filter is to use a wild card for the quote and the tic. Any suggestions as to...