Microsoft Access 2010 Personal Relational Database Management System.

learn more… | top users | synonyms

2
votes
2answers
13 views

Converting measurements in a form to update a table

I am using Access 2010 to create a database of fish caught by local fishermen. I have a table with all the information about each fish caught (location, day, length, etc) and a form to add new ...
0
votes
1answer
15 views

MS Access List Box multiple value selection

I have created form based on query output. I had used 3 combobox and one list box. 1st combo box gives me list of Dept, selection of dept on 2nd gives me location of that dept (distinct), the 3rd ...
0
votes
1answer
13 views

how to connect MS Access database with matlab (transfer data from GUI and save in database )

Hello ppl I am trying to work with databases and I am new to Matlab. I want to manipulate databeses created in MS Access but I don't know(I hope find a way to enter data from GUI (this GUI created ...
0
votes
1answer
11 views

Having to call SetFocus twice in MS Access 2010

I found that for a couple of hours this code worked: If KeyCode = 37 Then Me.Text12.SetFocus End If Then it mysteriously stopped working. I thought it might have had something to do with ...
1
vote
1answer
18 views

Disable Record Navigation SHIFT+TAB in Access Form

I have form that loads as Data Entry = Yes and the navigation buttons are disabled. I'm trying to figure out how to make it to where a user cannot press SHIFT+TAB and go back through previously ...
0
votes
1answer
23 views

count unique for field in crosstab query

I've searched for an answer to this, but can't seem to find anything that works to do a unique count in crosstabs. The closest I could find was: select count(myField) from (select distinct myField ...
0
votes
2answers
39 views

Vba Access error: Method or data member not found

I have been trying to open a contracts form from contracts_all page. I want to open all the records on the contracts_all form but only show the specific one clicked on. To show this one particular ...
0
votes
0answers
10 views

Retrieving Data From a Website in a MS Access Form

I'm working on a database that will have a table with the following columns: Original Location (Point A), Load Distance (Point A -> Point B), Load Mode (Truck, Ocean, Rail - corresponds to CO2 per ...
0
votes
3answers
34 views

Open a form using ID from a different form in Access 2010 using vba

I am trying to open a form from a button in another form. The form with the button,contracts_all form, has a field ID and I want to open up the form that contains the information with that ID. This ...
1
vote
3answers
34 views

convert years and weeks to date in sql msaccess

how to convert text to date in sql as listed below? Y12-W01 to 20120102 Y12-W02 to 20120109 Y12-W03 to 20120116 and so on... i use ms-access. thank you in advance regards.
0
votes
0answers
15 views

Access 2010 - Invalid Procedure Call or argument

I am getting an error with "Invalid Procedure Call or argument" when tryng to use the Export to Excel functionality inside Access 2010 for Reports. All other Export option are working fine. This ...
0
votes
1answer
33 views

MS Access event-driven Data Macro to update table (example)

I have imported some data into Access from Excel. Now I want to write a code similar to trigger which will update another table whenever I get new data from Excel. I know I cannot write a trigger in ...
1
vote
1answer
19 views

Crosstab query with date criteria

I have created a crosstab query as below TRANSFORM Nz(Sum([debit]*[GeneralExpenses]),0) AS mOmomeya SELECT Expenses.sName, Expenses.ArName FROM (GL INNER JOIN Expenses ON GL.ID = Expenses.glID) INNER ...
0
votes
3answers
25 views

Year-To-Date Summary by Month in Access SQL

Given this table, I need to generate a year-to-date summary by month. The result should have one row for each month of the year, and a running total for the year up to that month. I am by no means a ...
0
votes
1answer
41 views

the microsoft access database engine cannot find the input table or query 'Test'. Make sure it exists and that its name is spelled correctly

getting the following error in access 2010, the Microsoft access database engine cannot find the input table or query 'Test'. Make sure it exists and that its name is spelled correctly. when ...
-2
votes
0answers
29 views

Import pictures into an Access 2010 database [closed]

i am currently working on data base for student in which we have main Table name "Master Data" having detail of student along with their snaps (attachment), we have round about 1000 students data and ...
0
votes
0answers
52 views

Resolving SQL / Network path not found

I have built a very small (3 page) asp.net site using MS Access 2010 as the database. page 1 is splash, 2 and 3 show aspects of the data. This all works in test mode. This is for an off-line intranet ...
0
votes
1answer
43 views

how to supress error message Duplicate primary key ms access

I have created student attendance application in MS access 2010 in which I have two main tables. One table is master data of student and other is attendance table in which field ID Card Number and ...
1
vote
1answer
13 views

Need to split states per region in query

I have a query (picture will be included) that need to sort information by Region and then State for lifetime and monthly values. I have everything working correctly (and have had for several months) ...
0
votes
1answer
24 views

how to delete the record if it is exist on same day Ms Acces

I have created a database for students' attendance. I am facing an issue: if students scan their card twice there are two entries shown on the same day. I want one entry per day, and if someone tries ...
1
vote
1answer
30 views

MS Access SQL LIKE query from C#

I have this query for Ms Access and im using C# and Ole DB commands. It works on Ms Access but when I'm passing the query from C# using OleDB, nothing happened. Anyway here's my code: SQL query ...
0
votes
1answer
39 views

How to retrieve a record from a database and have it in order with the index from form load

My first attempt at performing a search on records in a database; I have a windows form project that upon load event displays a name from an Access database in a textbox. There is more to the form ...
0
votes
1answer
10 views

Appending new values to a Matchcollection

I'm working with regular expression because I want to extract some data from a text file. For example I want to extract each number from this row in my text file: ST/X 0.0000000000000000 ...
0
votes
1answer
20 views

How to allow additions but disable edits in an Access form?

I want to set up a form so that users: Can view/sort/filter all existing table records Can add new records Cannot edit or delete records once they have been added I tried the following property ...
0
votes
0answers
19 views

Cant create new MS Access database from team foundation server

cant create 'MS Access database from Team Foundation' it fails when using MS ACCESS 2010 i have the two packages installed:Access 2010 developer extensions & TFS MSSCCI source control provider ...
1
vote
1answer
27 views

How to automatically export data from Excel 2010 to Access 2010 using visual basic?

I am trying to setup a button in Excel 2010 such that when it is clicked the data is sent to a table in Access database. I have found many code samples online but none of them seem to work in my ...
0
votes
0answers
11 views

Import outlook item to Access 2010

I'm trying to link my inbox items from Outlook 2010 to Access 2010. Problem is, one of the CRITICAL fields--Category--won't show up.I really need that field as i am filtering the data based upon ...
1
vote
0answers
6 views

synchronous datatable update from other assembly

When I update datatable from other assembly process is to fast for updating datatable ; for example; I have 3 layer assembly as follows ; Framework.dll Bussiness.dll Win.UI.dll When I call ...
1
vote
1answer
64 views
+50

Import Ms Access Data by programmming

I am in search of an good approach to import data from ms access and bind it to any Model of an MVC pattern Here is the approach which we are thinking to following Approach 1 : Open Ms Access ...
0
votes
0answers
20 views

Formatting Issues in MS Access Report - The Height property does not change with the CanShink and CanGrow property

In an MS Access Report, I have text-boxes with the CanShrink and CanGrow property set to true. A procedure runs when the form is opened, dynamically adding data to these text boxes. I retrieve the ...
-1
votes
1answer
29 views

How to manage multiple roles and users in MS Access 2010 application?

we have to build an application solely using MS Access all the forms have to be designed in MS access and DB is also in MS access. what will be the best way to implement such an application.
0
votes
0answers
8 views

Relationship building help in access 2010

I have 4 tables in my database (houses to repair). Each room of a house has a separate table, for example bedroom, bathroom, kitchen and patio. On each table are various areas in the room that are to ...
0
votes
2answers
30 views

Link to Visual Foxpro 9 from Access 2010

I want to read some data from VFP 9 database using Access 2010. I have tried downloading the ODBC driver but I am told to use the OLEDB driver instead on the MS site. How do I link to a VFP table ...
0
votes
1answer
25 views

Microsoft Access 2010

I was wondering if someone could point me in the right direction. Here is my problem: I have a large form/checklist that I would like to make digital for ease of use. Thoughts: I would like to use ...
0
votes
1answer
23 views

MS-Access: Parent-Child Relationships: It shows me ALL the children. How to filter parents based on children

So let's say you create an AWESOME relationship between suppliers and products, you get super-cool stuff like this when you view the normal Table: ID SupplierName 1 Toys R Us ID ...
0
votes
0answers
15 views

run time error 5 invalid procedure call or argument while accesseing to a text file

I want to open a text file but I get above error. This is my code: Private Sub Command40_Click() Dim fso As New FileSystemObject Dim ts As TextStream Dim Name1, Line As String Dim regn As New regexp ...
0
votes
1answer
24 views

MS Access table validation

I was wondering if anybody would be able to tell me how to check if multiple fields in a form are valid or not. Basically I want to set up a validation rule for my last field to check if all of the ...
0
votes
1answer
11 views

Reports and percents with calculated fields

In Microsoft Access 2010 I am in Design View creating a new Report. I have two calculated fields and I would like to calculate a percentage figure with the two (percentage complete to be exact). ...
1
vote
1answer
23 views

Saving data from single form into multiple tables

Have a form that displays student information and the address. My table structure is as follows: Student ID - PK - AutoNumber Name - Short Text Age - Int Address ID - PK - ...
0
votes
1answer
25 views

Subquery top X of random rows not working (MS ACCESS)

I'm doing a subquery to select the top 5 of products for each supplier. The selection needs to be done randomly on the products for each supplier. For this I have made the following query (based on ...
2
votes
1answer
25 views

Access comparing floating-point numbers “incorrectly”

I am using MSAccess 2010 on Windows 7 64. I am comparing two tables in a query. I am joining on a composite PK and selecting rows where table A column A <> table B column A where column A for both ...
0
votes
0answers
19 views

Expression Builder for Report View Access 2010 (Count is sending error message)

How do I count a field in Access 2010 Expression Builder while in Report Design View and display it in Report view without an error? Here is what I have tried so far: =Count([Table Name]![Field ...
0
votes
2answers
61 views

How to create temp tables in SQL Server via MS Access

I have an ODBC connection to SQL Server. I need to process data within Access, but it takes too long. My idea is to push this data to a SQL Server temp table and have SQL Server do the processing. I ...
0
votes
2answers
26 views

Summing a field in an Access table and displaying the total

How do I sum a column in Access 2010 and display the total in a new column (using expression builder perhaps)?
0
votes
2answers
26 views

How to create VBA loop for Access 2010

I want to loop some VBA code on Form_Load that will update one field in my Form based on 2 other fields. Currently it will only update the first record or when I click on a record. Currently it ...
1
vote
1answer
27 views

How to update a table column with a loop of specific numbers that fills entire column

Kind of hard to explain so i will show an example. Let's say i have the numbers 3, 4, 12, and 19. I would like to add them to my customer table like this: Customer Column Other Column ralph ...
0
votes
2answers
49 views

search multiple criteria if then else on Access 2010 unbound form using VBA

I have the following simple and easy code: Private Sub Add_Click() Dim db As Database, rsAtype As Recordset, Criteria As String Set db = CurrentDb Set rsAtype = ...
1
vote
1answer
23 views

How to validate email addresses in Access?

I need to validate an email field in a table in Access 2010. I tried: Is Null OR ((Like "*?@?*.?*") AND (Not Like "*[ ,;]*")) but this did not work.
0
votes
0answers
39 views

Change the location of a scrollbar in Access 2010

I have an odd request from a customer asking me to move the scroll bar for a subform from the right half of the screen to the left (or to display it on both). I'm having a difficult time finding a ...
0
votes
0answers
14 views

Open model form with acDialog… Getting DoCmd.Find to work?

Any ideas how to get access to docmd.Find from within a modal form? I want to open a modal record selection form so the calling code waits for form to close before proceeding. While the form is open ...

1 2 3 4 5 19
15 30 50 per page