Search results for query: *

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

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

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

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

Hi, I am hoping that someone will be able to help with my problem. I have an Access 2000 front end which connects to a SQL Server 2000 back end. In total we have about 15 users, half of whom can access the database, half can't. I'm not sure where the problem is originating from as one of the...

Hi I am trying to use form text box values as the criteria for the dlookup, but am getting an #error! showing. Is it possible to do this and if so do I have a syntax error in this: =DLookUp('" & [Forms]![FRMEDIT]![MAGID] & "','" & [Forms]![FRMEDIT]![MAGTable] & "','" &...

HI I'm using Access 2000 front end on SQL Server backend. I am trying to get a query to execute in VBA code using the LIKE keyword but am having problems with the syntax. Can anyone help? this is my query: DoCmd.RunSQL "update tblJob set jbCurrentlyBilling = 1 from dbo.tblBook INNER JOIN " & _...

Hi - not sure if anyone can help me with this, I am building a module to obtain information from a query and using it to calcualte a cost. I am receiving a strange error: Runtime error 30020: Cannot find column: 'Cannot find column 'C1'' I do not have any columns called C1 or any references to...

Hi, I'm trying to add row numbers to a query so I can iterate through them easily in a loop. I have done it before in an Access query but now need to recreate this in a sql server stored procedure - this is the syntax I am using : Alter Procedure spItemsToBillNum As SELECT (select count (*)...

Hi I am having problems using a variable in the docmd.runSQL statement: DoCmd.RunSQL "update tblJob set jbCurrentlyBilling = 1 from dbo.tblBook INNER JOIN " & _ " dbo.tblJob ON dbo.tblBook.bkISBN = dbo.tblJob.jbISBN where tblJob.jbBillTag = 1 and tblBook.bkClient = " & clientToBill if...

I am trying to add a number to each row of my query I have looked at the FAQs here but can not seem to get it to work. I am using Access 2000 This is my query: SELECT (SELECT count(*) from dailycatchup where dailycatchup.trID <= Query1.trid), trID AS rownum FROM Query1 ORDER BY trID; The name...

Hi, I am trying to determine with the use of Visual Basic 6.0 a list of all groups in the domain. I have been able to use isMember to get a boolean answer to determine if a user is in a group, but am unable to figure out how to get a list of all existing groups. Can anyone help? Thanks Steph

I am trying to implement user defined roles in my SQL Server 2000 database and am experiencing difficulties denying delete permission from users. I have set up a role with myself as the only member and have set it to allow select and insert permissions and deny delete permissions on a single...

I need to implement security on one of of SQLServer databases and am thinking of using LDAP to query Active directory, can anyone point me in the right direction to start with please? Any help appreciated as I'm starting with a blank canvas. Thank you very much Steph

Hi, I have some vba code which opens a series of reports as follows: On Error GoTo Err_Command7_Click Dim SinglesCatchup As Variant Dim MultiplesCatchUp As Variant Dim MagazineName As Variant MagazineName = Me.Mag.Column(1) MagazineName = MagazineName SinglesCatchup = MagazineName &...

Hi, I hope someone here will be able to help as I'ma bit stumped on this. I'm working on Access 2000 I am dealing with a stock count. With the use of a query I generate a list of people and series of books they've ordered. E.g: Cust1 Title 1 from issue 1 to 6 copies 1 Cust2 Title 1 from issue...