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 think you were right about the empty string because I tried this and it worked - giving me the "you are about to update (78) fields - do you want to continue..." message. This is what I edited the statement to read: WHERE ([FY2005] Is Null Or "") And [DATEPD] Between #7/1/2004# And...

oops, I tried it again to see if it changed the one that didn't update and I realized it said that it was about to update (0) fields. So I guess I didn't do it quite right....

Thank you SO MUCH!!! It worked - except it missed one field. I created a new query, opened the SQL view and typed in: UPDATE ProviderResources SET FY2005 = [AMTPAID] WHERE [FY2005] Is Null AND [DATEPD] Between #7/1/2004# And #6/30/2005#; Then I ran it (yes I did it in a copy as you...

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...

Ok - well that it explains it! Thank you! Barb :)

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...

doesn't work for me Hey thank you very much - cool site!!! Unfortunately, the code doesn't work for my queries - none of them work. I have a parameter on the query - a check box which is "true". Not sure if that is what throws a kink in it or not and not sure how to move around that. I even...

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...

I would like to join the chorus of "please send me that too". Trying to set up a database that needs to limit access to most users. THanks!

Thank you both! Yes it is a continuous form. I did create a subform based on a query to add up by NameID on the main form and was hoping to be able to just set up an unbound text box - oh well! And I also realized that I could do the sum in a report by grouping per NameID...so you have...

No subforms. One field each for NameID, AmountPaid, PledgeID, DatePaid, AmountPledged, DatePledged....etc. As each person pays their pledge/portion of pledge, that data is input into this form. I had an unbound textbox that sums the total of all AmountPledged, one that sums how many NameIDs...

Thank you for your reply but I have tried that and it adds up ALL of the AmountPaid entries of ALL of the NameIDs and what I need it to do is: add up ALL AmountPaid per NameID. Thanks again for your efforts does this clarify my need? And is there a possible solution? Barb

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