Search results

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

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

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

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

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

I am currently using the following code to import multiple spreadsheets into a DB. Is there a way to prompt a user to select Multiple files instead of having them take everything in the folder? Function Impo_allExcel() Dim ImportDir As String, ImportFile As String ImportDir =...

I have the code below to import Data into a master access table which works for the most part but I still have a few issues. 1. I get a bunch of type conversion errors evertime it is run. 2. Can I limit the range of the imported sheets? It imports a lot more lines below what is needed every...

I am currently using the code below in my DB. All works fine except I would like to make the path in [Text819] a hyperlink when it goes into the task body. Is that possible? Sub AssignTask() Dim myOlApp As New Outlook.Application Dim myItem As Outlook.TaskItem Dim myDelegate As...

I have recently change a database over from Office 2003 to 2007. Now when I am in a form with a sub form data sheet I get multiple blanks lines (grayed out) below my new record row and blank columns to the right. This all worked fine in 2003 how can I correct this in 2007?

Ok, first I am self taught and still learning how to write code. I have spent 2 days searching forums and trying to modify code for and answer but I need help before I pull my hair out. I have a db I created that currently imports attachments and I have since learned of the 2 gig rule and am...

I have found and modified the following code to get me started in the direction I want to go. However I need help expanding it. Can I modify this code to prompt for an attachment and add a signature in the subject? Signature being something like John Smith 555-555-5555 Private Sub...

I am trying to do a simple query that is filtered off a form where the user can select a sign i.e(>,<,<>) in an unbound [combo1] and a date field [Date]. I thought I could then put in the query criteria [Form]![Search Form]![Combo1]&[Form]![Search Form]![Date] but when I do I can a error shown...

I have a query with three columns Apparatus ID, Apparatus Type, Select. when I filter for Items true in select, I somehow want the result in the apperatus rows to populate an Engine field in an incident commanders form. Example Apparatus ID; Apparatus Type; Select Engine 8............Engine...

I apologize this is long winded, I am having a hard time with how to explain. The best way I can explain is if I was using excel I could copy a column and paste special transpose into a single cell, but instead I want it with in Access 2000. More info I have a query with three columns...

When I attempt to open an excel template from an access form using either run application or a hyperlink the excel template opens to where I can only see the from of the excel and nothing else. (see screen print). Any ideas of what is causing this?

I am trying to filter a query by a combo box. I put the below in the Criteria under my visible column in my query. IIF([Combo141]=1,"Both" or "daily task","project")

I have a DB that I use a form filter in and would like to save the filter so the data can be exported. I originally used the export in the filter tool bar but the problem there is if columns are hidden they do not export and I need this user proof so the data can be changed and imported from...