Search results for query: *

I'm having trouble with a row height issue. I have a table with 4 rows and 3 columns. The middle column is going to hold text and is row spanned through all 4 rows. I would like the first 3 rows to be static heights that I have specified in my code. I would like the bottom row to accomodate...

I have a query that has the following field: Planned_Test_Date = IIf(IsDate([TestDate]),[TestDate],"else") The TestDate field is a date field that is sometimes null. When I display the table, it looks like all of the entries are either a date field or null, so the data is fine. When I run...

Awesome, that worked! I didn't see that as a form property, but I was changing it with VBA anyway, and it was listed as a property there. Thanks!

I am trying to change the ordering of entries in my form by using the "Order By" field as part of the form properties. I have tried entering the field name (ie: MethodDesc), but that doesn't work. I also tried entering "MethodDesc ASC", but that didn't work. Any ideas? I could change the...

Hooray, I figured it out! Apparently there is a value called "Allow Additions" on the sub form properties. I just set that to No and it all worked out. Thanks anyway!

I have a form that contains a subform. The subform contains a list of items (test types) that are pulled dynamically from one of my tables (TestType). The idea is that the user can go through the list and check off as many test types as he/she wants. These values are then stored in a...

Oh, I am such a dork! I figured out what was going on. I have two forms: frmTestReport and frmAddTestReport. My checkbox only ended up on one of those forms, not the other, so it was erroring out on the other. Thanks for your help!!!

What exactly do you mean by declaring the public at the top of the form? I'm using a global module, so it's not tied directly to my form in question. In my global module, I have: Option Compare Database Option Explicit Public User_ID As Integer Public NewClient as Boolean etc. Public Sub...

I tried to make it a little simpler and to eliminate any other issues that could be going on, so I just tried to set it to True, but it gives me the same error. Forms!frmTestReport.chkScanned.Value = True

I can't get that to work in a global module. My code is: Forms!frmTestReport.chkScanned.Value = True I keep getting the error Application-defined or object-defined error. I have the same set up with a series of textboxes and it appears to work fine with them, what's the deal with the checkbox?

Does this work the same way with checkboxes? I am trying to set a checkbox on my form from my global VBA module and I'm getting Application-defined or object-defined error My code is: Forms!frmTesetReport.chkScanned.Value = True What am I doing wrong?

No takers on this one?

I have the following line of code in a VBA global module in my Access database, but I am getting an "Application-defined or object-defined error". Can anyone help me out? Forms!frmTestReport.chkScanned.Value = TestReport_Query.fields("Scanned") It looks like TestReport_Query.fields("Scanned")...

I have a client who is using Outlook 2003 for email. When she receives an email, the "date received" field is set to an hour before what it should be. The time on her computer is set correctly. I set up another computer to download her email and the date received field displayed properly...

That's exactly what was happening! Interesting, haven't seen that before.

Yeah, I'm building a web-based database for a client using PHP and SQL, but I'm pulling fata from their Access file. It appears that the file is messed up because the table I am trying to pull data from doesn't even display in the Tables tab. If you create a query and do a select all from...

I wonder if format() turns it into a string field... Damn dirty apes! DateValue(Format([MyDate],'mm/dd/yyyy')) works now. Man, I hate VBA.

Okay, that makes some sense. I'm trying this in my query: IIf(Format[QuestionableDate],'mm/dd/yyyy') > #1/1/1999#,"Valid","Older than 1999") The [QuestionableDate] field is originally 3/8/2002, but I format it to 03/08/2002. In the query, I still get "Older than 1999". What's the deal?

It also says the date 2/25/802 is valid.

I am trying to use the isDate() function to do some data verification. I am importing data from one table to another and am checking text fields to see if they are dates or not. In the new table, they need to be set as dates. I have a query that I am running that is supposed to flag the...