Microsoft Access is a rapid application database development tool.
2
votes
1answer
20 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
1answer
42 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
9 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
18 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
23 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
18 views
Ms Access : “Unrecognized Database format”
thanks in advance, 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 ...
0
votes
0answers
22 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
30 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
16 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
28 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
31 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
37 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
47 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
19 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 ...
2
votes
0answers
52 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
44 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
20 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
43 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
117 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
84 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
106 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
66 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
32 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
82 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
80 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
57 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
340 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
113 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
127 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
38 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
82 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
23 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
112 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
38 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
113 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
57 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
200 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
174 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
209 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
47 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
140 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 ...
