Search results

Hi All You experts! A section in my system is there for linking products from the same category: There is a maidisplan Products table, and other Tables with lists of products in other countries named by convention CountryNmaeProducts. All these tables are linked by a CategoryID field. In the...

Hi All you experts! I am trying to, programmatically, receive a constant values defined in a VBA module, in other applications - all *.mde files.

Hi, I have a system running in a large organization, 1-3 users, FEs on each work station, BE on a LAN network drive. Using Acc2002 mdb files in Office 2010-13 environment. The user occasionally gets a few unexpected error messages. - Some are about the BE file format, indicating file...

Hi all you experts, I have some software by a client with 2-3 users, each copies the FE to his work station (regular PCs, I have VDI access to the network too), and access the same BE on the LAN (or Virtual LAN). all files are Acc2003 mdb files running in newer Office environments. part of the...

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

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

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

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

I'll make it short: Dim ID as Long Dim rst as DAO.Recordset Set rst = CurrentDB.OpenRecorset("SELECT GroupID, SUM(Val) As ValSum FROM Table1 Order By SUM (Val) ASC Group By GroupID") rst.MoveFirst ID = rst.Fields(0) Do while ID = rst.Fields(0) CurrentDB.Execuet("INSERT INTO Table1 (GroupID...

Hi All you experts! I have code I use for importing XML into Access. this code uses DOM document. I yesterday wanted to run a test, and got a compile error: "User-defined type not defined". The error is on the first line of the import function: Dim doc As New MSXML2.DOMDocument...

Hi, I'm trying to improve my SQL Server skills, and got stuck in the beginning... I have SQL Server 2012 & VS 2013 installed, and downloaded Northwind and Pubs sample DBs. I can't get the sample DB's attached to the server, these are 2000 versions... Any way around this? A link to a newer...

Hi, in brief: running these simple lines of code CurrentDb.Execute "DELETE FROM Components WHERE Code = " & p_Code CurrentDb.Execute "DELETE FROM Packs WHERE Code = " & p_Code sometimes causes error 3086 - 'Could not delete from specified tables'. usually, works fine. In detail: In a data...

Hi all you experts! A client organization IT is migrating my Acc 2003 App to VDI - Virtual Desktop Infrastructure. The App runs fine, but much slower - Desk Top and local directories are now virtualized network, or 'Cloud' drives, the App's Front-End looses the advantage of running on a local...

Hi all you experts! I want to insert the result of a query into a Temp table, but some data is omitted: the values of 2 fields in 5 rows The correct data appears in the query result, not in the table. Any ideas of what could have happened between the query and the table? Thanks in advance!

text is gibrish in group by query Hi all you experts! while processing string manipulation on a table (140K records, 200-250 MB) the file has corrupted, and I lost all vba Modules, but the data and other DB objects seemed to be in tact. I now have a query with a text field, when I make a...

Hi all you experts! I have some work Iv'e done on an Acc2003 format file (*.mdb), working in Acc 2010 environment, on a Win7 OS. the project is Testing some data, if suitable for other project, so I havn't split to FE and BE. a table of some 150000 Records contains a few text fields, witch...

Hi All you experts! I have a subform in Continuous Forms display, in a tab contorol of the main form. When I put focus on Controls of this sub form, the sub form's display gose bad, I attached an screen shot. Could anyone help me understand what could couse this?:confused: how can I get over...

Hi all you experts! A client wants to convert a report I designed for him, to a word document so he can edit it. The report's Report.Orientation Property is set to 1 - Right-to-Left Relevant TextBox.ReadingOrder Properties set to 2 - Right-to-Left, and relevant TextBox.TextAlign Properties...

Hi, I hope this is the place for this question: a client location I have my Acc FE linked to BE in a network drive named 'P' (P:\). I created a virtual drive on my computer, to mock this NW location, I must attach the VHD on every Computer restart. is there a way to keep it attached? Thanks...

Hi All you experts! I'me running on Win7, Office 2010, Acc2003 format (.mdb), writing data to Excel 2010 (.xlsx) I have code to create an Excel file, send record set data to it, and then add some formulas and formatting. I was trying to tune up the formulas, when I got a pull back: Access VBA...