Recent content by Xeseus

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