Microsoft Access is a rapid application database development tool.

learn more… | top users | synonyms (1)

0
votes
1answer
559 views

Display vs Value in a Microsoft Access Form's dropdown box

I'm a n00b at Access, so I might not be approaching this in an Access-y way. Say I have two tables, A and B. Every A belongs to a B, so A has a column B_id which is constrained to match the id ...
2
votes
1answer
271 views

Access 2003 VBA Form_Timer not firing during mouse drag

I want to catch a repeated 500ms Form_Timer event while dragging the mouse. i.e. between mouse down and mouse up events. The Timer event is firing outside of the drag but not inside. The reason for ...
3
votes
1answer
12k views

Why won't Access 2013 open an .mdb file?

Please not that I hardly ever use Access, so I might be missing something very obvious here, but a quick Google revealed little. I am trying to open an .mdb file used by an in-house application, ...
2
votes
0answers
270 views

Why is my Access 2010 ADP not filtering its SQL statements when connected to MSSQL 2008 R2?

I use MSSQL MS for most administrative tasks on SQL Server 2008 R2 databases, but I find using Access (via an ADP, not linked tables) to view and edit raw table data to be much more efficient. (This ...
1
vote
2answers
650 views

MS Excel and Access - which is better for reports?

Where I work, staff have just started to use a basic table in excel (1 October) to record sales which has about 10 columns (name, client, renewed, discount, paid etc). I record the data (total sold ...
0
votes
1answer
253 views

Oracle local database product (like MS Access)

Is there a Oracle, local database product (which I can run on my laptop like MS Access) which is free for developers, and in which I can Create tables, Load data from file, Run SQL (oracle's syntax) ...
2
votes
1answer
1k views

How to return current record number in Access?

I want to have my table to automatically returns current record number. What functions should I input in default value of this field (indicated in blue arrow) in order to automatically generates ...
0
votes
1answer
501 views

MS Access: Why can I no longer right-click to add a hyperlink?

I've been working in an MS Access system for a while now. It's a form system where users enter data, add links, contacts etc. Pretty simple. On the form is a hyperlink field. For months I could ...
0
votes
1answer
120 views

Does MS Access update the data on the clipboard from a query when the data in the database changes?

I was just debugging a macro in MS Access, and when it hit the breakpoint ran a query and I copied the data from it to the clipboard. Some of the values were null before stepping to the next step, ...
1
vote
0answers
51 views

Changing the connection information on a linked QUERY in Access 2007

This is about linked queries, not linked tables. With no linked tables, the Linked Table Manager is disabled. I know how to see the connection of a linked query, linked to SQL Server: ...
0
votes
1answer
1k views

In Microsoft Access how do you delete all values in a single column without deleting the entire field.

Is it possible to delete all of a column's data in access without deleting the field?
0
votes
0answers
26 views

In Access 2007 is there a way to just delete an adhoc query instead of saving it?

Say you have a tab open that reads "Query10", is there way to close it and forget about it instead of saving it as Query10 searching for "Query10" again in "All Access Objects" and then deleting it ...
2
votes
1answer
23 views

Enabling the User to Insert the Data in Access Database

I have created a data model in Access Database. Tables that are composite parts of the model are loaded with data. Some of the data needs to be loaded manually. Now I would like to link couple of ...
0
votes
1answer
322 views

Do I need to convert an old Access Database, and if so how?

I have an Access 2003 database. When I click on a pivot table, I get this message MS Access There isn't enough memory to complete the Automation object operation on the worksheet object. There is ...
-1
votes
2answers
339 views

IF value OR value Then [closed]

Using Access VBA we need to do an IF-Than statement but there are 16 values. So, I have tried including "OR" but this code returns error "Can't find the field 'I' referred to in the expression. Here ...
1
vote
0answers
188 views

Access 2010 Superscript, Subscript, and Math Notations

I am creating an Access 2010 database to read rich text files full of math questions. I have the necessary fields in rich text, but rich text does not seem to support superscript, subscript, and ...
2
votes
1answer
441 views

One page per record

I am trying to print each report on just a single page but have no idea as to how should I proceed. Let me explain:- As seen from the report, Allan and Danny is now appearing in a single page but ...
1
vote
0answers
40 views

acces2007. divided form. from side off excel table d'ont clear image fields when change register

In Acces2007 form divided the problem is: work correctly when the selection or change register is from side off fields but not clear image fields when the selection or change is form side off table. ...
0
votes
1answer
39 views

calculate text data

Access 2007: We have a query that performs a simple sum of two fields from two tables. But some of these fields are text and only a "X" can be entered. So, if the user enteres a negitive x (-x) we ...
1
vote
2answers
1k views

Access ignoring default printer settings

I have several Access programs, they're fairly complex, lots of VBA in them and dozens of reports, linked tables, etc. When I print these reports, they don't respect my default printer settings ...
0
votes
0answers
82 views

Access Password popup

Using Access 2007, I have a login page which lists the names from a table. That table has a value for password. Came someone direct me as to to how to password protect the sign on. Another words when ...
0
votes
0answers
674 views

Where can one obtain jetutils.exe / LDBView.exe and does it stil apply to Access 2003?

I'm trying to view a .ldb file, with something easier to read than notepad, and I understand there is a utility for doing this in jetutils.exe called LDBView.exe However, the utility is not still ...
0
votes
2answers
85 views

Changing the Open With Program in XP

I have a Windows XP Pro PC with Office 97 installed because there are a number of files that are only compatible with Access 97. I also have Access 2010 installed. Problem is the access files by ...
1
vote
2answers
5k views

How do I use Expression Builder in Access to create a LOOKUP function?

I recently moved from Excel 2007 to Access 2007 to manage what never should have been spreadsheets. Unfortunately, from what I can tell, the LOOKUP function in Excel does not exactly work the same as ...
0
votes
2answers
2k views

How do I publish/export Microsoft Access Forms

I developed some forms in Microsoft Access and have yet to connect the forms with the database. However I would like to build and maybe publish the forms so I can view them outside of Access. how do I ...
0
votes
1answer
825 views

Store updated credentials for an Access linked table

FYI: I am running Access 2010, but the file is saved using "Access 2002 - 2003 file format, if relevant. I have an Access database containing a linked table that was created using Windows ...
1
vote
0answers
43 views

Restrict use of Microsoft Access? [duplicate]

Possible Duplicate: Restrict use of Microsoft Access? I'm trying to remove the ability for non-administrators to create databases in Microsoft Access. My issue is that people are creating ...
2
votes
0answers
174 views

Restrict creation Microsoft Access Databases per user

I'm trying to remove the ability for users to create databases in Microsoft Access for non-administrators on a few computers. My issue is that people are creating databases left and right, so I want ...
2
votes
0answers
87 views

How to shutdown a Microsoft Access database programatically without leaving a database shell

Everytime I use application.quit it shuts down the database perfectly. The issue is that a shell database is left open on the taskbar. After an hour of processing I have 40 shells to manually close. ...
1
vote
1answer
1k views

Get Employee Name from another table, by employee ID from input field in form

I have an access database that i have gracefully been deemed responsible for.. I for the life of me cannot figure out how to do this simple relationship scenario.. Call Table id - PKey Auto Inc ...
3
votes
2answers
325 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
370 views

Excel 2007 table gets data from Access 2007 Table or Query

I have a table in an Excel file which has a connection to an Access Query. When I first create the table in Excel, the data comes in with exactly the same order as how I set up the Access query. ...
0
votes
1answer
112 views

How to write a query to see who called who the most in an Access database of phone calls?

I have a phone bill in Excel that shows all calls made to and from my phone and I imported it into a table in Access 2007. I want to learn to use Access to do a simple query to determine who I talk to ...
0
votes
1answer
96 views

Mathcing data that includes “string1” and ends with “string2”

In Excel or Access(preferably) I want to do the following: I have company names matched with their zip codes like: Ozer LTD-55200 Gelibolu INC.-34759 and also I have some strings like ze and ...
2
votes
1answer
870 views

Multiple tables in Microsoft Access that need to feed into one table

In my Access (2010) database, I have 4 linked tables (from other Access databases) that I would like to feed into one table, or query. I've tried using the query design but can't seem to get it right. ...
2
votes
2answers
312 views

Matching similar records in a database with Group By

I have a database in which there are company names each matched with the company post code. However there are duplicates since the company names are written multiple ways, like this: Company Name ...
1
vote
0answers
114 views

MS Access ignores confirmation dialog when updating linked MySQL table

I have a MySQL database (Version 5.1.63) which is connected to MS Access (2002) via ODBC (MySQL ODBC 5.1 Driver). In MySQL I created a simple table like this: CREATE TABLE IF NOT EXISTS `test` ( ...
0
votes
1answer
169 views

Combo Box in form not populating my table

I have a form with a combo box (last name, first name, age, club) it works fine in the form but it will not work in my report or in my table it gives me the ID number instead of the information that ...
0
votes
1answer
2k views

SQL Server 2012 Connecting to MS Access 2003

SQL Server 2012 - Access 32-bit 2003 - I can import the database, I don't understand why I can't link to it. SQL 2012 may have changed the connection string or something. I just installed SQL Server ...
1
vote
1answer
166 views

How to link 2 tables so that changes in one tables would affect another

I have two tables in MS Access 2003. Both have some common columns. Is it possible that if I change the common data in one table it will affect another table. So I would not need to update the same ...
1
vote
1answer
74 views

Count Items in Access 2003

I have a table which contains a column with different items which i would like to count by there type. For example the table looks like the following: Id | Type ---|---- 1 | Table 2 | Table 3 | ...
2
votes
3answers
698 views

Unrecognized file format .mdb in Microsoft Access — repair doesn't fix it

So what I have is a file from a staff computer that I believe is an access file b/c its called .mdb, however it does not open! I even tried to follow the repair steps (create a new file and use the ...
0
votes
1answer
1k views

MS Access: Force input mask characters in field

I have a mask that looks like 0\.00\.0000 which is used to force serial numbers to look like 1.20.0034. The problem I have is that the dots (.) are not put in the database field. How can I use an ...
0
votes
1answer
3k 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?
1
vote
2answers
7k views

How can I get a list of fields AND respective tables used in an MS Access 2010 database?

I know this is how you get a list of all the tables in the database (and more if you modify the critieria: SELECT * FROM MSysObjects WHERE (((MSysObjects.Type)=1) AND ((MSysObjects.Flags)=0)); But ...
0
votes
1answer
139 views

MS Access 2010 hide/show text with abutton

Hi I have a problem where the user has a form in MSAccess. The form contains information about the client. The client fields are – client’s first name, client’s last name, their street address, ...
0
votes
1answer
1k views

Automating Access 2007 Queries (changing one criteria)

So, I have 6 queries and I want to run them all once at the end of each month. (I know a bit about SQL but they're simply built using Access's design view). So, in the next few days, perhaps I'll ...
1
vote
0answers
289 views

Access 2010 Form Data Filtering Error In Navigation Window

I have a form based on my transactions table, which has an 'account' combo box in the header to filter the transactions based on the selected accounts. I used the new Actions (or Macro Actions) to ...
0
votes
0answers
102 views

How can I sum up sub-datarecords in a calculated field?

I'm building a little Music Database with following tables: I would like to sum up the total count of tracks in the Table 'albums' as calculated field. I created a Query with SQL that groups to ...
4
votes
1answer
469 views

Undelete records in Microsoft Access

About 600 records in a Microsoft Access File (.mdb) have been deleted. The .mdb file size hasn't changed, being around 20 MB. AccessFIX (Demo) shows the exact number and contents of the deleted ...