Search results

I'm more used to SQL Server than Access so you will need to change things regarding dates: If you had a table as follows: CustomerID ProblemDate -------------------------------- Cus001 21/01/2007 Cus001 22/01/2007 Cus002 21/01/2007 then...

Thanks for that. I ended up using the following: ========================================= While Not rs.EOF Row= 1 Col = 1 'Increment the row counter Row= Row+ 1 If rs.RecordCount > 60000 Then objWSheet.Cells(intRow...

Hi, I have an .adp that executes a stored procedure. The results of this stored procedure exceed 65535 records. I put the output of this stored proc into an ADO recordset and want to export into Excel, however it will no let me as the maximum allowed in Excel is 65535 rows. Is there an easy...

Could somebody tell me how to invoke an executable from within Access VBA? e.g. If I have an executable located in "C:\test\test.exe" how would I invoke it from code? Thanks Kabir

Hi all, Is it possible to change the Background color of a command button? Whan I right click in the properties of the command button I cannot see a BackColor property. Further, when I programatically try to change the BackColor property in VBA I get an error message. Thanks in advance Kabir

Yes Field1 is the name... any ideas? Cheers, Kabir

Hi all, I have a continuous form that is bound to a SQL Server view. For each record in my form I have a button, which when pressed opens up a second form. The second form is bound to a stored procedure that takes a parameter. The parameter value that I want to pass to this second form is the...

Hi all, I have a combo box that is bound to a stored procedure. The stored procedure returns values from 2 columns of a table, FieldA and FieldB. I need end users to see values from FieldA only (so FieldB needs to be hidden). At the same time I need the values from FieldB for other forms...

Hi, I have an .adp and am trying to add my Access forms to Visual SourceSafe. I have read in the Microsoft website that there should be a SourceSafs option under the Tools option. I do not have this option. Further, when I try to drag a form from my project to VSS it doesnt let me do it. Is...

Hi, Is it possible to change the size of a check box? When I modify the height and width of the checkbox it doesn't appear to do anything. Thanks Kabir

Is there a way of specifying the version number of an Access application? e.g. In classic Visual Basic you can specify the version number in the "Project Properties" menu option and then use these values in code by doing an app.major, app.minor etc... (or something like that). Is there an...

I have a couple of combo boxes within the "Form Header" of a form in my .adp. Each of these combo boxes is populated from a SQL Server table using a stored procedure. The values selected in the combo boxes define what records are returned in the "Detail" part of the form. To implement this I...

I have an .adp and would like to display the database name on my startup form. To do this I could run "select db_name()" from within SQL Server put the return value within an ADO recordset and update my form. However, this seems longwinded. Is there a property that can be used to display the...

I haven't used this particular package, but did try the upsizing wizard. It was reasonable in migrating the tables and data, but not very good at migrating code. I would imagine the same would be the case with the .msi you mentioned. The problems I had were that most of the queries would not...

I have recently upsized an Access database to SQL Server. The .adp is for the most part working fine. However, when an end user tries to create a duplicate record in one of the Primary key columns of a Form he gets a SQL Server error message as follows: "Violation of Primary Key constraint...

"Field 'F1' doesn't exist in destination table 'tablename.'" I hate this error message. I am using the following command to load data from an excel spreadsheet into a backend SQL Server database via an .adp: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel7, sTempTable, strFileName...

"Field 'F1' doesn't exist in destination table 'tablename.'" I hate this error message. I am using the following command to load data from an excel spreadsheet into a backend SQL Server database via an .adp: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel7, sTempTable, strFileName...

Hi all, I have an adp that points to a backend SQL Server database. One of the forms is bound to a view in SQL Server. I have locked all the fields on the form so that they are not editable. My problem is that a user can still right click on the row and select the "cut" option to delete a...