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

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

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.

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

Hi all, I have a form with a subform. As soon i add a new record i like to requery the subform listing the current ID of the form. When i now requery the subform, the subform jumps back to the first record instead of display the current record of the form. how can i resolve this?

Hi all, I have created an custom error message on my form. When i fillin all the fields and hit enter i get the custom error message when filling in duplicates. however i also have 2 arrows for the record selection. When i fillin all the fields and instead of hitting enter go to the next...

Hi all, I have created a combox based upon a query. 1 combobox with days of the week 1 combobox with times refering to the days. This works all fine and as soon i click on a day i get the list of associated times. BUT what i want is.. as soon i have picked a day with a time and populate it...

Hi everyone. I have created a access file that includes the following Name of the music band playing Place where the band is playing Timeslot how many hours Priority What i like to do is based upon the data above, create a Macro that will automaticaly fills in the data into a calender bassed...