Recent content by dRahme

Never Mind. Sometimes it works wonders if you shut down the PC and restart it.

We had an issue similar to that once where we were importing data from massive spreadsheets. Couldn't get rid of the bloat through compacting and the other usual means. What did work as first appending the Autonumber to the table and then running an update query based on the autonumber as the...

Hi, I have something rather strange going on: If I double-click on any .accdb to open, I end up getting a DDE time-out error. Doesn't matter if the files are local or on a server, split or one piece. If I start Access 2007 first and then 'file open' the same .accdb or any other .accdb, they...

That is exactly what the problem was. The option was ticked off on several machines, including mine. Thanks much, dRahme

Hi, For some reason on a few machines including mine, warnings seem to have been disabled - no prompts when running update, append queries and the like. Warnings work fine on other machines running the same database. This is Access 2007 Error checking is enabled with the exception of...

Hello, =Format([Forms]![Timecard Entry]![WEDate],"yyyymmdd") ?

Hi, you might try using the control's tag properties instead. dim Ctl as Control For Each ctl In Me.Controls If ctl.Tag = "aValue" Then ctl.Enabled = True End If Next Hope that helps

Boy, is this a favorite topic of mine. What I ended up doing was putting the onus on the user to get a new FE. I have a folder on the server where the Latest User Front End Resides. If I have an update, I copy it into the folder and Rev Up the latest revision the front and back end. The user...

No, but thanks for the links. As I said, I was not interested in linking to an external file which I can do, but reading a stored image in an access table and populating an unbound image control with it. Apparently it cannot be done. Thanks anyway, dRahme

Hi, I posted this question in the Access Reports forum and while an alternative solution was posted, I am still curious as to if this can be done. I have an Ole field in an Access table with one bitmap embedded. What I would like to do is to be able to read the contents of the table field into...

Thanks genomon, I actually found the second link a while back - just didn't read down far enough and that works. I don't know that it actually gains me much, but it is nice to have an alternative method for displaying images. Thanks again, dRahme

Because these databases go out to job sites and it is more convenient to save one small image to a table rather than link to an external folder. As I said, I am using a bound control in a subreport, which works fine I am curious though, as to if this can be done using an unbound frame in the...

Hello, I have an image stored as an ole Object in a table which changes periodically (for report logos). I would like to be able to use an unbound image control and use a lookup to display the image stored in the table. To date I have been unable to do this programmatically. My workaround has...

Hello, one way to get around that is to convert the double into a string in your query - str(yourField). Export out as a .csv and Excel will not drop digits when you open the file. Hope that helps, dRahme

Just what I needed. Thank You. dRahme