Search results

Awesome, thank you! I learned something new and this is much cleaner! For future users I had to modify case 4 as shown below. Case 4 Me.[TSKlookup subform].Form.Filter = "(DatePart('ww', [DueDate]) = DatePart('ww', Date()) )" Works perfect, Minty I truly appreciate the help!

Thank you! Now I don't get an error, however the filter doesn't show any records? When I know I have some from this week.

I am working on filter for a subform based on a combo box. The only issue I am having is filtering for current week (in red below). I think it may be a syntax issue but I am not sure. Can anyone help? Public Sub TskDateFilter() DoCmd.RunCommand acCmdRemoveFilterSort Me.Combo25 = ""...

My apologies I don't get the proper result. For example Length =154, width = 40 and height = 52. If I only do. ' bw = [Forms]![Jobentryfrm]![Length] + [Forms]![Jobentryfrm]![Width] + 12 [Forms]![Jobentryfrm]![StyleJobCurrentSub]![TotalDim] = bw I get 15452? Should be 206.

I am trying to perform a calculation within an IF then Statement. The difference is I need Access to remember a values to complete the calculations prior to setting the final answer. I think this is basic however I am a novice and can't seem to get it to work. Can someone help make this work...

Thank you. This is much simpler than I was making it. My only change is I think the end is 12/8 =1.5?

I am working a database to price jobs involving lumber. One of the first things I need to do is come up with a function to determine the yield. Example: Form![Yeild]![length] = 10.5 inches and Form![Yeild]![QTY]=12 and Form![Yeild]![Boardlength]=92. Previously in Excel I would Multiply...

Sorry. It seems to be working. I think I had a case of looking at something to long. Just to explain better, my input was 5.9375 because the DB adds .0625 for waste. That calc would give me a whole number (6) in the field that the function is converting. That is were I got the return of 6...

For the function the changes it to a decimal so I can do the math to work I have the fields set to decimal. Could that be the issue?

The decimal I see it with is 5.999 returns 5-1/1.

Thanks to a helpful post and run by Rawb I have been using the below code. It works great with only one issue, I am hoping to get help with. If the field I am converting is a whole number it still converts it. (i.e if the answer is 1 this returns 1-1/1) Is there way to correct this? I...

I agree that is normally how I have been learning. Problem is I spent all my time fumbling to get the current version now I need to start over. I do appreciate your help to this point.

Thank you. I have found this prior to my post, however I am not sure what to remove from mine and add to yours.

I have recently changed from office 2003 to 2010. With that change a script that I have painstakenly just gotten to work, now won't work. Can someone offer assistance in editing the code below to replace the "Application.File Search? Private Sub Form_Open(Cancel As Integer) 'Perform simple...

I have a continuous form that I can make and create directories from. The final piece I am having issue with is coping the pictures based on the same form into the new folders. Below is the code I tried to put together to loop through the form pick up the file name and copy to the already...

Perfect, thanks to all who helped.

It won't compile. I get an error that there is a loop with out a do?

Sorry for the head ache. I am by no means an expert. What I am attempting to do is loop through a form creating folders and in some cases sub folders if they don't already exist. I tried to make the code as straight forward as possible below.

I am working on making folders for each crate in a table. I made a datasheet for and put the below code. However I continue to get a "Loop without DO" error. Can anyone assist with what I have done wrong? Dim rs As DAO.Recordset Dim strSQL As String Dim strBookmark As String Set rs =...

I am working on a project that I will need to group pictures with an access record. My plan is to put all the pictures as all the "tools" move through the process in a folder on hard drive named with the specific naming system. Once all the items and pics are complete I would like to have...