Search results for query: *

Morning colleagues! I have fighted with an problem of listbox in MSAccess Form. It is a long story, but brief overview is, that I have a quite complicated MSAccess form with hudge listbox and with code I manipulate with this data (listbox contains a results of dynamic crosstab query)...

I have though about this option also, but problem will be same as with grid control option. There are lot of VBA, various ways search conditions, multiselects, etc... . Form itself have worked two years at least and my cutomer is extremely satisfied with this (they working with this like with...

I have a problem with quite sophisticated listbox application. I have a lisbox with couple of fixed columns on left side and then variable number of fixed format columns on right side (sawmill tables stock - some fixed parameters and length_columns filled with amount of tables). Based on sort...

Look http://www.mvps.org/access/api/api0001.htm oleg

> I might have to reinstall all of them. That will be a pain if that's the case. I suppose, that You have to reinstall only applications, which You want to run in Terminal server sessions. But I haven'n experience in this - I always have installed Terminal Server (Actually Win2K in TS mode) at...

Hi! Just one comment .... > You also can't print, at least not > on your remote computer. If we talking about Win2K Terminal server, then in Remote Desktop Connection settings (Local Resources tab) there are posiible connect local hard drives and printers to this session. I haven't tested...

I have a quite silly problem. My customer liked very much an form, where I use an multicolumn listbox to show him a query_based_table. Actually it is store of sawmill packages - each row is a package with attributes and in the end of row there are columns with numbers of various length tables...

If You talking about Windows environment (should be - MSAccess), then define odbc connection in windows and use odbc statements in PHP (odbc_...). Oleg

I using for this sometimes temporary saving of value in static variable (does not work in multiuser frontend database). I save the required value to Static function called SaveString and restore this value in query: ... WHERE (xxx.yyy=SaveString()) Function Savestring itself is simple: Static...

I going to use also short version - it is really ELEGANT. My solution is written years ago, when I started VBA programming.

Once I wrote a next function and it works in NT-environment and I suppose, that it should work also in other Microsoft environments. Result of this function is current database path. Hopefully it helps! Function FindDatabasePath() As String 'function returns absolute path of current database...

Comments are really mostly in Estonian - I programming in VBA and Access mostly for fun, so I did not planned to publish this solution. This solution I created for my friend, who using it. As You noticed - links refreshing module is written by Shamil Salakhetdinov, from Russia - i found this...

I have used such approach many years in various applications (in Access'95, Access'97 and Access'2000). Requiremet is that in the same directory as front-end database locates, should locate a ini-file which have same name as front-end database but .ini extension. In ini-file should be at least...

Function described in query OK - so problem is in VBA code. There are no data type Number. It should be Integer (probably). Also there are other errors (db is not declared, etc..) You have to compile module separately and You see, where is compilation error. But why You do not add table...

I suggest - print to Immediate window teh compunded query string, then copy it to new query (SQL view) nad try to run. This trick have helped me a lot of times to find out problems in genearting dynamic SQL-statements.

Yes, it works with multiple users - I have some similar applications working. One additional hint I did and could be useful to You. I have one initialization file in each frontend workstation (with same name as FE database, but .ini extension. All frontend databases performs refreshing of...

There are very nice constant in VBA vbCrLf - carriage return and line feed. So modify assignement line as strMsg = "You need to fill all the boxes whit a red dot" + vbCrLf + Err.Description and it should be OK! also You can use instead constant CHR$(10) + CHR$(13)