That didn't work either, wouldn't there need to be the single quote after the [IDNumber]= in the criteria along with & "'" at the end due to the criteria being text?
Strange part is that I am able to get this to work in Debug by using the Table "TblClientProfi le" instead of the Query "QryContactComp lete" for the Domain, which doesn't make much sense to me. If I go and open up the Query directly the...
SummerSolstice
Last Activity: May 6 '11, 10:58 PM
Joined: Apr 11 '11
Location:
-
DLookUp problem works in Debug but not on the form?
I'm stumped! I have a form that we will be using to write reports. The form is based off of a query that pulls from two other queries that go back to two different tables (one holds customer information the other will hold each report and they are linked off of the ClientID / IDNumber).
There is information stored in the customer table that I need to default value on the report which will be stored in the report table. This information...Last edited by TheSmileyCoder; Apr 29 '11, 07:54 AM. Reason: Remember a / in the closing code bracket. [/Code] -
SummerSolstice replied to Access 2003 Need to make command buttons enable / disable based on other controlsin AccessI tried to enter the code but I keep getting a Run-Time Error '438': Object doesn't support this property or method and when I Debug it jumps to the Me.TermTransCmd =Me.Enrolled (Line 8 of Post #2 above). Any idea what the problem might be?Leave a comment:
-
SummerSolstice replied to Can I have an unbound field that will retain the date entered in it until changed?in AccessMy concern with doing the auto datestamp After Update is that the Unit assignment is only a small part of a much larger amount of data that does get changed often so that stamp might not be based on the "room assignment" field rather some other part of the record.
Thanks for the input everyone.Leave a comment:
-
SummerSolstice replied to Access 2003 Need to make command buttons enable / disable based on other controlsin AccessSorry about the Code tags, first post here.
I'm a little lost yet (still learning especially the VBA part of this world). So does the set Buttons procedure go on the main form? and then how do you call for the procedure on the After Updates etc?Leave a comment:
-
SummerSolstice replied to Can I have an unbound field that will retain the date entered in it until changed?in AccessI thought the date would have to be stored in a table, but I hadn't thought about using a subform to bring the data in. That was exactly what I needed. Thanks much.Leave a comment:
-
SummerSolstice started a topic Can I have an unbound field that will retain the date entered in it until changed?in AccessCan I have an unbound field that will retain the date entered in it until changed?
Maybe this isn't possible, but it can't hurt to ask. I am working on a continous form that maintains a list of room assignments. The room assignments is stored as part of the large primary table, I'll call TblClientDemogr aphics for the post. One of our daily work assignments is to go in and update any of the room assignments that have changed since the day before.
This data changes a lot for some and very little for others. I... -
SummerSolstice started a topic Access 2003 Need to make command buttons enable / disable based on other controlsin AccessAccess 2003 Need to make command buttons enable / disable based on other controls
Hi everyone. Sorry this may get a bit long here trying to explain but I'm working on building a database that will be used for tracking enrollments & terminations in some classes that we offer at work for clients. There are two main tables TblClientDemogr aphics and TblAnnualEnroll ment. They are linked as a "one to many" based on an unique ID number for each client. What I'm currently working on is a bound single form used to edit...Last edited by TheSmileyCoder; Apr 11 '11, 07:31 AM. Reason: Please remember that [Code] tags around your code are mandatory on this site.
No activity results to display
Leave a comment: