Search results

Hello, I stumbled across this pretty old post and have some questions about it. I hope anyone still reads this ;-) If I alter my display properties, then the color change will only appear when I open the database on my computer, right? The rest of my users will still have the original color set...

Aaaaahhh! I didn't know that you can set up several columns in a list box :o That solves a lot of my problems! Thanks!!

Hi guys, I want to run a query based on a list box entry. For more user friendliness I want the list box to show both an ID number an a name, but the query shall only run on the number. Is there a (VBA-) way to read only part of the list box entry into the query? Or can I somehow concatenate...

Oh my god, vbaInet, this worked out!!! :-D I didn´t know about the parameter list... If anyone is still interested in seeing the database I will upload it gladly, but my problem is solved! THANKS SO MUCH, EVERYONE! See you ;-)

Ok, I will! But this requires some research for me (did I mention I am an Access Dummie? ;-)) and will take some time! Thanks so far for your efforts!

But how can I format a text box entry? I can not choose if it´s a text or a number in the properties settings. And the query itself is already running with these data, just the VBA command is not

Oh, I didn´t think this was a control! It should just tell Access that whatever is in the boxPNumber is a text and not a value/number. I chose "text" instead of "value" in the expression builder and this is what came out ;-) But it seems like the query needs this information, because when I...

Thanks for your answers! But I´m afraid I don´t understand what you mean :( What could be the extra control? I have many forms for all my DB tables, but this form "frmPriceCalculator" is not connected with any of them

Thanks, Paul!

Hello everyone, I have a query that I want to take its criteria from a text box (which is a form). The user shall put data into the box, hit the "calculate" button and get his result. The query works just fine when I enter my data in the box and open the query "manually". On pressing the...

Hi everyone, with no experience in database design and only little in programming (actually, I am a mathematician), I am about to create a database for my current job.. this is bound to create some difficulties! So thanks for adding me! Moori