Search results

i am trying to execute a query that sums two fields in a table of quarterly data. field one: the sum of all 4 quarters for [employees that left that quarter] for a particular year. so i need to sum this field for all 4 quarters. field two: the sum of [total employees] that are only in quarter...

data entry is set to 'no'. every time a record is selected, Access creates a new record. so even when a try to delete a record, every other time deletion is attempted then a record is created. any ideas??

i have made a form called Employee Data which is mainly for calculations of number values. when i open the form, it seems that a record is automatically created. in my other forms, the records start at "0" even though it says record 1 of 1. In the other forms i can press a new record button and...

When i press a button on one form, i want to set the focus on the field of another form. i am using vba and i thought this would work, Private Sub Job_Find_Click() Form_Clients_Information.Jobs_Created.SetFocus End Sub but i am getting: runtime error 424 Object Required. the current form is...

the reason i did not want to use subforms is because the clients information form (the parent form) is based around clients and if i were to use subforms they would revolve around clients too (like my counseling session subform). i would like the workshop forms to revolve around the workshops...

is there any way to link forms without declaring subforms? i have a form called clients information and a subform within that called counseling session. i also have a form called workshop and a subform within that called workshop attendees. there is a field on the counseling session subform...

I am trying to validate a field located on one of my subforms using the Beforeupdate property with Visual Basic. The field is called session number and it represents the current session number of each client. Because the field is based on a couple of important queries, i need to validate it as...

what i currently have is a listbox that counselors can choose their session number from. the session number is part of a table called counseling session and each client (which is from a table called clients) is connected to counseling session table via client id. i copied and pasted your code...

I am trying to validate a field located on one of my subforms using the Beforeupdate property with Visual Basic. The field is called session number and it represents the current session number of each client. Because the field is based on a couple of important queries, i need to validate it as...

ok. that makes sense. so i shouldn't use afterupdate at all? should i build a macro in the beforeupdate event?

do i use these functions in the 'validation rule' part of the table?

I am trying to create a validation rule for a field called session number. I want to make it so a duplicate session number is not able to be selected on my form. I am trying to create the proper validation rule for this by linking it to another field called session date. i would like to do...

thank you very much. this works.

would you be able assign a specific field with that expression then?

if i put the line, =DateDiff("d" ,[FirstDateFieldNameHere,[SecondDateFieldNameHere]) in the criteria segment of the field that i want to calculate the difference of the two dates, i get an error message that says i have too many arguments. should i be putting that line somewhere else?

the two date fields are from 2 different tables. would it be possible to do this in a query?

How do i subtract 2 dates in Access? I want the value of one field to be the difference of two different fields. these two fields are dates. i would like to display the calculated field as the number of days that have passed between the two dates. thanks ameen

I am trying to add the option "Merge With Microsoft Word" in the toolbox of a report. However, after i add this option, i cannot access it (it remains still when i point the mouse over it). When i add the option "Publish with Microsoft Word" it works fine, however i cannot print labels or do a...

ok yes. i needed to change my primary key to a number. thanks for the tip. peace. ameen

when i try to view the datasheet view the query i am getting problems. i used the query wizard and the last step asks me to open the query in design view or datasheet view. when i choose datasheet it says "The wizard is unable to open the query in datasheet view, possibly because another user...