Search results

I was trying to keep it all on one report. I'm logging draft #'s to documents, and some of them are reaching the limit of how many drafts were provisioned for, so I'm trying to avoid adding another report for a few extra draft #'s when only a few of the recordsets need it.

That is all correct. But even if i don't add a text box, but just adjust the location of a field already in the myform, it will not allow me to save it that way. Its like theres a restriction on altering myform's properties.

I'm trying to add text boxes to add data onto a form, but even if i just move a previous text box, it won't allow me to save changes to the form.

I have access 2013 windows7 , I'm making additions to a database someone else made, and there is a form i need to add some fields to, but it won't let me save any changes. every time i try to save it doesn't do anything and when i try to close it it asks me if i want to save changes (yes) but it...

I have access 2013 windows 7, I'm trying to expand the record keeping on a database someone else designed. I've added the fields i need to the Recordsource(s) (the table, query, and working on the form as well) I can't make the report any larger it seems (its currently at 22") and i need to add...

Genius! That was it! I'll take this as a lesson to be thoroughly meticulous in the future... Thank you so much for your time!

Like this... still Expr1001

here is the sql

i moved it, and now it says Expr1001, should i try remaking the field in the Table, and then try all this again in the query?

how do i do that? i am unfamiliar with the clause.

same happens after i've removed both and tried just from the layout view. there are no relationships directly to that field, i don't know what else could be confusing it.

When i initially changed it in SQL, i had the Expr... problem, so then i tried from the layout view, and got another Expr..., having now removed one it still gives me the Expr...

BookDetailsTable.Edition doesn't appear as "Edition" in the datasheet view. i added the highlighted sql, and the reason there are 2 "BookDetailsTable.Edition" is from trying to add one throught the layout view afterwards.

SELECT BookDetailsTable.BookTitle, BookDetailsTable.AuthorID, BookDetailsTable.FormatID, BookDetailsTable.Edition, BookDetailsTable.Edition, BookDetailsTable.DateOfEditionRelease, BookDetailsTable.Impression, BookDetailsTable.DateOfImpression, BookDetailsTable.PrinterCompanyID...

I have windows 7 access 2013, i had a query made, and wanted to add fields to it, so i went into the SQL and added several fields. Only the first one i entered didn't work and on the query is called "Expr1003" when in datasheet view. Its right in layout view, and even when i tried adding the...

It still wasn't working when i would place the Field name there either, so i re-made the field in the report and now it works! Thank you so much!

I'm sorry, Command20 is the command button i created to execute this action/open the report

The field in the table is called BookTitle As is apparent I know absolutely nill about coding

It is a text field, I get a "compile error Expect end of statement" window, and its highlighting my command in the square brackets. DoCmd.OpenReport "BookDetailsReport", acViewPreview, ,"[BookTitle]='" & Me! [Command20] & "'"

Windows 7 OS Access 2013 I posted this question in the Macro discussion area, but perhaps it is more appropriate here: I have a report that gives me an overview of my records, and i have built a report that gives me the desired details. I have created a button that will open the details...