Search results

All you write is correct and it all works well otherwise. It is only when I assign the default value to the DateRequested field that I see this error. And it is only in the Parent/Child form that this error occurs. When I create a record in the subform (when not nested in a Main form) no error...

Okay, thanks. Yes, it would be helpful to provide the DB. I need to pull the confidential info as you say.

I have, [Tasks_T].DateRequested and set the default to Now() to create a timestamp on record creation. THe Tasks_T has a Subform. When I created a new record in the subform.... the error. How do I fix this error? Is the object is DateRequested ? Can I code this instead on the subform? I...

I did as you said in the SQL. I seem to be at odds with several commentators about how DBs function. Mike60Smart says the purpose of forms is to input data. My documents are very much alive, meaning the data is updated often. Reports are not produced frequently. I just work from the form so it...

Okay, yes right. So no need to sort by the StrataPlanNr, because it is the main form. 04_Infosheet_T.Services is what I meant to write. In the Infosheet subform on the Form the service (Plumber, Catch Basin, Landscaper ect) in not in alphabetical order but the kp_04_Infosheet_ID order. I have...

Thank you for providing this insight. I must read about parent and child properties as I see this is how you link the subform to the form. I cannot get the form to sort. I would like to sort the query based on StrataPlanNr Ascending, and then the Service from 82_Infosheet_T. I tried to sort the...

Yes, thanks it work. It has taken a while to implement as how did someone put it, "there is a spiderweb of relationships. I am cleaning this up as well. 30 minutes later. Interestingly, if I sort (order alphabetically) the subform using the filter feature it uses this sort result as the...

My apologies for that indeed. Do not doubt my appreciation for your generosity answering my question. But regardless, you are right I should acknowledge the reply no less.

Not sure why you say that. I am trying to reorganize my database and at the same time understand your advice, and the advice of others. I actually did what you suggested and think I had success but that was on a backup of the db. Now I need to redo this on the database proper. I go to work at...

Can you post the file so I can see what you did to the DB? Thanks

Okay thanks. Yes I understood the Join issue you explained. I will try your proposal tonight. I have to say I do not quite understand yet the concepts like you explain. I thought Queries were how you joined tables in Access.

The numbers allow me to organize the tables as I want. Otherwise the tables are organized alphabetically. My numbering has a logic. The strataplan is the root document. The other tables are levels down from the root. 02 through 08 is the next level - the documents these tables produce are all...

I have been struggling to produce the form 'Infosheet'. The business process: All stratas have a list of contractors that provide certain services. I have an Infosheet that conceptually should draw data from 01_StrataPlan_T (the StrataPlanNr), 30_Contractors_T (CompanyName), and 82_Services_T...

Thanks June 7. I understand LookUps are to be avoided. The issue is not the ediability of the data but producing a form that marries 4 tables. A strata is a building

A strataplan is a building I have 4 tables 1. Infosheet_T (Infosheet_T is a record of services provided for the strataplan by contractors) Field: kf_StrataPlan_ID, one to many relationship with kp_StrataPlan_ID : allows me to relate the infosheet with the strataplan record (this allows me to...

Thanks. Of course what ever I do will be on a copy. I am frustrated but not stupid. Well, not completely stupid.

I have made a lot of fundamental mistakes putting my first db together. I am trying to correct these and my thought is to delete my queries and rebuild the relationships. Is there a flaw in this idea.

They represent buildings I manage. This form represents a schedule of annual events. So when I visit this form I am always interested to review one building only, not every building I manage. It would be convenient to have a button that filters for kf_StrataPlan_ID = "a pre-determined StrataPlanNr"

So far in my attempt to build a database my search buttons execute code based on the content entered into an unbound text box. It would be much simpler in certain circumstances to have a button that selects all the records based on the string value of a field. You can see my thought in the...

Here is my db . I am trying to search the Quoting form accessed through the A Main Menu