Search results for query: *

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

Hello, what I would like to do is open a front end and get the front end's physical location. Something like: Private Sub Form_Load() msgbox "I am located here: " & dir(me) 'my directory path End Sub ...but I don't quite know how to work that out. Thanks, dRahme

Hi, you might be able to tweak this: SELECT Distinct TOP 2 r1.* FROM revisions AS r1 LEFT JOIN revisions AS r2 ON (r1.deliverable_no = r2.deliverable_no) AND (r1.issue_dt < r2.issue_dt) WHERE r1.deliverable_no = "075B"; HTH

I don't know why this never occured to me, but instead of stacking buttons, change the button caption of one button and what it does: Dim ctl As Control Select Case Me.cmdInfo.Caption Case Is = "How It Works" For Each ctl In...

Looks pretty straight forward: SELECT IIf(DateValue([rep_date])>DateValue([org_date]),DateValue([rep_date]),DateValue([org_date])) AS EvalDate FROM Table1;

Hi, it looks like everything you have is 1:1, which could make updating a bit of a challenge. Why not change your form around a bit and use tblCSCPatBio as the recordsource for your main form and place the biographical data there. Keep the other four tabbed forms and link each one back to...