Microsoft Access is a rapid application database development and reporting tool.

learn more… | top users | synonyms (3)

0
votes
0answers
6 views

How do I format fixed-width whole numbers to decimal values during import?

I have a fixed-width data set, and I am trying to convert some whole numbers to the appropriate decimal values. I would like numbers formatted as 0000001576 to appear as 15.76 on import. Is there ...
0
votes
0answers
5 views

Access VBA OpenForm Grouping and Sorting

I have a form that is used for data entry. We have to go back through and add data to these records. Is there a way to pull up the form that groups the records by field "A" and sorts by field "B"? ...
1
vote
4answers
40 views

SELECT DISTINC LOWER : SUBSTR

I'm having difficulties to resolve my request: SELECT DISTINCT LOWER (CustomerName), SUBSTR(Customer.PostalCode, 1, 3) +" "+ SUBSTR(Customer.PostalCode,4,6)AS'postal' FROM Customer ORDER BY ...
0
votes
0answers
17 views

how to calculate data in a Row using C# with access 2010?

im trying to calculate electricity consumption using this formula: electricity consumption = Usage Per Day * Power (Watt) * Number of Item * 30 / 1000 but i have no idea how to call the data in a ...
0
votes
0answers
19 views

ms access query to oracle via odbc

I want to execute oracle function from ms access: this query works perfect: Select * from table(rpt_0257_ArtEtk_fn('1','1')); this one too: Select * from ...
2
votes
2answers
25 views

syntax error in update statement in C# with access 2010

im working on updating information in mic access 2010 using this code, but its keep telling me the syntax error in update statement. ihd already search through the previous answers but non of them ...
0
votes
0answers
16 views

Finding Duplicates in Access with more than 2 columns as basis and results

I have an access table with 11 columns. PeriodYear PeriodCycle PeriodZone PHSRCode LastName FirstName PRC Specialty HCPType Class Institution I want to find duplicate entries for it using ...
0
votes
1answer
37 views

how to populate textbox depending up on combobox value?

I have this scenario where I have a combo box name contract, row source type is table/query. Now on the text box I would like to display the name of the person, telephone, mobile, fax, address. A ...
0
votes
1answer
31 views

Query doesn't return empty Brand fields

I am having trouble pulling data from a table in a query and returnig all results if i have a blank field in 'Brand'. I have two queries, this is the first, it pulls essentially the same data but ...
-1
votes
2answers
45 views

VB.net table iteration

I have this code now. But it fails at three steps. Can you help me figure this out?? I have listed the three points where it fails. Also please validate for me If I'm doing it right? Retrieve ...
1
vote
0answers
77 views

I am getting an error in my code from an sql statement that works fine in the query design in MS Access

The SQL statement runs properly in the query design in MS Access but I get the following error in the netbeans code: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few ...
2
votes
5answers
45 views

Counting multiple fields in SQL

I have a table listing People's First Names, their Age, and their favorite color. I need to create a query in SQL (In access) that counts how many people like Red, and how many people like Yellow. ...
0
votes
0answers
16 views

Creating a data edit form for a relational database

I am building a business data dictionary in Access. I've done most of the setup and data entry, I'm now looking forward to maintenance. I want to create a form that would, in datasheet view, allow a ...
0
votes
1answer
27 views

Conditional Formatting on an MS Access form

Is there way to use conditional formatting (similar to excel) to a text box in an ms access form? The user will enter a number in the text box. If the number is between 0-25 is red, if its from 26-50 ...
0
votes
0answers
6 views

How can I import a linked access table to Visio?

I want to open up a linked access table in the Visio external datasheet. When I select Access Database, the table I want won't show up; I can only see local tables. I tried making a view of the table, ...

1 2 3 4 5 911
15 30 50 per page