Recent content by Penrodcigar

Thanks AceMan, I am self taught (Access for Dummies) and wasn't aware of either command you mention. But will try them!

How can I write a make a table query that will add an autonumbered field to the new table ? DoCmd.RunSQL "SELECT Inventory.Face, Inventory.Price, Inventory.Quantity INTO Autonumber FROM Inventory WHERE (((Inventory.Face)="xxx"))" This DoCmd will produce a table called Autonumber with records...

Well I've got quite a lot going on with this little database, including bound sub-forms, record sets, etc That's why I'm confused where the update message is coming from. I was only hoping there was an easy cure...

Will setting all the record sets to adopendynamic etc stop the message box? myRecordset.Open "Example", , adOpenDynamic, adLockOptimisticg

I get the following message eacj time I click on a combo box "The Data Has Changed. Another user edited this record and saved the changes before you attempted to save your changes. Redit the Record" After I click the message box, and retry the combo box, the message doesn't come up and I can...

Ramou...how about the possibility of a defined series of 2 or 3 images operated from a form control? If all the images are in a single directory and the Access control shells out to a particular image in the directory, the rest of the images will appear in sequence after it. I would prefer if...

...I knew I would get a difficult philosophical question...it's for the kids of course...thanks

Yes but, when the scan files (and database) are copied to another computer the paths will change...

Dim S As Object Set S = CreateObject("WScript.Shell") S.Run Chr(34) & "C:\01_LawSchool\12 Spring 2007\Independent study\Data zoning exceptions 2000-2004\2000 vol I\HPIM3948.JPG" & Chr(34) Set S = Nothing I'm using the above code to open scans with a command button on a form. But the directory...

How can I open Microsoft picture/fax viewer from access? The data table has a file name for the .jpg scan. I need to open the scan from a form command button that will reference the .jpg file name. Is there another application I can use if not the picture viewer? I don't find the viewer...

The Date() function keeps giving the wrong date when used inside a subfunction. Typed into the immediate window it returns the correct date. Why this stubbern insistance on returning an inaccurate date?

Well, I'm not sure what was the matter, but I finally worked it out. Maybe it was the update/append dichotomy. Actually I just found a work around instead of writing a new temporary table I made a form dialogue box with its record source as the table that needed updating. Regards, Peter Landeck

Is it possible to use an append query SQL statement with DoCMD.RunSQL when updating a table that has an Autonumber ID field? I keep getting a key violation. It's no problem without the Autonumber field.

Yes, thank you, I think some secretary typing up the user manual trasposed the writer's shorthand "numrecord" literally. It's working now. Thanks.

Using the .Move numrecords, start: method Access gives me the error message “Sub or Function not Defined”. The actual lines of code read: Dim PrIDVar As String PrIDVar = Me.Face.Value ‘where the value is the row selected with a combo box...