Recent content by CarlettoFed

The routine "Public Sub UpdateStocks" does not exist within the file you linked.

The cost of each beer type is used to determine if I've accumulated enough to drink it. For example:I have two types of beer: - Beer 1 costs $10 - Beer 2 costs $15 let's say drinking one beer creates a $4 bonus, and so far I've drunk 3 beers, so I've accumulated a $12 bonus. If I now want to...

To evaluate a project, you should know, in detail, what you would like it to do and then see directly the structure you have created, so at least an example file.

Do the beers: - entitle you to the same loyalty amount? - are they all the same price? this information is used to determine if you're entitled to free drinks and how much.

Please try attaching a sample file.

Tax: IIf([tblEmployees].[Basic Salary] Between 0 And 12760;[tblEmployees].[Basic Salary]/[tblEmployees].[Salary Pay Period];IIf([tblEmployees]![Basic Salary] Between 12760 And 25520;([tblEmployees].[Basic Salary]-[tblpayrolltaxes]![Lower])/[tblEmployees].[Salary Pay...

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.