Can I update an Access Data base from a Linked Excel spreadsheet uploaded to an Office Live site ?
Answer Question | July 21, 2008 3:29 PM
Microsoft Access, Microsoft Excel, Office Live
Access 2007 Database; Employee Info; Form:Sick Days Docking/Pay. I created a form with a subform that keeps track of Employee sick days. It transfers totals from the subform onto the main form…Then the main form does a couple calculations on those amounts…But I need to access that information in a report for each employee. Reports [...]
Answer Question | July 29, 2008 1:23 PM
Access 2007, Calculations, Database programming, Form, Microsoft Access, Parameters, Reports, Subform, Variable fields
I’ve had some exposure to VBA and know the Access Interface very well (Microsoft Certified). I purchased MS Access 2007 Programming By Example by Julitta Korol a couple of months ago and all of the hands-on examples display the results in the Immediate window or a msgBox. Although I was able to figure out how [...]
Answer Question | August 30, 2008 4:44 PM
Access 2007, DAO, Microsoft Access, VBA, Visual Basic
I’m having a problem with opening a shared database in Access 2002. I open it on a specific workstation as a shared database others users cannot open it. But when I open it on any other workstation as a shared database everyone can open it.
Answer Question | July 17, 2008 7:51 PM
Access 2002, Database permissions, Microsoft Access, Shared databases
Hello, Here I’m directly passing the crystal reports parameters through the code, and generating the report but for some obvious reason, I want the records to be stored first of all into a 2-dimensional array and from there writing it back onto Crystal reports. Note : The reason why I’m looking for 2-Dimensional array is [...]
Answer Question | July 17, 2008 7:14 PM
2D arrays, Arrays, Crystal Reports, Database programming, Microsoft Access
I’m attempting to add subdata sheets that come from several different tables in my database to my master table. I have found, however, that no matter how I manipulate the different relationships I can only get one subdata sheet to work at a time. Is there anyway to link multiple tables as subdata sheets to [...]
Answer Question | July 15, 2008 8:24 PM
Access 2007, Microsoft Access
Is there any function in MySQL that can create a query similar to crosstab query in MS Access???
Answer Question | August 5, 2008 3:06 PM
Microsoft Access, MySQL, SQL Query
I’ve been out of the IT Business for several years and have come out of retirement to work with a local community college on Training Grants. We collect specific pieces of data on each student that works for the company that we have the state grant for. It is becoming a nightmare to track everyone. [...]
Answer Question | July 16, 2008 3:08 PM
Access 2007, Excel 2007, Microsoft Access, Microsoft Excel
I am using MS Access 07. Whenever I use the control to export the table as a .csv file, it changes all the fields properties, returning to the “text 255 cha” values. I need specifically to keep the same properties. I used to be able to do it and is not working now.
Answer Question | July 10, 2008 4:49 PM
CSV, Export, Microsoft Access
Is is possible to run reports similar to how you run reports in Access in Excel 2007?? If so, How?
Answer Question | November 8, 2010 4:04 PM
Excel 2007, Microsoft Access, Reports
How to send a report in MS Access to the body of an email in MS Outlook.
Answer Question | July 10, 2008 1:58 PM
Access reports, Microsoft Access, Outlook, Outlook 2003
How do you make the text boxes required to type in for an MS Access form in design view?
Answer Question | July 19, 2008 1:54 PM
I have several directory paths in a list box and I want to highlight one and double click on it and have it open the file
Answer Question | July 9, 2008 5:05 PM
Database programming, DropDownList, Microsoft Access
Hello…I want to make something in VB (Version 9) that reads multiple data from specified file (Access 2007) and displays content in list box. If file doesn’t exist, alert user. More description: My name is Steven, I’m a college student and now I’m running my practical session to complete my study. I’ve been assigned to [...]
Answer Question | July 9, 2008 9:29 AM
Access 2007, Microsoft Access, Visual Basic 9
When I open a specific database in Access, the Database Window is helplessly stuck behind the title bar. I’ve tried everything to get it out including closing and reopening, moving menus, everything. Here is a screen shot to show you what I mean: http://i35.tinypic.com/2mq7zux.jpg If anybody could help it would be greatly appreciated!
Answer Question | July 9, 2008 9:10 PM
Access errors, Microsoft Access, Windows
I have installed SQL Server 2005 Express with about 10 client PCs. I also have Microsoft Access 2003 on the front-end linking to it using System DSNs. On one of the PCs, it refuses to recognize the SQL Server when I try to create a DSN. It does, however, see a different SQL Server that [...]
Answer Question | July 8, 2008 3:45 PM
Access 2003, Microsoft Access, SQL Server 2005, SQL Server Express
Working with Analysis Manager Version: 8.00.194, my Sales cube looks good until I try to browse the data that comes from Foodmart 2000.mdb. Is this because Access is required?
Answer Question | September 20, 2008 5:10 PM
Analysis Manager, Database, Microsoft Access, SQL Server
I am using an append query to add data to a table. The query works except I have an autonumbering field and am not including it in my query because I want to continue the autonumbering in the table I am adding data to. The only problem is, is that the autonumbering is beginning from [...]
Answer Question | July 8, 2008 7:32 PM
I have am MS Access (VBA) program where I need to create a table on a SQL Server database then append data to the table. I have the code that generates the update query but I need the ADO code that creates the connection to the SQL Server 2005 database then I need the code [...]
Answer Question | July 3, 2008 3:44 PM
Microsoft Access, SQL Database, SQL Server 2005
When i link tables with a ODBC driver then some table won’t give me any records (I link into microsoft access. But I do see the column headings. I the record fields I get: #Name? Is this an AS400 problem, ODCB or Access ?
Answer Question | May 3, 2010 4:14 PM
AS/400 errors, Microsoft Access, ODBC