I had made a Microsoft Office Access 2007 database with more than 2000 records. A copy of which was given to my friend. We both made a number of amendments and added new records in our respective copies. Now I want to compare both databases & merge the databases into one. There is only one table in the database, so basically both the tables need to be merged with the amendments made by both of us. How do I do it?

Member Avatar
Member Avatar
+0 forum 3

Hi I am trying to resolve an issue with Word 2007 not opening a document. I get this message: "There was a problem sending the command to the program". The OS is Windows 7 Pro running on a Dell 490. I have tried running in safe mode and deleting the Data entry in the registry. I have also checked for problems with Office and also did a Detect and Repair which completed successfully but the program still didn't start. Geoff

Member Avatar
Member Avatar
+0 forum 2

Im creating an application where some data should be populated in a gridview and then user should be able to update it and then same should be replicate to the database. So i have put a gridview and configure it to connect to my database which is base on access 2007. On grid view configuration i have enable the option INSERT, UPDATE and DELET statement based on my select statement. I have also put my access file in the "App_Data" folder in the application. When run the application the gridview work perfectly fine, it display all the information which is …

Member Avatar
Member Avatar
+0 forum 4

I am trying to apply conditiona formating to shade every other row with a different colour. I am applying the following formula =MOD(ROW();2)=1 and nothing happens, if I use a coma instead of a semi colon I get an error. Can somebody help me. Thank you.

Member Avatar
Member Avatar
+0 forum 8

Hello everyone my name is andy... is anyone know how to make a simple data entry worksheet in excel 2007? i noticed that excel 2007 have a form control inside the developer tab i can add input text box and command button in sheet1 but i dont know what syntax to insert inside that text box and command button so if i click the command button anything i've inserted inside the text box will be added to sheet2 as data records please help thank you

Member Avatar
Member Avatar
+0 forum 4

Hello to all, I am working on a spreadsheet/database for my company to track our service calls for the equipment we sell. There are a total of three of us that travel to different locations. I have helped create a database that allows a user to enter information after completeing a service call. However, the interface is awesome and the company wants to use it as a service report as well. Problem is that service reports travel with the technician while the database is hosted on the server. Long story short, is there a way that I can make this …

Member Avatar
Member Avatar
+0 forum 3

A client of ours uses Outlook 2007. They have recently reported an issue with attaching files to emails. Here is the issue that pops up... ![Image1](/attachments/large/3/Image1.gif "Image1") This happens when trying to open a folder to find the file to attach. This only happens with a couple of the folders. Other folders open fine to attach the designated/intended file. Obviously it's a permissions problem, but where and how? Or more importantly what's the fix? The users (with the issue) have access to these folders outside of Outlook. They are however limited to specific sub-folders within the main folder. Much a …

Member Avatar
Member Avatar
+0 forum 2

how do i link ms access 2007 with microsoft visual basic 6.0

Member Avatar
Member Avatar
+0 forum 1

Office 2007 on a Windows 7 PC. A user has an intermittent problem where when she copies a cell with a formula in it, clipboard picks it up as text. Typically, if one pastes a copied cell with a formula it also puts the formula in the cell. Not always with this one. Likewise the drag feature where one can grab the lower right corner of a cell and drag it down to past the contents of that cell into the cells below. Doesn't work sometimes. Similarly large numbers (13 digits) copied paste to a cell in text and are …

Member Avatar
Member Avatar
+0 forum 2

please i need help on making data report which the database is access 2007 with accdb format. what connection will i use and how and sample codes. thanks a lot in advance.

Member Avatar
Member Avatar
+0 forum 2

search button for vb 2010 ultimate in access 2007 database and filtering on a datagrid Hi all! I am trying to make a search button which filters a datagrid. First of all, I have a tab and on this tab a have a datagrid (dgr1). When I load this tab, I fill in a dataset from the database using a data adapter and this code: [CODE]DAProjects.Fill(DSProjects.Tables("Projects"))[/CODE] and then I send and display the data set to the datagrid with this code: [CODE]dgr1.DataContext = DSProjects.Tables("Projects")[/CODE] Also, I have a TextBox1 and PushButton and when i Push the button I want to …

Member Avatar
Member Avatar
+0 forum 1

Hello! Now I am trying to make selection of Customers easier for my user. My user's business involves making deliveries on [B][I]routes[/I][/B]. Every customer is assigned a route number, which references the route in the route table. In my form I want to have [B][I]two list boxes[/I][/B], side by side. [B][I]lb1[/I][/B] showing customers already assigned to the route, and the other. YES, all other customer NOT assigned to this route - [B][I]lb2[/I][/B] ... clever huh ? :-). Besides the usual buttons ( " < " & " << ", " > " & " >> " )< I would like …

Member Avatar
Member Avatar
+0 forum 1

Hi I do not know whether Outook, in this case 2007 running under Vista Home Premium, is the cause of this message. Email has worked, but now displays a Enter Network Password pop up. I would like to know whether this is a Microsoft Windows issue or one due to the email host's server? Geoff

Member Avatar
Member Avatar
+0 forum 2

Hi all, I wrote a .hta script (with vbscript - no jscript, in it) and put it on a fileserver. The people who use this script, start the script by clicking on a shortcut on their Desktop that leads to the .hta script on the fileserver. The .hta script reads data from an access database, writes to the database and read/writes to excel files etc. While we where using IE6.x and an older version of office (2003), the script worked fine, we did not have any problems with it. Now we use the latest version of IE and we use …

Member Avatar
+0 forum 0

Hello everyone this will be my first post. I am happy that there is a forum like this with very supportive people.:) So on topic.. I am a student creating an Inventory System software for my school using VB on VS 2008. I am having trouble saving items from a DataGridView to Access 2007. The codes I browsed here are quite different from what instructors teach us at our school. These are some of the codes we are using to save items from textboxes to Access 2007 database with a table named studenttable and database named student for your added …

Member Avatar
Member Avatar
+0 forum 3

I am trying to attach an XML Schema to a document as mentioned here: [url]http://www.tech-recipes.com/rx/2099/word_2007_attach_xml_schema/[/url] However I am having trouble attaching the schema(s) in question. I am wondering if anyone can shed light into possible reasons this is happening. The XML Schemas I am trying to attach are these: [url]http://www.ddialliance.org/Specification/DDI-Lifecycle/3.1/XMLSchema/[/url] I would like to use logicalproduct.xsd. Using the Add Schema button I know that I also need to use the following schemas: dcelements.xsd, ddi-xhtml11.xsd, simpledc20021212.xsd, xml.xsd, reusable.xsd. However I get the following error message after adding all these schemas and trying to use them: [QUOTE]xml.xsd#/schema/attribute[1][@name = 'lang'] Duplicate named <attribute> …

Member Avatar
+0 forum 0

Hello, I have to append 30 Excel 2007 files, each with 6700 columns, into one. The problem is that in these files the columns are not in the same order(the column names are the same in all the files). Im having Python27 with openpyxl, Win7, MS Office 2007, MS SQL Server 2008. Any ideas are appreciated!

Member Avatar
Member Avatar
+0 forum 1

Hi, I am developing database in Access & VB. My question is how can forms be displayed so that they automatically size to any screen whether it be 15" or 21", for example. Many thanks.

Member Avatar
Member Avatar
+0 forum 2

I have searched and cannot find out why my code will not update the database. The program stops at the mDA.Update(mDS, "temp_data") line with the following error: System.Data.OleDb.OleDbException was unhandled ErrorCode=-2147217904 Message=No value given for one or more required parameters. Source=Microsoft Office Access Database Engine StackTrace: at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable) at DojoTracker.Form2.Button2_Click_1(Object sender, EventArgs e) in C:\Users\Documents\Visual Studio 2010\Projects\DojoTracker\DojoTracker\DojoTracker\Form2.vb:line 130 at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 …

Member Avatar
Member Avatar
+0 forum 1

[url]http://rapidshare.com/files/370940756/commands.jpg[/url] [url]http://rapidshare.com/files/370940682/toolbar.jpg[/url] My question is that is it possible to have the above two options in Visual Studio Tools for Office (outlook 2007). I am trying to build custom toolbar with lots of mail items for templates or is there a way of building the whole lot in outlook as it is easy to setup(images attached) and then somehow export it as an addin or something else which can be easily distributed to other users. It is strange that the ability to create these toolbars and commands doesn't exist in visual studio and i don't want to spend time creating …

Member Avatar
Member Avatar
+0 forum 1

So I've been reading a lot about Access 2007, but all the books and tutorials don't talk about the stupidly easy questions. I have a SharePoint 2007 running on a server that my team has access to. From what I've read, SharePoint can easily display information and generate reports based on information in an Access database. I want to be able to allow them to create, update, and delete records from SharePoint, but I can't find anything that verifies it's possible. I don't want to use the Outlook integration solution. If it is not possible to allow users with appropriate …

Member Avatar
Member Avatar
+0 forum 1

Hi all, I have designed an application in MS Access 2007 that will be used in some schools (over 60 schools). Each time I start the application, it shows an alert in the message bar that the VBA macros are disabled, and gives me the option to enable it for the current session only. I know that it can be solved by enabling macros from the Trust Center each time the database is started. The problem is that this way applies only to the current machine, and moving the application to any other machine will reset this setting and needs …

Member Avatar
Member Avatar
+0 forum 1

Hi All, i was wondering if anyone could help, we have a RAID failure and we decided to install a new SBS 2008 server from the sbs 2003. now the problem is ew just got ur data back on a hard drive and i was wondering if i could plug it in via a hard drive and extract the exchange DB into PSTs from the SBS 2008 box?

Member Avatar
Member Avatar
+0 forum 2

guys, i ahve problem with configuration of outlook 2007 and my msn email account(username@msn.com). i heard that some dll is missing with os .is it true? Is there any way to configure with out payment. what is the problem? why there is limitaion? sajeev

Member Avatar
Member Avatar
+0 forum 2

Hi all.. I have made a database in Mcrosoft Access 2007. In my Database there are four tables. ORDER, ORDER DETAILS, CUSTOMER & ITEM. I have made order and order details combine form from Form Wizards. When flling the form of any order when i give the Item_id in the order details, the database automatically dont insert the price of that item_id from the ITEM table in which its price is saved. E.G. like in shopping center while the sales man is making bill, he just insert item_id and the software automatically place the price in the item_price attribute. please …

Member Avatar
Member Avatar
+0 forum 2

Good day! Im a new programmer in vb.net and it seems that i cant update my table in access 2007 here is my code. [code] Try con = new oledb.oledbConnection("Provider = Microsof.ACE.OLEDB.12.0"; data source = |DAtaDirectory|\Attendance.accdb; Persist Security Info = False;") con.Open() sql = "INSERT INTO tblProf VALUES('"&txtEmpNo.Text&"', '"&txtProfName.text&"','"&txtProfLname.Text&"')" cmd = New OleDbCommand(sql,con) icount = cmd.ExecuteNonQuery() MessageBox.Show(icount) Catch ex as Exception Finally con.close() ds.dispose() End Try [/code] --I dont received an error message when i run the codes i even dont receive an exception message. but when i check my database the record was not added. I hope you can …

Member Avatar
Member Avatar
+0 forum 2

Hello everyone! Trying to setup a connection to a website to be able to update currently displayed data and push it on a regular basis to my spreadsheet. The link I have is a direct link to download the newly updated spreadsheet. I continue to get an error message when entering this link into excel.... Please advise.

Member Avatar
+0 forum 0

I want to buy MS Office 2007 or 2010 Professional and I can find it on Ebay at an average price of $175 US. I am wondering if there is some reason I am not aware of to not buy any of these programs. What do I need to know to make an informed decision?

Member Avatar
Member Avatar
+0 forum 3

Can I get some assistance with the T SQL syntax required to use the contents of this combo box in a pass thru query in order to improve performance response time over the LAN [CODE] [Forms]![WELCOME]![FILTER_BUILDER].[Form]![Combo28] [/CODE] Apparently TSQL doesn't like the "!" from Access: [CODE] SELECT dbo_A_VIEW_LOWEST_LEVEL.contract, dbo_A_VIEW_LOWEST_LEVEL.[Profit Center Name], dbo_A_VIEW_LOWEST_LEVEL.MATERIAL_DESC, dbo_A_VIEW_LOWEST_LEVEL.cust_Name, dbo_A_VIEW_LOWEST_LEVEL.cust_id, dbo_A_VIEW_LOWEST_LEVEL.mat_id, dbo_A_VIEW_LOWEST_LEVEL.pc, dbo_A_VIEW_LOWEST_LEVEL.MEMO, dbo_A_VIEW_LOWEST_LEVEL.SUP_ACCT, dbo_A_VIEW_LOWEST_LEVEL.act_id, dbo_A_VIEW_LOWEST_LEVEL.actuals, dbo_A_VIEW_LOWEST_LEVEL.budget, dbo_A_VIEW_LOWEST_LEVEL.forecast, dbo_A_VIEW_LOWEST_LEVEL.link, dbo_A_VIEW_LOWEST_LEVEL.bud_var, dbo_A_VIEW_LOWEST_LEVEL.fcst_var, dbo_A_VIEW_LOWEST_LEVEL.CDEPMNT, dbo_A_VIEW_LOWEST_LEVEL.MNTATT, dbo_A_VIEW_LOWEST_LEVEL.MNTCM, dbo_A_VIEW_LOWEST_LEVEL.MNTCPI, dbo_A_VIEW_LOWEST_LEVEL.MNTCPROB, dbo_A_VIEW_LOWEST_LEVEL.MNTHELD, dbo_A_VIEW_LOWEST_LEVEL.MNTIMPOC, dbo_A_VIEW_LOWEST_LEVEL.MNTIMSD, dbo_A_VIEW_LOWEST_LEVEL.MNTMIGR, dbo_A_VIEW_LOWEST_LEVEL.MNTOTH, dbo_A_VIEW_LOWEST_LEVEL.MNTQ4IM, dbo_A_VIEW_LOWEST_LEVEL.MNTRECVD, dbo_A_VIEW_LOWEST_LEVEL.MNTSWSD, [pc] & [cust_id] AS CUSTLINK, dbo_A_VIEW_LOWEST_LEVEL.MNTIMPOC FROM dbo_A_VIEW_LOWEST_LEVEL WHERE (((dbo_A_VIEW_LOWEST_LEVEL.SUP_ACCT)=[Forms]![WELCOME]![FILTER[/CODE]

Member Avatar
Member Avatar
+0 forum 2

Is it safe to purchase MS Office 2007 or 2010 on Ebay. Why can I buy it so much cheaper then the regular retail price? Is it legal?

Member Avatar
Member Avatar
+0 forum 3

The End.