Recent content by Schippi

Hi George, in case you work with access you will find in the design view of the tabe under datatype the AutoNumber. this function automatically numbers your data set.

I made a workaround which is working pretty well: I added in field Picture in my query the function CurrentProject.Path and the folder path with the pictures so that access always updates the path.

Hi, I have a funny bug in my code, which only gets active after the database was opened again. I have a Treeview on a form with the organization data in it. The data is stored in a Table and via a query it is transferred in the correct fitting. Now the problem is that when I klick on the...

did you check the Microsoft Website? office.microsoft.com/en-us/access-help/CH006366750.aspx

well you're right. that was the issue, it's now working correctly. thanks for your quick help.

Hi Bob, thanks for your answer but i already tried it and it is still the same error. And I have removed all ,_ and put them into one line. It always runs into the errAddBranch with the above mentioned error. best regards, andreas

Hi guys, I was trying to display the org chart in a treeview. I got this code but currently I get an error message saying: Syntax Error (missing operator) in expression. Sub Form_Load() Const strTableQueryName = "Contacts" Dim db As Database, rst As Recordset Set db =...

Has no one an idea how to solve it? br as

Dear Community, first of all I would like to say thank you for the great job that is done here! Here is my issue that I want to solve: I need to login to website and retrieve the data stored there. The website is password protected. Is there any chance to get with an Access 2007 database to...