Search results

Hi, Here's my prob: I've got a table with a unique Key (= serial nr) These parts are in a project (= second column in table) Now I would like to make a form (maybe with subform) where I can select a project in a combo and that all the parts (serials) within that project are shown. Every...

Hi, When I copy/paste a hyperlink from my browser to an excel cel, the link can't be used. I first have to doubleclick the cel, or push F2 to enable the link. Now, the prob is that I export a report from access to excel, with lots of links. I don't want to doubleclick them all one by one...

Hey, I know there is a function to, in VBA, check a table exists yes or no. But I don't remember... Can anyone help please? Thx! V.

Hi, I've got a form in access. I'd like to, in VBA, count rows in a query between 2 dates (parameters), and put the countings in textboxes on the form. what's the best way to do so? Greets, V.

Hi, This works fine in a query, but if I use it behind a commandbutton in VBA error 3067 occurs. I tried spaces at begin & end of the strings, but it doesn't help much. anyone? thx, V. SQL: Private Sub Vette_Test_Kopij_Tblmkqry() Dim SQLstringTEST As String DoCmd.SetWarnings False...

Hi, I need to make a table, in VBA using SQL, with 2 parameters (variables). (a startdate & enddate). I made some SQL statement, it seems to do what it needs to do (table is made), but the table that is made contains no records. The 2 variables are filled with dates, but... someone got an...