Recent content by jan pieter

Thanks everybody for replying it really helped me! On an other note, is it possible to run a website and an online database on 1 server? and if so, which website host would you guys recommend for doing this The database has around 500 rows. Thanks in advance. - Jan Pieter

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

Thank you for you reply Namliam, I have tried to make it a little bit more readiable and used the link you posted. But when I want to do the nested query it gave me an error on second the select statement. "Compile error no instruction end" Code: Me.[Resultaten].RowSource = "SELECT Rubriek...

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

Thanks for the reply CJ_London, I have a variable that is called Price that I calculated in VBA and that price differs from car to car. Is it still possbiel to add this variable to the Rowsource in vba ? Thanks in advance - Jan Pieter

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

Thanks for responding, I have two textboxes in a form the first one is the one you can put in your car_number and in the other one you can put in your car_total so when somebody types in his car_number and his car_total I first whant to filter with car_number and then match what is filled into...

Thanks for responding, Well whant to achieve is: I have 2 colums car_number //////car_total 11///// 7 11///// 6 11//// / 5 12 ///// 4 12///// 5 and I whant to filter out the first column (...

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

I have checked it looks fine i have uploaded a sample hopefully you can find the mistake :) - jan pieter

Oh I hope this is where you're searching for: combobox1 controlelement: voorstellingnummer Rowsource: SELECT [Voorstellingen].[Voorstellingnummer], [Voorstellingen].[Titel], [Voorstellingen].[Uitvoerende] FROM Voorstellingen ORDER BY [Voorstellingnummer]; combobox2 controlelement...

Thanks for responding! So these are the values im working with: combobox1 has the values: Carnumber Seatnumber Comboxbox2 has the values: Carnumber ( carnumber in combobox 2 is related to carnumber in combobox1) Name of car combobox3 has the values Name of car ( name of car in combobox 3 is...

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