Search results for query: *

Thanks for all your help on this, I simplified my request to read rs(variable) and it worked fine, I didn't realise it was the default. Thanks Steph

Hi Again - when I look in the object browser at the item recordset, and then select fields, value is not a member of fields, the only choices are append, count, delete or refresh, am I missing a reference or something? Thanks Stef

Hi, thanks for your suggestion, but using this syntax gives me the following error: method value of object '_Field' failed. Any ideas what might be causing this? Thanks Stef

Hi, I hope someone will be able to help with on this. I have a dao recordset for which the sql is created on the fly dependent on certain criteria like this: sqlStringIssueCode = "Select [" & IssueID & "],[" & issueselect & "] from [" & TableName & "] where [" & IssueID & "] = " &...

Hi - I have a form with a combobox on it that has as it's record source a stored procedure. I want to make the combobox appendable - so if the item the user wants isn't in the list they can add it, but I can't see a setting to allow me to do this. At the moment I can type in the box but it...

Yes, of course - thank you - I wasn't thinking of it like that, I know get th evalue returned - cheers!

Hello, I'm hoping that someone will be able to help me with this. I am using an Access 2000 mdb and writing a module to carry out some analysis. I normally obtain the maximum field value of a query using dmax()but am unable to do so in this circumstance as I am creating the sql on the fly using...

Thank You!

Hi, I have a query that returns 5 addresses that I want to print labels for. I have a report to do this but I want 3 copies of each address to show on the report. Is there a way that I can make the address repeat 3 times within the sql, but forcing some sort of multiplying join with a false...

No unfortunately not. Thanks anyway though for your suggestion.

Yes, I had looked into doing this but get the following error: "You can not set the control source property after printing has started" I have the following code in the detail on format event: txtFormat1.ControlSource = =IIf(Not IsNull([Name]),Chr(13) & Chr(10) & Trim([Name]),([Name])) &...

Is there a way that I can alter the control source of a text box on a report at run time? I have an address text box and need to format the address differently dependent on the format code which is found in another text box. Can I do this? The control source itself is an if statement. Thanks...

I have now discovered the answer to my query - the knowledge base article relating to it is here: http://support.microsoft.com/kb/269824/EN-US/ Thanks for your input anyway.

Just to add to the picture: Ok, thanks for your reply. I have other copies of this database working perfectly on other computers but the stored procedures do not have the ;1 after their names. When I look at the version that is not working properly and try to go in to design view of the stored...

I have moved this post into this forum, hoping it is more appropriate Hi, I hope someone here will be able to shed some light on a problem I'm having. When I try to open a form (Access 2000 front end)based on a stored procedure (SQL server 2000), it errors and closes, and when I want to go to...

Hi, I hope someone here will be able to shed some light on a problem I'm having. When I try to open a form based on a stored procedure, it errors and closes, and when I want to go to the design view of a stored procedure nothing shows. I think the problem is related to the fact that all stored...

Hi, I am experiencing a problem with a dts package, unfortuantely these were written by a third party and the documentation is somewhat sparse. I have very little knowledge on dts packages. The package is failing on one step only, the code is as follows: -- Kill all users in database before...

Thanks everyone for all your help on this. I have now figured the problem. It was a combination of stuff, the ODBC DSNs had been wiped and the MDAC needed updating. So Thank You!

Thanks for your continued help on this. All of your statements are correct except I am using SQL Server authentication not windows authentication to access the SQL Server, as the users who are on the new domain. So in answer to your second bit SQL Server is on the old domain (DomA) and all...

Thinking about it, I don't think it can be related to the ip address as when I log on as administrator on that machine I can connect to sql server no problem.