Search results

And what if the item has not been purchased before?

Try DoCmd.RunSQL "Update tbl-fe_version SET tbl-fe_version.fe_version_number = #" & Format(DueDate, 'mm/dd/yyyy') & "# WHERE (((tbl-fe_version.ID)=1))"

Crossposted here https://learn.microsoft.com/en-us/answers/questions/1364160/have-written-the-code-but-elseif-statement-is-not

1- I want to create relationships between tables Go ahead. Make sure data types are the same in related tables. 2- I want to create a form for the material card I don't see a table named liked that. If you mean items card, again: go ahead. 3- I want to create a sales invoice I don't see a...

Why do you want to use a report to open a form? Reports are for printing. Use a continuous form with a button to open a detail form.

It is easy to add a WHERE clause to your SELECT statement. INSERT INTO tblProductsTemp ( ProductID, ProductName, Type ) SELECT tblProducts.ProductID, tblProducts.ProductName, tblProducts.Type FROM tblProducts WHERE tblProducts.ProductID NOT IN (SELECT tblProductsTemp.ProductID FROM...

I don't think that will help. The user might not want to change the last one, but the one before.

And what if both are selected and the user wants to change one of the locations?

Welcome to the forum. That's an impressive amount of tables. We don't see that often here. I don't want to be negative right away, but such a large amount can also indicate a not quite right design. Anyway, you've made me very curious. Can you tell us more about the database?

And to combine the answers of The_Doc_Man and Pat: use the DateAdd function in the query to calculate the dates.

Because the five dates can be derived from the first date, it is not necessary to store them. If you want to show the dates you can calculate based on the first date.

You should certainly not store the data you mention in one table. Moreover, what you show is probably not the whole story. There are probably more subjects than English and I think you want to record the results of students. So start with a good database design with tables like: - subject -...

Remove the quotationmarks around PolicyNumber.

You previously posted your question on another forum (https://answers.microsoft.com/en-us/msoffice/forum/all/syncdelivery-problems-multiple-users-editing-the/cfb989fa-5dfe-44c0-8c62-0b8b7bf78409). You got a lot of responses there. You didn't even reply to the last one. It is inappropriate not to...

There is a neat way and a less neat way. To start with the latter, sort by: Right([fld_Smst],4), IIf(Left([fld_Smst],1)="S",1,IIf(Left([fld_Smst],1)="F",2,3)) A neater way requires a bit more work. Split the field into two: year and semester. Create a table in which you store the permitted...

Sorry, I did not see that. The problem is you are also grouping by RevNotes. The values are different for the reviews, so you get the max for "Construction issue" and the max for "Section D revised".

I do no understand your problem / data. There are 16 unique drawings and each drawing has ONE stored revision. So using MAX will have no effect.

The DLookup will return the value of er serial number. If .... Then expects an expression that is True or False where the .... are. I think that is why you get a type mismatch.

Create an aggregate query. Look here for more info.

Is there only one record in tblAgentEmailDefaults? In that case simply use: DLookup("MsgBody", "tblAgentEmailDefaults") If not, you need to add a condition.