Search results

This shows me a count for each row. For example, I might have 10 "1307" entries, but I only want it counted as 1.

Hi All, I have the following SQL which returns rows of distinct numbers that are calculated from a field. SELECT Distinct (Left([ProjectID],4)) AS NumberOfCalls FROM tblProject; ProjectID looks something like this : 1307-IND-001 and NumberOfCalls looks like : 1307 I need to count the number...

Thanks for the help on this Jdraw. My only issue with it is that with the model this way, a company or project cannot have more than 1 contract. I think what I would need to do is put CompanyID and ProjectID into ContractedEntity and remove CEID(FK) from company and project table. Make sense?

Hey All, I have a database that tracks projects and companies. I have been asked to add a table that will track contracts that are either associated with project OR with a company. I have made a very simple data model that is attached to this post that will hopefully help explain better. I...

This might help you out: http://access.mvps.org/access/forms/frm0031.htm

Why do you start writing the code like this "Me.[ApplicationQ1].Value = 1" and then in the same statement start writing it like this "Me.[ApplicationQ4] = 1"

Same here with Tandy CoCo 128!

That's a good question....I guess I really just need each quarter as a row, with the sum of values in each row. I have a new PITA problem with linking this query to excel. Apparantly I can't do this because the query is based on a function! :banghead:

Thank you again for this, it worked like a charm! My next question is how to sum each column so that I end up with just 1 row and a summary of values in each column?

Hi PLOG, I really appreciate your help with this! Please see the attached database.

I totally see what you are saying and have no idea how I would implement it. It also seems to go against proper database design as I would be storing calculated values, no?

I need help creating a cross tab query that will calculate the value of a person who is hired and terminated between 2 dates. What I currently track in a table is the date someone is hired, and the date someone is terminated. We call these people HQP - highly qualified people. Every quarter...

So I got this to work...sort of. I can have the database delete itself, copy the new one and open up, but I get stuck in an endless loop. I think my confusion lies in the method of releasing a new FE, and where and when to update the version numbers in the linked table and the new local table...

Alright, I moved my master FE and BE to my local drive and it works. Any idea why I can't copy the master database FE from the network to a local PC? I have full permissions for that network drive.

Sorry to hijack this, but it is a solution I have been after for quite some time. I am having an issue with the batch file. This is how the operation goes: 1) I open the database, it warns me to update 2) Database closes, deletes the local file 3) I can see the new file get copied 4) An...

I have a form that shows a companies engagement with our company. If someone wants to edit the details of that company (address phone number etc...), they click the "edit" button, which then opens a form where edits can be performed. After the edits are done, the user clicks a save and close...

You Win! I feel like that is the only thing I didn't try.

I would have expected that as well. When I had that code, I would get "the text you entered is not an item in the list" error. This is my not in list code: Private Sub cboCompany_NotInList(NewData As String, response As Integer) On Error GoTo cboCompany_NotInList_Error 'Set default...

Hello, I have a form with a subform that contains a combobox where I choose companies to add to a project that is on the main form. If the user types in a company name that is not in the database, I run code on the NotInList event that passes the company name using openargs to a company entry...

I have gotten closer by adding Cancel = true if the user chooses to return to the form, but still get the warning message that "access cannot save the record at this time".