Update Access Data Base from Office Live site
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
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
How to access and use subform data/calculations
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
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
Can you help with the following DAO code explaining a step-by-step process?
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’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
Shared Access Database
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
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
Storing values into a 2-Dimensional Array
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
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
How can I add Multiple Subdata Sheets to a single Table in Access 2007?
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
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
equivalent for crosstab query
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
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
Rusty and Need Help
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’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
MS Access conversion to CSV files
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
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
How do I run Excel Reports?
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
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
Sending MS Access reports in the body of an email.
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 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
MS Access Forms
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
Microsoft Access
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
Microsoft Access
open a file in access by clicking button
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
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
Building A File Searching/ Tagging System
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
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
Database Window Stuck Behind Title Bar
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
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
Refusal to recognize SQL Server 2005 Express on a client PC
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
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
must Access be installed to use Analysis Server
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
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
Autonumbering gone wrong Microsoft Access
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
Microsoft Access
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
Microsoft Access
SQL Server 2005 within MS Access VBA
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
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
AS400 ODCB table link
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
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
