Search results

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.

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.