Recent content by slames

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...