Search Result

Good Afternoon Ladies and Gentlemen of this forum, I had a question for all of you.

I am trying to write a query. The idea of the query is showing when a person needs a new appointment. I now have a query which gives the Last Name, the first date they visited, and a so called 'visit number'.

The visits follow a set pattern. The second appointment is always 10 days after the first one. Then, the third appointment is 2...

Hi, I'm trying to create a form (MS Access 2003) that currently has 2 items in it: a combo box and a list box. I'd like to be able to make a selection from the combo box and have the list box display a filtered version of the data based on the selection from the combo box.

For example, the combo box has a list of different projects, (a, b, c, and d) and the list box has a list of ALL of the reports associated with all of the projects....

I am creating a form in Access 2003. It has 3 subforms in it. Because of all the data in the form i need to be able to scroll since not all the information will fit on a single page.

I have gone to the scrollbar property box and set it to have a scroll bar both horizontally and vertically. The problem is, even after doing this there is no scroll bar going vertically. There is a space where the scroll bar should be, but there is no...

I'm very new to creating union queries. I understand the purpose but not how to properly implement it for my purpose. So far I've created to perfectly fine crosstab queries. One shows input on a date ordered, the other shows the out put on a date completed.

I am trying to combine these two charts into one chart. The code I've got so far will only show one date. I am looking to have 2 (4 if you count the break down into the two material...

I tried setting up a new combo box to have todays date as a user choice by setting its property to a value list. Then for the row source it set it to =Date(). Access will not show what the expression equals but only the expresion formula itself. What am I doing wrong here? Thanks in advance!

I am relatively new to Access and I am using the 2003 version.

Here is my issue:

I have a report that is a summary of the products we manufacture. On the report I want it to list the components needed to make the item. I am using one master table to pull the information from. However, when I run the report it doesnt list the different components, it gives a new page for each component and i dont want that. Thanks...

Firstly: I've a fairly inexperienced access user!

I'm developing a simple stock control database and need to be able to show a total stock for each item.

So far I have two queries, both are grouped by the unique item of stock.

The first query shows how many items of stock we have received. All unique items of stock are always displayed even if there are none in stock.

The second query shows...

I am trying to find an interface that allows one to do a GET from a webpage and process the XML/HTML response. Specifically, I'm trying to get to the www.isbndb.org database to get book information.

I tried CreateObject("M icrosoft.XMLHTT P"), but get a failure (which may just be a linking issue, but I followed an example that I saw :-/) on the HttpPost.send. I get err.number = -2146697211 and err.description "The system...

Hi,

I have an ASP scripted business web application connected to a SQL 2000 server, that suddenly after a few hours is slowing down.

it becomes so slow it can take up to a minute to load each page, wich usually takes 1 or 2 seconds.

This only occurs on the server and not on the clients running the same application, this makes me think the problem might be in the browser itself..

still when...

I am having difficulty finding the proper code to print to a network (non-default) printer.

I have it currently set to print on a default printer using this code (created in wizard):

This program is going...

I have a form that can get called from different forms. I need to requeue the original form, but need to know what form to do this to. I saw a suggestion that had the calling form include its name into the called form, where the name is saved off. While this might work, I'd think that there's a stanard way to query this into the objects. Is there a way to do this?

Hi, I've made a database and added a switchboard to it yesterday. I thought i'd try and be smart and went on the database startup options, and deslected the menus and all the toolbars, so that when i open the file, only the switchboard is displayed.
This looks great, but the problem is is that I need to do a few final tweaks on the database, like adding a password etc etc, and I cant access this menu.
Im using Access 2003.
T...

Hi,

I have just installed a 2003 DC to our 2000 Domain and the only problem i'm getting is from our intranet server, the ASP script which authenticates users with AD is getting the following error when the the intranet server is using my new DC as it default LDAP server :

mbloggsmsg: login failed

This script is still working as long as i point it directly at either of our 2000 Domain controllers? I have...

In Vb.net 2003 you are supposed to have a graphics folder,and I'm missing it.
Is there any way I could get the graphics folder from a download?

Hi everyone, hope someone can help me.

Problem:
I have an event on a beforeUpdate of a textbox, which sets another hidden field on the same form. When my focus is in the textbox, and I click a command button, the beforeUpdate runs just fine, but it seems to 'Cancel' the click of the command button, so I have to press the command button once more.

The Textbox is a unbound field with the following code attached (Ignore...