Microsoft Access is a rapid application database development tool.
0
votes
0answers
16 views
Microsoft Access divide listbox with lines
I have a table including listboxes. I want to divide content of these listboxes into lines. Is there any way to do so? Thanks.
0
votes
0answers
16 views
Access 2010 on Windows 7: very slow performance
I have upgraded from Access 2000 to Access 2010 64bit and I've noticed very serious performance problem. For example a simple query is 10x slower.
This is a known issue of Windows 7 and Jet 4.
I've ...
0
votes
0answers
9 views
Access 2010 error 3073
I have a VM with Access 2010 installed. When I open a database under the Administrator account everything works fine. When I open the database under a user's account I get a Run-time error '3073' ...
0
votes
0answers
26 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
26 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
20 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
39 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
18 views
Access 2000 Database Form will not Print
At work, we have an Access 2000 database to store our part specifications in (I know it's old, and we're working on something newer), but I've got two Windows XP Professional SP3 computers that when a ...
0
votes
0answers
46 views
Three rows of almost the same code behave differently [migrated]
I have three dropdown boxes on a Main_Form. I will add the chosen content into three fields on the form, Form_Applications.
These three lines are added :
Form_Applications.Classification = ...
2
votes
0answers
49 views
Microsoft Access 2010 Error
Ok, so I am not a pro in MS Access (or databases), but I tried googling this and no answers, so here goes nothing:
I am trying to create a field to convert currencies from one of 2 fields, thus I am ...
0
votes
0answers
36 views
How do I export to CSV without decimals using MS Access 2010?
Is there a way to export numeric data to csv file in MS Access 2010 without decimals? I am using ImportExportText in my macro. I don't see anywhere where you can specify this.
The macro is ...
0
votes
0answers
15 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
41 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 ...
0
votes
0answers
75 views
MS-Access Run time error 438 Object doesn't support this property or method
I am hoping that someone out there can help me to resolve this error that I get in my MS Access application. My application makes use of a main form, named 'frmSurvey', and a sub-form which is named ...
0
votes
0answers
13 views
Export Informix BYTE fields via MS-Access
Is it possible and if how to use MS-Access to export data which is stored in a BYTE column of a table of an Informix database?
Informix runs under HP-UX and access is done via ODBC.
0
votes
0answers
71 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
98 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
55 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
29 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
67 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
0answers
26 views
How do I place details section at the same level/top/height/alongside as group header in MS Access report?
Is it generally possible to squeeze out some vertical space from group header?
When I add grouping to my report I have to dedicate certain amount of vertical space to a group header. I would like to ...
0
votes
2answers
68 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
15 views
MSAccess HotKey to Add Date
When I'm in a data grid in MSAccess 2010 I'd like a hot key that puts the current date and time in the current cell I'm in (if it's a date field). I'm a developer and very comfortable in VBA but I ...
0
votes
0answers
53 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 ...
0
votes
1answer
290 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
0answers
109 views
Access: Export an Access Report to Word (Access 2007 and Access 2010)
I try to export an Access report to Word document in order to edit its contents. It shows a popup asking for my password every time. Whatever passwords I put it in do not work at all (I have dbo ...
0
votes
1answer
106 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
37 views
Connect MS Excel to MS Access linked to MySQL
I am attempting to connect MS Excel to an MS Access database comprised of tables linked to a MySQL database. This may seem roundabout, but the goal is to use Excel as a front end to make edits in the ...
2
votes
0answers
72 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
22 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
92 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
0answers
37 views
Access Query and Report Font changes data to look like a different font only in one cell
When I pull my query and report there is one cell where the data looks like a different font that I cannot read. But when you look at the data in the table is is right. How can I correct this in the ...
0
votes
0answers
39 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
110 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
49 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
193 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
67 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
36 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 ...
2
votes
1answer
160 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
204 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
39 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
93 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
0answers
45 views
Access database linked to SQL database [closed]
My domain account has access to our MS-SQL server where the database resides, so I never experienced this issue.
When I gave the Access .mdb file to one of our regular users, he was unable to use the ...
0
votes
2answers
133 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
0answers
14 views
Dynamic droplist filling in access
I have a couple tables. Tables W, X, Y, and Z describe a hierarchy:
W: ID, Desc
X: ID, Desc, W_ID
Y: ID, Desc, X_ID
Z: ID, Desc, Y_ID
I also have a table A that has a many-to-many relationship ...
0
votes
0answers
95 views
Use a set of checkboxes for multiselect in Access 2010
I have three tables, A, B, and a join table AB:
A: (ID, Desc)
B: (ID, Desc)
AB: (A_ID, B_ID) (with primary key (A_ID, B_ID))
I've figured out how to create a form for records in A that contains a ...
0
votes
1answer
169 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
168 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
159 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 ...
1
vote
1answer
2k 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, ...
