Search results for query: *

I don't take that as offensive at all, Patrick. I appreciate the generosity of your time. How will starting with 2003 help me?

I am using Excel 2002 and Frontpage 2002 and am tasked with making part of a Excel spreadsheet dynamically linked to a website. I have not had the need to use Sharepoint and do not currently have any files dynamically linked to our website. I maintain our company's Frontpage website and have...

Thanks PHV, it turns out that all I needed to do was to uncheck the date field, and in the total section, select WHERE on the date field!

I have a query where I am trying to count the number of claims issued against a specific insurance company. I have no problem until I impose a date range, then I end up with a listing of the number of claims against a company per date entered. Is there a way to define a date range and still get...

That sounds very cool! I will give that a try and let you know how it goes! Thanks PHV!!!

I have a client who would like to, ideally, be able to have a field in a form that is required to be unique, yet is able to have a re-usable default value. For example, an I.D. field with a default option of "n/a". Now, of course, this is self-defeating and contradictory but I can think of at...

Yah, I think I will include it with the order detail, that seems to make the best sense. Thanks a lot for all of your input!

Thanks dhookom! So I would link the Rate History table to the Customer table via the Customer ID. In addition to the Customer ID foreign key, the Rate History table would record a Rate and a Date. The queries for any associated billing report would compare the report date to the Rate Date...

I have created a table for customer bills, and a table for customer profiles which contains rates associated with them specifically. The problem is that after a new rate change has been imposed I want to be able to look at an old bill, via a report, and have it reflect the "old" rate within...

I'm sorry, my posting was in haste, I think I'm getting the hang of the VBA to some extent. Nonetheless, hopefully my solution can be of help to others. I created a radio button called "cmdRecordComplete" with a label that asks the question, "Record complete?". Then created a condition that...

On the form I created I use list box fields that populate other tables. If an item isn’t in them I employ a command button that first opens a form to enter in the new item into the other table then the user is redirected back to the original form and uses a command button to refresh the list...

That works great!!! Thanks PHV!!!

When I ran this I had problems when I deleted an entry and hit "Yes" to change the value then I received an error message. I remedied this by replacing <> " " with > 0. But I would like to a way to only invoke the pop-up for values being change, that is, when a brand new entry is being made then...

Thanks a million, it works great!!!

This is the code I'm using: Public Function ValCtl(ctlName As String) As Boolean Dim Msg As String, Style As Integer, Title As String If Trim(Me(ctlName) & "") <> "" Then Msg = "Are you sure you want to keep your current Data Entry?" Style = vbQuestion + vbYesNo...

Thanks, this gives me a real good jump start. I do get an error, however: Run-time error '2465': StartUp can't find the field '928' referred to in your expression. I pasted the function you gave me (without changing anything) into my code module. I then pasted the code you gave me into...

I would like to create an event which is initiated by entering a value into a specific field and hitting the tab or enter button. It would create a pop up that asks the user if they are certain that they want to keep the value entered. If the answer is “yes” then the newly entered value is...

Yes, the parameters are fairly simple: a date range, and a company ID field. Also, each user has their own front end.

I am new to Access and would like to know the best way to set up queries for a database that uses 20 - 30 reports. Will it run better with a query built for each report or should I re-use queries for more than one report if possible? I am concerned that if two separate reports are run using the...

I am a little embarrassed to say that I missed something that should have been obvious to me. I found that in addition to the primary and foreign keys, I had another field that required a unique value and over looked it. I was focused on something else and had left this field blank. I am not...