Search results for query: *

Hello. I am having an issue that is driving me insane today. I have an access form on which there are 4 Combo Boxes. The form is in MS access but the data to populate the combos is on SQL Server. I have a pass through query that links to the server and when the form opens, the following...

Hi, Would really appreciate some help with this query. I am moving an access database on to SQL Server and need to reproduce some reports. The reports are mostly based on Bands that are created during running the query behind the report. So if the field being reported was value and the bands...

Hi, Hoping someone could please help. I have 2 stored procedures that run one after the other. They both insert a row but in 2 seperate tables. However the rows are linked so if the row goes in the first table, it has to also go in the second table. I know how to use Transactions within a...

Hi all. I am having a problem with a very simple piece of work. I cannot ever remeber there being an issue with this before. I have a form which has a textfield which has a date in it. I have a Select query that selects from a simple table all records that match the date that is in the...

I have a number of text boxes on a form in Excel 2000 that I need to be able to tab between. I have used the textbox.select followed by textbox.activate which worked OK in Excel 97 but in Excel 2000 I keep getting the following error message The instruction at 0x60010b06 refernced memory at...

Hi all. I am afraid I have what is probably a very stupid problem. I have never used the command object before but now find that I have to as I have atrted using ADO and cannot get SQL to pass any parameters back to access when I run my stored procedure. If someone could please have a look at...

Hi All, Posted on here a few days ago regarding connecting from Access to SQL without ODBC. Thanks to the replies I discovered ADODB and I now do not need to set up 200 ODBC connections. Or so I thought. Unfortunately there is one further problem.... I have used ADODB to create the...

Hi All, Posted on here a few days ago regarding connecting from Access to SQL without ODBC. Thanks to the replies I discovered ADODB and I now do not need to set up 200 ODBC connections. Or so I thought. Unfortunately there is one further problem.... I have used ADODB to create the...

Hello. Would really appreciate some help with this. Can anyone tell me if it is necessary to have an ODBC link set up on every PC where a user is going to access a SQL Server DB through Access. There will be about 200 to rollout and I am praying there is some other way. Please Help...

Hello. Would really appreciate some help with this. Can anyone tell me if it is necessary to have an ODBC link set up on every PC where a user is going to access a SQL Server DB through Access. There will be about 200 to rollout and I am praying there is some other way. Please Help...

Hi, Any help with this would be really appreciated. I have an access database which imports an excel sheet to a table. On the excel sheet there is a column for comments. In the table this is imported into a field of type "Memo" However when I export it again, the comments get truncated to...

Hi All, This is going to sound rather silly I fear. I have just started using stored procedures and am trying to select a number of records with a start date less than 21/03/03. If I link the table I am running the stored procedure on to access and run a query I get results no problem. The...

Does any one know why this message is coming up when I try and insert a record in the table on SQL Server. I am using Access and an ODBC link. This was not happening before. Any help would be greatly appreciated Thanks

Would really like some help with this as it is driving me insane. I have an access database which is linked via ODBC to SQL Server. I create an SQL string in access and create a connection. I then use the line: Set rst = connodbc.openrecordset(SQLString) Usually it works but at times I get...

I have a DTS package to bring data from Oracle to SQL Server. The package first creates the table using for most fields a type of Varchar(20). Then it populates the table with data. The problem is they are coming in sort of as fixed length values. If a string is 5 chars long, it puts 15...

I would greatly appreciate any help I can get on this. I have written an enormous amount of code in VBA in an access from which creates a recordset from a table on SQL Server. It then loops through the recordset and processes each record, i.e. checks all flags etc and then writes a new record...

I am trying to insert data with name and address in a field in a SQL database. I am passing it to a stored procedure from access 2000. If the name has a ' in it, it fails. e.g. John O'Neill. I have had this problem before but cannot remember if I found a way to get it to work or had to write...

Hi All, I have created a database in access 2003 which is used to store meber details in a club. When a new member is added, the joining date is set to the current date and inserted in the table using an Insert SQL string in the form. This works on my PC in work and at home but in the club...

I have written a few systems which email lists of people with specified attachments. I am using VB through excel to send mails with Outlook. Does anyone know if there is a way to include the users signature which is stored in outlook on the emails