Search results

hi, i have an access database published to sharepoint and i have a datasheet form sorted (on Load) by a checkbox and a date. the setorderby macro uses planned,startdate desc as the arguments. It works as expected on my local machine but when i look at the web version , it only sorts by...

hi, i am pretty new to access and very new to access services. i have two tables and2 forms. one subform is called by the first on a checkbox condition. i am trying to populate a combobox with the value from the parent forms textbox. When it runs the macro on the afterupdate property, i get an...

hello, i have a 2010 db and i created a simple form with the wizard. i added a combobox to the form because i wanted some data from the same table to populate. i want to change the combobox to a textbox. when i try to delete or change it, i get an error and access restarts. the db is very simple...

i have a split form (access 2007) that takes in new information on top and has related historical data on the datasheet part on bottom. i would like to print a report based on the new information added - just one sheet with one record - that will be used to write notes on by a maintenance crew...

i have 2 tables that share a one to one relationship. the problem is that when i enter the data into a form, i get an "unable to add or change data in table1 because of related data in table2. it seems there is a "must have" relationship between the 2 tables, when i really need a "may have"...

i have 2 tables that share a one to one relationship. the problem is that when i enter the data into a form, i get an "unable to add or change data in table1 because of related data in table2. it seems there is a "must have" relationship between the 2 tables, when i really need a "may have"...

I created a lookup field to view data other than what was queried. how do i delete this? it is more trouble than it is worth? when i view my tables, they have combo boxes where there used to be just text. renaming it didnt help. thanks

i have a form that has 2 comboboxes. one is for a contractor name and the other is for employee name. how do get the values for the employee to update whenever i change the contractor name combobox? the contractor to employee relationship is one to many. the form uses the contractor table to...

i am creating a report using a query and some of the data is null. i have a start date and end date. some of the end date fields are null. what i would like to do is use a condition to print the start date in place of the end date if the end date is null(the start date and end date are...