Search results for query: *

Hi there, I have a continuous subform containing a click button that when pressed, uses the DoCmd.SendObject object to send the records from the subform using Outlook. The message text contains the records in the format line 1 :field1 line 2 :field2 line 3 :field3 The problem I have is that...

Hi there, I have a label control on a form, when clicked it opens another form. Code in the On Mouse Move event underlines the label when the mouse moves over. The underline is on a timer so after 0.5 seconds the underline disappears. The problem i have is that when the the mouse moves over...

Hi there, I have an update query shown below:- rs.Open "select [date] from vreport_workpackage_dates WHERE (WPID = 2878) and (milestone = 'integration end')", conn strSQL = "UPDATE WorkPackages1 SET [planned start date]='" & Format(rs.Fields(0), "yyyy-mm-dd") & "' WHERE WPID=2878"...

Hi there, I have an update query taking a date from a smalldatetime field which I want to put into a datetime field. I've used the code below:- DoCmd.RunSQL "update [WorkPackages1]" _ & " set [Planned Start Date] = (" & Format(rs.Fields(0), "dd-mm-yyyy") & ")" & "where [WPID] = 2878" But it...

Hi there, I'm trying to fetch data from a table in another database and insert it into a table in the current database. Dim strConnection, conn, rs, strSQL strConnection = "DRIVER={SQL server};SERVER=zfrdc003;DATABASE=SitetrackerTest;ID=Integrationdb;pwd=I&A;" Set conn =...

Hi there, I need to make a blank version of a database. What would be th eeasiest way of clearing the data from all the tables? Thanks

Hi there, I'm using the following code from a form's click event to pass a parameter from a combo box to a stored proc. When running the I get a run time 3708 error, parameter not properly defined etc. The offending line is .Parameters.Append .CreateParameter("@service1", char...

Hi there, I've put a database together which all works fine on my PC (I'm the db owner). The problem is that other users cannot use the databse as they cannot run the stored procedures and so combo boxes etc. won't work. Initially they had permissions of datareader and datawriter, I then...

Hi there, I'm pulling my yhair out over this - have been scanning posts all morning but have got nowhere. I have a form, with a click button which runs a stored procedure to screen and a combo box which is used to provide a parameter to the stored procedure. I've this code: Dim stDocName As...

Hi there, I used the following code happily, but it no longer seems to work and I can't work out why. I've recently moved from windows 2000 to XP could this be the reason. The code allowed me to make changes to a subform, then on update refresh another subform with the focus on the record that...

Hi there, I'm Using an Access front end and I'd liek to insert the data from a view into a table. Before I upsized I used Make Table, but I'm unsure now how the best way to go about it in SQL Server. The table already exists I'd like to clear the contents then copy in the view. Is it best to...

Hi there, I'm using an adp on an SQL Server 2000 backend, I have a simple update query (see below) which I'm using to update every row in a table field with the date. UPDATE dbo.testtable SET date_added = { fn NOW() } But...The Update procedure will only update the first...

Hi there, I'm working with an adp front end to an SQL Server backend. I have a simple update procedure:- UPDATE dbo.tblRawOSP SET date_created = { fn NOW() } But only the first 10000 records of the table update, I can't find a way of updating the rest. Am I missing something...

Hi there, I have a click button on a form that I'd like to use to insert data from a textbox into certain records on a table. I've used this code:- DoCmd.RunSQL "INSERT INTO [tblpartnercosts] (submitter) values ('" & Me![username] & "') " _ & "Where " _ & "[tblPartnerCosts].[service]...

Hi there, I used the following code which worked well when my database was Access based, I've moved it to an SQL Server backend and I get an "incorrect syntax error". DoCmd.RunSQL "INSERT INTO [tblUniqueKey] ([Unique ID Ref]) values [Unique Ref ID]" The problem seems to be the [Unique Ref...

Hi there, The following code worked perfectly well with Access; Forms![frmdeleteProject]![sfrmAddRemoveRecord].Form![CustomerDelete] = DLookup("[Customer name]", "[tblOSPWithAllAddedFields]"...

Hi, I've recently upsized an Access database to SQL Server and am working through all the bugs that have now ppeared as a reesult. The code belwo worked fine in an Access only DB but now the form reference at the end of the statement is n't accepted. DoCmd.RunSQL "INSERT INTO...

Hi there, I have a main form with 2 continuous sfrms. I can scroll through the records of one sfrm and the 2nd shows the details for each of those records. A control in sfrm 2 has On Update code to save changes and refresh sfrm 1 (so a flag indicating a change is shown). The problem is the...

Hi there, I'm passing this thread on on behalf of a friend. He uses the code below to mail merge to Word. I'm told the code works perfectly but when the .dot template is opened the standard toolbar is not on view. I know that the code from within word is "CommandBars("Standard").Visible =...

Hi there, I used the code below on an access form (mdb database) and it worked very well. I've since moved the back end to SQL Server and the code no longer works. The code is on On Enter, the status bar on the form says its calculating but the record is not found. Does anyone know why this...