Search results

Yep, found what I was looking for there... cascading combo. tx! Vic.

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...

Thanks a lot! V.

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.

Thx pbaldy! That sure was the solution, thank you! 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...

jzwp22, Could I trouble you again? ;-) You might have a nice solution to this: what i'm trying to do with this project is counting rows, actually. But I need to put in diff parameters (startdate, enddate, etc...) when I push a commandbutton. So, what is the best way to count rows? What I...

runs like a train... :-) thx again! bye, V.

additional question on this matter: want to add 2 fields, this works fine, but want to fill up these fields with begin & end-date, every record the same. I did this, but again, no records in the table that is made. thx, J. SQLstring = "SELECT tblOverview.NcNumber, tblOverview.IssueDate...

jzwp22, You are my new God! THX! V.

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...