Sponsored Links

comp.databases.ms-access comp.databases.ms-access

Page 12 of 816

Threads in Forum : comp.databases.ms-access

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
A2010: difficulty linking tables I am having problems linking a front end to a back end in Access 2010. For about a decade I have successfully linked tables in Access 2000 using... Jim Devenish	03-28-2011 11:01 AM Jim Devenish	3	4
SharePoint Developer I have over 10+ years of experience in software development. I am System Analyst looking for freelance work, my skill sets: MICROSOFT... sumeet.leo@gmail.com	03-27-2011 05:07 PM Access Developer	1	2
Data Transformation All, Periodically, I have to import some large excel spreadsheets into an Access Db (I'm using Access 2007). The excel spreadsheets are of this... Gilgamesh	03-26-2011 10:29 AM Gilgamesh	4	5
Add a custom class button to a form I am figuring out how to make a simple custom button to do what I want by making it a class -- in particular it will display its value as... PandaData	03-26-2011 10:08 AM PandaData	0	1
Disable a sql server trigger from an Access Module Hello; MS Access 2000/Sql Server backend. We have a situation where an automated (access app -- based off of cmd button) append to a certain sql... Tony_E	03-25-2011 03:18 PM Bob Barrows	1	2
PassThroughQuery failing Hello ; Access 2000/ms sql server I built a PassThroughQuery. It is an append to a sql server table. The message I get is ODBC call failed. Invalid... Tony_E	03-25-2011 03:09 PM Bob Barrows	1	2
Microsoft Jet database engine Stopped during Insert I have a database on my desktop. I have a link to a source data table. I have a local table with the same structure. I am running an insert into... Tim osgood	03-25-2011 11:03 AM John Spencer	1	2
Changing the NumberFormat property From Access 03 I can change the NumberFormat Property of an Excel 03 cell. For cell say F10 if original Date format was "dd/mm/yyyy" I can change it... JohnP	03-25-2011 10:56 AM Tom Clavel	1	2
you tried to assign null value to a variable that is not a variant OK, I'm pulling my hair out. I'm trying to append records to a table. No code, just an append query. When the table is in the same database, it... musicloverlch	03-24-2011 09:47 AM musicloverlch	2	3
Rotated Labels or TextBoxes ( 1 2 3 ) Sorry to re-post this query, but I am getting nowhere. I would like either a rotated Label or TextBox on a form, rotatable to any angle that I... Phil	03-24-2011 05:11 AM Phil	24	25
Crosstab and missing category I have got a routine to store statistics of document status on a weekly basis to identify trends. There are several status points of documents, for... bezz	03-23-2011 06:38 PM John Spencer	5	6
MAS90 Visual Integrator question Anybody working with Visual Integrator? The process I am most interested in is exporting data from Access and importing into MAS90. Can one... Salad	03-23-2011 06:17 PM Salad	4	5
The Microsoft Office Access database engine cannot open or write tothe file access 2007 runtime, FE / BE on different servers, both running windows server 2003 periodically the following relink function fails... Roger	03-23-2011 08:02 AM Roger	0	1
Rank by sales on MS Access Report Hello All, I want to have a field on the report which ranks by the sales of each wholesaler. However, I cannot use the Running Sum because I am... Orchid	03-21-2011 06:32 PM Salad	7	8
Ampersand in string behaves different on form caption and reportfooter Hi all. I have a client where there is an ampersand in the company-name. Like AT&T I am using a global string gstrRegorg to display the Company-name... Arno R	03-21-2011 01:11 PM Arno R	4	5
Need help with Hyperlink on Form I have a form with a text box set as a hypelink. When I type the url into the text box everything works fine. It shows as a hyperlink and saves as... JackonLI	03-20-2011 10:38 PM JackonLI	0	1
Form on the fly - VBA ( 1 2 ) Hi NG I am making a form on the fly - it works fine, but... In the form i have a With statement : With frm .Visible = False .Caption = "Ledige... bsn	03-20-2011 07:08 PM bsn	10	11
Access 2010 Web Form - tab order How do you change the tab order of a web compliant Access 2010 form? Normally to change the tab order on an Access form you would select Design... JJ	03-19-2011 05:03 PM Albert D. Kallal	5	6
Seven seconds to open a very simple report ( 1 2 ) I create a brand new 2007 db. Open the report designer - 6 to 8 seconds to load. Put in one label. Open the 'Report1' - 6 to 8 seconds to show me... christianlott1@yahoo.com	03-18-2011 04:05 PM ron paii	13	14
Using DAO to access the querydefs collection to document fields ina query def I am trying to traverse the querydefs collection, to list every field in the query. so far so good. However, some of my queries have... Bob Alston	03-18-2011 02:17 PM BobAlston	6	7
A2K working out relationships between two tables I am confused by how I can save some user choices which are captured in one tblData but I need to save them in tblDefinitions where there will... buckskin	03-17-2011 08:24 PM buckskin	6	7
Scroll a continuous form ( 1 2 ) I know this should be simple but... Having updated a record on a continuous form using VBA, I want the form to scroll so that the updated record is... Phil	03-17-2011 07:58 PM Phil	13	14
Migration to Access10 Hi All, The company I work for is migrating from WindowsXP/AccessXP to Windows7/Access10 later this year. I have many AccessXP apps out there and... bobh	03-17-2011 07:32 PM SteveJ	5	6
Formatting combo box drop-down list Hello, everyone, Have a Microsoft Access 2003 form with a combo box used as a record selector. The combo box "Row Source" is a table field... Arsene@selenium.net	03-17-2011 04:27 PM Arsene@selenium.net	2	3
NavigationWhereClause I haven't found any code examples on NavigationWhereClause on the internet or in my book on A2010. Has anybody ever used that property and have... Salad	03-17-2011 12:11 AM Salad	1	2
Can a Navigation form have synchonized forms? I am looking at the Contacts template. If you open up the form Main it has Datasheet and AddressBook as tabs. When I am on a Datasheet record, it'd... Salad	03-15-2011 11:28 PM Salad	0	1
Anybody gave up MDB+MDW to go ACCDB+Sharepoint ( 1 2 3 4 ) ?"David-W-Fenton" wrote in message news:Xns9E9DE519CC5BCf99a49ed1d0c49c5bbb2 (AT) 74 (DOT) 209.136.95... Ok, I expand on this. The difference... saintor1@hotmail.com	03-15-2011 03:01 PM James A. Fortune	38	39
Library Database ( 1 2 3 4 5 ... Last Page) "Phil" <phil (AT) stantonfamily (DOT) co.uk> wrote in news:ihvi8a$5cc$1 (AT) speranza (DOT) aioe.org: You can use Application.Run or... Phil	03-15-2011 02:39 PM David-W-Fenton	77	78
Access 2007 View Object Dependencies WITHOUT Track name AutoCorrect? Is there an easy way to do this? Track name AutoCorrect was constantly corrupting tables but now I need to see what's using what. Thanks! ShadesOfGrey	03-15-2011 01:06 PM ShadesOfGrey	2	3
idMso ExportExcel - Select which query TransferSpreadsheet just dumps the data into excel w/o formatting while the ExportExcel command (w/ ribbon) brings up the wizard to select the name,... christianlott1@yahoo.com	03-15-2011 11:46 AM christianlott1@yahoo.com	0	1
Implementing public VBA function in Access 2003, passing multiple parameters ( 1 2 ) Hello, everyone. I have a large application, with several forms, containing numerous data fields (mostly bound text boxes). I have converted some of... Arsene@selenium.net	03-14-2011 03:24 PM Arsene@selenium.net	11	12
A2010 Navigation Form question Using VBA, not a web based database for this test. I created form Form1 with a button to open NavForm2, another to open Form2, another to close... Salad	03-14-2011 11:34 AM Salad	0	1
Download registry cleaners Is your PC running slow? Does your system has malware or unwanted programs? All these same problems i was also facing in old days. But i have spam... jack tom	03-14-2011 01:43 AM jack tom	0	1
Acc 2007 Runtime Zoombox alternative problem ( 1 2 ) I have to roll out a 2007 application with most users having only runtime Acces on their machines and the missing zoombox feature is an issue. I... Malcolm	03-13-2011 11:24 PM Malcolm	14	15
Determine installed versions of Access? Hello, I would like to be able to use VBA to enumerate the installed versions of Access on a particular machine. We have an environment in which... Bruce	03-13-2011 04:56 PM Tony Toews	8	9
Sample code to backup changed records while backend MDB open viaappend queries to another DB ( 1 2 ) Anyone have any sample code or know of utilities to backup changed records while a backup MDB is open and in use? I know you can backup via windows... Bob Alston	03-13-2011 03:17 PM David-W-Fenton	15	16
Data entry report Need to create a data entry report for each project to show fields that do NOT have data. Could be by projectid which has data spread across several... davjoh123@yahoo.com	03-13-2011 02:58 PM davjoh123@yahoo.com	0	1
Run time error 438 - VBA problem VBA Error occurring in Access 2010 (database is Access 2003 compatible) There is no object in this control (Selecting hyperlink that opens form) Run... Duncan	03-12-2011 05:02 PM Duncan	0	1
BringToFront ( 1 2 ) I have a form where I can drag controls around at Runtime. Frequently, one control will overlap and partially conceal another control. I need a... Phil	03-12-2011 04:18 AM Phil	17	18
totals in sub data sheet I have Totals rows in both parent and child data sheets. (Access 2007) Parent Totals row displays fine, giving the * for new record. Child records... christianlott1@yahoo.com	03-11-2011 12:13 PM christianlott1@yahoo.com	1	2
App path oddity I can't seem to find anything about this on the ng. Using Access2007 I have created an app in a certain directory in the root drive. The app is... Lou O	03-10-2011 03:23 PM Jens Schilling	2	3
Error 3078 when maintaining connection to tables on server I found code to maintain a persistent connection to my tables on a server (http://www.fmsinc.com/microsoftaccess/performance/ linkeddatabase.html).... Sara	03-10-2011 01:34 PM Bruce	3	4
Error 429 on opening Outlook 2007 with Access 2003 The following code runs fine from my computer, which is running Windows XP, Access 2003, Office 2007, . There is no reference set to Outlook. Other... Toots	03-10-2011 01:27 PM Toots	0	1
yes/no field problem I am using this code in my report: Private Sub Report_Current() If IsNull(Me.Vacated) Then Me.Vacated.Visible = False Me.Label15.Visible =... JkingSJR	03-10-2011 08:27 AM John Spencer	2	3
Linking tables to MSSQL -- key/identifer issue We're using Access as a 'temporary' gateway to a fairly complex SQL Server backend. Today I stumbled into an issue between DB design and this... Jeff Norville	03-10-2011 07:08 AM Rick Brandt	1	2
can i disable the popup windows? HI I have an access macro that copy and pastes data into a new record then closes the form. The problem is the user is then asked what to do with the... fishqqq@hotmail.com	03-09-2011 04:22 PM Phil	1	2
Access 2003 I want to within a field on a table find a char and its location. Then I can move left or right and collect the data. This can easily be done in... Barry	03-09-2011 02:58 PM Phil	2	3
A2K Error 2427 - big roadblock, need help! On occasion and for no apparent reason, I get error 2427 when I open my form which has a subform containing the data. The data is definitely... buckskin	03-09-2011 12:29 PM buckskin	1	2
Wayne Gillespie Anyone have a valid email address for Wayne Gillespie? I am looking for a copy of his code offered... BobAlston	03-09-2011 10:17 AM BobAlston	0	1
Importing CSV Files with no headers I am importing a large CSV file into a table called "FUND" (I didn't name it.) When I do it using the import wizard it works fine. It has no... musicloverlch	03-09-2011 10:15 AM musicloverlch	3	4

Page 12 of 816

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off