Microsoft Access is a rapid application database development and reporting tool.
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, ...