Recent content by TURabbIT

I also already had to think about this... I don't hope we will have such an pandemic outbreak within the next 28 days... At least not here in Europe/USA

Okay got it! :D It needs n "!". DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel8, "Härte", file, True, "Härte!"

Hey all, I need some help with the DoCmd.TransferSpreadsheet Range parameter. I want to import from an xls-File just the second page, titled "Härte". How do tell this the compiler? Code is: DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel8, "Härte", file, True, "Härte"

I learned while working with access / microsoft: Don't try to understand why it works as long as it works. Sometimes there are such weird connections that cause trouble, i stopped asking.

Tried it with DLookup("SAPANLAGE"; "[Query_Anlage_42]") So somehow it works now :D THANK YOU!

The textbox is in a subform and the code (tries to) refers to a query. The code is in the content field for the attributes of this textbox

The ';' is correct. Pretty sure. :rolleyes: Several How-Tos from the web and the access help for DFirst told me to use the semicolon. Any integrated function (like "if" and so on) uses semicolon to seperate the syntax parts of the command. Without semicolon I get syntax error.

I try to get any value from the query [Query_Anlage_42] at [Query_Anlage_42]![SAPANLAGE] and insert this value in a textbox in a subform. I tried the code in the properties in the field for the element content. The help told me to use this syntax with ';' and without this the field just shows...

I intendet to get a Value from a Query for a textbox, so I tried to use the Domainfunction DFirst. =DFirst("[SAPANLAGE]";"[Query_Anlage_42]")but now the box just shows #error and blinks like crazy. :eek: I have no idea whats the problem with that, anybody an idea? :confused:

I am from Germany and are also relatively new to Access. I use it for my job at a steel company since mid of last month (August). My task over here is to create a surface for a archive database for users to get information about done jobs if there comes any request from the customer. Beside...