Search results

Yes. Its not doing that. That is what I wanted to do was test to see if the loop even worked but its not doing that.

ok thanks.

Yes. But when i move the focus to one of the subforms the before_update event is initiated.

I have a main form ("frmMain") that includes 4 subforms. I want to prompt the user before updating the record with a basic msg "Do you want to save this record? Yes/No ... The problem I'm having is once I move the focus to one of the subforms the msgbox pops up. Does anyone have any other...

I would like to loop through all the files in a specified directory and add the filenames to a table. The example I'm given doesn't work for me. Here's what I have: Sub ShowFolderList(folderspec) Dim fs, f, f1, fc, s folderspec = "C:\Documents and...

If sfile is the full path name .. where do I tell it that. This is what I have and it didn't do anything: Public Function NoSpaces(sFile As String) As String Dim ff As Long ff = FreeFile Dim strline As String sFile = "C:\Documents and Settings\e3utbl\Desktop\Query1.txt" Open sFile For Input...

So .. I will need to export the data back out into a text field and then import it using that function? I don't understand. I've already imported the data into the database table. That is where I'm trying to remove the line feeds.

My attachment is Query1.txt .. thanks for any help.

I have a huge issue that I've been trying to resolve. I imported some data from a text file and some of the memo fields contained symbols for line feeds. I was able to replace the symbols with the vbCrLf. Now my issue is removing the leading and trailing line feeds and extra line feeds. I...

Hey Guys... I figured it out. Thank you.

Hey Guys .. In regards to carriage returns in the value, I have a similar situation. I've imported a text file into a table. One of the fields is a memo field that includes carriage returns(line feeds) but the carriage returns are translated into a symbol. Is there a way I can search for...

I am trying to add users to a MDW file thru VBA. The MDW file is not the current MDW I'm attached to. I figured that I would just have to create a wor Here's my code:Dim BWS As Workspace Dim BiMDW As String Dim usr As User Dim grp As group DBEngine.SystemDB = "C:\Documents and...

Actually, I'm sorry .. that did work!!! .. I was specifying the wrong control .. "I'm a Dummy" .. LOL .. Thanks SOOOOO much!!

Yes. I tell it to use HTML. This is the code that I have in the Option Compare part of the module: Public olApplication As Outlook.Application Public olns As Outlook.Namespace Public myItem As Outlook.MailItem The email function work properly. The <br> tags work fine. That isn't my...

I have a button that sends an email using data from the text boxes on the form. The email uses HTML tags. Everything works just fine except I can't get the HTML to read if the text box has carriage returns. For example, the following 2 sentences are entered into the textbox which includes a...

I have a macro that simply runs a TransferSpreadheet action. However it doesn't import the spreadsheet because of the file type (Web Page *.html; *htm). Once I open the spreadsheet and manually change the file type to (Microsoft Office Workbook .xls) then the macro works. Is there a way to...

Hi, I have some basic code that auto sends an email: DoCmd.SendObject , , , "tl@infotech.com", , , "Onboard Notice", msg, 0 But before it sends I get a pop-up from Outlook that reads "A program is trying to access e-mail addresses.......... do you want to allow this? ...." Is there a...

I'm trying to open another Access database with wrkgroup parameters using the Shell function. I get a "file not found" error when trying to run the function. Here's what I have: Dim varSitewide As Variant Dim curUsr As String curUsr = CurrentUser() Const q As String * 1 = """" MsgBox...

Hey .. i figured it out. collection.refresh ... thanks for the suggestion!

yes. it works when I close out of the database and then go back in. That's exactly the problem .. I need for it to refresh without having to close it. How do I do that?