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

learn more… | top users | synonyms (1)

0
votes
2answers
2k 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 ...
0
votes
2answers
475 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 ...
0
votes
2answers
1k 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 ...
2
votes
1answer
121 views

How to toggle between views in Access 2010

I have a form which displays count sheets. One view is with the pre-count qty and the other is without the pre-count qty. This was originally developed in Access 2003. I can not toggle between the two ...
1
vote
1answer
216 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 ...
1
vote
1answer
3k 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 ...
1
vote
1answer
699 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 ...
0
votes
1answer
13 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 ...
0
votes
1answer
191 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 ...
0
votes
1answer
1k 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
1answer
66 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
1answer
1k 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 ...
0
votes
1answer
754 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
859 views

Focus the property sheet in Access 2010

Is there any keyboard shortcut in Access 2010 to focus the property sheet? In Access 2000 and 2003, I could press F4 (or Alt-Enter) and then type to change the value or the selected property, or use ...
0
votes
1answer
1k views

How to import row data into Access when Excel does a date conversion?

I have an Excel worksheet that looks like this: MONTH WIDGET QUANTITY COST Jul-09 Widget1 1000 1.00 ... <repeat a few thousand times> ... I would like to ...
-1
votes
1answer
112 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. ...
2
votes
0answers
45 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 ...
2
votes
0answers
85 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([£ ...
1
vote
0answers
9 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! ...
1
vote
0answers
20 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 ...
0
votes
0answers
7 views

Count checked boxes in a list in MS Access

I am trying to make a query that counts the checked boxes in a list. We have a list of crew members that are checked when a person is present. I would like to be able to query out the number of ...
0
votes
0answers
33 views

The query could not be processed: File system error: An error occurred while opening the 'File Path\file_name.cub' local cube file

Please Help Me !! What happen and how to fix it ? It occurred when I open Pivot Table in Access 2010. (My OS is Windows 10) File Path\file_name.cub is always changed every time database is opened. Now ...
0
votes
0answers
22 views

Query will work in designer but not in code

I have used this type of structure several times with no problem but this time I get a "type incompatibility" error message (error 13). The SQL statement returns results when I run it throught he ...
0
votes
0answers
30 views

Hide column in report based on combo box on form

In Access 2010 I am trying to get a report to show or not show the contents of one column based on the value of a combo box on a form. For example, the column name in the report is "foo" and I only ...
0
votes
0answers
53 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, ...
0
votes
0answers
42 views

Advanced Query Filtering in Access 2010

I am using Access 2010 to log prospective students for a school program. Once these students apply, they need to have a school ID generated (or if they are a current or former student, simply looked ...
0
votes
0answers
19 views

Access 2010: How to enter dates in a payroll?

I am trying to create a payroll for employees. I set up a staff_details table, salary table and deductions table. I also added a salary_date field to the salary table. Problem is, I do not know how to ...
0
votes
0answers
183 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
94 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
68 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
0answers
36 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
0answers
1k 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. ...
0
votes
0answers
46 views

Microsoft Access 2010 upgrade issues

I have just been upgraded to MS Access 2010, and am experiencing: syntax error (missing operator) in query expression "xx" Is this because all the tables were created in Access 2007, and Access ...
0
votes
0answers
43 views

Access Query: Matching days up days of the week for past years

I have historic data in a table in Microsoft Access from seven years ago. I need to create a query with a column for each year and match up in each row the 1st Monday in 2007 with the 1st Monday in ...
0
votes
0answers
675 views

When using the Access Table Analyzer Wizard, I get the error “Cannot define field more than once”

I'm trying to normalize a very simple dataset: user_id | role_id I have a table with 60,000 records, and all I need to do is turn this into a join, so one table contains users, and another table ...