Search results

Hi All, I've got some code working to connect to the Active Directory problem is it doesn't seem to be returning much. I'd like to get First name, last Name, Phone Number and Email. Right now all I can get is Name. For example if I select only displayName or telephoneNumber they come back...

Hi, I have a problem with a subform turning white when it is refreshed. I've been using Access 2010 and there is no problem but when the database is used in Access 2007, the problem occurs. I have a database recording several nurseries. I have a form with a subform and when the form opens...

Hi All, I have created my own class called Organisation. In a pop out form that the user enters the details of the organisation, an instance of the Organisation class is instantiated. e.g. Public myOrg as COrganisation Set myOrg = New COrganisation The properties of the object were then...

Hi All, I'm trying to create my own class and having some problems accessing it. It's an Employee class and I have a method within this class to Search for an employee. I created an instance of the class when a user clicks a button to Add a new employee. However, when I try and use another...

Great..Thanks :)

Hi All, I'm creating my own Class in vba for the first time and I was wondering if I can access a method (sub) I've created in a Module from within a class. My idea is to have an Employee class and one of the methods I would like to have for this class is AddNewEmployee. This method will add...

Hi All, On my report, I have a subreport. When I preview the report some values in the subreport are not displaying. The recordset of the subreport is a pass through query. I have a total on the subreports footer with the total of a column returned from the pass through query. I calculate...

Hi, The recordsource of my form is a recordset. This recordset is populated with records returned from a sql server stored procedure, so records from a sql server table. The AbsolutionPosition returns the numeric position of the current record in the recordset. So what I am doing in the If...

Hi All, I'm trying to clone the recordset that is the recordsource of my form so I can determine if I've reached the last record in the recordset as I move through it with a button on the form. My current code is... Dim rs As ADODB.Recordset Set rs = Me.RecordsetClone rs.Bookmark =...

Hi All, I'm having a problem getting a subform (continuous form) refreshed to remove items that have been deleted. It works fine when there is more than one item in the list, however, when I delete the last item in the form it is still displayed. The only way for it to no longer be displayed...

Hi All, I've always had problems with subforms and todays no different. I'm trying to set the source of my subform to the results of a stored procedure. The result of the stored procedure is stored in a recordset. However, no matter what I try nothing works. I either get the error...

Hi All, I'm having trouble updating the contents of a listbox. I have a form and users select a file, a sql server stored procedure is then called and the filepath is saved to a table on the sql server and the filename is then added to the listbox. This works fine and the listbox refreshes and...

Hi All, I've been looking online for some guidance on this but not finding much :( What I'm looking to do is take a users windows login id, e.g. 'tmccp' and look up the login in Outlook to grab the users name, e.g. 'Tony McPolick' and then store that name in a table. Any guidance would be much...

Hi All, I'm trying to clear the contents of a listbox but not having any success. The Row Source Type is 'Table/Query'. I've tried.. Me.ListBox_Name.RowSource = "" Me.ListBox_Name.RemoveItem(1) The source of the Listbox is the result from a Stored Procedure in SQL Server...

Thanks everyone for your help...much appreciated :D

Thanks for that! :) I had been working on displaying a hyperlink on a form and when the user clicks that the file opens. I have the file path displayed in a text box and changed the 'Is Hyperlink' property to Yes and 'Display as Hyperlink' to Always. I put some code on the onClick property of...

Hi All, I have a table with the file paths of solutions to problems. What I want to do is select the solution to a problem, click a button 'View' and the solution file will open. The solution files will be txt files and maybe .sql files. Is this possible? I've been googling it but most of...

Hey, I put in a custom format "dd/mm/yyyy h:nn:ss am/pm" and that seems to have done the trick. Thanks RainLover and mdlueck for taking the time to help me...much appreciated :)

Hi, I didn't have any format on the text box. I just tried there some different ones but I only see the option for either date (general, short, long etc) or time (long, short etc). I didn't see the option for a date/time format. Is there one that I'm over looking :confused:

Hey, I think I've done that but in a different way... Dim cn As ADODB.Connection Set cn = New ADODB.Connection cn.connectionString = ObjBEDBConnection.getADODBConnectionObj() cn.Open Dim cmd As ADODB.Command Set cmd = New ADODB.Command cmd.ActiveConnection = cn Dim paramDate As...