Search results

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 attached a screen print and circled the area's I am trying to explain. This has been fine for years in 2003 but i have had this issue since opening (not converted) in 2007.

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?

Thank you all ! Even with my limited VB knowledge I have been able to compile all the advice and acheive my goal. Thank you!

I think the DB is to large to attach. I currently have the MKDir working great using a combination of both ideas. Thank you both! I am still struggling with linking to the folder later. I adapted the find files as suggested but it has limitation like it doesn't show zip files and I can't...

How do I save the path to be used later?

That would be great thanks!

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 can live with not having an attachment but how about the signature? There is no way to force a new line in the "My Message section"?

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

This is very informative thanks. But I need to go to the next step. How can I use what is in the video with a selection of i.e (<,>, Between ect)

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 combo 141 = 1 Then then filter Visible for Both Or Daily Task. The next part will be if Combo141 =2 then Visible can = Both or Project.

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