Search results

Where are the listboxes getting their original values from? EDIT: Forget that. I see its a value list So you want to save the value list after you move it and keep it there? Read option 4 http://allenbrowne.com/ser-27.html

Take a look at what I did based on the sample you gave me and see if you can figure it out. Does your data have anything with a 5 in it? I didnt see any when you gave it to me so I had to put one in there. Its the button with the phone on it.

Look here http://bytes.com/topic/access/answers/765291-populating-1-listbox-another-listbox

Using this post, http://www.access-programmers.co.uk/forums/showthread.php?t=77694 I came up with this, put it behind a button and see if it does what you want Private Sub FilterFives_Click() On Error GoTo Err_FilterFives_Click Dim strSql As String strSql = "SELECT...

Add the tables to the query, and if you have the joins correct you should just be able to pull the names out of the 2 tables..

attach the staff and customer table to your query then pull the names into your query.. It will be easier then using a lookup on your report.

Hi Chris, The combo box is based directly off of the table so if it was in the combo it must be in the table. Did you happen to have the table open when you created the person in the comobo box?

Just did, from a 2000 format to a 2007 format and now the query works... I'm curious as to why It wont work as is, seeing as in access 2007 it works just fine...

Unchecking it didn't seem to work... and I can't uncheck them all because some are in use.

I have the following, I'm not sure I see anything missing... VB for Applications Access 14.0 object library OLE Automation Microsoft Activex Office 14.0 access database engine object library

Yeah I probably could have cleaned it up alittle bit..... sorry about that. When I try this I get "There was an error compiling this function. The visual basic module contains a syntax error." Then It highlights "Year"

Yeah, I didn't mean to come off that way! I wasn't taking a wack at ya! Maybe should have started that sentence with "I feel that the mods..."

The Mods do a pretty damn good job of keeping most of the spammers out of here. I know Bob has a system that works extremely well, but im not exactly sure what that process is...

Does anyone know why access 2010 would not be able to handle this where statement? WHERE ((([dbo_Calendar].[endYear])=IIf(Month(Now())>=7,((Year(Now())+1)),((Year(Now())))))) I get a compile error . in query expression, but 2007 handles it just fine!

Jeff, Apologizes for the untimely response. Holiday weekend and all.... Take a look at the attached sample... I think what you were missing was the fact that you needed to either set the control source of the form to a query based off of your junction table, or you needed some vba to add the...

Like i said... Mine is Ugly, but it will handle clumps!! Thanks mailman!

Ok this is probably ugly, and I'm sure its not the best way to do it, but if i wanted to do it quickly, its how i would do it...... Id create a dummy table with record numbers 1-2000 or whatever. Just numbers. just copy and paste from excel Then I would do a left join on the records table and...

You can also do this by selecting password for the input mask property of the textbox if you dont want to do it using code..

Alright then I think you will want to look into the "not in list" function of a combo box Here is a quick link http://www.databasedev.co.uk/not_in_list.html

Do you want them to be able to create a new award/employee directly in the main form? Another option would be to use the combo box for both employee and award, but have a button or something to create a new award/employee right next to the combo. Be sure to requery your form after you create a...