Search results

Without seeing your database I can only guess. Sounds like it is in fact treating it as AND and thus no results appear. I'm not sure how you want this to look aesthetically, but if you are only selecting one employee at a time, you should just use a combo box to select the employee of interest...

hmm im a bit confused after reading your post, but if you want to know how to make a form continuous...go into design mode, click the upper left corner of the form so that a solid square appears, right click this and select form properties. Under 'All' select Default view and choose continuous.

you need to base your listbox on a query. Then when you make a selection in your combo box you can use this function to retrieve your selection and place it in the criteria of your query. Put this code in a module. Then in your query in criteria under the field your filtering on type...

all you need to do is change the tab order in design, 'tab order is located on the menu ribbon when you are in design mode. You can also change the tab stop to false in that text box, enter design mode, right click on the text box and select properties. Then click other and enter false for tab stop.

hmm i do not see your attachment, see if you can post that pdf and if possible the database or at least the structure so we can see what we are working with. If you have structured correctly then this can be done, either by a cross tab query or by a few creative queries to reorganize the appearance.

for your query, for FirstName under criteria... type this <> "Helpdesk" then below that in or: type <> "Open" and below that type <>"Test"...this is saying to the query to display records in that field not equal to those three criteria

yes, after creating the list box, go to the double click event and write your code there. Dim rs As DAO.Recordset Set rs = Me.Recordset.Clone rs.FindFirst "[ContactID] = " & Me![cboContact] & "" If Not rs.EOF Then Me.Bookmark = rs.Bookmark Make the necessary changes so this code...

Hmm, for starters you do not need the reference to the table since you have Me., and you need to supply the controls name since that is what your setting the visibility of. When you set the visibility of a control it must = True or False Me.ControlName.Visible=True or False Also, you can only...

This one is baffling me. I wish I could have helped more, but my knowledge of SQL Server tables is nada. Hopefully someone more experienced will have the solution. Good Luck!

What is your access/vba background? Would you say your savvy/competent in access design as well as vba programming? I ask this because in order to help you understand and answer your question it must be explained at your level of understanding. I think the confusion began here when a certain...

Hmm, This is something I wrote earlier today. I made no reference to text or value and it works perfectly. If Len([cboJobNumber]) = 7 Then Me.cboJobNumber2 = Left([cboJobNumber], Len([cboJobNumber]) - 3) Else Me.cboJobNumber2 = Me.cboJobNumber End If How is this data formatted in your...

Im just throwing out an idea since I cant test it with your database, but it feels like the culprit is in your if statement. Perhaps removing '.text' ---> If Len(Me!cbo_Lastname) > 2. I get the feeling when you enter that 'space' or hypen, your rowsource is dropped...sorry if I am way off.

Looks like Spike answered your question despite not knowing any of the structure or relations...If you want the individual to select their department data by a button, then yes, this is certainly possible to display on one form. This can be achieved by filtering or by queries. You can also use...

Perfect! looks like you can loop thru objects based on tag. Seemed like an obvious solution too :/ next time i wont be lazy and ill test it out before asking >.< Thanks alot!

Does anyone know of a trick to set the visibility of objects on a form by group and not individually. For example, you can group elements in html by <div>. Does access have anything similar already built in? Perhaps using tag or smart tag? I ask because I am always trying to improve the visual...

I had to read this a few times but ill see if I understood correctly. You want to generate a report specific to a user and their input and replace yes, no, n.a. with their appropriate comments on output for that user. If this is right then some simple vba should do the job assuming your savvy in...

Perhaps the simplest approach would be to use msn or outlook, etc. to PM another user. In order to view who else is in the database you can use the module in the database i linked. Copy paste it into your modules and all you do is hit ctrl+G and type showuser then enter and it will print out a...

it would be under form properties-->event tab-->on load, then click cod builder and place the code there. Depending on how you have users input the project number, you could simply use a combo box that refers to a query with only the existing project numbers. This way a user can only select a...

I assume when you say 'the date appears in alphabetical order' you mean that its sorting on another field since a date can not be alphabetized. For the report, try under report properties to set the order by 'date'. Even if a query reflects the ascending order you prefer, it may not reflect on...

Like jdraw said, without seeing your structure its all guessing, you can post this through 'post reply', though i believe you need 10 posts on the forums before you may do that?