Tagged Questions

0
votes
0answers
36 views

How do I export to CSV without decimals using MS Access 2010?

Is there a way to export numeric data to csv file in MS Access 2010 without decimals? I am using ImportExportText in my macro. I don't see anywhere where you can specify this. The macro is ...
0
votes
2answers
69 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
0answers
22 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
86 views

How to join duplicate fields in one table in Access 2010

Have a table1 with the following fields: Recipient, Sender, & Comment. Recipient and Sender are duplicate employee name fields. I want to create a query that summarizes how many comments the ...
3
votes
2answers
208 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
493 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?
0
votes
1answer
2k 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
2k 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 ...
0
votes
1answer
450 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
460 views

Access 2010 forms: direct entry of foreign key into text box

In a form I am creating for an MS Access 2010 database, one of the fields represents a foreign key. I would like this field to be displayed as a text box, rather than as a combo or list box as is ...
1
vote
2answers
5k views

“MSCAL.OCX” error when moving from Access 2007 to 2010: I don't have a calendar

I have a database created in Access 2007. When opening it in Access 2010 I get the following error: "Your Microsoft Office Access database or project contains a missing or broken reference to ...
2
votes
1answer
368 views

Is it possible to create groups of objects in Access 2010 forms?

I have a form with 3 option buttons, and about 50 labels, textboxes, and buttons. Is there a way I can group some of these objects so that way when I select an option, some of the objects get disabled ...
0
votes
0answers
338 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 ...
0
votes
1answer
481 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 ...
0
votes
4answers
1k views

Microsoft Access: How do you create fields with multiple boxes to tick?

I'm using Microsoft Access to fill in information from a questionnaire, which has been answered by 80 people. This is a questionnaire with both quantitative and qualitative answers. I've set it up so ...
0
votes
1answer
784 views

MS Access Forms: Store number is table, display text in ComboBox

I'm using Access 2010. In trying to maximize both user friendliness and data efficiency, I'd like to store or reference a record by a reference number and display it in forms by the value in a ...
1
vote
4answers
493 views

MS-Access database-upsizing error

I am working on upsizing an MS-Access database from Access 2010 to MS-SQL 2008 (10.0.1600). When I run the Upsizing Wizard, all the tables get moved over except for one... The table that doesn't get ...
1
vote
1answer
1k views

Using a PivotTable to Count Items in Access

I have a list of text entries and I want to count how often each entry appears in the list. e.g. Berlin Paris London London Paris Paris Paris The result would be Berlin 1 Paris 4 London 2 This ...
3
votes
1answer
5k views

How do I view system tables for a `.MDB` in Access 2010?

How do I view system tables for a .MDB in Access 2010?