Search results for query: *

Hi all, Is there a way to dynamically create SQL users? I am working on an ASP.NET web application and am using a modified version of the stored procedure which adds users to the aspnet roles database. You can pass in comma separated lists of domain usernames and roles as parameters and it...

Hi, I have a problem using the VB6 ListView control in a Citrix environment. The checkboxes are displayed the wrong size. They are too large and therefore make the height of each row bigger than it should be. Switching the checkbox property on & off dynamically, toggles the rows between to the...

Hi, I am new to .NET. I am using VB and have a dataset with 6 tables in it. A child table of the primary table has parameters set on it. This is set by a userform. When the user chooses dates, the relevant table is filtered, but the other tables still display all the original data. How do I...

Hi, I have created an Outlook COM addin that adds a CommandBarButton to the 'Standard' toolbar to run a custom for. I declared it as a control WithEvents. The problem is if a user copies or moves the control to another toolbar the Click event no longer fires. It does not seem possible to...

Hello, Not sure if this is the right forum for this. We are migrating from Novell Groupwise to Outlook 2003. We have over 1000 pc's to do, which are having standard images put on them. I have created a Phone Message form as an add-in. Is there an easy way to set the default Com Add-ins for...

Hello, Not sure if this is the right forum for this. We are migrating from Novell Groupwise to Outlook 2003. We have over 1000 pc's to do, which are having standard images put on them. I have created a Phone Message form as an add-in. Is there an easy way to set the default Com Add-ins for...

Hi all, Not sure if this is a silly question, but is there any way to use .NET controls in Access? I would like to use the .NET version of the ListView control in Access 2003, so I can use the improved features. (ie: different coloured ListItems). I have not found any info on this and was...

Hello All, We have a database that we have converted for our Czech office, which is not exporting data properly. Most of the Czech characters display OK, but the characters that are part of the extended codepages do not show up. They are stored properly in the tables, but when displayed on...

Hi, How can you put a new line/carriage return in a textbox on a report at runtime? If I have a calculated control or one that I want to set at runtime, it always comes out as that square symbol instead of a new line. Dean :-)

Hi, I have a search form and a stored procedure that returns the resultant recordset. It works by using tags on each control on the form to store the name of the corresponding parameter in the stored procedure. So basically whatever values the user types in get parsed into the sql statement...

Hi, When exiting a certain database the Access process is not terminated. Access looks as if it has closed but I cannot restart Access again without going to task manager and ending the MSACCESS process on the Processes tab. If I had been in the VBE editor in a session, again Access looks as...

I have an unbound database that uses several DateTime Picker controls. When I populate these in VBA as a user moves through the records, they seem to cause whichever control has the focus, to fire it's AfterUpdate Event for no reason. This is really annoying. Anyone dealt with this before or...

Hi all, Is there any way to change the printer that a report prints to in VBA? Thanks, Dean :-)

Hi, Is there any way to access the fields in a view in an Access project? What I mean is, is there an equivalent of DAO QueryDefs for Views? I want to enumerate and change the field names specified for a view in code. The AccessObjects in the AllViews collection doesn't allow access to the...

Hi, I have a TextBox that I want to put a 2 line Calculation in: ControlSource: =[Imperial] & "ft²" & Chr(13) & Format([Imperial]*0.0929,"Fixed") & "m²" It shows up as that square symbol instead of a new line. How can I do what I want? I have tried using vbCr and Chr(10). None work. Thanks...

Hi, Sorry if this is a bit long. I have written a function that returns a random string of a random length. I used the random (Rnd) function to create these strings: The user specifies the shortest length they want the string to be and the function then determines the length at random between...

Hi, Is there an equivalent method for creating tables in ADO to the DAO CreateTableDef method? I want to create a temporary table that has an AutoNumber ID field. This table would then be populated by a form and the AutoNumbers handled automatically. Do I need to use SQL commands, and what's...

Hi, I am upgrading an Access database to an Access project with a SQL backend. I have a form that is based on 4 tables that works fine with an Access back-end, but I cannot add records in the adp version. I understand that you can only add records to ADO recordsets that are based on one table...

Hello All, I have a report that no longer opens. I double-click its icon and nothing happens. Doesn't open in preview mode or design view. If I try and open it in code or in the immediate window, I get the 'You cancelled previous operation' error message. I have tried compacting and repairing...

Hi, I have to create a summary report based on fields from one main table. The table has loads of fields that I want to do counts on, each with 3 or 4 possible options. So, what I want is a report with each fieldname as a row heading with the possible values as column headers and the counts...