Search results

Yup, that simple action.. These errors have occurred a few times in the past few weeks, in the last occurrence both CTRL/C and CTRL/F were of words in English, written in simple Latin letters. When occurs, the user restarts the computer

Hi all you experts, in a Acc2003 project running in a client's location in Acc2010, he searches for a value in part of a text field a main form. This value is usually copied (ctrl+c) from part of a field in one of 9 sub-forms. These sub-form have about 20K records each (not all loaded at once...

Colin, is the Nz function in VBA and Ace the same function? would compiling issues be a good solution for function errors in queries?

Bumpkin, What about the references? VBE - Visual Basic Editor. That would be my guess, try that before going to the decompile - compile option.

Hi, My friend and colleague offers his Acc2003 product in a Windows server using Remote Desk-Top, serving dozens of clients. After making sure you have enough CPU and web connectivity, it works just fine

I have managed to delete a few 'invisible' characters prier to the file name, and it works now... Thanks fot your support!

It seems as if there are some additional invisible characters... 'MyFile.2.mdb' works fine, so mapping is not the issue. I should use UNC file paths. Could that be the issue?... could you please point out what would could be the issues and the circumstances? maybe some link or term to google...

Yes, it worked just fine

Hi all you experts! I have an Access system running in a client's location. As part of an upgrade a few year ago, I have separated the front end to a few mdb files, Put them all in One netework directory, and added to the name of the main file a".2" suffix. So the main file path is...

Thanks you all for your great replies! Iv'e seen this error by the client, but everything seemed to run nicely: the data was updated in the DB, I'm not even sure it jumped every time I tested. Do you mean form1 you created doesn't error? the Pic was displayed in the report? That's sounds...

Hi all you experts (: Here is some code I use replacing a picture in an Image object: Public Sub SetPictureSettings(ByRef img As Image, Optional Path As String = "", Optional SizeMode As Integer = 0, Optional picAllign As Integer = 2) img.Picture = Path img.PictureAlignment = picAllign...

It's an old thread, but this post may give a good answer (Iv'e just neede it now ;) )

Would you know how Access decides if to create a numeric or text field?

I am attaching some sample data and relevant process. I would like it to be text, and contain all data. TIA!

Thanks for your reply. This line of code tackes care of that: ChangeFieldType dbs, "ING", "ISID", dbText, 50 ("ING" being the table name, and "ISID" being the field name) changes field type to dbText, 50 Chars long. It runs after creating the table: App.ImportXML FilePaths(i), acStructureOnly...

Hi All you experts! I am trying to import to Access few XML files, containing, roughly, products, ingredients, and prices. The products and ingredients data are linked by products Primary key - a number up to 18 digits long. In the XSD file, the field is declared as an Integer type. While in...

Many years later... I am searching for an answer on the same question. For the time to be, I have found Application.TransformXML Method

This is a very general question, please point out your difficulty: creating the sub-form? opening the file dialog? saving the link? some other issue? Please point what you have tried. ATB

When you apply filter, you remove out of the underlying Record-Set the filtered-out records. If the next search is for records filtered-out in the previous search, these records will not be found. try using DoCmd.FindRecord instead of DoCmd.ApplyFilter. Note: you first set the focus on the...

First: Have a link to this at all times, I have it bookmarked. Second: note that NavigationSubform and ReportingForm should be names of subform controls, witch may or may not be same as the name of the actual Form. the [Form] keyword refers to the actual form.