Microsoft Access 2010 Personal Relational Database Management System.
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 ...