Search results

Hi, it's SELECT dbKlient.KlientName FROM dbKlient; which for some mysterious reason stopped working just now, ill investigate.

I did! i select the criteria and there i found the combobox i use for the client selection but that has not worked for me. (the second code is made by the query builder)

in the second piece of code the "[Formuláře]" part is just a translation made by the query wizard in my language.

Hi, I'm trying to make a query which i would later export to excel, however i got a form where i want to be able to give selection options such as date, yes/no fields, client name etc. Right now I'm trying to make just the client name combo box work with the query, but i think i got my code...

Hi, I wasn't able to get the desired effect with any of these tips. I now made a new form that would just have adjustable parameters for a query, however i'm unable to get this working properly. I tried methods described on youtube, however that didnt work for me either. I tried my magic SQL...

is it possible to skip making the query and just have it export based on a SQL syntax right on the form?

Hi, I'm looking for the best way to go about this. I have got a unbound form (which i use to input data into one table) that has a listbox on it which displays currently pending items to be invoiced for any given month (meant to replace a physical board we use in our office) and we'd like to be...

Hello, I'm trying to make my Edit form lock it's txt boxes based on a yes/no value within the currently displayed record, is that possible?

That's some advanced stuff right here! I'll get there, all in due time-or rather, when i'll have use for this, i'll remember that you gave me a good preview of what's possible, thank you once more!

I'm so new to all of this, i don't even know ActiveX yet or how to work with libraries. But i appreciate your resourcefulness my good man.

Ah that's nice, but i can not imagine this working unless i would migrate data from table to table to achieve the color i want as the color is defined in the actual tables' column format property, right?

Hi, the title says it all basically. I'm looking for a way to set background color of individual rows within a listbox, is that achievable? I saw some posts regarding using a ListView instead of ListBox, but those were rather old so i figured that info might be outdated (?)

thank you both! Thanks to Gasman's comment i tried putting the ID collumn first in the rowsource SQL and in the properties of the listbox enabled one more row but put the first row's length to 0cm which did the trick

I was unsure whether to post this into the VBA section or here, so please forgive me if I was wrong.

Hi, I've been going on about this clickable listbox for a while now and I'm sorry for that, however I'm now attempting to hide the column i use to open records (the ID column within records). So i got a table with 9 columns, but in my ListBox RowSource i have the ID field on 8th position in the...

Ok but for what purpose? Is the number then used in the procedure somehow? I don't see it, i mean, i don't see the meaning behind declaring "response" being a number, when i then clearly use the word response.. I apologise if this sounds stupid, but i honestly don't get the point of this. I...

Thank you! So in my code example, the Dim Response As Integer declares "Response" as a number value?

Hello, I'm trying to understand the Dim statement in vba, however I don't know whether it's the lack of english skills or what, but I just don't understand what it does based on explanations found on support.office.com. Could anybody explain this to me as you would to a dumb person? (because i...

Thank you, however the position itself is not what bothered me regarding the quote you made. It was the inconsistence with the size of other visual objects on my form and the interference with the overall visual layout of my design.

Oh i had it set to "1" instead of "Yes" but i read this on support.office.com : So i figured i'll give it a try but that didn't initially make no diference in the occuring errors, and as i progressed i forgot the option to revert back to the original "1", which now has resolved my issue and...