Questions tagged [microsoft-access-2010]
Microsoft Access 2010 is a Rapid Application Development (RAD) and desktop/workgroup database application.
72
questions
0
votes
0
answers
68
views
Error in duplicate record in Access 2010 [duplicate]
I should work with a database into the Access 2010 recently. It has few Tables, a few Queries based on their tables and finally a Form. The Form has a button for duplication records. When I click the ...
0
votes
1
answer
1k
views
Access: How to use IF function to fill out the specific column based on the value from another column
In Access database, one column is Asset Value that is currency format or it could be numerical, and second column is Insured that is CheckBox or it could be a text format. I have to create code that ...
1
vote
0
answers
299
views
What is the VBA coding for getting data from multiple tables in Access?
I am a newbie in access VBA coding. I would like to get the data from multiple tables which table name begin with "AB" and show the result in the combo box. I have around 50++ tables and ...
1
vote
0
answers
623
views
Disable shift key on startup in ms-access (Doesn't want to work)
I'm an advanced Access VBA programmer, and even though I have programmitcally set the 'Use Access Special Keys' to FALSE (using VBA), or set that option through the Access Options screen, I can still ...
1
vote
1
answer
480
views
Access tries to import more than 255 columns from Excel worksheet with only ~10 columns. Why?
Using Access to make a table by importing an Excel Worksheet, it tries to import more than 255 columns from Excel worksheet with only ~10 columns. Why?
Excel Worksheet has only the 10 columns in ...
1
vote
3
answers
2k
views
CTRL+F (find dialog) not appearing in tables/queries in Microsoft Access 2010. But CTRL+H works just fine
If I pull up a table like this:
And try to press CTRL+F, the find dialog does not appear.
But if I press CTRL+H, the find/replace dialog does appear:
I can then of course go to the find tab. But ...
0
votes
0
answers
280
views
MS Access 2010 - Query for "previous date"
I'm working in an access database with the following fields (and others):
Asset; Asset_Date; Start_Date; Start_Time; Office_Stop.
Asset is a # field, Asset_Date is text; Start_Date is Date/Time; ...
0
votes
1
answer
2k
views
checking a checkbox based on other checkboxes being checked in access
I have a form in access 2010 with a checkbox field named DR Process, then I have 25 other checkbox fields that if checked I want the DR Process checkbox to automatically be checked. Also if one of the ...
0
votes
1
answer
122
views
How to calculate the difference between the Date created of two records
I have an Access table. The table has two main fields: OperatorId and DTCreated.
I am trying to devise a way to calculate the time between two records based on the DTCreated field.
Can anyone assist ...
0
votes
0
answers
380
views
Microsoft Access Query Count two different criteria in one Query
Really Bugging me that i cant do this !!
i am trying to show two columns one call visits and one called Pointless visits from a quantity field.
Visits needs to be a count of all records in Qty ...
1
vote
1
answer
226
views
Populating fields in existing records in postgresql using record ID to determine what goes where
The Scenario
I have a postgresql database containing a list of product variants, which has been populated automatically, however, without the part numbers. I exported the table in order to run some ...
1
vote
0
answers
559
views
Error when connecting an Access query to an excel sheet -expression in query prevents connection being made
I have an Excel sheet which is linked to a query in my Access database (both 2010 version). It works really well and I decided that I wanted to have the same Excel sheet but to only contain data for ...
1
vote
0
answers
252
views
Access 2010: Database cannot be opened because the VBA project cannot be read
I used a simple software made with access on windows 8 s.o. with accde extension
After formatted pc and installed windows 7, I can't run software because "Access 2010: Database cannot be opened ...
1
vote
1
answer
31
views
Access 2010 - Providing the FE to Users
I have an Access database I split into backend and front end. I want to share the Front End with users; however, I don't want them to have all the queries I use (not useful to them). Can I hide my ...
1
vote
1
answer
5k
views
How can I determine which SQL db my Access app is pointing to?
There is no ini file containing any kind of connection string so it must be embedded somewhere, but where can I find this?
The linked table manager appears to point to something but doesn't give ...