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

hi, i have a similar situation (Problem). i have created a database based on the projects web database template. the web template has a button to select tasks within a project. its basically a sort feature. i was wondering how to do this going "up" two levels. i have project - subproject -...

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

the db models a process that evolves. one table is an assembly that eventually becomes table 2. each assembly must be installed on 1 machine. 1 machine can have only one assembly.

boblarson, i'm not sure i understand your question. the primary key on the parent table is the foreign key on the other. there is nothing linked to the primary key on the child table, if thats what your asking.

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 used macrobuilder to refresh the current record on the onChange field. is that overkill? it there a standard convention reguarding macro utilization as it pertains to where and when? it looks like it does the same thing as you all are suggesting. i will look at the sql code as soon as i can...

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

here is what worked =IIf(IsNull([Reaming_Date_End]),[Reaming_Date_Start],[Reaming_Date_End]) if original field is null then use another field, if not use original field. couldnt get nz to work but its probably a format/syntax issue) thanks again.

son of a .................it would help if the data type in the table was date instead of text. thanks for your patience.

my textboxes are prefixed txbx_ using the query variables i get a #Type! error. =Nz([Reaming_Date_End],[Reaming_Date_Start]) this looks like it should have worked. since the query variables are bounded to the report

since the report gets its info from a query, i tried the nz expression with the fully qualified name as well [query]![fieldName] but that didnt work either. i'll keep at it. thanks

i end up with #Size! in the field.

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