Recent content by trixxnixon

i have to introduce a new field now, but i need it to calculate based on a condition being true. the new field is Sumofdays. the calculation should not calculate if sumofdays here is my logic. but i know this syntax is way off. if isnull(sumofdays)=true then DIH =Workingdays2(DateValue([Date...

i have the same problem, but when i put in the me!fieldname = "", it crashes the program, saying the field can not be a zero length... whats up with that?

so this is where i am at so far, i have been able to use the dlookup to look up the specific record number, how would i be able to get the form to either open up that specific record number, or if there is no matching record, have the form create a new record?

i just got to work, so i am going to try it right now. i will let you know as soon as i get it all in.

Correct, this is exactly what i am trying to do.

i want to set up the form in the picture so that only one pending record can be open at one time. the way to do this is to have the form search the query results for the record that has "yes" selected. i have a query that returns the only record that is marked as "yes", but the form will not...

i have a form that is being designed to pend requests in a requests database. the pend form is opened from an update form used by an employee to enter updates. when the pend form is updated, the tracking number of the current request is imported to the pend form, and query results are displayed...

i figured that the database i am updating does not require the corresponding drop down menus as each request type has its own form......... the bad part about this database, is everything is contained in 1 table... over 100 different fields, all the forms update the same table, all i really...

Hi all, I have been handed a new project that required me to update a database... a rather complicated database. I take that back, its not that it is super complicated, I am just a novice user and not a programmer. The biggest change that I have to make is to create a form with a...

Hi all, I have been handed a new project that required me to update a database... a rather complicated database. I take that back, its not that it is super complicated, I am just a novice user and not a programmer. The biggest change that I have to make is to create a form with a...