Recent content by Sue B

I agree, there is something wrong with the way I am using the CDATE function. Odd that it works in the Query wizard. I have not written my own CDATE function. I will look into that problem. Thank you!

It is the exact query. The date is actually sitting in a text field, not a date formatted field. Maybe I need to pull out the CDate().

I have a select statement that returns the right record when it runs in the Access query wizard, but returns too many records when run in VBA code. This is the query: Select * From Data_detail Where ( Procedure = 'T1004') AND (Charges = 139.5) AND (cdate(To_Date) = '8/10/2009') AND (parent_ID...

I just solved one of my problems. I couldn't add a new record to an internal table (a temp scratch pad), turns out that the default setting for one of the fields (Date()) was causing the problem. The problem only shows up on my client's machine. When I run the accdr on my machine the error...

So, what do you do with your projects when bits and pieces suddenly quite working? During the last 2 months, in 2 projects that worked fine before that, I have found issues with: adding records to internal tables, and with picking up the table def of an internal table, also with creating a...

Bummer. Not what I wanted to hear.

Well, I don't feel that I can charge my clients for changing code that worked 2 months ago, but now doesn't work because Microsoft changed something. So it is costing me plenty. In fact, I am thinking about downgrading the whole project back to Access 2003 to get a more stable platform.

That does seem to work, thank you! I have to say that I am having a terrible time with the Runtime. All kinds of things have fallen apart in my project in the last 2 months. What a headache.

Thank you, I will try that.

I have not worked too much with Access Runtimes. But I have a few users - some local and some across the country - that have my Access 2007 accdr application running. My problem is that I don't know how to update their systems with the new SP 2 runtime that was released this spring. They are...