Experts Exchange

1. vadimrapp147,500
2. LSMCons...40,950
3. boag200020,400
4. peter57r15,000
5. LPurvis12,000
6. angelIII9,200
7. thenelson8,000
8. tbsgadi7,600
9. matthews...7,200
10. rockiroads7,000
11. TextReport6,000
12. jimpen5,300
13. kelvinsparks5,000
13. BrandonG...5,000
15. rrjegan174,250
16. cactus_d...4,000
16. nmcdermaid4,000
16. sb94,000
19. johnb67673,500
20. pteranodo...3,000
21. DatabaseMX2,800
22. reb732,600
23. EugeneZ2,500
23. mwvisa12,500
25. TimCottee2,000
25. cquinn2,000
25. ralmada2,000
25. bmatumbura2,000
25. profya2,000
25. chapmandew2,000
25. aneeshatti...2,000
25. jrfaust2,000
25. bigbillydot...2,000
25. bokist2,000
25. lwadwell2,000
25. cwood-...2,000
25. carl_tawn2,000
25. tigin442,000
25. kprad2,000
25. Torrwin2,000
25. dportas2,000
25. GrahamM...2,000
25. Wikkard2,000
25. ThrainSon...2,000
25. RPCIT2,000
25. Jubal12342,000
25. JohnSingl...2,000
25. Aaronroach2,000
25. Mestha2,000
25. srikanthre...2,000
25. 8080_...2,000
25. Bobaran982,000
25. vegasIT2,000
25. Notexa2,000
25. necrit2,000

1. vadimrapp1178,950
2. LSMCons...156,475
3. LPurvis101,936
4. peter57r96,986
5. rockiroads51,447
6. boag200044,065
7. capricorn141,518
8. SidFishes37,544
9. jimhorn36,229
10. angelIII33,277
11. thenelson32,639
12. stevbe31,815
13. matthews...27,325
14. nico503826,250
15. DatabaseMX22,750
16. TextReport21,950
17. JDettman21,743
18. kelvinsparks21,700
19. jimpen21,075
20. harfang20,172
21. jefftwilley19,800
22. Arthur_...17,524
23. cactus_d...14,250
24. chapmandew13,748
25. jadedata12,677

2000 organizations, including eBay, Ericsson, and Lockheed Martin, now work smarter with Corporate Accounts. Save over 36%!

Having problems asking a question? Have a general question about Experts Exchange? Let us know!

Time Tested Microsoft ADP Solutions: 1 - 25 of 106

how to open access file (mdb) in development mode?

Hi In order to work on VBA access application, I open the mdb file by holding the shift key and double clicking the mdb file. I find this process not very accurate. Half the time ...

How to prevent the error: Arithmetic overflow error converting expression to data type nvarchar ?

I am developing an Access application with Accesss as the front end and SQL Server as the backend database. I have an existing table named tblMutualFunds comprised of the following fields...

Get SQL query result in VBA variable

I have an Access project linked to SQL server data. In my VBA code I want to get the result of a query into a variable. The stored proc returns one value, with a field name of "count". In...

automated import from fixed width flat file

I have about 50 separate fixed width text files that I need to pull into SQL Server 2000, so I want to automate the process. They are BIG files, with 731 fields and a sum of 250 gigs. I ...

How to create the use of multiple worksheets using Excel VBA ?

I am developing an Access application with Excel VBA using Access 2003 as the front end and SQL Server as the back end database. I use the following Attached Code Snippet containing 2 funct...

MS Access web page for data entry

I am designing a MS Access database (2003) to handle the registration of new employees in a company. I want to set up a web page (on the company's intranet) that allows managers (concurrent us...

Converting Access MDB to FileMaker

Hi, is it possible to convert a Access 2007 MDB to FileMaker? If so how can I do this and would I lose any functionality (I have used macros, queries and VB code)?

Disable/enable shift key in Access 2003 ADP/ADE

Much has been written about this subject but I am struggling to find a workable solution for ADP/ADE files. The perfrect solution would be this one: http://www.utteraccess.com/forums/sho...

Access 2007 ADP - How to pass date parameters to stored procedure

I have a form with 2 TextBoxes to accept a date range, e.g. Startdate and EndDate. I need to pass the 2 dates to a stored procedure where the SELECT statement has a DocumentDate. (Floyd.dbo.P...

Populate ListView From View/Sql MS ACCESS 2003 MSSQL ADP

Any idea how i would populate the contents of a ListView control with the results of an Sql String? example: Function PopulateListView(Sql As String, LV As Object) Usage: PopulateListV...

Pass SQL 2005 Stored Procedure Return Value To Access 2007 .adp Project VBA Code

I am trying to capture the return value from a stored procedure in an Access 2007 .adp project. I've been beating my head against a wall for days trying everything I have found online with no...

How to resolve runtime error '50290': Method 'Quit' of object '_Application' failed ?

I am developing an Access 2003 application using Access and Excel as the front end and SQL Server as the back end database. I am trying to give the user the option to either SAVE or DISCARD...

Skype works but no access to the http protocol

Hi , i am a little bit confused. I am setting up an Watchguard Firebox X550e Core. I am using the System Manager Ver. 10.2.2 and i didn´t get the access via firefox to the www. My internet ...

ADO .ADDNEW - Do you need .insert or .update?

A few days ago I asked the following question and received this reply from a former programmer of the system I've taken over "Unless you plan to replace all the code with the Insert into pro...

Cannot open .adp file with Access 2007

We recently upgraded to Office 2007. Now when attempting to open an Access .adp file (Access 2002-2003 format) that is linked to SQL data, I receive the error "There isn't enough memory to per...

ADP calculated column and form footer sum that update when a row is updated

Requirement: Display the sum of a calculated column in the footer of continuous form and keep the column and the sum updated when rows are updated. The recordsource can be a stored procedure (...

Can't Bind recordset to report in Access

I am trying to create a recordset and bind it to a report but I get an error the first error I understood to be that in an mdb I can't bind an RS to a report so I created an adp and in and ...

Form requery ?

I have a form with combo box and two subforms in it - combo box allows for selection of customers and is used as link field fo on first subform (in datasheet view) - ORDERS. Selected order se...

how to display records in descending order in VBA programming

How can I dispaly records in descending order in VBA programming ?

Invalid data for type "numeric" error openquery on 64 bit sql server to oracle

Hi, we just migrated a sql server db on a 64 bit sql server machine and our openqueries to an oracle database return the error Invalid data for type "numeric" The query is as simple as th...

How can I limit the number of records in an Access Report?

I am developing a Microsoft Access 2007 "project" (.adp) as a front-end to a Microsoft SQL Server 2005 Express database. I offer my users a "Filter Form" in Access with which they can choose ...

Help converting application.filesearch

I had posted this question before, but just found out the solution didn't work. Here's another attempt... I am using Access 2007 adp to SQL 2005. During the conversion, we've discovered t...

DoCmd.OpenStoredProcedure can't find the object

In an Access database project form I have this little piece of code DoCmd.SetWarnings False DoCmd.Close acForm, "View_Edit_Tree" DoCmd.SetWarnings True...

Update SQL Server table via ADP form.

I am creating an Access Project (Access 2003) connected to a SQL Server 2005 database. I need to present the results of a query (Stored procedure? -- ADO? -- View?) to the user on a form and ...

Using VBA variables as parameters for report queries

I am in the process of upsizing from Access to SQL Server 2005 with Access frontend. In the application I have several forms that use comboboxes to pass parameters to my report queries. Now th...