Search results for query: *

Hello, I have a Microsoft Access database table that links to an SQL Server database table. I have created an access query that retrieves the fields from the table. For some particular records they are not being shown in the query. For example I have tested this on one particular record and it...

Hello All, Using asp.net I am trying to retrieve a cookie that is being set manually on the IIS server when the page loads. However I cannot seem to get the value. When I use firefox debugger all the cookies are showing correctly, but when I use a CookieContainer to loop through all the...

Is there a command line function to stop the Report Services? Thanks

Hello, I need to know how to order a list alphabetically in a drop down list ddUserList contains the contents of the list This is my html code: <label class="fixed-label" for="text1">Who are you? <span>*</span></label> <asp:DropDownList ID="ddUserList" runat="server" CssClass="select"...

Hello, I have an .xml file that I am using as a configuration file and I want to read the data in the file and use the values in a condition in my logic. This is my xml file: <?xml version="1.0" encoding="utf-8" ?> - <caseSettings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"...

Hello All, I need some help with the following process - not sure where to start but this is what i have to do in my integration package: For each row in my tableA I want to update it with a string value (the value is derived from an SQL statement using a condition - WHERE clause). The...

Hi, i am trying to create a new connection using connection manager for an SSID solution. However the server name does not appear in the Server name drop down list. I am configuring the package on my server and the database resides on the server that I am trying to connect to. I'm using SQL...

Hi There, I want to ping results to a file but also want to capture the system time as my connection keeps dropping out and I am trying to find out exactly when it is happening. The command I am using at the moment is: ping servername -t >> log.txt is there an additional command I can add to...

Hi, I have some VBA code that is on a users PC which copies the email to a folder - this code works fine without any problems. I have set the macro up on as a customized button. However, the button keeps on disapearing every now and then and I have to keep on putting it back Using the Tools -...

Hi, I have a bit of a problem with some code i have taken over from another developer. I have an Access application that intergrates with outlook. I have copied the application to a new PC and it is failing when i initialize the outlook folders. Can someone help as I have no idea why it is...

Hi, I have a strange problem. I am running an sql query from vba code within Microsoft Access. I am passing the value of the date from a combo box into the sql string. My date value (varDate) is 4/5/2008 (4th May 2008) this is passed into the sql string as ...#" & varDate & "#.... when i...

Hello, I have a problem with setting Property Sheet values for a Form using VBA code. I am trying to set the following properties: .RecordSource .InputParameters .UniqueTable I am setting this in an ADP and for a couple of my users my code works without any problem, and for other users it...

Hello, In pre 2007 access I could simply create a link from my front end to a backend from the file menu and link the table. How do I create a link in 2007? It does not seem that obvious to me, any help is appreciated. Thanks

I have an ADP project with a back end SQL Server. I'm using the following code to connect to the database. But this will only allow me one user to connect using the front end ADP. Once the first user has logged on a second user cannot seem to connect as it can't open anotehr connection. Does...

Hello, I have an ADP front end with SQL Server backend. My environment is Citrix and the ADP is set up in an application pool so there is only one instance of the ADP . This locks the file when a user connects to it and therefore does not let any other users open up another connection. Is this...

I am doing an import FROM SQL Server INTO Microsoft Access 2003. The SQL Server veiws are getting converted into tables. Is there a way of creating queries out of the views automatically or is this just not possible? Thanks in advance

Hi, This may seem like a simple question, but... I am trying to add two time values together. For exmple my first value is 0:59 (being 59 minutes) and my second value is 2:36 (being 2 hrs and 36 minutes) which should make a total of 3:35 If I use a parseInt my values are not treated as time...

Hi, I am trying to set up Full Text Search from Enterprise Manager and am having trouble turning it on. If I select 'Tools' drop down menu my 'Full Text Indexing' is greyed out and I cant select it. Can someone tell me how I can enable this so I can set up Full Text Search. Thank you

I am trying to Update a View (vwSPOpp3) which references another view which references other base tables. The update statement I am using is below and uses a join from my view to another table. This is the code i'm using /////// UPDATE vwSPOpp3 SET New_ProjectManagement =...

I have created a Delete query in Access which I want to delete records in a table 'dbo_BOOKING' where there are matching records in my second table 'dbo_COURSDET_ARCHIVE_Tmp'. I am referencing the table in the Criteria secion of the query using the 'build' function and selecting the field value...