Microsoft Access also known as Microsoft Office Access is a rapid application database development tool. It commonly uses the Jet or ACE database engine, but is not limited to these. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or ...
1
vote
2answers
17 views
select a column based on multiple condition but no direct connection in tables
Okay, well I know title might be a little unclear, but I couldn't find a better title. Let me explain the situation,
I have 3 tables (actually many, but for this example we need 3).
1. teachers table ...
0
votes
1answer
12 views
[Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition
I am accessing an Access database inside a java program, however I get an error when I execute the sql command:
static String SQLCreate = "CREATE TABLE CONTACT_INFO (" +
"Contact_ID INTERGER ...
-1
votes
0answers
12 views
What is the access vb script to make easy questionaire?
i just want to ask simlpe vb script that could update certain field in a table, witha text box that is connected to that field? and editing script.
I want to make a questionaire, but it seems so hard, ...
0
votes
1answer
56 views
Using the MS Access COUNT DISTINCT function
The following query returns the count of requests where AcquisitionDate is within 60 days of RequestDate, along with various other columns.
How can I modify the code to count the number of unique ...
1
vote
2answers
34 views
Lookup and Display a Date Value from an Access Table
I am trying to have a msgbox popup when clicking on a command button within a form in Access 2003.
The msgbox should be triggered by the current date, when compared to dates referenced within a table ...
1
vote
1answer
14 views
Composite Primary Key Cascading
Two fields, Building and Room, make up a unique primary composite key in my rooms table. The key validates and saves, etc.
I have a BLANK Objects table which has three fields which will make it ...
1
vote
2answers
17 views
Refresh Combo Box query after another
I have two combo boxes on a form. One for start date and one for end date. When a start date is selected it limits the end dates to those greater than the selected start date. This works correctly but ...
0
votes
1answer
18 views
Multi-Field Primary Key
For reasons I cannot understand, the people who supply my tables do not have any form of single field unique identification for the 20k+ entries in their tables.
I have two fields, BuildingCode and ...
0
votes
0answers
11 views
How to pass through an Excel sheet where single cell contains more than one field and several line are really one record to add records in table?
I have areport generated from our system exported to Excel. Each record is exported in several lines and Each line contain more than one field but all field in the same line are exported into only one ...
1
vote
2answers
21 views
update statement error in Access VBA
I am trying to update several columns in a table called "tbl_Responses" but it gives an error after running which I have been trying to find!
varX= DLookup("[ID]", tableName, "[supplierNum] = " & ...
1
vote
1answer
20 views
How to show UNICODE characters stored in MsAccess Database on a browser page?
I'm using IIS7 on my Windows7 operating system to run my project written in ASP3.0 language with use of Ms Access 2010 database.
Most of the data that I saved on MsAccess DB is in Arabic language. If ...
0
votes
0answers
27 views
Advantages of changing from MS Access to MySQL [closed]
Hi I am trying to gather some information about why people should change from MS Access to MySQL.
Here are the some of the advantages I have found
MySQL can handle large amount of data
MySQL is ...
2
votes
1answer
37 views
How do I display form properties in a message box?
I have the following code, which should loop through all the forms in the project, and give a messagebox with the settings for each form. I know the loop is correct, because I use the loop elsewhere ...
1
vote
1answer
18 views
Access Report Prompts for query twice
I am developing a report that has a text portion and a graphical portion. Both portions of the report are created using the same query. Unfortunately, I am being prompted twice when running the report ...
1
vote
1answer
28 views
How do I create a passthrough query in access using a DSN-less connection?
I'm using DSN-less connections to my SQL Server in an Access database. However, whenever I try to write a "Pass-Through" query and run it, a dialog box pops up asking for the DSN.
