Recent content by DiverGuy

Just tried CInt: INNER JOIN tbl_Sec ON CINT(tbl_MCHS.SecNum) = tbl_Sec.SecID ...at first it produced an error that Access could not represent the expression in Design View. After clicking ok, it rendered as planned in datasheet view. This did the trick. Thanks for leading me down the...

Hi Paul, Thanks for the response. Back at work and had a chance to try it. This will probably work but one little stumbling block to overcome first. Working with a legacy table. It's a long story but the SecNum column is nvarchar(2) and the entire app is too far along to change the datatype...

Strangeness... A query is refusing to return the desired results. It's obviously a syntax problem but I'm not sure where and I'm hoping someone can suggest an approach that will work. Working with Access 2003 that is pulling data from linked MS SQL tables on a SQL 2005 server. In SQL Server...

Thanks. That actually lead me down the path I needed. Googling on those phrases revealed these links, which detail how to set up the ODBC connection to the SQL server (http://www.mssqltips.com/tip.asp?tip=1470) and then connect Access to SQL through the newly created DSN...

Good afternoon. Your thoughts and input would be appreciated on this one. We have an existing Access database, complete with reports that pull data from fairly complex queries. The tables were migrated to a SQL server and the data input/manipulation forms have been recreated as asp.net...

Oh goodie. :rolleyes: Okay, here's what I've done so far (and, in retrospect, probably should have done from the beginning): The update form properties have been changed to lock the record(s) selected. The code behind that form now counts the records selected and reports that number in a...

Interesting. No, these are all hard-wired connections.

Yes. They've all been given a separate front end. Worth double-checking, though. Would that be enough to cause such a corruption?

That's an interesting workaround. Could work. Can you provide an example of how to wrap it in a transaction? Have only heard about that before and never tried it.

I put a split database (created in 2000 format using Access 2003 SP2) on the network three weeks ago. Three times the entries in two of the columns have been changed for every record, essentially making the data useless. I have not been able to narrow it down to a specific event that is...

I wasn't interested in saving it. Just wanted it to run once to avoid having to manually update the pre-existing data. I ended up using: Public Sub test() CurrentDb.Execute "Update tblLog " _ & "Set DaysToProcess = CompletedDate - IntakeDate" End Sub That did the trick nicely. Thanks...

Searched the forum but didn't find anything specifically on point. Could sure use some help. I have inherited a table called tblLog with over 5000 entries and growing. It has the following columns: ID IntakeDate CompletedDate DaysToProcess My predecessor never used the DaysToProcess column...

I'm trying to use the value selected in a combobox to update the selected items in a listbox. Running into difficulty and all of my local resources were unable to help. Here's what we're working with: A table called tblFileList. A table called tblPerformers A query called qryFileList that...

Our company has Rumba, Attachmate, and Reflections and they're all pretty easy to write a VBA screen scrape. IE is proving somewhat more difficult. Just a few minutes ago I found out how to put an ActiveX web browser on the form and will navigate to the correct intranet site. That part was...

I'm halfway there. The problem I ran into was an unanticipated one and I would appreciate your thoughts. The report the customer wants summarized is accessed through an intranet website. Unfortunately, each time you log onto the website, it generates a randomly numbered session code, which...