Microsoft Access is a rapid application database development tool.

learn more… | top users | synonyms (1)

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
700 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
717 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
342 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
64 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
765 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
580 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
716 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
110 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
426 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
1k 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
581 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
297 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
94 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
398 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
142 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
69 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
774 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
80 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
98 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
501 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
309 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
2k 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
47 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
331 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
579 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
821 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
105 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
740 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
37 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
1answer
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
559 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
52 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
268 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 ...
0
votes
1answer
353 views

Removing the second line of an address when it is null in an Access 2007 report?

I'm trying to use the CanShrink property in a report in Access 2007 so that if the mailingAddress2 field from my query is null or blank it will collapse the Address 2 field and move the mailingCity, ...
-2
votes
1answer
564 views

can a Windows 8 tablet run a Microsoft Access form? [closed]

can a Windows 8 tablet run a Microsoft Access form? thanks in advance, Nahaniel
0
votes
1answer
189 views

Excel or Access: how to group several lines in a table and insert contents in columns? (“split column”)

I have a table containing data of sold products (shown in the example on the left): Columns: Number of the order Product Name Attribute - specifies what is given in the following field "value", e. g. ...
0
votes
0answers
87 views

Access 2003 - SQL Project is not connected to a SQL Database

I believe there is something wrong with Access 2003 on a machine I rebuilt, possibly a missing component. There is an Access database that we use that connects to an SQL database, normally I just run ...
1
vote
1answer
6k views

Access query to combine two columns into one longer column with both sets of data

I need an MS Access query that will combine data from two identical fields in two different tables into one field. The two tables are "Payroll_2011" and "Payroll_2012"; and both tables have columns ...
3
votes
2answers
385 views

How do I add a link to a macro to the Quick Access Toolbar

I am trying to add a button to run a macro in Access 2007 to my Quick Access Toolbar (QAT). In Excel 2007, I have never had an issue. In the Customize Quick Access Toolbar window I can select ...
1
vote
1answer
527 views

Basing one combo box on another

I'm trying to follow the instructions to base one combo box on another in an MS Access 2010 form, and I'm running into some issues. I've got two tables: Strategy +----+-------------+ | ID | ...
0
votes
0answers
58 views

want to combine columns on access 2007

there are 3 columns into 1 in my Access DB which I want to combine without loosing any data. can you please tell me an easy way to do it I have to show it to an elderly person Thanks