Search results

Hi eklinkow, I am new to using the iGrid by 10Tec. There are a lot of sample Access databases available but i was wondering if you have some pointers in using a treeview with iGrid. Like to hear from you! Regards, Guus

Hi, I've had similar problems in the past. They went away when i started developing in the english office versions. When my client has a dutch office version installed there are no problems when they run my Access application. I have customers all over the world and even the Chinese language...

Hi, i have an Access 2013 application with a SQL Server 2008 backend. Customer requested an update and with this new version several tables needed to be updated. Fields added and such. Some indexes where renamed and added Previous version linked to the tables relativly fast in 4s. This new...

@galaxiom: i've never digitally signed an mde. do you have a link i can investigate on the subject and when signed does that solve my problem? @ridders: i will look into your security challenges. Thanks for your input!

atm i am using a dns less connection. it uses a connectionstring which is stored in a textfile on the customers computer. it is not encrypted. Perhaps there's some room for improvement. and like you said ridders, and ACCDE instead of a MDE.

Hi. I work with a Access FE and a SQL Server BE in a lot of applications. Now and again customers asking that if they start a different access database and an ODBC coupling if they can see the tables in the SQL Server database. Then my answer would be yes you can. A lot of Access versions have...

Not a question. Just for future reference, I just found a new one: Immediate window: ?forms("About").Formname About ?forms("About").Form.Name About ?forms("About").Name About The second gives an error in an obscure environment (Windows 7, Office 2013, Access 2016 runtime) "Me" is a reference to...

Thanks Arnelgp. It is not immediatley clear to me what it does but i will figure it out. Thx!

Hi arnelgp, Thanks for your answer. Where can i find mr.Alessandro's code? Thx, Guus

Hi, I am creating an application for the international market. In it there is a report created on-the-fly. In Europe we use papersize A4 and in the US there is a Letter format. I want to retrieve the dimensions (height, width) of the report automatically. When printed to a pdf file it shows a...

Hi ridders, as you can see i have put a stop command in the select case statement in case i forgot one. and i didn't. obviously i don't use hidden queries. Thanks Pat for your advice. Some time ago i wrote SearchInQueryDefs which i can use to search through all queries. I just have to search...

Hi Ridders, The code shown in my second post shows that you can check the execution of each select query. Very fast. Since i have well over a hundred queries it came up with about 20 queries which needed to be changed to accomodate the database change. It is a lot faster than checking each sql...

This is a quick and dirty method of accomplishing what i want: Public Sub ParseQueries() On Error GoTo Err_ParseQueries ' 0 is select ' 16 is crosstab ' 48 is update ' 64 is append ' 80 is ddl (create table) ' 96 is ddl (drop table) '128 is union Dim dbs As Database Dim qdf As...

Hi, After changing the database design i want to parse all queries to see if i have forgotten to update a query to the new design. Is there a way to accomplish that using code? Thx! Guus

Hi, I want the listbox column heads to appear in a different color. Is that possible? Thanks. Guus

:banghead: @Pat Hartman, I hope i didn't offend you. I am very sorry if i did. I didn't know.

Hi missinglinq, I am using MZTools and Rick Fisher's Find & Replace add-ins so i am well covered in that aspect. To reproduce: Create a form with two buttons; Command0 and Command1 This is the code: Private Sub Command0_Click() DoCmd.Close acForm, Me.FormName End Sub Private Sub...

Thanks for your input. FormName is also not the name of a control on the form or the name of the attached recordset field. To my knowledge the application doesn't have any ties to Outlook. In an odd way it is reassuring that two men with a combined expertise of more than 30 years also don't...

Odd thing happend to me today, I upgraded from Acc2010 to Acc2016, still using mdb files, i created an mde file for the customer who runs it in an Acc2010 environment. I tested it on Acc2010 and it gives me an error message. "Method 'Name' of object 'Reference' failed" Which refers to this...

Hi all, Thanks for your input. Seems i've got something to read. It is not a simple database application i would like to port to the web so I am also looking into the VPN posibilities. Thanks again! Grtz, Guus