Search results for query: *

Hello Axworthy and kermit01de, Thanks for your quick response. The date format are the same for both 2003 and 2010 version. Yes unchecking the "check for truncated number fields" in the "Access Options" - "Current Database" solved the problem!! Cheers Stable

Hi Mirko, Both the Access 2003 & Access 2010 reports are using Century Gothic font size 9 so there is no variation there. I have noted that Access 2010 have new control properties Left Padding, Right Padding, Top Padding & Bottom Padding. These had the value of 0.053cm after the conversion...

Hello, I took the following steps to convert an Access 2003 database to Accesss 2010: Created a blank Access 2010 database Imported all objects from Access 2003 database. Opened new 2010 database and checked reports. At least one report cannot now display date data in the column - i.e. it now...

Hi Simon, Sorry for the delay in responding to your reply. In SQL Management Studio when I run Transac SQL the Binary(20) field looks like this: 0x0000000000014C3130303039392D353020434164 We have noticed that the legacy system does not accept certain fields updated via Transac SQL , even...

Hi there, I’m new to Transact SQL and working with a legacy system where the key to a table is a binary(20) field. The source code for this legacy system is not available. We would like to add new records to this table using data from another system by running a daily transact SQL script. The...

I forgot to mention that this is a windows application not a web one. cheers Stable

Hello, I'm new to vb.NET. I have a datagridview and one of the columns contains the filepath of files in a directory. I would like the user to be able to click the cell to open the file. Included in the filepath is the filename which contains the file extension (e.g. .txt, .doc, xls, jpg etc)...

Hi primagic, Thanks for the tip. The reason for saving it as a hyperlink field is that the field appears in a datasheet in a subform to a form. I wanted the user to see all records (and hyperlinks) in the subform and click on the corresponding hyperlink for any record. I worked out that to add...

Hello, Thanks for this tip. I have saved the browsed file path to a hyperlink field in a table. When I click on this hyperlink field it does not take me to the same file at all. Instead it opens Window explorer to somewhere different on the network with an UNC path. Am I missing something...

Thanks xlbo and GlennUK. The first worksheet contains a list of GL Codes and descriptions. The second worksheet uses these GL Codes and has extra columns for inputting actual data, budgets and other calculated formulae. The reason for 2 separate worksheet is so that 3rd and subsequent...

Hello, I have 2 worksheet in an excel workbook. The second worksheet is linked to the first worksheet. Periodically I need to insert/delete rows in the first worksheet. Ideally when this happens I would like the second worksheet to reflect this automatically. Is this possible in Excel? Thanks...

Hello, I have developed an Access .adp front end application that uses SQL 2000 database in the backend for a client. The client has 3 machines - 2 with Access XP and the 3rd with Access 2003. Initially all machines did not have any MS Office Service pack installed. The application allows the...

Hello, I have 2 instances of SQL Server on my laptop and wish to test some modifications I am making to an existing SQL Database. This SQL database is "merged" replicated to the 2nd instance of SQL server on my laptop. I have made changes to some of the existing stored procedures and also...

Hi Denny, Thanks for that tip. I'll give it a go. cheers Stable

Hello, I new to SQL server 2000. I am working on an existing SQL DB for a client who already has merged replication. The amendments requested require adding new colums to some tables. I know that I can add the new columns via the replication monitor in Enterprise manager. As I already have...

Hello there, I have a form that passes parameters to a stored procedure which is used as the data source for an ADP report. This works fine on my laptop, however when I copy the ADP front end to the clients PC and change the connection to their SQl database on their server the report does not...

Hi Phil, Thanks for your prompt reply. Yes the user has a valid login account and permission for the SP. cheers Stable

Hello there, I have a form that passes parameters to a stored procedure which is used as the data source for an ADP report. This works fine on my laptop, however when I copy the ADP front end to the clients PC and change the connection to their SQl database on their server the report does not...

Hi Duane, I've removed the line of code that sets the rowsource - no difference. I can't use the Link Master/child properties - the message I get is "Can't build a link between unbound forms". I've put the chart into a subreport linked by ServerName field and kept the server name in the...

Hi Duane, In actual fact I only inserted the rowsource line to see if it would make any difference - it did not. The rowsource does not change for each record in the Table. Its the filtered data in "qsGenericServerChart" that changes with each new value of ServerName. I will remove the on...