Search results for query: *

Hi, A user's login account has been disabled and also the checkbox, 'Hide from Exchange address lists', has been checked off. My question is: how do I try and add this user's mailbox to my outlook program? If the above checkbox was not checked, I could add to my mailbox in Outlook, but...

Hi, We have a Citrix network and my question is how to configure citrix to allow a non-admin level user to perform a shadow session with another user. Regards.

Hi, Has anyone ever experienced this error? I did some searching prior to making this post, and this error is not trappable. Here's my setup. I have a main form that is unbounded. In the form, I have a subform, it is a datasheet form. I realize that you cannot connect a datasheet subform...

Hi, Does anyone know the code syntax to wait for all records in a datasheet to be returned when perfoming a filter? I have button on the form that a user will click on that will manipulate the filtered records but if not all the records are completely returned yet, Access will generate an...

Hi there, I currently have TSQL code that queries from 2 separate databases residing on same the MS SQL Server instance. My question is: What's the syntax to call a function that's on a separate database? Current Code -- Data Source #1 -- -- -- -- -- -- SELECT ds1.fname, ds1.lname...

Hi, I ran VBA code to access information from Active Directory; information like user names, groups which the user belongs to. I was wondering, is there a security issue with this privledge of querying Active Directory? I didn't find the syntax yet, but could I run code to query what a user's...

Hi, I'm having difficulty registering an MSDE database in SQL Server Mgmt Studio Express. The MSDE database resides on a laptop. I wish to connect to that database on my desktop computer to work off it. Here's what I have done in terms of SQL Server set up on laptop: - enabled TCP/IP -...

Hi there, does anyone know how I get a docmd.runSql command to append a local table based on external data on a back-end database that is password protected? Here's my statement: DoCmd.RunSQL "INSERT INTO tTempTbl( fname, lname, strEmail)" & _ "SELECT fname, lname, strEmail FROM...

Hi, I've been creating Excel Add-Ins that act as mini-programs that fetch data from an Access database, which in turn has its tables linked to an Oracle backend. It's only recently that I started encountering a couple of problems. There are no error messages; it simply runs forever without...

Hi there, What am I missing that causes the listbox columns to be out of sequence from the SQL I used in retrieving a recordset, which I set to the listbox? Clearly in my SQL, it's the NameID that comes before the Name field, but after it has run, it's the reverse. I'm using Access 2003...

I'm just curious, I read books that show code written with the 'New' keyword after the declaration statement, and was wondering what's the difference between doing that and simply inserting the 'New' keyword beside the object on the Dim statement? New object set after Dim statement: Dim rst As...

Hi, After reading this online article I was wondering, if I create an Access mdb file and use ADO code to retrieve recordsets of data, is it still pulling all the data as noted in the article? Article URL: http://my.advisor.com/Articles.nsf/dp/6847CE0F237AC9378825681E005C9BC3 Quote from...

Is there a menu bar control that you can place on the form? I know that you can do that with the Access shell, but I want to be able to have the menu bar (File|Edit|View|Window|etc.) placed at the top of my form instead. That way, when done, I can run the form without the shell and have it as a...

Hi there, Anyone know the correct syntax for writing up an SQL statement that'll return me a list of tables in a database? I use ADO code to write SQL statements. I'd like to know what I need to write in the line where I equate the sql string. Private Sub listDBTables() Dim sql As...

Hi, What would you suggest for pausing a loop that's in process? I've got a loop constructed that imports records into a table. When it's a new record I want it to pause to let me create a new entry into a separate table thereby ascertaining a new ID, which upon resuming the loop, will be used...

Hi, My question relates to finding out who the caller of the routine was. Example: I have 2 buttons on a form that calls the same sub routine. What would the code be to find out which button made the call? The reason I want it to work this way is because I want to have a select statement...

Hi there, Just wondering can one append sub-forms programmatically through VBA code? The reason I ask is because when working in design view, I don't want to clutter up the main form with sub forms on it. I figure, I can work in a more organized fashion by having it decoupled. I'd create the...

I'm looking to add a line in my code that will halt the next code from executing in Access. Following is my routine for a button that refreshes a web query in an Excel file. Instead of waiting until the line, xl.ActiveCell.QueryTable.Refresh completes, Access immediately goes to the next line...

i'm going back to print a job that i created last year, and now all of a sudden, it prints in a bad quality. It looks fuzzy on my HP 6m printer. There's no fancy graphics or anything, it's just pure text that i have on this. I had played around with the settings when i created something to be...

how do i prevent the f1 key's help from popping up? I've placed code on the form's key_press procedure, which captures the F1 key being pressed. I've routed this to run a sub, but then afterwards, it pops up the Help. How can i disable that?