msaccess

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Make data entry in Access easier by changing text boxes to combo boxes

Lookup WizardAlthough the solution presented is serviceable, it would force you to do those same steps on each foreign key you place on each form you build.A more elegant solution would be to open the table in Design View, and use the Lookup Wizard on each foreign key field (RepID...

Tags: combo box, Lookup Wizard, Microsoft Access, ttrollen@..., data entry, RepID, foreign key, software, database, msaccess

Discussion threads 2007-03-07

Asking twice on MSAccess 2003

Hi to all!I've an issue that I really have no idea why is happening...When I FIRST run the query shown below, it's asking me twice the field "[PLC]". When this happens, I only need to insert the value I'm looking for on the second pop-up window.SELECT *FROM Table1 SWHERE (((S.Field1)...

Tags: PLC, rayasta@..., S.Field1, S.Field2

Discussion threads 2007-02-01

Could Access 2003 support 9k trans. a month?

Could MS Access 2003 be able to support an application to handle about 9,000 transactions per month and about 50 users? I'm planning to design it using Data Access Pages.If all the 50 users are using the Access concurrently,performance of the MS Access will be effected.Regarding the transaction values,...

Tags: access, access capacity, capacity, database capacity, Microsoft Access, Microsoft Corp., software, Synchronized MSAccess, wgonzlez

Discussion threads 2005-05-21

Entering data in MS Access

What would keep more than one person from entering data in a MSAccess database at the same time?Some ideasLimit the database access to one person. Not recommended.Use document management software that keeps track of versions. Recommended.The easiest way is to open the database exclusively. Open the Access Application (not a...

Tags: Click, database, marie.hall@..., Microsoft Access, Microsoft Corp., msaccess, Open, software

Discussion threads 2005-08-05

Passing an parameter to a Query in access

I have a query in MS-Access which when run prompts for a parameter and then copies data from TableA to A Temp Table.As I need the Query to run more than once how do I pass a parameter once or how do I do this using code?ThanksBrianPassing ParametersThere are a...

Tags: bop_zw@..., database, msaccess, Passing Parameters, Query, software, Use ADO

Discussion threads 2005-07-11

Additional Resources

MS Access Application with C#

What lead me to write this application is when i wanted to access the MSAccess database using c sharp I couldn't get any information material. All the material available on the net is partial to sql, and hence the purpose we will develop this application in 2 phase First we...

Tags: Application, Csharp Help, Microsoft Access, Microsoft Corp., C#, Storage, Databases, Programming Languages, Software Development, Software/Web Development, Hardware, Enterprise Software, Software, Data Management

White papers

Linking PDF documents to MSAccess db

Is it possible to link a previously scanned document to a MSAccess database ? I'm thinking of a URL to the document sort of thing.Basically, when I'm looking to a record in a form, I would like to see a shortcut to the scanned document, or press a buton and...

Tags: highlander718, software, access, Adobe PDF

Discussion threads 2007-01-15

Change Table name in MSAccess

Is it possible to change the name of a table in msaccess and have it automatically updated everywhere it appears in relationship, queries, and SQL?Same question for changing a query name.My naming conventions werent established until i was halfway done building a database, and nine months into the project, so...

Tags: Programming languages, Databases, jim@...

Discussion threads 2007-07-17

how to add delete,insert record in msaccess using adodb with vb6.0,& data

how to add delete,insert record in msaccess using adodb with vb6.0,& datagrid control handling with adpdb?

Tags: manisha_gaware@...

Discussion threads 2007-04-22

Data Editor (exe)

Data Editor is a great way to manage and access data in SQL databases. This product works with SQL Server, SQL Express, MSDE and MSAccess. Insert, update and delete data using a form based interface. Form based searching makes it easy to find the data that you wish to access....

Tags: SQL, Data Editor, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2006-06-29

MS Access97 "OutputTo" Macro

Hi , In my application (MSAccess 97 ) whenever i tried to export a datareport to excel sheet using the OutputTo macro , The excel sheet shows a error message as "Renamed Sheet name" . but this error is not appearing when used in MSAccess 2000...

Tags: Microsoft Corp., ms access 97, programming, sunil.mpt@...

Discussion threads 2005-04-27

Msaccess User

Hi,I have created Database in MSAccess and created users so that they can access the database.Is this possible I will connect msaccess users to Domain User id so that when they open their Database and give their user id and password it will be authenticate from domain.Thanks and Regards.Anurag.This is...

Tags: VBA, VBA CODE, database, User Name, ask_anurag@..., software, AUTOEXEC

Q&A 2006-03-29

MS ACCESS

How to get MSACCESS report from c#.net windows application

Tags: susmitha.mamilla@..., e-mail, Microsoft Corp., Microsoft Access

Discussion threads 2007-02-09

DBManager Professional (exe)

Application for Database Management with Enterprise features like: task builder; server monitoring; diagram designer; form and report builders; import and export data (MSAccess, MSExcel, Paradox, FoxPro, Dbase/Clipper, ODBC, text, html and xml files); query builder, debugger and planner; dependencies browser; database control version system; database comparer; procedure builder. Supports MySQL,...

Tags: DBTools Software, Builder, Databases, Storage, Enterprise Software, Software, Data Management, Hardware

Software downloads 2007-06-26

Creating a networkable link

I have a secured database that is on a shared drive. What I am trying to do it put a shortcut to this secured DB file that any user would be able to use. Some of my clients are on WinXP and others on Win NT 4. Is there a...

Tags: Goliathkutaa

Q&A 2005-06-15

Access to Visual?

is there any routine to convert a MS access file to an exe using VisualBasic, i made a small one but dont want to rely fully on MSAccess...check the other posting of your question

Tags: Microsoft Office

Q&A 2005-04-05

Impromtu odbc connection

How do I set up an odbc connection to Imprmptu. I have the catalog but i want I direct connection through MSaccess

Tags: robert.wynter@..., ODBC

Discussion threads 2007-05-02

Running MS Access 97 & MS Access 2003 On The Same Workstation

I have heard that there are issues when you try and install MS Access 2003 on a box with Access 97. Understand that I need both to be there. Is there any kind of way to allow them both to run in harmony?O/S WinXP 20003 - SP2Domain registered devices in...

Tags: Microsoft Office, Databases, mjohnson01@..., workstation, Microsoft Corp., Microsoft Access

Discussion threads 2007-11-14

Course Evidence (zip)

This template done in MS Access 2000 is very powerful assistant for various courses. It enables you to maintain evidence for lingual, IT and other courses, fitness clubs. You must have MSAccess 2000 to use it or run time files. This version is the first release on CNET Download.com.

Tags: Evidence, Course, Microsoft Office, Databases, Strategy, Office Suites, Software, Enterprise Software, Data Management, Management

Software downloads 2007-10-02

how to export active dir user and computer

hello friends,i need one help i want to export my active directory user and computer in excel or msaccess format please some one help me.rgds,m.maha

Tags: PRODUCTIVITY, mahalingam_moorthy@..., computer

Discussion threads 2007-06-21