Microsoft Access is a rapid application database development tool.

learn more… | top users | synonyms (1)

0
votes
1answer
109 views

Microsoft Access 2003 on Windows 7 x64 fails to restart after loading a form that has a subform

Here's the problem: Open Access 2003 on Windows 7 and load a form that has a subform. Then close Access. Try to start it again. You can't. You click on the start menu to run it but nothing happens. ...
1
vote
1answer
77 views

Does a “make-table query” ever delete anything in Microsoft Access?

When I use a query to make a new table, does that data get deleted from the old table when it is put in the new table, or is it duplicated so that a copy of the data is now on both tables? I partly ...
0
votes
1answer
361 views

cascading combo boxes and queries in access

I am using access. I have queried a table using a form to trigger the query, with three combo boxes(cascading) the results how ever are not based on the three criteria, only the first. The code below ...
0
votes
1answer
42 views

Get date from a datetime in access

In access query ,I only need to get the date 01/01/2012 for example from the following : 01/01/2012 9:18:35 AM how can this be done?
0
votes
1answer
2k views

Include database in project without adding datasource?

For the project I am working on I have created an empty database as a template file and need it to be included in my project. The file is only being used when the program copies it to a new location. ...
0
votes
1answer
205 views

Access 2007 - Auto Refresh Without VBA?

I have developed a system using Access 2007 and would like to know if it is possible to auto refresh the data within each element of the entire form after the selection changes. For example: I enter ...
0
votes
0answers
29 views

Microsoft Access 2013 Files

I created a file in Access 2013, but now only have Access 2007. Is there a way I can open this file in Access 2007?
0
votes
1answer
260 views

MS Access 2007 - Update query won't update

I have a Access 2007 database that I wish to be able to click a button and update Null values in a table column with the current date when the button is clicked. For some reason it just won't update. ...
1
vote
0answers
77 views

MS Access saving changes made in one table to another table

I am trying to create a tables relationship, so that before the record gets changed through the form, it gets saved in the separate table, so that the record before changes can be retrieved for future ...
1
vote
2answers
834 views

Access keeps asking to enter parameter value

I have the following query in Access: SELECT Death.AccountNumber, Count(*) AS NumberOfRecords FROM Death GROUP BY Death.AccountNumber HAVING (((Count(*))>1)); The field AccountNumber has ...
1
vote
3answers
96k views

How to Merge Data From Multiple Excel Files into a Single Excel File or Access Database?

I have a few dozen excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 master file which must have just 2 of the 4 worksheets. The ...
0
votes
1answer
33 views

How to delete spaces in my access reports?

my report adds two fields together but the first field has spaces in it and puts a big space in my report. I have be going to each field and back spacing all the blank spaces. this takes a long time ...
1
vote
1answer
61 views

Export from Access to Excel, Bosnian char š not showing completely

I hope this is the right StackExchange forum for my question. I need to export a table from Access to Excel. It has all sorts of special characters in it. Ranging from é, à, ù to ß and finally š. ...
0
votes
1answer
751 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 ...
1
vote
1answer
3k views

Install MS Access 2013 alongside Office Home and Business 2010

I currently have Office Home and Business 2010 (64 bit) installed on my computer (running Win7), and the trial period of Access has just ended. I don't want to purchase a whole new office suite if ...
0
votes
0answers
67 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
184 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
64 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
60 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
91 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
890 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
696 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
1k 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
928 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
5k 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
437 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
71 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
1k 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
708 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
1k 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
148 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
577 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
4k 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
684 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
429 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
106 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
549 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
161 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
90 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
1k 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
85 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
114 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
685 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
395 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
213 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
4k 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 ...