Edit My data

[Infinite]

Hello there, once you download the ledger, you can see the form frmMenu, once you click on it your given a list of shows. Double click on those and you can edit the show, add date, cost, etc, etc. At least, thats what I want. I can get it to allow me to edit the information like Event type, Start Date, End date, State, and many others I couldn't include due to size. So, after looking at it, does any one know how to fix/do it? It cant be just a one time fix, like you upload it and its fixed for that, I need to know how to do this, and I need to use it on others. Thanks for your time!

 

[pbaldy]

If you mean frmEvents, it's based on a query that is read only:

http://allenbrowne.com/ser-61.html

You're also getting a Cartesian product with that query; is that on purpose?

 

[Infinite]

OK, first, how do I make it not a ready only? And 2nd, what is a Cartesian, and if its not good, how do I get rid of it?

 

[pbaldy]

Did you read the link? Does the query return the expected data? Your events table has 10 events in it, the query returns 100 records. Is that what you want/expect?

 

[Infinite]

I know that, but, I want to know how to edit the information in the events form. The query gives me what I want, I just want to know how to edit that information.

FYI here is the SQL code for the query

SELECT tblEvents.*, tblShowTypes.ShowTypeID
FROM tblEvents, tblShowTypes;

 

[pbaldy]

You can not edit the data in a query that has multiple tables in the FROM clause that don't have a join between them. If you want to edit an event, limit the query to the events table.

 

[Infinite]

Ok, how would I do that?

 

[pbaldy]

Delete the other table, or just change the record source of the form to the events table.

 

[Infinite]

Yes, but the table events doesnt include things like Home away, Inside Outside, Gross sales (added in later) stuff like that. Or, do I just forever have it keep referencing back to the table events, and getting home away from the qryEvents?

 

[pbaldy]

How do they relate to events? If those other tables are lookup values, perhaps there should be a field for each in the events table. On a form, you'd have a combo bound to that field but getting its selections from the lookup table.

 

[Infinite]

Ok, how would you do? And, can you just do it with the database I posted, and upload so I can see what you would do?

 

[RainLover]

 DoCmd.RunCommand acCmdSaveRecord

Instead of using the DoCmd simply use

 Me.Dirty = False

It would be good if you established the Relationships in the Relationship Window.

This displays an overall Blue Print of your design.
You could also print that out and pin it to the wall as a reminder to yourself where you intend going with all this.

I don't know what others think about this but I would not be using Macros. I would use VBA instead. VBA allows you to do bigger and better things while at the same time it is not difficult to learn the Basics.

Suggest you also fix the various things that do not work. I noticed that none of the Combo's work on frmEvents.

Just to help a little. I created a Combo Box using the wizard. This is in the Form frmEvents. I did not change anything the wizard did. All I did was to answer the questions.

To do this simply insert a Combo from the Tools Toolbar.

Why are you closing people out of your forms. Namely there is no Close, Restore or Minimise Buttons. Save this until you have the database at least partly working. You are just making thing unnecessarily difficult to navigate around.

The attachment may help you with the Naming of your objects.
The other attachment has the example of a working Combo Box.

Good luck with all that.

 

[Infinite]

Another thing I would like to know. With the information from my data base I uploaded, how would I get show totals to the show info on frmMenu? or frmEvents?

 

[Infinite]

And, hey look, I still dont get how to make it so I can edit my data with my database....

 

[RainLover]

And, hey look, I still dont get how to make it so I can edit my data with my database....

Would it not be best to fix what you have, which may fix a lot of your problems, before moving on to something else.

For me to answer your question I would have to do what I am asking you to do. That is fix all those little problems like Relationships.

How do you feel about that idea.

 

[Infinite]

I have no idea what your talking about.

 

[RainLover]

Is there a question that goes along with that.

 

[Infinite]

Sorry rain, just was busy, I have the whole editing my data done, fixed most of my relation ships like you said, sorry for being such a jerk about your answers, I know your just trying to help. What you said did help a lot. Thanks you very much!