Search results

I think I would open the .accdb then shut it down and then check whether the .laccdb file retains an older date/time stamp on it that should be the case ... if so simply delete it.

Has the sheet/tab called "CCL" be renamed/moved/deleted?

No, did that, hence why I'm still puzzled ...

Tested assoc and .accdr did have a correct-looking association! So, next I created a desktop shortcut that does seems to work:- Target = "C:\Program Files (x86)\Microsoft Office\Office12\MSACCESS.EXE" C:\Folder\File.accdr Start in = "C:\Program Files (x86)\Microsoft Office\Office12"...

I tried exactly that last night without success ... even though I found an MSACCESS.exe file in the Office12 folder ... I double-clicked and/or opened the MSACCESS.exe file but the new association wouldn't change?

The program wouldn't open for the user ... by the time I got to the user they'd opened the file Properties and associated MS Works to the file ! So, I'm perhaps trying to unstitch a user-created problem ... Using the assoc command, then, what else do I type in?

I found this on an Internet search ... Hit Start-->Run and type the command-line switch below into the box and hit Enter (or click OK). Note that there is a space before the slash: msaccess /regserver or maybe it should be msaccess.exe /regserver Anyone know whether this is worth...

I have installed a Runtime 2007 application on a user computer, but the computer's file associations appear to be missing/incorrect. How and where do I change the file association for this .accdr file? Where does the MS Access Runtime file actually get installed ... and should I be pointing...

I do exactly this with a couple of Runtime Databases ... I use a one-line Macro attached to a command button, with an "OpenTable" command.

Sounds like you have a record lock, somehow. I would try copying the file into a different directory and see it the error persists. If you are able to open the file, run the "Compact & Repair Database" utility immediately.

You will need to set up a CALENDAR table with the following fields: Date (date field) Year (text field) Month (text field) Off this Table you can build a SELECT Query with TOTALS to establish the first and last day of each month (GROUP on Year and Month, MIN/MAX on Date) e.g...

Do you actually need to update the first table? Perhaps not ... You can certainly build a SELECT query using the TOTALS utility to GROUP BY the Product Code and MAX the Price ... this will then display each Product with only the highest price.

This is a workaround ... but it works! Left(Trim([FurnaceModelNumber]),1) & Replace(Mid(Trim([FurnaceModelNumber]),2,1),"*","M") & Mid(Trim([FurnaceModelNumber]),3,20) The TRIM function is included just in case you have any FurnaceModelNumber codes with leading blanks. Hope it works for...

That worked, many thanks

Thanks, I'll give that idea a whirl in the first instance

Hi I should know how to do this, but am not seeing the wood for the trees right now so can anyone give me a pointer? I want to output just the first field from each record in the attached DATA table into a .txt file. The records must remain in the same order. I created a TransferText...

I wonder whether the following part of your criteria is incorrect? 1 And 2 And 3 And 4 And 5 Depending on what each of these Values 1,2,3,4,5 actually represent (please advise) then you appear to asking the Query to return records with values matching ALL of the five values rather than just...

I can't help you with the script, but can warn you of the impact of importing thousands of JPEGS into a table. Even if the JPEGS are carefully managed in terms of actual filesize and/or resolution, you will experience severe database 'bloat' meaning that the database filesize in increase...

I wonder if it's becuase you're calling a new form, rather than using a subform?

Assuming that the End Users are using a Works Order Creation Form in the Database, why not control what they enter with a Combo Box field (the takes values from a controlled data Table) rather than a Free Text field?