Search results

:confused: I am trying to help someone with a complex problem (so it seems to me) but I will first ask about what should be a simple thing.... First goal: to COUNT the number of times a TYPE of visit is made. There are several different TYPEs but only interested in tracking 2 of them. When a...

Hi, I have a flat database I created to share information and track pmt information. I have created Front Page "Database Results" pages to display pertinent information so that I only have to update the database in one place (my "back-up") - then I copy it to the Front Page (Intranet) server...

I know that is kind of a long title...was hoping it would catch quicker attention. :) I don't know code very well (not at all - but can understand the concepts) and not sure where to look for help to create a possible query or button to auto update fldFY05 when fldDatePaid is >7/01/04 but...

Hello, I am wondering if it is possible to have several combo "boxes" in one form. The form is based on one table. In the table there are several fields which use a look-up (combo) drop down box to choose from: Type, Description, Manufacturer and Location. In the form I want a combo box for...

I store this database on a flash drive and when I tried to compact and repair it, it said there wasn't enough room, so I got rid of some files on the drive and tried again, and now I just keep getting the message: Table 'TempMSysAccessObjects' already exists. But I don't find that table...

(I like the new look!) I am having problems trying to post a query from the database I have in FrontPage to a web results page that asks for the month of the [DATEPD]. I found the code in Access: DatePart("m",[DATEPD]) which works when you type in the number of the month - in the database, but...

Hi, I am not sure I am in the right Forum to ask this but I have a table that I am trying to populate with data from a form in Front Page. I created the table first, then I created the Form in Front Page. I have the database in the same web. When I named the form fields the same as the table...

I am outputting query results thru Front Page Database Results wizard - one of the fields I want to output is a Hyperlink - which I have changed the "way it should read" to be a type of Title instead of the URL address - but what shows up in the report is only the URL. How can I change that...

Here's another dilemma I am having: One of the fields that my query has is a hyperlink which will only show the actual URL address and not the NAME I gave it - how can I change the properties of that field in the output? Is it better to use a macro to output the queries to an HTML page or to...

Hi, I am posting the results of a query thru FrontPage by using "Database Results" and the Query(view). I have a request to number the results (which will vary as the data changes). Can you tell me how (if possible) to do that - can't seem to do it in Front Page - is there a way to have it as...

Hi, I am trying to sum up AmountPaid by NameID in a form. I can do it with a subform referring to a query but isn't there a SUM calculation I could use? I can't find a formula that works. Barb

I am setting up a form to enter contribution data. The users don't want the personal data to be on the same form as the contribution data. But I want the capability of typing in the name (frmContributions) and the associating NameID to pop up. I have a query using tblAddress with...

How can I make a report preview be 100% when it is viewed from the switchboard????