Search results

Are there other data in the terminal or tag tables besides the names?

Easiest way is to add a command button to your form with the Wizard active, and then choose the appropriate options. The wizard will generate code for the button's click event that will print just the current record. Otherwise, you can modify the code for the existing button so that it filters...

Are you looking for all of the Null values associated with a given criterium, or are you trying to set values to Null?

You create a query based on your table, and add the fields you wish to work with. Then you specify a sort order for the weight field (ascending, light to heavy; descending, heavy to light). Next, you create a form based on said query. (You can also specify sorting criteria in the form, if you...

And hello to you. :)

Welcome to the forum. :)

Glad to have you here. :)

Welcome to the forum. Having a specific mission in mind is a great way to learn Access. :)

Erm, wrong place for the introduction, but welcome. :)

Glad to hear it. :)

Since you are insisting on keeping your tables separate, you can create a third table as the parent table for the customer ID, and join it in a 1-to-1 relationship with each of your two customer tables.

When I work with complex lines of code and concatenations, I like to paste them in Word and highlight the pieces with different colours to help see what is there. :)

Still fun to play, but GW2 seems to be drawing away a lot of players... for now. They'll be back. They always come back. ;)

It sounds like a behavior issue. When you Tab or Enter from the last field in the form, the cursor is moving to the first field in the next record, forcing the Update related events. You want to change the behavior of Tab and Enter so that the current record stays current. You can set the...

I am happy it worked for you, but it occurred to me that it will not work for the overnight shift. You will need to go the other way and append the date component to your constants. Otherwise, the shift that spans midnight could have an end time less than the start time. Option Compare...

It sounds like a feature of Access designed to protect referential integrity has guided you to a better form design. Good work. :)

Here is the code I used: Option Compare Database Option Explicit Public Function NStime(InTime As Date, OutTime As Date) As Date Dim ShiftStart As Date, ShiftEnd As Date, ret As Date Dim datIn As Date, datOut As Date 'Isolate time component of arguments datIn = TimeSerial(Hour(InTime)...

You are including the date with the time in your arguments, but you are only setting a time in your constants. You could isolate the time component of your arguments into temporary variables, since the date part is not used for this function.

I believe you will need to create a function in VBA that counts the number of days between the given date and the current date where Weekday(idatDate) is not equal to 1 or 7. This will omit the weekend, assuming your first day of the week is Sunday. Your function should loop through each date...

It sound like a standard First In, First Out (FIFO) model. Your order details will provide the value of the items you have purchased, but this is just half of the solution. You will also need details for the items that are removed from inventory (used, lost, thrown away), and have those items'...