Forms

Date minus date in working days?
Hallo, Is it possible to manipulate the outcome of a data substraction with workingdays? E.g. 30-01-2005 (=date()) minus 20-01-2005 (=fldDate) is 10 days. Between 30-01-2005 and 20-01-2005 is a weekend (saterday/sunday). So the outcome should be 8. Can the outcome of 8 be generated through code? Thanx... 16 Feb 2005 18:31

The ACOS function
Does MS Access provides the ACOS function (also called arccosine), where it returns the angle, in radians, whose cosine is the given float expression? If not, how can I create one? ... 15 Feb 2005 14:41

Repost - Hyperlinks and RunTime Errors
Good morning, I am working on a budgeting tool that saves (in Excel) a file to my network. The filename and the entire path are stored in my tblProject table. I want to be able to use the application (form) to call up the Project. The full path looks something like this: v:\distcntr\dcdesign\projmgmt\capital0... 17 Feb 2005 08:00

Tracking Log In and Log Out Times of Users
I need to tracking log in and log out time of users. My approach is to set up Public variable that store the [UserId], [LogDate],[LogInTime] at the time of intial log in. Add store the [LogOutTime] info at logoff time How can I append this info to another table call "tblLogInTracking". Do I use reecords... 25 Feb 2005 18:56

Fill fields automatically
I've been trying to work my way through something I got from the Access Web, code to automatically fill in certain fields on a form based on the value placed in another field. I'm getting a hazy idea of how the process should work, but I'm struggling with some of the specifics. This is the sample code: Sub... 15 Feb 2005 17:05

VBA Code for Combo Box to Find Record
I can not get the Combo Box Wizard to help me create the code to find a record on my form. As such, I need to write the code myself...but I could use some help! Form Name is TEST Has fields: SettingValue (text box), Comments (text box), and Event (combo box). The records that this form should display are ... 16 Feb 2005 13:24

Runtime error 2220
Using Access 2002 have a form with the Access Image control & linking the image to that control Using the following code at OnCurrent event: Dim str As String, MyImage As String str = DLookup("SlidePath", "Admin") ' MsgBox str ' MsgBox MyImage If Me![ImagePath] <> "" Then My... 13 Feb 2005 14:52

Deleting a node from TreeView
I would like to delete a node from treeview. I can add, I can rename, but I don't see a delete method. The work around I've tried is to delete the record from the table, clear treeview, then repopulate the tree. However, after doing that my tree is collapsed. Is there a better way to do a delete? Thanks, ... 28 Feb 2005 21:28

convert feet to meteres upon text box entry
does anyone have the code handy to convert feet to meters upon a vlue being entered into a text box ... 12 Feb 2005 17:06

Hyperlink Text to Display
I added a combo box with values that I would like to pick up in the Hyperlink TextToDisplay of a hyperlink field. In the After Update event of the combo box, I added: Me.(myfield).SetFocus RunCommand accmdInsertHyperlink What is the command to then pick up the combo box value in the Text to Display? I trie... 12 Feb 2005 17:06