Recent content by Stingone

Hi Everyone, I'm currently working on a new DB. It contains multiple data. One of the table's i have a called unit_rates. This tables contains 3 fields. - Customer - Function - Price Now i have another Table that describes 5000+ records of equipment containing multiple customers with...

Got it working :) using DMax... thanks for the support

max 8 users. In couple of months getting access to sharepoint to store the data. So yes you are right :) but for the time being.. i just created a dlookup works good but it pickes the oldest date instead of the newest.. so need to see if can change the script.. almost there.. :)

I'm a step ahead now. i created a database to store username and time they open the splash form. now i need to compare the username on open the from with the username in the table and get that date to compare. any ideas to do this lean?

Just created a txtbox on the splash with now() that passes the value to my form that contains the value from a query. The check works however i now ran into the issue that more people work in the same data base. so if someone opens the database and that person is the one that adds the records...

Ah ok get it. I use a splash screen where it loads the queries. So i should use that timestamp of opening the splash screen and compacte it to the date/time of the queries running after that.

I have 2 queries, the append is most important i use indeed a timestamp date() So you are saying add a txtbox in the form hide it. Then compare the timestamp date with the date of now()? dont get it fully.

Hi everyone, I'd like to know how to use conditional formatting on records that have been append and updates through a update and append query. What i would like to accomplish is make all append and updated records green so that people can see what has been added/updated. Regards Tony.

Hi all, I have incorperated a ActiveX progerss bar in my splashform when starting up my database. As i have all my tables on sharepoint it takes some time to load all data and run the queries. What i want to achieve is when starting the database the progressbar gets the values from the...

I tried the code below in the subform click event. Private Sub Form_Click() DoCmd.GoToRecord acDataForm, "Evenementen", acGoTo, Me.Form.CurrentRecord End Sub So when i now click on a record in the subform it goes to the associate record on the mainform for editing. However as soon i trie...

Many thanks hopefully you can find it

I now understand :) i just tried the split screen but with the split screen you dont get the same overview as with the subform. but i see if i can try some different setup's

I understand what you mean. Although i have the feeling that the subform works as it should be. See attached picture below. Currently the subform cannot control the main form. as you can see there are 2 records in the form associated with the BandID on the mainform. My goal was to click on...

Sorry, I just try to find a awnser on this forum. As i'm just a starter in Access i don't have all the knowledge as many of the people on this forum have. I created the subform through the wizard as i thought i should be worked. I created the subform just for the user so that i can see directly...

1. Evenement 2. SELECT Bands.[Band], Bands.BandID, Evenement.Dag, Evenement.Tijd, Locatie.Locatie, Locatie.Podium FROM Locatie INNER JOIN (Bands INNER JOIN Evenement ON Bands.[BandID] = Even 3. BandID I found some example of what i try to do. but doesnt work :( this is where they use employeeID...