Search results for query: *

Hello! I am trying to "convert" a bigger MS Access application which currently uses MS SQL Server 2000 as the database. The main reasons for the change are so I don't need to distribute the Access frontend to each of the 30 users (whenever I make a small change in a report or added a new field)...

I'm new to ASP.NET, so please be gentle :) I have a DropDownList with a bound datasource. One field from this source is an ID, the other the name of the item. As DataTextField I use the name, and as DataValueField I use the ID (because it is used to filter a gridview). Then I added a label and...

Hi! I've embedded an Excel Chart in an Access-Report because the standard MS Graph Chart would not be sufficient. Now I know how to automate the Chart in Excel, but I do not know how I would access the properties of this embedded OLE-Chart via Visual Basic out of my Access-Report! I just can't...

Hi, I added some fields to an olTaskItem and saved it for use with my Tasks. Now I want to import data from a database and fill these Tasks, but *how* can I access my new fields ? Here's a snippet of the code used for filling "normal" task items: . . . 'rs is my opened recordset...

Hello, i'm trying to add a calendar item via Visual Basic. Here's the code i'm using (so far): Sub Notes() Dim session As Object Dim db As Object Dim doc As Object Set session = CreateObject("Notes.NotesSession") Set db = session.GETDATABASE("&quot...

Hi, I've got a report using a Stored Procedure as Recordsource. The Stored Procedure can have parameters, i.e. sp_test '01' shows all records where the userid = '01' There ist the possibility to set these InputParameters in the Properties of the Report, but how can I use a textfield or a...

Hello, I'm trying to merge-replicate a database to another server. They're both SQL-Server 2000 with SP3 installed. The snapshot works so far, but when trying to connect to the other server, i keep getting an error: The process could not connect to subscriber 'Server_Name' (source: Server_Name...

Hello, we're transferring our Access Database to an ADP-Project, thus were not using the queries in Access but views in SQL-Server. The problem is that the function "iif" is not working in views / stored procedures. I need a column where either 'NULL' or text is saved to give back...

Hi, i've got a Form with a subform. The mainform has a textbox in it which gets its value from a textbox in the subform (i.e. [Forms]![mainform]![subform]![subformfield]). Now the problem is, when the subform has no data in it, there is no such field and the target textbox produces an...

Our 4500 Color LaserJet has a problem in printing grey areas on colored pages. Grey areas look pink. Other colors, including black, are looking fine. Greyscale pages (without any color) are fine, too. But as soon as there is color on the page, grey seems to be mixed, not using the black...

Hello, when I update a recordset (press F9) in my Access-Project, Access keeps jumping to the first record. This didn't happen in my .mdb-Database, only in .adp How could I stop MS-Access to jump to the first record after updating ? Is there a simple solution or do I have to bookmark the...

Hello, I don't know how to solve this problem purely with SQL or a stored procedure. There is a table called tlb_Users looking like this: UserID SuperiorID 1 1 2 1 3 2 4 3 What I need is quite simple: I want to know all the inferiors of one User (and himself). e.g...

Hello ! I want to pass parameters to a function which is called directly from that button (no code in vba, just the function name entered in the event line). This works fine if I only pass ONE parameter and it looks like this: =fct_navigation("next") But how can I pass more...

Hello, how would I get back the name of the button the user clicked on a form ? I know the Sub is named like the button, but I want to use the same code for every button but need the name of the currently clicked button for this. Is there a possibility to find out what the name of the...

We have a replicated Database running in different countries (MS SQL Server 2000 does a merge replication from Germany to Poland every full hour). There are some tables just counting an ID field one number up using this field as a key. This means when two users in different countries create a...

Hello ! I'm using a DAO-connection to a SQL-Server 2000. This means I'm linking tables from a database on the server to my Access-Database. Now I want to know how can I use a simple select-query in VBA to get back a useable value (for use in a variable i.e.) ? I don't want to use the table...

Hello ! I have linked tables over an ODBC-Connection to an SQL-Server 2000. The problem is, when I link the tables to Access 2000 it is NOT using the set keys (primary keys) in SQL Server 2000 but the ROWGUID-column (used for replication by SQL-Server). If I remove the replication (and the...