Not sure what error this is (1 Viewer)

[asteropi]

Note: If you compile, you'll find a bunch of problems in other parts of your code, try to solve those too. You can also redo the form making sure no controls have those "foreign" (to Access) characters.

I tried compiling and it asks me to put a bunch of brackets on some names. But the database works fine as it is now and I'm afraid I'm gonna screw it up completely if I do. Why does it do that if it works fine?

 

[CarlettoFed]

First make a copy of the current file.
On the current file you only have to comment the line where the error is highlighted by placing a quote (apostrophe) at the beginning of it.
In the case of errors in an If loop you have to comment all the lines of the same from If to End If.

 

[Edgar_]

I tried compiling and it asks me to put a bunch of brackets on some names. But the database works fine as it is now and I'm afraid I'm gonna screw it up completely if I do. Why does it do that if it works fine?

I did not get any message asking me to place brackets around any names after attempting to compile. Instead, it encountered issues related to missing objects and a procedure where you attempted to set a method as the value of a control.

The database appears to be functioning fine as is because none of those procedures are being triggered. It seems that the controls associated with them have been renamed or removed. However, the compiler detects that the referenced controls no longer exist and highlights this issue. If you don’t resolve this, the compiler won’t be able to help you identify other problems. The compiler is important, let it find issues and you will have a better development experience.

 

[Gasman]

Is this what you are talking about.
This comes up after I pressed that Add button your circled.

DEbug leads to

If I select an entry in the Supply combo and then press Add I get

and

Unable to compile as it states Me.Customer does not exist.

and when I Cancel the debug and get back to the form I get

 

[asteropi]

Is this what you are talking about.
This comes up after I pressed that Add button your circled.
View attachment 116551

DEbug leads to
View attachment 116552

No it highlights the SupplyName for me and then it says it can't find LotNumber in table with LotNumberID

 

[asteropi]

I wanted to change the file but I accidentally deleted the whole reply

so I have a new error and I don't now what it is.

If I press Add, it takes the supply info (SupplyT), supplier info (SupplierT) but it won't find the Lot Number and it gets stuck.

 

[Gasman]

Is that the last image in my reply?

 

[asteropi]

Is that the last image in my reply?

yes indeed

 

[asteropi]

Unable to compile as it states Me.Customer does not exist.
View attachment 116557

I deleted that. I had accidentally left it there

 

[asteropi]

I don't know how to change the form name to compile this part

 

[Gasman]

You have more issue than that.
The query for your subform is read only.

That is why I get 'Field cannot be updated'
None of those fields can be updated.

 

[asteropi]

You have more issue than that.
The query for your subform is read only.

That is why I get 'Field cannot be updated'
None of those fields can be updated.

I don't know what you mean or how to fix that

 

[Gasman]

I am out, as I do not know where that code is.
The labels are all in Greek, so PurchaseSum means nothing to me, unless I have to go search for each individual control in each form.

If that control value is on the subform, then your would use Me.Parent.control =
If that control value is on the mainform then look at the syntax here.

Forms: Refer to Form and Subform properties and controls

 

[Gasman]

I don't know what you mean or how to fix that

Well the source for that subform is read only, so you cannot set any value in that query.
Try it yourself, in just the query output for the form itself.

 

[asteropi]

The labels are all in Greek, so PurchaseSum means nothing to me, unless I have to go search for each individual control in each form.

That was also a leftover which I deleted now.

Well the source for that subform is read only, so you cannot set any value in that query.
Try it yourself, in just the query output for the form itself.

I also allowed the data entry but I still get the same error as before

I fixed all the controls and deleted any leftover commands that didn't make sense and compiled the database

 

[asteropi]

Ok I fixed this problem but now there is another one

Even though it takes all the data I input, if I close and reopen the form, the Batch Details don't show, even though they are saved in the table

 

[The_Doc_Man]

Just for clarification of the original question, regarding this error

"Microsoft Access can't find the field '|1' referred to in your expression"

This occurs when a query has an error in the first field requested in a SELECT clause.

In your case, you had a domain aggregate function similar to DLookup( [fieldname], [tablename], "criteria clause" ) for which you had not enclosed the field and table names in quotes as the function requires.

What Access does with domain aggregates is that it synthesizes an SQL statement based on the input function parameters defining the field, table, and criteria. But these functions required quoted strings for the three arguments. What happened here is that the [fieldname] parameter SHOULD have been "[fieldname]" but instead, the function tried to look up whatever was in the field whose name was in [fieldname] - which might even have been null at the time. That field would have been the first field in the synthesized query, and therefore when it failed, it was referenced as "|1", i.e. the first field. You CAN see errors like this with "|2" sometimes, though not from domain aggregate functions. Sometimes when I was dynamically building an SQL query I would see this error (with other than |1) if my concatenation was incorrect when I tried to build that string.

 

[Gasman]

If you set Data Entry to Yes, you can only add records.

Worst named property in Access.

 

[asteropi]

If you set Data Entry to Yes, you can only add records.

Worst named property in Access.

Fixed thank you

 

[gemma-the-husky]

You need to change the line

Price = Nz(DLookup([Price], [OrderDetailsQ], "ProductDetailsID=" & Me.ProductCmb), 0)

in the following

Price = Nz(DLookup("[Price]", "[OrderDetailsQ]", "ProductDetailsID=" & Me.ProductCmb), 0)

I'm not sure but you might also need spaces before and after the equals sign in these expressions. I probably add spaces in SQL expressions where I don't need them, but I know for sure there are some places where you do need to have them.