Search results

The '#' was the key Spikepl. Thank you so much! Thanks to all those who tried to help. For anyone that needs it here is the answer. Not sure yiou really need the if then statement.... Dim HoldDate1 As Date Dim DENIEDDATE1 As Date DENIEDDATE1 = rs.Fields("DENIED_DATE")...

I changed the variable to a variant. Still experiencing the same problem. I believe the Null value is getting stored in the variable. The real problem is the fact the Null does not need the single quotes but when I do have a date, it needs the single quotes. If I take the single quotes out...

Thanks I'll give this a shot later today and let all know the results.

strSQL2 = "SELECT distinct CH.SEQ_CLAIM_ID, CD.LINE_NUMBER, mm.SUBSCRIBER_ID, " & _ "ch.line_of_business, CH.MEMBER_AGE, CH.MEMBER_GENDER, CH.PLAN_CODE, CH.SEQ_PROV_ID, " & _ "pm.SHORT_NAME, ps.PRIMARY_SPECIALTY, ps.SPECIALTY_TYPE, CH.Primary_Svc_Date, CH.CLAIM_THRU_DATE...

I've been struggling with this for some time now. Have looked for threads specific to this issue but haven't been able to find the correct thread. My issue is that I am trying to update a date field. When I do the date field may have a date or may be a null. When I try to pass in a NULL date...

Ugh you are brilliant. Was only looking at the error number. I'm a little new to error debugging. Didn't think about printing the error description. Didn't see this in any of the forum comments. Turns out the tables was locked....Thanks for the assistance.

Absolutely. For several hours. Have checked all the posts and can't seem to find in particular why I would get the 259 issue.

I have a nasty bug. Have worked and researched for hours. The issue is that I keep getting these two errors no matter what I try. In the update sql, if the where clause has a space it gives the 913 error. With no space it gives the 259 error. & [currdetailid] & " ;" & [currdetailid] & ";"...

Ugh. Thanks Pat! That worked.

I've reviewed several solutions listed on this web site and have knocked off everything I could find to the site. I do not see the Make ACCDE button. I'm using Access 2010 32 bit. Have an ACCDB FE file which I'm trying to create the ACCDE. I've compiled and fixed the VB errors. I've...

Thanks for the quick answer and the correct answer! This solved the issue. Thanks for the note of caution. Unfortunately setting up the purely normalized manner will cause extremely cumbersome maintenance of the data and is not practical. Maintenace goes from a few thousand records to a 100...

Could really use some help on something I've been stuck on for awhile now. Found a few threads but nothing which solved my issue. I have a list box (LOB_Multiselect) on a form. The list box calls and retrieves 20 values. I'm able to highlight and save the values to a field called LOB on the the...