Recent content by Harr777

Excellent, thanks a bunch!

I'm trying to produce a query the will display a list of records of items that do not have a certain value in a connected table. The SQL Code should be something like: SELECT tblAssets.SerialNum, tblMeterReads.ReadPeriod FROM tblMeterReads INNER JOIN tblAssets ON tblMeterReads.SerialNumber =...

I got it, in the query design view I set the sort property to Ascending. It saved fine. Thanks.

I got that far, but I can't get it to produce the list in alph. order. Went into datasheet view, ordered the column (from a-z) and saved the changes...doesn't work. When I open form it doesn't relfect the changes. Maybe in I change the SQL code itself. Here is the SQL code; SELECT...

I can't figure out how to get the items in a drop-down both in alphbatical order. Does anyone now how to do that? Thanks.

Forgive me, because I know that this must be a pathetically easy question for may. For my website, I want to create an icon that when the user clicks on it, bookmarks the website. I want to make sure that, if possible, it works in all browsers. I would like to put in HTML code. Thanks!

That was it. I have been creating my queries in Access design view (please do not frawn upon me). I was able to switch to SQL view insert the LEFT JOIN code. Thanks a lot.

I have a query that should idealy show all of the results from one table and whatever exist in the other. In other words, not every record in tblOne has a corresponding record in tblTwo. Yet, I need every field in tble need to be listed in the query results. I don't know if there is an answer...

If put this in query design view: GetNumDays: DateDiff("d",[installDate],#6/30/2004#) and it worked. Thanks, I'm on my way from here.......

Should be #06/30/2004# I have also tried to do the calculation with just the date 06/30/2004. If fact, for this case it should be something like; GetNumDaysQ2: IIF(InstallDate>03/01/03, 6/30/04-InstallDate, 90) But I need to get a whole number value (total number of days) Thanks in advance

I need to get the total number of days using a query. This would be something like; GetTimeFrame: [installDate] -#6/30/004# When I try the above, I just get a crazy date. If I try to change the properties of the output field to a number, it limits me to choosing a form of date. Please help!!!!

You nailed it, Zion7. That code worked perfectly. The quotation system is still a little confusing to me. I'm going to have to spend some more time trying understand it better. Thanks

SerialNumber is text and ReadPeriod is a number. Should this have a bearing on the code? As always- Thanks alot

I tried this code: stLinkCriteria = "[SerialNumber]='" & Me![cboEditMeterRead] & "' And [ReadPeriod] = '" & Me![cboReadPeriod] & "'" When I click on the button that runs this code (which should open a new form with the applied filters) I get an "Open Form Action was Cancelled" message. I...

I've been trying to get more than one filter for a form that opens with two primary key values. I need the new form to open with the two values coresponding to two combo boxes on the first form. Tried the above sugestion, but I am getting nowhere fast. Can anyone help?