Forms - Forms help

How do you delete a page header that was created accidentally.

How do I get the "new record" button on the ribbon to light up so I can us it?

(Yes, I am new)

Thanks for your help.

In design view right click on the page header, click Page Header/Footer - this a toggle item.

To allow NewRecord, form's AllowAdditions property must be set to Yes and DataEntry property to No.

The Page Header/Footer toggle works, thanks.

The AllowAdditions, Deletions, Edits, Filters were all Yes originally and DataEntry was No originally, so no this wasn't the problem. What else could it be?

Thanks for your help.

I haven't given this item on the ribbon much attention. I have the ribbon disabled for my users and handle adding records with command button coding. I only tested what makes it disabled after I read your post and found that altering those property settings for one of my working forms affected that item. Only other thing I think might be cause is if the form recordset is not editable to the point can't even add record, but that is wild speculation.

If you want to upload your project to a file share site such Box.net and post link here, I will look at. (Can't attach files here until member 30 days)

I am trying to create a db to replace my current Lotus Approach db because I think that one day MS will not allow Lotus to be installed on a PC. In any case, I have looked at the Northwind template and cannot figure out the New Customer Order button and cannot recreate it in my db.

I bought a book Step by Step for Access 2007 and while it tells how to do some things it is very lacking. For instance, it doesn't have any explanation of the macro commands, so when I looked up the commands I was surprised that there wasn't a "new" macro command. Don't know VBA either.

Any suggestions?

I don't use macros, only VBA. Worth your while to learn VBA and SQL commands. Get a reference that integrates VBA programming with Access objects. Not hard to learn. If you have to, pay a consultant (which we did for me) to help get you started. Just depends on how quick you want this project functional and how much to spend. We took 4 years and about $150,000 in consultant fees and employee time to build an app to replace 20-year old dBaseIV. Would have cost lot more if totally contracted. Last 2 years programming this db was my life. I had to learn on-the-job from consultant and reference materials and just perusing the partially built project I inherited. I did already know programming concepts so that helped with learning curve.

I think that Northwind uses a lot of embedded macros which I find annoying to try and debug. Hard to debug here without code to analyze. Again, if you want to make your project available, I will look at.

I would appreciate any help I can get and will post it to Box.net later today. It is VERY RAW (as am I).

I will reply to this forum when it is posted.

Thanks for any help you can give me.

June7, I have posted the db on box.net. How should I get you the link?

Paste the link to the uploaded file in a post here. If site doesn't like it, leave off the http from the string. I will copy/paste the link into my browser.

http://www.box.net/signup/collablink/d_33993728/77fa373a5991b

I started a review of your project. Problem with SalesOrder form is that its RecordSource query is not editable. I found duplicate Customer IDs in the Customer table. As soon as I eliminated them, the form recordset is editable. In Customer table make the CustomerID a primary key to prevent duplication, cannot have blank fields in primary key so will have to fix that.

This works, thanks. Anything else you can add?

Happy to have helped.

Might want primary key in LineItem and Catalog tables also. Data normalization looks good. Reimphazise learning VBA and SQL. Switchboard form and table must have been built by the wizard. Except for a couple of the query wizards, I don't use the wizards. You have left text fields at the default 255 size. Don't know if this impacts performance much but might want to set size to just what is requred for the data. I prefer the Overlapping Windows setup instead of Tabbed Documents. Have you checked out the project property settings? Click: Office Button > Access Options > Current Database

Good Luck!

Why can't I add the field CatalogNumber in the table Catalog to the Sales Order form? Here are my current relationships:

Customer.CustomerNumber (key) to SalesOrder.CustomerNumber (SalesOrderNumber is key)
SalesOrder.SalesOrderNumber (key) to LineItem.SalesOrderNumber
LineItem.CatalogID to Catalog.CatalogID (key)
Catalog.CatalogID (key) to Assemblies.CatalogID

Thanks for your help.