Search results

Pls help. I am trying to find a way to get the code similar to last() function in access. I got a table recording prices of different items (autonumber, item name, item price) and need some thing to get the last price for each item. All I can do now is to build a 2 steps: 1- Get Max...

It sometime happen when you have form name the same with table name. In the design windows of subform you will see it says "table.tablename", make sure that it is written"form.someformname"

Hi June 90, You can do below: Create a table logcount with: ************ id: autonumber userid: text login time: date/time, default value = now() ************ Paste the below code to replace your current update login time code. ************ Dim mysql As String mysql = "INSERT INTO logcount...

Thanks for your help.

Hi Guys, Pls help with the below: Combo 1: Order type Combo 2: Customer name I would like user to choose order type from Combo 1 and in Combo 2 they can choose the Customer groups belong to order type choosen in Combo 1. I already try this but not work ************ Dim myrow as string if...

if your combo data source come from a table, I suggested you add a field in that table that store "form name", so the task is very simple: docmd.openform me.myformnamecombo ,.....

2 ways: you add a code to insert the username and time (getdate() or now()) to the log in tracking table. you set defaut value of "login time" field in tracking table to getdate() and just create a code to insert username