Search results

I took the liberty of creating an example, to work with it extract the files and open the MembersManagement.accdb file

strSQL = "UPDATE tblCurentPastYears SET DateFrom = #1/1/" & Me.txtY & " # WHERE DateFrom is Null;" if in the txtY control it says 2026 otherwise use strSQL = "UPDATE tblCurentPastYears SET DateFrom = #1/1/" & Year(Date()) & "# WHERE DateFrom is Null;"

If you can attach a sample file, to also check the database structure, it would be much easier to understand and help you.

In fact, if you read, I said it's another kind of solution.

This could be another kind of solution. However the database structure has many things that need to be improved: Normalizationcorrect management of field Properties (Required and Indexed in particular) Indexes to prevent creating duplicates etc...

You have to compact it first and then compress it. If it remains too large you have to post the compressed file on a data sharing site, such as FileTransfer.

Possibly with different Sports, Categories and Sub-Categories.

Attach the file with about ten articles and the related images separately.I'll show you how it can be done.

To make a judgment first you should see a file that you have recently made. Often we care more about aesthetics than content and this is serious.

In one or more tables you use Descrition as the field name which is a reserved word, you must change it.

For more concrete help, it is necessary to have examples of both Excel and Access files available.

When you create the supplier you have to say if the lot should be automatic or manual, once you do this you block or not the txtLotNumber control depending on your choice.

Try this update. The fact remains that the database is quite poorly made, suffice it to say that in the LotNumberF mask by not inserting the date or inserting a date after today's the record is still saved, etc...

Maybe if you attach a sample file, as always, it will be easier to help you.

It would be easier and quicker to have an example file where you can see directly what you have created.

You should attach a sample file to actually see what you have achieved and give a judgement.

I took the liberty of making some changes to the orderF and OderDetailF forms.

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.

Read here https://support.microsoft.com/en-us/office/dlookup-function-8896cb03-e31f-45d1-86db-bed10dca5937

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)