Forum

Posts

RECENTLY INDEXED PROGRAMMING SOLUTIONS OF Microsoft Access


How to combine excel files in access  

Hi Dear,I have 4 excel files, containing 1 Million rows each (5 columns).How can I combine these excel files (in access)?Thanks a lot Continue Reading
Views : 161
Wednesday 10th of October 2012

Access field mixed up  

I have created an Access database which contains numerous fields, one of which is a reference field. Recently all of the data in the reference field has been mixed up so that the wrong reference is with each record. This is the only field which seems to be affected. Does anyone know why this... Continue Reading
Views : 127
Wednesday 10th of October 2012

Grouping by two to three months  

Does anyone know how to group data in a query by two and three months instead of summarizing the data just by month? Can you explain in design view?Thanks! Continue Reading
Views : 120
Wednesday 10th of October 2012

Tab pages/Combo and list boxes  

Hello,I have created a db with a tab control (mytab). On a page of this tab (mypage) I have placed a combo which gets it's record source to a table (mytable). I then added on the same page a listbox which should pick up the records from a query (myquery) based on the criteria selected in... Continue Reading
Views : 148
Wednesday 10th of October 2012

Update Query truncates >255 characters  

Hello I am doing an update query in Access from any MS Access Table to an Oracle Table...However, the update query truncates the text in fields where it exceeds 255 characters. Is there anything I can do to avoid this truncation?The Oracle Table Field... Continue Reading
Views : 127
Wednesday 10th of October 2012

Access 2010 - Combo Box Help  

Hello ASP/free forumsI'm having some trouble with combo boxes in MS Access 2010. I used the Control Wizard to create a combo box that searches a field of names for a record matching the search criteria. So far, it works fine, but until now, I never thought about how to... Continue Reading
Views : 74
Wednesday 10th of October 2012

Access 2010 - Macro or VB to activate/find a particular record  

Good day,I've got a order form that the user populates with the materials they need, each item on the sheet becomes an individual record but through a query, the form appears to be a single form with multiple parts (if in fact the user needed more than one part). A manager then has... Continue Reading
Views : 156
Wednesday 10th of October 2012

Last Day of Current Year  

I have an expression I can use in queries for "Last Day of Current Month" (DateSerial(Year(Date()), Month(Date()) + 1,0). However, I'm looking for an expression for the Last Day of the Current Year. Would appreciate any help. Thanks. Continue Reading
Views : 98
Wednesday 10th of October 2012

Query to count users that have a matching item record  

I want a query that will return the count of users from the Users table for who one or more items in the Items table is listed under their username.For example:Users Table:a ...b ...c ...d ...Items Table:a ...a ...a... Continue Reading
Views : 141
Wednesday 10th of October 2012

VB6 convert text to access  

i have problem with my coding with red colour, the error come out "type mismatch" ...plz help me... plz email amira_maisarah@yahoo.com ...thank youPrivate Sub cmd2mdb_Click()Dim iLen As IntegerDim iOccurs As IntegerDim... Continue Reading
Views : 146
Wednesday 10th of October 2012

Sum Function  

hello,I have created a form with three texboxes (txtFrom, txtTo and TxtSum). The txtsum has the following control source:=DSum("[km]","qrykm")I have built the query from my table and named it qryKM. It has two fields: KM and Travelfrom. The criteria of the TravelFrom... Continue Reading
Views : 56
Wednesday 10th of October 2012

Combo boxes / automatically filling in boxes  

Hi guys, I'm having a little trouble. I have made a combo box with these relevant fields, however I would like it so when I select the company name instead of having this long line next to it I would like it to fill the relevant boxes on the form. How would I go about doing this? Continue Reading
Views : 170
Wednesday 10th of October 2012

MS Developer Extension and Runtime  

Several post in the recent past asked the question of how to package the db for distribution and how to run the Access db in computer not installed with Access. Before Access 2007, you must purchase another program for about one thousand dollar to do this. Microsoft now offer these two... Continue Reading
Views : 110
Wednesday 10th of October 2012

Access vs. Excel   

Don't ask "Which is better, Access or Excel?" because there is really no answer to that. Databases and spreadsheets are different kinds of tools, for different kinds of jobs. It would be like asking "Which is better, a hammer or a screwdriver?" Any carpenter would tell you that... Continue Reading
Views : 113
Wednesday 10th of October 2012

Access Tutorial Videos  

Sorry, couldn't let the world go without these instructional videos. It's not much, but it's a good place for beginners to start:Access Instructional VideosThis might be a good... Continue Reading
Views : 42
Wednesday 10th of October 2012

Relational Database Principles  

The first time a person tries to use Microsoft Access, they are likely to miss the whole point of what a database is and how to use it. When they start having trouble making it work for them, they think in terms of what they may be doing wrong in their use of the obvious tools of Access. But... Continue Reading
Views : 100
Wednesday 10th of October 2012

Locking down your Access Database by Carl McDade  

DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\\nas2.orcsweb.com\aspfree.com$\authors\carl_mcdade\db1.asp Continue Reading
Views : 126
Tuesday 28th of August 2012

Locking down your Access Database by Carl McDade  

DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\\nas2.orcsweb.com\aspfree.com$\authors\carl_mcdade\db1.asp Continue Reading
Views : 118
Tuesday 28th of August 2012

Upgrading your Access Application for a Multi-user Environment  

IntroductionIt often happens that a database designed for a single-user needs to be upgraded for use in a multi-user environment. This article will illustrate how to upgrade your single-user, Access-based application. As a rough rule of thumb, you can continue to use... Continue Reading
Views : 121
Tuesday 28th of August 2012

Upgrading your Access Application for a Multi-user Environment  

IntroductionIt often happens that a database designed for a single-user needs to be upgraded for use in a multi-user environment. This article will illustrate how to upgrade your single-user, Access-based application. As a rough rule of thumb, you can continue to use... Continue Reading
Views : 134
Tuesday 28th of August 2012

An Access Front-End to MySQL  

Why do it?Even though I have been running a dual-boot Windows/Linux machine for a number of years, I still enjoy being able to see my Windows partition from Linux. So, as you might imagine, the voyeuristic pleasure of seeing a MySQL database through the eyes of Access was... Continue Reading
Views : 60
Tuesday 28th of August 2012

An Access Front-End to MySQL  

Why do it?Even though I have been running a dual-boot Windows/Linux machine for a number of years, I still enjoy being able to see my Windows partition from Linux. So, as you might imagine, the voyeuristic pleasure of seeing a MySQL database through the eyes of Access was... Continue Reading
Views : 55
Tuesday 28th of August 2012

Securing and Administering Access  

Continue Reading
Views : 64
Tuesday 28th of August 2012

Securing and Administering Access  

Continue Reading
Views : 68
Tuesday 28th of August 2012

Getting to Know MS Access 2003  

Let?s begin the tutorial with an overview of Access 2003. It helps to have the program installed on your computer before following the tutorial. Open your Access program. When it has loaded onto your screen, you?ll see the main Access window accompanied by the Getting... Continue Reading
Views : 74
Tuesday 28th of August 2012

Getting to Know MS Access 2003, Part 2  

There are several types of databases, as you learned in last week?s lesson. Access 2003 is a relational database. A relational database is one which stores logically-related data in tables. Tables are the most important objects in relational databases; you?ll learn more about tables next week.... Continue Reading
Views : 91
Tuesday 28th of August 2012

Getting to Know Access 2003, Part 3  

Creating Tables and RelationshipsYou created database structures in our last lesson. Now it?s time to make tables to hold your data. Before you start creating your tables however, it?s a good idea to plan your table designs carefully. You should decide what kind of... Continue Reading
Views : 81
Tuesday 28th of August 2012

Getting to Know Microsoft Access 2003, Part 4  

  Continue Reading
Views : 88
Tuesday 28th of August 2012

Getting to Know Microsoft Access, Part 5: Retrieving and Arranging Data Meaningfully  

Continue Reading
Views : 75
Tuesday 28th of August 2012

Getting to Know Microsoft Access, Part 6: Advanced Queries and SQL  

Continue Reading
Views : 68
Tuesday 28th of August 2012