Search results

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...

I understand but. I have on my mainform BandID/Podia/Day/Time. As soon i have filled in all those options it shows on my subform for that BandID the podia/day/time. So when im at the 6e record i directly can see what podia/day/time have already been used. So on my main form i use the record...

When i click on a record in my subform is does not go to that record in my main form. I have a big query in my main form with comboboxes. So what i simply want when clicking on a record in the subform it sets that record in the main form for editing.

Hi all, i have a form and subform. The subform is connected to the form and display all BandID's associated with that record. What i want is the ability to click on a record in the subform so that it automaticly set's that record in the form for editing.

Found it :) http://access.mvps.org/access/forms/frm0012.htm

Hi all, Im almost done with a littel project in Access. Only thing left is a combobox (dropdown) with predefined values. What i want is, as soon you have picked a value from the combobox, save the record and go to the new blank record, the last picked value of that combobox auto appears in the...