Search results

Yes.... This is the actual form when we run it.... See Image-2.jpg

Hello All, Is there a way to prevent the file path to show in the form. This is on the top of the form when its being run. (See Image). I looked in the options and didn't see any thing that will effect this. I was wondering if there is a way of doing this via VBA...... OS: Win 7professional...

Thank you all for your help....... Cronk.... Added debug gives me the same as error...... I will figure this out eventually, I always do........ Thank you all.

OK.... Here is the result... I modify the code a bit got rid of strPath....... This is the complete code....... Private Sub Form_Close() ' Attaching and sending e-mail Dim N As String Dim S As String Dim strFile As String N = Forms!Contact_Calls_NRSS!Lbl_Notes...

Thanks for reply cronk...... I really appreciate it..... I think I will find a solution for saving all attach files in the table (I mean attach to a record file) to the strFile directory........ Your solution will help me half way which is great.........I have been changing this code so many...

Hello All: I have an applet in Access(2007). The applet logs calls and enables users to attach files to the call and if they choose, send an e-mail out. Not a VB programmer but I understand it. More of a spaghetti programmer. These are my issues……. 1. Need to be able to attach to...

Thanks...... Was missing a \

I get a Run-Time error '3839': The specified file exists already...... The debug highlights fld.SaveToFile strPath :banghead: OK... this is a bit confusing.... the strPath is pointing to CurrentProject.path......I checked and there is no such file at all.......so I don't understand what is it...

Hello All. I have found the code below , It is function. I have managed to incorporate it to my form. The issue I am having is that I don't get any error, which is good, but I don't get the file saved either it seem nothing happens........ Can somebody hint me to the right direction...

Static, Do appreciate your help. sometimes when you look at the same code day after day things become fuzzy, The purpose for the code placement was that sometimes when a fresh set of eyes looks at it they might just might see something that is obvious. You have helped me greatly and no...

Solved. I needed to place the code in couple other places........ Forms!Access_Agreement.Dirty = FalseThanks:)

Thanks for the reply....... I see the logic, I added the code, but still come up in edit mode....... I have to look at the events when I open the form more closely, I must be missing it somewhere........:banghead: if o do a DoCmd.RunCommand acCmdSaveRecord behind a button on the form and run...

Thanks for the reply...... So I guess my confusion at this point is that do I do that in every code that set values..... and which part of the code I inset that right after I set it.......? can you show me an example in one of the codes I provided.......

Hello All.... I have been working on a Access(2007) applet. All is going well with an exception of not being able to open one of my forms in normal mode(not an edit mode). It seems no matter what i do the form opens in edit mode. this is with the little pencil to the left( See EM.jpg). I need...

CJ, This works great.... Works like a charm........ Thank you.......

Fiscal starts: 7/1/2016 - 9/30/2016 = Q1 10/1/2016 - 12/31/2016 = Q2 1/1/2017 - 3/31/2017 = Q3 4/1/2017 - 6/30/2017 = Q4

Thanks....... learn new everyday....... No more dialog box...... Is there a way of adding the 5th column......

Hello All. I have an existing query that will give me the number of dates for given month and year in Fiscal Calendar Year. QUERY: SELECT Count(Sch_Sampling_Date.Sch_Sampling_Collection_Date) AS CountOfSch_Sampling_Collection_Date, Year([Sch_Sampling_Collection_Date]) AS CalenderYear...

I found this code in a tread back in 2005 :)which works pretty good, Thanks to DCrake, Would it be possible to have the output be *Xls and have the hedder to print in each file. The files seem to be Data only. Public Function SplitTableOrQuery(TableOrQueryName As String, MaxRows As Long)...

Hello All, I am kind of lost as to an approach to the problem I am having. I have a table with over 400,000 records. I need to export several attribute(name, date, num-1, num-2)from the table to *.csv or *.xls files with no more than 1000 record for each exported file. Can some body give me...