Search results

Hello, Currently I'm working on a small project. This project needs a database. The problem that I have here is that I have no clue on how to put a database on a server. Program: Microsoft SQL server express 2012. Some help would be appreciated :) Thanks in advance. -Jan Pieter

Jan Pieter here, I have made this sql statement in VBA where rubriek = a variable but I dont know how to implement a variable in a nested query. SELECT "rubriek, SUM(verkoopprijs) as prijzen FROM voorwerp (inner join VoorwerpInRubriek on voorwerp.voorwerpnummer = VoorwerpInRubriek.voorwerp)...

Jan Pieter here, The VBA code I have at the moment: me.Results.Rowsource = "SELECT car, title, FROM dbo_inventory" Is it possible to add a variable to a specific row in listbox using the code above? In this case the price? Some help would be appreciated :) - Jan Pieter

Is it possible to have WHERE,ORDER BY and HAVING as criteria in de function dlookup? Function: DLookup(expr, domein [, criteria] ) Thanks in advance!

Today I came across this error(ODBC : "the call has failed" ). Everything works, the forms im working with and the other reports) Is there any explanation for it to show something like this ? When I click on " Help " it only shows a very global error that doesn't really help me out :(. - Pieter

Ey Jan Pieter here, I have three comboboxes and I want to have the first one filter the second one and the filtered second one filter the third one. Filtering the first one on the second one works, but when I whant to add a third one to it, it just shows blank spaces on the third one. What I...

I have had this problem for a few hours and I can't figure it out :mad: I'm trying to filter out a report by year, but the value i'm trying to filter is a datetime value and it just doesn't whant to work. I tried to make a separate unbound text field to filter out the Datetime into year and...