Search results

I've been here now a couple of days, asking questions and searching the forum, and it helped me a lot. the project is almost finished which is good because as a student in Belgium I'm only allowed to work 23 days tax free, and I had to finish it in that time. which I think might've been a lot...

oof, here I thought I was really ignorant about access, not knowing controls might have recordsources. glad to know they don't, and are just like the stuff in Visual Basic, basically single information units with some properties. all my SQL is explicit (I.e. I don't use stored queries), and...

I assumed vba code was constructed when creating a label, but I don't really know where to look for it :), I wanted to delete it there as well. However, I still have my doubt wether that is my problem, because that could be the problem if I did create something else then a label. however...

I'd immediately agree with that (although would changing a textbox's name be such a sin?) if it wasn't for the fact that I'd really made sure that the thing I changed was in fact the label. access wouldn't automatically name anything else besides a label "Label#" and I made sure that the name I...

maybe, However the label control had as original Name: "Label12". I changed "Label12" into "comm3" and all went to hell I did solve it. instead of calling them comm, I'm calling all those labels "labela1" to "labela12". they seem like information boxes for beauty products and not on a comment...

Well, I don't know really what to say about this one: Here I am thinking I'm doing the simplest job in the world, adding labels. I drag and drop about 3 labels on my form, and name them "comm1", "comm2" and "comm3". I will need them later to show comments but for now, there is no code anywhere...

well, luckily no dates have to be entered, only week-numbers. I decide how the dates look. a format(startDate, "MM/DD/YYYY") did the trick. And I really don't mind to use the American date format, it's American software in the end. What does frustrate me is the fact that it kinda goes along with...

its that last part which is a problem for me. I think I remember the MSDN specifically saying that Access handles dates the way your region handles them. since Access is mainly a Database management system, I'll end up using SQL. and in such an SQL statement some dates were turned around. In...

Probably this has been replied before in many topics, but I didn't really find a post informing people of this strange thing that MS access does. on MSDN I can read that MS access will use the system date used on the host system. in my case that is dd/mm/yyyy. However, just to be on the safe...

sorry about bumping an old thread :o got here through google. probably it's best that I indeed use pbx's solution. another bad thing is that it kinda seems to keep my project real busy

reading the other posts, I wonder if what I did is exactly what you want, but it might help you or other people. Private Sub addNotes_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) 'MsgBox "X: " & X & " Y: " & Y If X > 10 And X < 800 And Y > 10 And Y < 500 Then...

Hey Christ0 I am Sooooooo grateful for the code you provided. Option Explicit Option Compare Text Private Const conX As Integer = 5 Private Sub Form_Open(ByRef intCancel As Integer) Dim intSuffix As Integer For intSuffix = 1 To conX Me("boxAssignment_" &...

i've seen it, and even tried it (not in this situation though). when I tried, the old value was the same as the new one, so if it were to work in my situation I should know when the old value is updated. hmmm... maybe I should give it a go, see what the values are with some wellplaced MsgBoxes...

For the moment I got my form back working. However, now I see the problem with this solution. the information in a textbox depends on two things: 1) The Assignment 2) The date this information was translated into the name of the textbox: Day1_1 and so on. the old data is collected into an...

hmm, well, apparently it is not the coding of datacode that ruins everything. is Access 2002 known to be buggy in that respect? something like, if I have 13 loops in each other that the system stops? at any rate, vbaInet, many thanks for all the help. wasted enough time trying to revive the...

with the huge risc of sound really stupid, what exactly do you mean by that last phrase? something like this: Dim recSetCombo As ADODB.Recordset and then later whenever I use it, first set it at the start of thes stub/function Set recSetCombo = New ADODB.Recordset and I close (and...

Hey vbaInet, I've got another question, and slightly off topic. I think I discovered why my project is going crazy, and it has to do - I believe - with how I code access to my database. in the top, I define two things. my connection as cnn, and all my recordsets. Option Compare Database...

sorry mate, you're right. guess this whole mess makes me braindead :o I tried colum(1) before and I wasn't very succesful in getting the value back then. I must've done something wrong, something small. at that time I didn't really try because I had already an alternative. as soon as I got...

I tried that, but how do you get the value from the second column? I thought I read somewhere on this forum that it was simply not possible, that you can only read data from the first column and that any other column after the first is to clarify the first

I completely agree, it is usually our fault. though in thise case, I'm not sure. I completely emptied the VBA screen, the only thing there is "Option Compare Database" and it still crashes, so I must've done something wrong, really deep, somewhere I didn't go yet. I made a new form and am...