Search results

Thanks for the replies, guys! I think I've got it!!

This works on my test dataset, but when i try it on my actual table, I get the very first date the account was balanced for all the records that have that account. SELECT dbo_Balances.BalanceID, dbo_Balances.AccountID, dbo_Balances.Balance_Date, dbo_Balances.Difference, (SELECT Top 1...

If you look at the example data I provided, the first set is what I have to work with. What I want to do is compare the date in BalanceID 1 to the date in BalanceID 2. The second set is what I want the resultant query to look like. Sorry, the tables didn't come out as clear as I would have wanted...

Thanks for the reply! DateDiff doesn't help me - the problem is that the two dates I want to compare are in different records. Any other ideas?

All, I have a table that contains balances for certain accounts by date. At certain intervals, a new record is added for each account. I am trying to measure the intervals for each record (basically, the number of days since the last balance). The data looks like this: BalanceID AccountID...

Use a custom error handling routine. You can set it up so that the error is logged to a table, which you can then review later. Alternativley, you could even set it up to email you. If you use a custom error message, the user won't have the option to hit debug. However, a clever user might know...

You have a couple of options. First, you could just hard code the names of the boxes to check instead of looping through all controls, like so: If me.cbo1 & "" = "" Then MsgBox "Missing data in cbo1" Exit Sub End If If me.cbo2 & "" = "" Then msgbox "Missing data in cbo2"...

What you can do is this: 1. Create a copy of the table (structure only, no data) 2. Set the primary key on the new table 3. Append data from the old table to the new. Only 33,093 fields should append. 4. Do an Unmatched query on the old and new tables. This should report the 6 problem records.

You can set an index on both fields that will prevent duplicates.

I'm not really sure. I know that you can loop through all open workbooks and check the name like so: With xlObj.Application For Each wbk In .Workbooks Debug.Print wbk.Name Next wbk End With However, I don't know how you could modify that for multiple instances of Excel being...

This will show you how to tell if Excel is running: http://www.mvps.org/access/modules/mdl0006.htm

You can use the Dir() command to check if a folder exists. Check out VBA help.

You can just say: [Notes] = [Notes] & " " & strConcatenation There is no need to assign the value of [Notes] to a variable first. Of course, if [Notes] is null, there will be an extra leading space. You could use: [Notes] = ([Notes] + " ") & strConcatenation if you do not want the extra...

You would only put: <#1/1/06# in your criteria field. You don't need to type the where part.

You need to put the error handling code on the sub that is causing the error. In your case, the sub that is casuing the error is the on_click event, therefore you need to trap the error there.

I assumed your table was called tblGroup, just change it to match. SELECT tblGroup.prb_no, tblGroup.seq_no, tblGroup.commitment_user_group_cd FROM tblGroup WHERE (((tblGroup.seq_no) In (SELECT tblGroup.seq_no FROM tblGroup GROUP BY tblGroup.seq_no HAVING...

I don't see why you wouldn't use: WHERE tblOrders.OrderDate < 1/1/06

Yes, removing the "MsgBox Err.Description" will work. However, you will never recieve an error message about any error. That may not matter to you, but if it does you can use my above advice to automatically ignore the cancelled error but report any other error.

Nope, its an error. The reason being that you asked Access to open a form, and the form did not get opened. Therefore, the DoCmd.OpenForm method results in an error. When you get the error, you can just control-break to go into your code and type ?err.number in the immediate window to get the...

First, make sure the first column (visible or not) in your listbox is the primary key of the record. Then, on the DoubleClick event of the listbox, you can use the following: Docmd.OpenForm "frmYourForm", , , "[PrimaryKeyField] = " & me.lstBox Just make sure to add the name of your form, the...