Recent content by Trogdor

Ignore my last tidbit. I was having issues with it yesterday, but I re-compacted the file and issues are gone.

SOS.. OK cool, thanks. I was wondering what that actually did. I have another quick idea, but I haven't tried it yet. At the moment in my frmSearch I have the listbox with the query, and I select one and click a button to confirm. Can I also have it so that when I doubleclick the nominated...

cheers, the DoCmd.OpenForm stDocName, , , stLinkCriteria worked a treat, thanks! Didn't realise I had to use [ID]= id_number. Thanks again!

Thanks for the reply John Big Booty, So I am not sure I explained myself properly. I have two forms frmMain, and frmSearch, frmSearch being the form with the listbox showing the results of the query. I want to select a result from the query and then goto that record on the frmMain. At the...

Hi All, I have created a simple search ability for my database, where I can put in my search parameters, and using a drop down box pick the field to be searching in. Then I open another form where I display in a listbox the query generated from the search parameters. What I want to do now is...

Awesome thanks for that! :) I also realised that when I did a me.refresh it was re-selecting items in the list boxes, so I just ran the function after a refresh :) I am still unsure on the checking to see if an item is selected inside the listbox though, but I am now thinking i might be able...

Ok.. I haven't really done much with listboxes before so any help would be appreciated.. I have two listboxes which values are associated to events. These events are triggered using buttons, for capturing data. so For example, someone walks into a room a button is pressed, when they take a seat...

okay.. sorry.. I think i just got it.. It's been a logn day :P I changed failedID = "Person-12" to failedID = me.lstFailed.value It seems to work now :)

Hey all, I am on a new project, and I am trying to use listboxes for a queueing system. What I have done is I have created a unique ID and when someone enters the queue that unique plus the string Person is added to a list box. e.g. Person-1 What I need to do now is when another event occurs...

No need to worry people :) I put a wrap around the form_keydown sub. Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) If TypeOf Me.ActiveControl Is TextBox Then Else Select Case KeyCode Case vbKeyW Call chkWait_Click...

Hey people, I am hoping that there is a simple fix for this problem but... I have a text box that I need to put notes into, but I am also have buttons on my form with hotkeys associated to them. When I put notes in my textbox and I press a key that corresponds to a button event then that...

Thanks Wayne! Worked a treat! It helps when you know all the small little functions that VBA uses :P

Okay me again.. Instr() gives me the position of the first math in a string. Is there a method to find the last position in a string? For example, I am trying to create a button that puts the string wait or wait end in a label (yes it must be a label). I want to search through the string to...

gemma, thanks for that Worked a treat :) After I figured out how ubound worked and how to arrange the code :) FUNTASTIC!

instr gives me the position of the vbcrlf, is there a function that gives me the count? Or can anyone think of how to use it to give me a count? Wazz - I cant use textboxes in this project, they have to be labels.