Search results

It was sarcastic. :)

I did not say a high percentage believe in ghosts. There is a difference. I spoke of conspiracy theroists as they support things they have little credible proof about. It wasn't a statement about God; it was about believing in something that may or may not be true. As for your statement...

I hear they have cookies on the other side. Alisa - Someone is quite defensive. Why do you feel the need to directly attack the ideas I presented as though you are the defender of truth? I don't remember directly pointing at you and saying: "Heretic!" I was merey stating my point of view as...

I don't believe in atheism. :rolleyes: First, I’m not of the Christian faith, so please don’t view me as some Bible thumping wacko. I’m just someone who has hope. Education is not an indicator of belief. Intelligence has nothing to do with belief. In order to believe something, you let go...

I'm still looking for help on this. Anyone? I did find a way around the issue and it does resolve my need. However, I would still like to know if this is possible. My solution was to create nested IIF statements in a query that resulted in the category names I wanted. Then I simply put that...

I am using PivotCharts to graphically display my data. However, when I place the data into the chart it names the labels with the calculation (e.g. sum of X, count of X). How do I edit these? The only posting in the forum I saw recommended doing the sum in the query and then base the PivotChart...

Thanks much. That did the trick! Now I'll have to wrap my head around the syntax so that I know what (more specifically... how) to do this in the future.

If I want to do this from a command button, should it work the same? Doing the following code produces an error stating "Compile error: Expected: line number or label or statement or end statement" in the VB editor: ----------------------------------------------------------------------------...

Thank you for the reply. However, I don't want to implement that change company-wide. I'm looking for a VB solution that will be universally applied no matter the individual settings.

I'm trying to figure out how to move the cursor to end of text in a textbox after I set focus to the control. Right now all of the text is highlighted when the focus is set. The code I'm working with is very simple: -----------------------------------------------------------------------------...

Problem solved. I figured the syntax out on the drive home (you know how it goes when something is stuck in your head). You confirmed it. Thanks. However, my DCount value ended up always being zero. Therefor, I had to set up an external query to base the DCount instead of building the WHERE...

Good idea. I'm not sure why I didnt think of that. Is Friday a good excuse? Bad execution. I'm getting a syntax error stating that I have a missing operator in the query expression. I'll have to take a look at it on Monday as I'm free for the weekend. Yay. Thanks for rattling my brain and...

The title pretty much says it all. I have a series of cascading comboboxes. However, if combobox 2 has no values to choose from, I would like to turn Visible = False so that the users don't have to click on it to find that there are no choices. Essentially, I have cboCategory and...

I'm using a Where clause instead of a filter, but my code to launch the report looks like this: DoCmd.OpenReport stDocName, acPreview, , stWhere stWhere is Dimmed as a string and the value of stWhere is set by code as you have set the value of the filter in your code. I know this is long...

Okay...Let's look at each of these separately. 1) I changed the Dim from String to Long....Done 2) I want to open the form in 'Add' mode. So, what I need to do is write the code to say open in 'Add' mode only if no match is found. Thus, I need to change the button on frmEvents that is used to...

wazz...The OpenArgs part is what I said works perfectly. What doesn't work is the part to check whether materials already exist for an event. I do not want to create two sets of materials records for the same event.

I am attaching the db with all data stripped. All OpenArgs are accounted for (I'm passing them all through but not capturing the ZipPlusFour on the receiving end as I didn't put it in the proper table yet. Args(6) shouldn't be Null as it is an autogenerated number and the primary key for the...

That creates a compile error. It says: Expected end of statement.

Here is what I'm trying to accomplish. I have one form with a button on it that calls another form to add additional information. I want to be able verify that there is not already data entered for the specific record. The reason it is a separate form and not a subform is that the data in the...

Why is it that the most complex issues typically have such simple solutions? Ugh!!! Thanks Allan, that did the trick.