Questions tagged [microsoft-access-2010]

Microsoft Access 2010 is a Rapid Application Development (RAD) and desktop/workgroup database application.

Filter by
Sorted by
Tagged with
1
vote
1answer
67 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 ...
0
votes
2answers
267 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
0answers
44 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
1answer
942 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
1answer
67 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
0answers
356 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
1answer
80 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
0answers
427 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
0answers
217 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
1answer
24 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
1answer
2k 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 ...
1
vote
0answers
20 views

How do I bypass the Bypass startup if the person who set it is gone in Microsoft Access Plus 2010?

The database is set to disable the shift key when opening, but the person who set the Bypass startup is no longer employed here. We need to edit tables and a query in the background but can't get in! ...
0
votes
0answers
192 views

MS Access Ctrl + Enter for new line results in extra line breaks when exported to a text file

I am preparing a database with many different types of fields. One, a memo field is best organized with line breaks. When I type the lines and use the appropriate Ctrl + Enter to force a line break, ...
2
votes
0answers
116 views

How to paste multiple entries to a query?

How to do you paste multiple entries to a query in design view? I can only paste one value at a time, and I need to add multiple values. Is there a way of doing an Advanced Filter in Microsoft ...
0
votes
1answer
967 views

Change background color of text box in MS Access form based upon information from query

I have a form that displays data from a table in MS Access 2010 and allows users to change the data in the table; along with other information this table has a list of unique serial numbers. I would ...
1
vote
0answers
24 views

Which Databases Link to Particular Table in Database

I'd like to know if there is a way to determine which databases link to a particular table in a database without looking through each database to see if it links to the database of interest. I'm ...
1
vote
2answers
3k views

Query for false values in Access not working

I'm trying to create a simple database to keep track of paperwork as it's turned in. In the form and table I've used yes/no check boxes, checking them when a paper is turned in. What I want to do is ...
0
votes
2answers
2k views

MS Access 2010 maximum number of records

I have VBA program written in Access 2010. It creates and populates a table from a text file. Previously, there have been less than 20,000 records total. With the current data set, I get an ...
-1
votes
1answer
554 views

I need to calculate the time between two dates in access in working hours

I have a formula to do this in Excel, but I want to convert it to Access I have two dates - start time and end time. I need to know the number of hours:minutes between them in business hours only. ...
0
votes
1answer
6k views

How to store a Display text along with Hyperlink in Microsoft access 2010 database?

i mean how to store "Display text along with Hyperlink" in microsoft access database so that when you generate "Forms" from the database table. and you click on the that item text , you are actually ...
0
votes
0answers
305 views

Text Box and Combo Box conflict

I should mention that I'm brand new to Access, so please don't vote down my question. I really need help on this. If someone doesn't help me, then I'm just going to keep posting the same question ...
0
votes
0answers
468 views

Recover back end database password from front end connection string

I built an MS Access database about a year ago and set separate passwords for the "front end" and "back end" components of the database. It's been a long time since I've had to access the back end ...
0
votes
0answers
84 views

How to place query data of one column into multiple report columns

I have a multi-table query in Microsoft Access 2010. The Employee Table (name, employee #, position, etc.) and a Time Input Table (date, cost code, Reg hrs, OT hrs). After inputting hours, cost code ...
0
votes
3answers
5k views

How to lock Access 2010 record after it has been saved?

How can I create a macro to permanently lock a record once it has been saved? My problem: every Access 2010 lock command that makes the saved records un-editable, also locks the 'New Record' form ...
2
votes
1answer
3k views

When importing an Access table into Excel, a look-up column is showing all values as numbers

I have a basic Access to Excel question that has me frustrated. I have two Access 2010 data tables. One is a list of managers. The primary key is a manager ID (which is an autonumber because managers ...
1
vote
1answer
3k views

Can I change the default Access 2010 view to allow for “Window”ed objects?

Before Access 2007, Microsoft Access was an MDI Container. For those who aren't developers, this means that each time you opened a DB object (i.e. Data Table, Query, Form) it appeared as a window ...
0
votes
1answer
14k views

Access 2010 Table appears to be locked and can't be modified? How do I unlock it?

I have rather simple Access 2010 database. I needed to add a new field to one of the tables. While in Datasheet View, I Clicked the "Click to Add" column header and defined a new field. I went to ...
0
votes
3answers
2k views

MS Access 2010 “The expression ”|“ you entered is invalid.”

This a very odd problem and I am hoping that someone here can figure it out. I get this error when working in a database and trying to FILTER a table by column and more than 1 value. For instance, ...
0
votes
3answers
1k views

Access 2013 file to open in Access 2003

I made Access Form which was working fine in Access 2013 and Access 2007 until I add some new features(I don't remember what) to it. After adding them, it keeps giving me error "Unrecognize file ...
3
votes
1answer
4k views

How to avoid rounding numbers in MS Access 2007-2013?

I have an MS Access 2007-2013 database (.accdb format) which I open in MS Access 2013. It has just one table with several columns Lat Long PositionDate -54.82045 -68.33834 ...
1
vote
1answer
329 views

MSAccess - Updating all fields in form when selecting one field from listbox

I have a form which has the following fields Club Player Handicap Membership Number Score I have set the Club as a list box how do I get the other fields to automatically polulate when I ...
2
votes
2answers
9k views

Password Protect Access Database from Edits

I'm familiar with how to encrypt an Access database with a password (requiring a password to view data). Is there a way to allow data viewing w/o a password, but requiring one for editing the database?...
0
votes
1answer
137 views

Automating the input of query criteria

New user to this site and found an extremely informative answer to a question I had but can't find an answer to this one. Using Access 2010, I have 42 different criteria that I need to run ...
0
votes
2answers
655 views

Why is my pivot chart not saving properly in Access 2010?

Working in Access 2010 and am trying to build a pivot chart from a query. My query is looking at an item type (multiple possible) and closure date with the intention of creating a stacked bar chart. ...
0
votes
2answers
5k views

MS Access List Box Lookup on Table Not Showing in SubForm

I have a list box lookup embedded into one of my tables: This works fine and shows up in the datasheet view of the table. However, I built a form, bound to the table, but the drop down list does not ...
0
votes
0answers
41 views

Add Microsoft Access to my 2010 package

Let me know if I am sinful for asking this and I will delete it. I would like to add Access to my 2010 Office package (for a few months). Is that possible? How is it possible? The issue is that I am ...
0
votes
1answer
1k views

How to automatically make all entries to become Hyperlinks to files in folder in Microsoft Access Database

I have Microsoft Access database, where I want to keep hyperlinks for the pdf files. I got the list of filenames and put in corresponding fields in my database. I made that Field of Hyperlink Data ...
0
votes
1answer
2k views

Export an entire Access (accdb) database to csv/txt

There is no option to export the whole db, rather Access only allows export of one table at a time. I'm not familiar with any VB scripting so how would I go about doing this? CSV must be exported ...
0
votes
1answer
2k views

Save multiple Selected Items From List box In Access

I have a simple form in Microsoft Access 2010 in which I have a list box with Multi-Select Enabled. I want to save the selected items in table. How would I go about it in Access 2010?
4
votes
4answers
12k views

Active content security warning in all files

Every time I open a *.mdb or *.accdb file I get the yellow Message Bar with a text in Spanish that translates as: Security Warning: Some active content has been disabled. Click for more details. .....
0
votes
1answer
3k views

How do I control MS Access navigation pane by macro or VBA?

I would like to use either macro's or VBA to programatically control the Access Navigation Pane (i.e. hide and unhide it). I've found plenty of resources to hide the Navigation Pane (e.g. ...
2
votes
0answers
106 views

Error when validating formula

I am trying to create a field to convert currencies from one of 2 fields, thus I am putting the following code in "Default Value" as I want this field to be open for my manual input too: =iif([£ ...
2
votes
1answer
8k views

Is there a way to convert a memo field to a text field in Access 2010 in an expression?

I have two tables (each in an Access DB) -- called LinkedTable1 and LinkedTable2 linked to my working Access database. I got them on my computer after downloading them from a SharePoint site (Actions ...
0
votes
2answers
2k views

MS Access Default Images Used On Access Forms and Reports (header section)

From within Access, if you click on the Create tab and then click on the Form button, it creates a basic form with all the fields from your table/query. In the top left hand corner, an image always ...
0
votes
1answer
5k views

Move The New Record Entry Row In Access Table To The Beginning Row

Is it possible to move the "New Record Row" in an Access table to the beginning of the table? For example, say you have 200 items entered into your table, you would have to scroll the whole way down ...
1
vote
1answer
1k views

Access 2010 Multi Table Report Combining Fields with same info

I am creating a Microsoft Access database for my office and am trying to create a Report to show every purchase for the whole office. My office is split into 4 teams, and, due to the differing ...
3
votes
2answers
971 views

Truncation of Calibri rich text in preview/PDF mode on a report

I am experiencing truncation of text in rich text boxes in preview/PDF mode on a report. There is enough space for the text box to grow on the page, and the text appears in full in layout mode, but is ...
0
votes
1answer
16k views

how do you use RunSavedImportExport from a macro

I have yet to figure out all the 'musts' for getting this gem of a macro step to even show up in my macro step drop down. does anyone know what you have to do?
3
votes
3answers
18k views

How can I change the default datasheet font in MS Access 2010?

I've never liked the default font that is used as for datasheet views in MS Access. Recently, I've upgraded from 2003 to 2010, and for the life of me I can not find out how (via Google or otherwise) ...
0
votes
2answers
15k views

Why won't MS Access 2010 show my list of System DSNs when I attempt to link data tables from SQL Server?

Recently the company that I work for has upgraded my PC from Windows XP to Windows 7. On my new PC they've also update my version of MS Access from 2003 to 2010 and they also gave me a new domain ...