Microsoft Access is a rapid application database development tool.

learn more… | top users | synonyms (1)

0
votes
0answers
63 views

SQL Query from Excel 2007, use in Access 2007?

I have a query written with MS Query in Excel, but I would like to instead run this in Access. I'm getting a "syntax error in query" and not sure what it is. This is the query: SELECT ...
2
votes
1answer
155 views

'Select Table' screen when trying to open MDB file

One of my end-users is having an issue when they open an MDB (Microsoft Access) file over the network. This user only uses this access database once per month, and it worked fine last month. This ...
0
votes
1answer
54 views

Creating Relationship in MS Access

I have a Student table and a Course table. One student can be involved in many courses and a student can only pay the fee of the course which he is invloved. How can i create relationship for this ...
0
votes
0answers
12 views

Is there any way I can access an access database I set to read only from other computers on another computer?

Basically I secured the database to only open fully on one system but now I need to change it from another system. Is there anyway I can do this? Thanks Edit: The database is a .accdb I changed the ...
1
vote
1answer
54 views

MS Access - Totals in Report

I have constructed a database in Microsoft Access and have a report in which I want to include the number of alerts that relate to certain areas. If I wanted to include the number of alerts relating ...
1
vote
1answer
77 views

How to get access into table mode?

An Access database is getting to much data through forms so new copies get made. To make the old data available for searches the tables should be linked. The problem is that the menu group "EXTERNAL ...
0
votes
3answers
639 views

MS Access - Auto-Update Data Type After Import

I am looking to automatically update the data type of numerous fields in MS Access once I have imported some Excel data into the database. Almost all fields are set to Text fields, and this would ...
0
votes
0answers
513 views

Why is MS Access Report repeating the details section?

I am using MS Access 2010, and I created a form that then produces a report. Because it is designed to print on a label instead of a regular piece of paper, the entire report is smaller than usual, ...
0
votes
0answers
10 views

Access VBA code combination not working, issue with exit sub? [duplicate]

I'm very new at VBA and I can't seem to solve this problem. It seems like it should be an easy problem to fix, I just don't know how. I've looked around on the web, but the question remains unsolved. ...
0
votes
2answers
1k views

Acces VBA code combination not working, issue with exit sub? [closed]

I'm very new at VBA and I can't seem to solve this problem. It seems like it should be an easy problem to fix, I just don't know how. So what the code does: In the main form is a record. This record ...
0
votes
1answer
762 views

Access: How to match/relate records to each other within the same field?

In my Access Database is a table with project information, the ID is 'projectnumber'. I want to be able to match/link/relate different projectnumbers (all stated in the same field) to each other. So ...
0
votes
1answer
749 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?
1
vote
4answers
3k 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. ...
2
votes
1answer
362 views

Adding foreign keys from existing Access tables to imported Excel sheet

I have an existing list of personnel that I am trying to associate with an imported list of computers. Specifically, I want to replace the current columns listing the names of the personnel assigned ...
0
votes
0answers
67 views

export windows file structure into .csv with date parameters

My real goal is to get a list of the files in my windows file structure into Access, but as there are over 500k files the various bits of VB code I've tried all take a very long time and is not ...
0
votes
2answers
794 views

VBA remove string by a specific character

I have a String str = "abc#daso.xlx". I want to remove all characters in front of "#" so str -> "#daso.xlx" . I can't use Left or Right function because the length of the string in front ...
0
votes
1answer
592 views

How to export multiple Access Class objects to text from Microsoft Visual Basic for Applications at a time

I have a lot of access files that have Code Behind event procedures defined using VBA. I want to search this code for a large number of strings. I can accomplish this by selecting the Access Class ...
1
vote
2answers
790 views

How do I find an existing query in an Access file?

I have an .mdb file that should contain a complex query that I would like to modify. The .mdb somehow is used to create reports against a database. If I open the .mdb file, I see all the ribbon ...
0
votes
1answer
119 views

Windows Help Shows Blank Window

I use Access 2000, and when I am using the VBA IDE, I sometimes press F1 for help on a certain keyword. Afterwards, the help window shows, but it's a blank white window with a title bar stating ...
1
vote
1answer
455 views

Excel data doesn't update after data injection from an access db

Description of the situation: I have a access DB where I export data with the following command to an excel: DoCmd.TransferSpreadsheet The export works and the data is exported into an existing ...
1
vote
1answer
2k views

Access Query for Positive Checkboxes

I have a table which contains personal information of our staff, at the end of the table there are checkboxes for general training (medical, military, health and safety) etc. Say for example i wanted ...
0
votes
0answers
599 views

Ms Access : “Unrecognized Database format”

I have an VB6 project which use the database MS Access 2000. With some electricity problem i lost the database file from project, but with the help of some recovery based tools , i recover the data , ...
0
votes
0answers
317 views

Using Hyperlink in Access to link to excel spreadsheet

I am trying to link a cell in a table in Access to some specific spreadsheets in an Excel workbook. I used the hyperlink and put the address like this "My%20workbook.xlsx#Sheet12!a1" , it work ...
0
votes
2answers
96 views

Combining two Excel sheets

I ship a lot of items to a lot of stores and I have two Excel sheets. I have one sheet showing how many items I have shipped to each store and another sheet showing how many I have sold in each store. ...
0
votes
1answer
414 views

customize access 2010 Ribbon

I have notice Microsoft provide 2 verions of guildline to customize Access Ribbon, one for version 2007, other for 2010. ...
1
vote
1answer
146 views

Database workflow advice? [closed]

I've got a product database that I need to update a couple of times a week and am looking for some advice on what workflow I should setup. I can export my database from my online store as a CSV, I ...
0
votes
0answers
75 views

Access Query Designer Woes — select by multiple values not working

Table 1 Names Table 2 Services If I do a simple select of both tables together, I get a list as follows: Name1 Service X Name2 Service X Name2 Service X Name2 Service Y Name3 Service Y Name3 ...
1
vote
1answer
827 views

Passing Query Parameter to Sub-Report

It has been a long time since I have worked with MS Access and am not sure if I am doing this right. I have a Report bound to a query of single list of user names. The report groups on the user name ...
0
votes
1answer
81 views

How to retrieve data by dates that are not affiliated with the same field in each record

I have a data base that has fields (i.e. Date 1, Date 2, Date 3, etc.). Associated with those dates are Breakfast 1, Lunch 1, Dinner 1. Each person's Date 1 is not necessarily the same date ...
1
vote
1answer
99 views

How do I perform this special operation with a calculated field in Access?

I have a Microsoft Access table called calc1 with fields: calc_ID (primary key, number) calc (text) I have another table called res1 with: res_ID (primary key) calc_ID (number) dimensionbefore ...
0
votes
1answer
536 views

0kb Access Database file, file not found

This could be related to Access or separate entirely. I have an access database in a mapped network drive that reads 0 kb and upon opening, Microsoft Access 2010 tells me the file cannot be found. ...
0
votes
0answers
316 views

Microsoft Access Print preview report subreport getting cut off?

While creating and previewing a report on Microsoft Access, the last field of the sub report is being cut off. There is a scroll bar if viewed as report view. Everything has been set to can grow. If I ...
0
votes
1answer
196 views

visio excel link

I was wondering if is there any chance that I could connect visio with excel in dual link? ill try to be more specific. I already linked visio with excel, I mean, I edit properties in excel and when I ...
0
votes
2answers
3k views

Export only specific range of rows in Access

I know MySQL but I don't know Access. I have nearly 1 million rows and I want only the rows between 300 000 and 500 000. I mean as seperate file. I don't need the ones before 300 000 and the ones ...
0
votes
1answer
48 views

Ms access Speed issue with vista office 07

Greeting, I lately upgraded my MS Office from 03 to office 07, Using windows Vista. I am using an access based program for my business and it was very smooth and fast, but since the upgrade ...
0
votes
0answers
339 views

Microsoft Access Database and Unicode Charset

Im trying to edit the database of a program to make it output unicode or utf8 characters. As of now the characters appear as question marks. The database tables contains strings like this: ...
0
votes
2answers
633 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
102 views

advice on generating reports with Excel vs Microsoft Access

I have a Microsoft Access based tool that lacks the reporting capability I need. The tool is able to extract extract each table from its relational database as a separate CSV file. These files aren't ...
1
vote
1answer
3k views

How to convert from Access 2010 (.accdb) to Access 95/97 (.mdb)?

How can I convert an Access 2010 .accdb file to an Access 95/97 .mdb file? Is there a conversion facility available within Office?
0
votes
1answer
852 views

Simple fixes for improving multi-user MS Access performance?

I'm overhauling the entire IT infrastructure for a small office. They had a Dell T410 doing nothing but serving as a Win2k8 file share, so I figured I could replicate its functionality on an unused ...
0
votes
0answers
2k views

Cannot open all .SNP snapshot files on Windows 7 x64

We receive .snp snapshot files from legacy MS Access databases out in the field. Our new Windows 7 x64 machines are running Office 2003 and the Snapshot Viewer (SNAPVIEW.EXE), however the vast ...
2
votes
0answers
107 views

Insert Excel Spreadsheet Into Word From Access Database

I have an Access database with Excel spreadsheets (files) linked to a field in each record. In Word, I have setup a mail merge which picks up the data from each record and I want to insert the ...
3
votes
1answer
799 views

How can I open a .mdb with a password in OpenOffice?

I'm trying to open a .mdb with a password in OpenOffice Base. I can connect to the .mdb, but I cannot specify a password (forums say this method doesn't support passwords). Is there a way I can open ...
0
votes
0answers
39 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
2answers
5k views

Access 2007 wont open in 2013 just gives errors saying not compatible

This is my first attempt at a big access project so please be gentle :) I have created a database in Access 2007 on my works PC and it is a .accdb format files. I tried to open it in Access 2013 on ...
0
votes
1answer
1k views

Append a record's field value with a string in MS Access SQL

I would like to run a query that updates a field's value with whatever is already there but with an "n" appended in the end. For example say there's a field called AccountNumber and for a certain ...
0
votes
1answer
593 views

Can Access display a related field on a data entry form?

Let's say I'm building an Access database to hold recipes and calculate the cost of those recipes. I need a table of recipes, a table of possible ingredients, and a table of recipe line items. Each ...
0
votes
2answers
1k views

Is it possible to convert a Microsoft Access MDE file to an ACCDE file?

I wish to convert an MDE file to an ACCDE file. Assume I don't have access to the original MDB file.
0
votes
0answers
53 views

Divide one long line into shorter lines with the particular data

I have a query in Microsoft Access which extracts data from 2 tables: 'modems' and 'antennas' Headings: 'StName' 'ModemType' 'ModemInstallDate' 'ModemPrice' 'AntennaType' 'AntInstallDate' ...
0
votes
2answers
272 views

Microsoft Access 2010 loads slowly every time

More in hope than expectation ... I've lived for some time now with the fact that Access 2010 takes a minute or two to load on my laptop. The problem is to do with the fact that I've also got Access ...