Microsoft Access is a rapid application database development tool.

learn more… | top users | synonyms (1)

0
votes
0answers
34 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
3k 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
612 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
305 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
929 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
51 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
227 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
222 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
456 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
151 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
71 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
4k 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
1answer
319 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
457 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
54 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
1
vote
1answer
156 views

Finding instances across multiple excel columns and rows

I am working in MS Excel 2007 with data regarding a series of forum posts. Each post is represented by a row of data that includes a unique ID for each post, the unique ID of the user that posted it, ...
0
votes
2answers
245 views

Find the different two Excel sheets when having identical row

I have two excel sheets with same column Names and Format. And it has one identical row(can use as Primary Key) id. I want to get the diff. table 1: id Name GPA ----+------+------- 1 | AA ...
0
votes
1answer
541 views

How to reject two fields combination if already exist in MSFT Access File

I created "Customer" table and created a form to mimic the registration process. Upon clicking on "Register" button I want to reject the process of registration if email and password combination are ...
0
votes
1answer
670 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
277 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
14k 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
284 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
715 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
266 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
559 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
123 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
53 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
2answers
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
337 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
369 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
196 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
558 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
41 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
2k 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
90 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
715 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
88 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
953 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
179 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
93 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
2k 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
343 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
424 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. ...