Search results for query: *

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...

The subform based on a query repeats the first record of the table in each instance. The main form and the subform are based on the same query. I use a purchase order number on the main form to call up different information on the subform. Everything works fine, except every instance of the...

That's great. Working fine now. Thank you....anybody have a convenient way to display decimals as fractions? Regards, Peter Landeck

When I try your expression Format(Val(yourNumericString), "0.00") I get a Compile Error: Sytax error message For "yourNumericString" I insert a variable for the string say TVar = "23.23567" so...Format(Val(TVar), "0.00")...is my expression Not sure what to put for "Val" and I presume...

Anybody have a simple way to truncate a string number with a decimal so it limits the places after the decimal?