Search results

Hello, I would like to determine the key pressed without using the actual event on a form. When looking at the event I can see they have created an integer that stores the ASCII value, so my question is how do I store the key pressed into an integer of my own making without the event? Thanks!

You could apply a filter to the form where the records are located, taking into account that it's not only a data entry form. So, you have a search from, they enter the record number (or PK or another significant identifier that they know) and it opens up another form that's filter is the query...

heh. A quick fix for a simple problem. My knowledge of the syntax is apparantly lacking... Thanks Dennisk!

Hello, I need some help with a piece of code for a db. This code checks to see if the last three characters on a ControlSource.Tag property are "Req" and if they are, tests if it's null or = 0 and if it is then it outputs a msg box stating that the control.ControlSource is required. It does it...

hmmm. thanks for the response! I didn't know that about tab controls and their appropriate tab controls. That makes things make more sense. I'll just rebuild my query so it doesn't depend upon the tab form's name. thanks again!

Hello. I'm trying to build a query criteria for a tab control with three different tabs. They are all using the same subform in each page. I want to be able to set the criteria for one specific field to the current tab control page that is selected. Does anyone know how to do this? I wasn't...

Hello. I have been struggling with this problem for quite some time, and it's getting quite frustrating. My knowledge of access is limited and i have been using this forum to educate me in the best of ways possible! But, now i have a question that i really need help on when it comes to the...

that's a good point, but i guess that's what the message is there for anyway? hah. also, even if they are switched off here if there's something wrong with the delete you could easily needed recoreds without noticing! i guess. be careful, regardless.

well damn. don't you just love it when you solve your own problem after trying forever first? thanks to this post: http://www.access-programmers.co.uk/forums/showthread.php?t=116704 i was able to use their idea and come up with the solution. SELECT * FROM table1 WHERE (table1.Field) Not In...

in (edit)your run query button put this in: DoCmd.SetWarnings(0) before opening the query

hello. i saw this post http://www.access-programmers.co.uk/forums/showthread.php?t=116737 , and i was so happy because i thought it was going to be my same problem, but alas! similar, but different. i want to know how to do a 'not' query on every value in table's field. the query should list...

in a networked environment. i have tblUsers which has Username, Pwd, Access (privelages). example: sbertram, bert, Basic then, on my login form i use an overloaded Environ("UserName")(because of sandbox mode) in a locked text box that will give me "sbertram" when i'm logged onto my...

Right(txtDate,4) should do the trick. where it's 4 digits from the Right side? get it? 10/13/2006 would then equal 2006

thanks, dude! it answered my questions...

hello. out of curiousity, i would like to know when is the time to use SQL server as the be for a database? examples or, guidelines. thank you!

maybe you could turn off the auto expand option on the combo box? are the appropriate fields being shown in the box?

eg Private Sub cboBox_AfterUpdate() Me.SUB_FORM.Form.RecordSource = "SELECT * FROM QUERY_NAME " & CreateFilter Me.SUB_FORM.Requery End Sub Private Sub btnReport_Click() Dim strDocName As String Dim strCriteria As String strDocName = "REPORT_NAME" strCriteria =...

Do you mean physically sticking? Or do you mean the data in the combo box is sticking... Try Me.cboBox.Requery if it's the latter...

i was actually just working on something similar, a subform recordsource dependant on user's input. is the subform going to be running off of the same source object? If that is the case, and you just want one dropdown box, what you can do is build the recordsource for each combo box option...

holy moley! thanks a lot. I was attemping to do stuff like "Not isNull(lstBox.ItemsSelected) Then" Thanks for the quick reply! you're my hero!:D