Search results

*** SOLVED **** I need to declare the parameter. In this case I was using a form to pick the date range, so I had to delare the path to the form as a date field in the parameter window. Thani you anyway!

Hello, I have the following: 1.) qryEventsMasterReport1 << main query This consist of tblEvents 2.) qryEventsMasterReport1a << used inside of the main query This consist of a crosstab query with the General Ledger Coders I am tracking for the events and the EventID field to link the queries...

Thank you for your reply, I have been working on too many projects lately and haven't had time to address this one yet. I will try your approach, but wanted to make sure I thanked you!

I have a combobox that has a list of values that come from a table called campaigns. What I want is to have the user choose one of the values from the list (combobox) and store that value in the data entry table (which the form is bound to). Currently as it is setup, it does exactly what I...

It's been a while now since your first post, by now you may already be a PHP Master. :) There is a GREAT site for PHP beginners that you may find useful... PHP 101 Good luck!

That's okay, no big deal. Thanks again for the help!

Oh, one last question on this. The label comes out only as wide as the text in it. Is there a way to have the label come out the same width as the field?

That's it! Different method (much quicker) than I have done, but that's it! Thank you

Hello, I am using Access 2003 and would like to design a field format (color, length...) and copy that design so that every time I lay a new field on the form it looks like the one I first designed. Kind of like "AutoFormat" but with my design. I have done this before, but just can't remember...

Got it working! But what I did was set allowedits to true on the setfocus of the search field in question. I am going to check out tags as it sounds like a great tool to have at the ready.

Tag property? I have seen it, but never utilized it. I'll look it up, thank you!

Hello, I am able to use the allowedit property on a form (setting it to false), but it also locks my search field (combobox). I am trying to avoid using the lock property on all the individual fields if possible. Thank you

Thank you, I will try apply your suggestion, it may take a while as this is a side project and I just got hit with another project. But I will let you know how it goes!

I have an employee form and I was able to set up a toggle button that toggles between "all" employees and "active and recently terminated" employees (within the last year). My boss just doesn't always want ot look through employees that have been termed 6 years ago. The filter works fine and...

Thank you for the assistance. Again, I have never used java before so don't laugh at me too hard. But going with you idea, I named the buttton "BSBut" and then I wrapped a div named "test" around my text from col#3. So the plan would be that if the button (BSBut) was false my div ("test") would...

I am working on a webpage that has 3 columns, the first column is a button, the second one is an image (with 4 hotspots) and the third column is text. When the user clicks on a button (col#1) an image in col#2 shows up and when one of the four hotspots is chosen on the image the related text...

I have read about this a little bit and I think this is the problem. How do you change the record locking? I understand your warnings and will look for other solutions first (like time-outs). Thank you all very much!

Here's the scenerio... I'm in my database on a particular record after having entered data into it and I have not exited out or moved to a new record. Then another user comes into this same record and enters data into the record I'm in. If go to exit out of the database or start a now record or...

Got it! Thank you very much for your help!!!! I didn't use quotes... strWhere = "[txtDistNum] = [Forms]![frmReportCentral]![DistrictPicker]"

That's exactly what I was looking for, but when I test on just the district field on the report form I get an error..."MS Access can't find the field "|" referred to in your expression". Private Sub MSRDetail_Click() On Error GoTo Err_MSRDetail_Click Dim stDocName As String Dim strWhere As...