Search results

hmm, yes, how to explain? the name of the day is a code for what that value represents. Day1_1 means: It's monday and that person is working on assignment 1 Day1_2 means: it's still monday but the person is working on assignment 2 Day2_4 means: it's Tuesday and the person is working on...

Hello again people, I have a bit of a logical problem. the solution seems so incredibly simple, but I don't seem to be able to come up with anything. there are days: day1_1, day2_1, day3_1 ... day1_2, day2_2, day3_2 ... day1_3, day2_3, day3_3 ... ... ... ... every day is a textbox with a...

so, if I understand it correctly, you don't want to have a combobox open vertically with from top to bottom 123 456 789 instead you want your combobox to show only one line, and horizontally present 123, 456, 789 ? what you could do is make one String: do comboString = comboString & "; " &...

hmm, in which case I should really learn how to work with Access his buttons :D it probably doesn't help my case, but I'm actually really unfamiliar with all that access can do for me automatically. I'm always kind of afraid of those automated things because I don't know what happens under the...

Thanks all for the (very) quick replies The thing is vbaInet, that I am trying not to use that tactic. it's what I have now Private sub boxAssignment_1_AfterUpdate() Call Assignment_AfterUpdate() end sub Private sub boxAssignment_2_AfterUpdate() Call Assignment_AfterUpdate() end sub...

Dear people of the Access forums, Once more I call for help. I thought that this current problem I have would have a simple solution that is easily found on the internet, but apparently I am wrong because google has no answer for me. what is my problem? every employee has an amount of...

I hope its no problem that Im bumping this thread, but I believe I know what the problem is with Access, why the BETWEEN doesn't work. take my table for example when you perform a SELECT on Date for dates BETWEEN 19/04 and 25/04 you'd expect to see the dates 24/04, 22/04 and 25/04. However...

Hmmm, good thing you tell me, because as you said, the "Outer Join" goes as this in my course: SELECT e.ename, d.deptno, d.dname FROM emp e, dept d WHERE e.deptno (+) = d.deptno AND d.deptno IN (30,40) and I do remember that I had to do stuff like that in class, but goodness did I suck at...

Little update on the project, so I inserted the connection code that lagbolt has given me and I have to say, it works like a charm. Wow, does a whole lot for my project, thank you so much LagBolt. since I've redone all my connection code, I thought that maybe it is time to clean-up my SQL...

to my shame, I'm afraid to admit that I am using an unbound form. I don't use any controlsource or any of that stuff. the reason why is that I never learned to work with access in that way. I know to program, and now I know a bit of VB as well, but it seemed tedious to first learn how...

Hello all, I'm new here to the community and before I start asking away I want to say hello to all, and hope that I can help out as much as I can. beforehand, maybe I should inform that I actually am not familiar with VB and even less with access (I was a c# fan and usually went for Visual...