Search results

Finally!!! Luckily, the Yas Marina Circuit is just a 45 min drive away for me and I've been scrutineering for the past two years! So I get to watch in the teams garage while I supervise their work on the cars :) Here are the pictures I took in 2010...

Assume you have a monthly inflation rate of 1%. You started with 1,000 in the first month. Then your payment after 5 months would be 1,000 * (1.01) ^ 5 How do you plan on using this information in your database though?

Even if you do loop, you would need a really slow processor from the 80's to show a difference in the time values :)

Yes, you can use VBA code in a module like this Sub SQLadd() Dim strSQL as string strSQL = "INSERT INTO ..." 'insert your SQL statement here as you have done above CurrentDB.execute strSQL End Sub Note that numbers don't require quotes, strings require single quotes and dates require hash (#)...

Instead of locking every control on the form, try me.allowedits = false This will ban users from editing records in the form.

Try: DoCmd.RunCommand acCmdBringToFront

And that is why you should have a front-end / back-end environment. The back-end database(s) store(s) all the data, the front-end is sort of like the hot receptionist that's smiling all the time. The front-end is linked to all the tables you'd need behind the scenes.

1) You will a need a Permissions Table, that's where you store user permissions by username. 2) You can get the current username using the following: Environ("Username") 3) You will need to use the dlookup() function to lookup what permissions the current user has from the user permissions...

You can use Shell command to open another database. I would do it all in one DB though and have add/edit/delete privileges linked the logged in user.

One way of doing it would be to use DAO to lookup the most recent record for ClientA in your archive. I made up names for your tables & fields for demonstration, change them to your own. Dim rs1 as DAO.recordset set rs1 = currentdb.openrecordset("Select * from ClientsArchive where client='" &...

Aaah the good old days of Material Science and Alloys. Your structure should look this: Let me know if I got it wrong

How do you choose which records go from Archive to Original table? Do you have a timestamp on your records?

Ok I get the picture now, not sure you can join tables on expressions however I found a way around it. Let me know if it does the trick for you:

Glad I could help :) Cheers, Sam

Try changing: [TransactionDate] between #01/01/2012# and #31/01/2012# To Month([TransactionDate]) = 1 Then you can have that 1 programmed later on by linking it to a combo etc..

And can these values be changed and permanently stored easily in runtime? Every DB I build has a table just for tiny bits of data like this. Makes life a lot easier.

You're basically asking Access to count the records, if they're equal to zero (aka no records) then hide the subform.

Can you upload what you have done so far? What you're trying to do maybe easier with VBA

Tell you what, share the Excel sheet and I might come up with something along its lines.

If you want that value to be editable, it's better store the value in a table and have it looked up on form's Before Insert event.