Microsoft Access is a rapid application database development tool.

learn more… | top users | synonyms (1)

0
votes
0answers
3 views

Troubleshooting an Access rowsource query with a server name specified?

I have a list box rowsource query that addresses a specific MS SQL server in it: SELECT DISTINCT alistname FROM differentserver.dbo.Inventory ORDER BY alistname When I try to run this query in ...
0
votes
0answers
9 views

I have an error 3223 err.number access microsoft [closed]

I have an error 3223 err.number access microsoft while executing "DoCmd.OpenReport" The error message is '[DalğaBlablabla].[Blablabla].[Blablabla....' is invalid because it is too long, or contain ...
0
votes
0answers
21 views

How to do a cross apply in MS Access?

I have a cross apply query that I wrote in the SQL Server Mangement Studio where I can't seem to figure out how to write the same query in MS Access. I know how to do a GROUP By in MS Access the ...
0
votes
0answers
7 views

Is there a way to prevent the Action Catalog from opening when a macro is opened in design view?

I'm aware I can close it after it opens, and it stays closed for further macros, but that first time it makes opening the design view irritatingly slow.
1
vote
0answers
23 views

MS Access 2010 Expression error when using Column filter - “The expression ”|“ you entered is invalid.”

This a very odd problem and I am hoping that someone here can figure it out. I get this error when working in a database and trying to FILTER a table by column and more than 1 value. “The expression ...
0
votes
0answers
7 views

Access Database Forms - Query placement and functionality

The question actually has two parts, the first is that I currently have a working access database and query for the database. I'm trying to make a search page for the database, but I would like the ...
0
votes
0answers
12 views

Microsoft Access - how to show document location in quick access toolbar?

In Excel 2010, I am able to show the location of a workbook by adding "Document Location" to my quick access toolbar (this is found under "commands not found in the ribbon). This is shown in Excel ...
0
votes
1answer
18 views

Can i give foreign key relationships of ODBC tables from ms sql to ms access

I have a question regarding the ODBC relationships between SQL and MS ACCESS as i have migrated several tables from SQL to ms access and i performed some operations but the problem occured in ...
0
votes
0answers
13 views

Use subform value when saving record from main form in Access

I have a main form and a subform. When I create a new record with the main form, I need it to save the value from a subform into the main form's table. I have a text field bound to ...
0
votes
1answer
17 views

Can i input duplicate values in foreign key column

A small but important question can input null and duplicate values in foreign key column connected with some another table with same column identity and values as far of my knowledge it is not ...
1
vote
0answers
43 views

Can't create a COM object in a powershell script running as a scheduled task

I have a powershell script I'm trying to run as a scheduled task. Its purpose is to perform a nightly export from an Access database, then upload the exported flat files to an SFTP destination. The ...
1
vote
0answers
4 views

Showing where infortion was imported from in ACCESS

I have imported a few excel spreadsheets into one ACCESS table but i need to add a column named "source" that will show me where the information was imported from. Any function or coding will help
0
votes
0answers
43 views

Unable to open MS Access MDB from mapped drive hosted on Windows Server 2008

I administer a MS Access database (.mdb) at my workplace and users are reporting that the frontend can't be opened. The database is split (backend/frontend) and users access the frontend by either a ...
0
votes
0answers
7 views

Make Access Inputbox Alert

I have an access macro that imports some data and sets a certain field to a value I give it in an inputbox, and I was wondering if there is a way to make the input box alert like I have my message ...
0
votes
1answer
29 views

Is there a function in Excel or Access to reshape a table to First Normal Form, or a way to do it in SQL?

Very often tables are presented in Excel files in a non-normalized form. I have one such table which I wish to take into (somewhat) First Normal Form using either SQL commands in Access or, ...
0
votes
0answers
48 views

How can I reinstall the 64-bit version of MSO2013 if I've purchased a Dell computer with MSO2013 32-bit installed?

W7/64. I'm a SQL Server developer dealing with the mess described here, which is that the 32- and 64-bit versions of the MSA10 engine cannot coexist on a single server. This problem might be solved ...
0
votes
1answer
35 views

Cascade combo box query sorting

I have a question regarding ms access 2007 query sorting for the cascade combo box. As i have initially 3 tables with names country,state and city and i want to have a combo box such a way that if i ...
0
votes
2answers
21 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 ...
1
vote
0answers
26 views

Removing Access 2013 password

I have MS Office Access 2013 installed on my machine. I've set an application password a while ago but now I forgot... Since this is not a mdb or accdb specific password, I couldn't find a way to ...
0
votes
0answers
21 views

Edit MS access front end

I need to edit an MS Access database. It's split into 2 parts. database.accdb which has a password and shows me the front end database-be.accdb which is the back end and shows me the tables I can ...
0
votes
0answers
27 views

Access Database Tables

I have taken over responsibility for an access database not designed by me that I need to clean up. I have a table that I need to find out how it is calculating data. I can't find that it is based ...
0
votes
1answer
35 views

Passing an element name using a variable in VBA

I have a multi page element on a MS Access form and I am trying to use GetArgs to identify which page to open using the below code. Dim WrdArray() As String If Not IsNull(Me.OpenArgs) Then ...
0
votes
0answers
79 views

Access 2010 WebBrowser Control configure Windows Explorer to show Details

I wish to use a WebBrowser control in Access (2010) as a Windows Explorer but each time the control refreshes, it re-sets the view to Tiles. I want the display to show Details view. I have set the ...
3
votes
1answer
77 views

How to avoid rounding numbers in MS Access 2007-2013?

I have an MS Access 2007-2013 database (.accdb format) which I open in MS Access 2013. It has just one table with several columns Lat Long PositionDate -54.82045 -68.33834 ...
0
votes
0answers
11 views

Text-to-head in MS-Access text field

I have a text field (255 char) in MS-Access and I would like to insert a text-to-head command for the print modality. Now the note text in something like this: Wake-up at 7.00am. "unknown command" ...
1
vote
1answer
70 views

Can data in the Access 2007 ACCDE file format be viewed outside of Access?

There is free software on-line that is capable of reading the data stored in Access MDB and MDE format. Is there software that is similarly capable of viewing data in non-password-protected Access ...
0
votes
0answers
20 views

I can not make Access repair database using built-in utility?

Access 2013 reports that the file is not a database, and the data in the file are displayed via NotePad. Function "Database Utilities | Compact and Repair Database" does not work.
0
votes
0answers
18 views

Access 2010 fixed width files

When I try to export from Access 2010 to a fixed width file, it's not working. The service paks are installed on my computer; it say they are all up to date.
0
votes
2answers
61 views

Best way to share an Access database

A company who I admin for is looking to create a database for vendors to be able to access their trackers to follow the progress of their projects. I want to build the database in access, but my ...
0
votes
0answers
37 views

MS Access Personal Macro Workbook

In MS Excel I have a personal macro workbook that is with me no matter what excel file I open. Is there a similar solution available for MS Access? The reason I am working on this is that i want to ...
0
votes
0answers
20 views

Microsoft Access change default row height for inserting rows on form?

I frequently insert new rows in a table layout on an Access form. I am unsure where to change the "default row height" - the rows are always 0.1667" height when I insert them. The rows I am adding ...
-1
votes
1answer
23 views

Operation in MS-Access?

Is it possible to view a new column in MS-access with simple operations? eg: my database has 2 columns A: arrival time B: departure time I want to view C column with (B-A)
0
votes
0answers
6 views

Short cut to move in sub-mask in MS-Access

I have a mask with 3 different sub-masks in this layout main (level 0) submask1 (level 1) submask2 (level 1) submask3 (level 1) when I use to entry data I can move the cursor using TAB. After ...
0
votes
1answer
50 views

Import a large number of .csv files into Access

They are all in the same format, an I want all of them to be in thier own tables, with the table name being the same as the filename. How can I do this?
0
votes
0answers
40 views

Viewing tables from Microsoft Access database on Mac/OSX

I'm looking for a way to VIEW (not edit) tables or queries in a Microsoft Access database on a mac. The database file is located on a Windows computer, and can be put in a shared network location. ...
0
votes
2answers
60 views

Import data from Word 2003 (Doc) file to Access?

Is there any way to import data from a table in Word 2003 (Doc) file to Access 2010?I tried External Data menu in Access 2010 but it has not an option for importing from Doc file. Really I did not ...
1
vote
2answers
47 views

Problems with MS Access running slowly?

I have to use MS Access in a remote location nearly ten miles from the servers where the database is stored. Here are some of my impressions: I am under the impression that the connection between ...
0
votes
0answers
103 views

We need to open an unknown .dat file

We have an unknown .dat file By a text editor on first of file it says: Standard Jet DB I tried to open it by Microsoft Access but it says enter password. I tried to recover password by "access ...
2
votes
1answer
82 views

Why do “yes/no” values in Microsoft Access map to -1 and 0?

The use of -1 puzzles me. I would have expected the values to be: NO --> 0 YES --> +1 Is there an historical reason behind the use of -1 instead of +1?
0
votes
1answer
80 views

How to one-click print in Access 2010

I want to create a button on a form in Access 2010 that, when clicked, prints the current record/view of a form. I have tried various VBA scripts. Some print all records, others print partial parts of ...
0
votes
1answer
37 views

Linking two entries in a list

I'm a keen DOTA 2 player. It's a 5-a-side team video game where you play one from a pool of about 100 heroes with different abilities and strengths and weaknesses. I often play team captain and it's ...
0
votes
1answer
26 views

MS Access Autonumber dilemma

I am using a sql query that will copy the data from one table to another. The problem though is the counter which I put in the Second table of my Insert into Select Statement. It all started from ...
0
votes
1answer
36 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
19 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
91 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
0answers
21 views

how to toggle values and look for a lable ms Access 2010

Function ToggleLabels(ByVal lblName As String, lblStyle As Integer) Dim objL As Label objL.Name = lblName If objL.BackStyle = 0 Then objL.Caption = "" objL.BackStyle = 1 ...
0
votes
1answer
27 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
664 views

Include Access database in VB.NET 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 only way the file is being used is when the program copies it to a ...
0
votes
1answer
31 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
22 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?