Search results for query: *

I know that somewhere in the registry there is a place where I can add file extensions so that a data output macro will be allowed to name the file Filename.xls. where .xls is not currently allowed. I've added allowed extensions in my registry before but I can't remember where that is done and...

Thanks that was very helpful and got me moving in a better direction. I had to tweak it a bit to get the results I was looking for. I also had to take into account that some of the records had middle name rather than middle ititial (something I didn't realize in my first post) so the field...

I have a field called [fname] that is the customer's first name. Sometimes it contains a middle ititial as well and I need to get rid of that initial. So sometimes the field contains "Mary" and sometimes it contains "Mary B" for example. It seems like my solution: Replace([fname],"* ?","* ")...

You've gone above and beyond- With your help I was able to get this done. Thanks for helping me out! Bravo6

I appreciate the help very much. This is access I just copied/pasted into excel so I could easily color code and show what the data looks like. I really don't follow your logic however. There is nothing in the field to tell which leg is the second leg. So I really can't simply select 2nd...

ok here is a url where I placed a screen shot of a few rows of the table. http://www.tvlon.com/images/excelscreenshot.jpg The first row is a round trip ticket and is fine. The next two rows are two one-way tickets that I want to combine. Row three is really the return portion of the same...

Yes, they are realted by last name. Can you tell me how to do it? Thanks

I work for a large Travel Management Company. I am creating a data handoff for a customer that has their traveler's ticket information (depart date, time, depart city, arrival city etc.) and return date/time. I have no problem doing this with round trip tickets. One-way tickets are a...

Can an update query be used to change a portion of text within a record? I have a field that is populated by numerous records that contain the string "//" eg CCCC//CCNN.CCC I want to write an update query that will select fields that contain the "//" and change the "//" to "@". So in the...

I have a query that selects invoices from [invoicedatefield] with "Between [forms]![formname]![startdate] And [forms]![formname]![enddate]" in the criteria box. This works fine I now want to add prior year data in a new query for the same month/day range without having the user need to input...

No way to do this without VBA? I not VBA literate.

I know how to use the Left, Right and Mid functions to select parts of a field by their position in the field eg. mid([field],2,3) Is there a way to do the same thing if the field contains a delimiter? For example, if my field value is 23.639.rf2 how can I have the system return everything to...

I have set a macro name to be autoexec in access so that it runs automatically when the .mdb is opened. I also put the "quit" command at the end of the macro. Now I can't get into the .mdb to make changes without the macro running and closing the .mdb. Is there amyway to disable the autoexec...

I wanted to pass along this fix that I found that allows one to name exported text files with any extension that they chose. Installing Microsoft Data Access Components MDAC 2.1.2.4202.3 (GA) and the Microsoft Jet 4.0 SP3 update adds the following registry key when a program loads the Text...

I don't know VBA, can you give specific instructions?

I need to send a fixed width file daily to a bank. The file needs to have the filename 123456.afs When exporting to a fixed width file in Access (I am using macros) it only allows my to name the output file with a .txt extension. How can I get it to allow me to name the exported file with...

I am trying to create a network connection to our company intranet. I am doing exactly the same as everyone else in the office but am unable to connect. This is what I am doing step-by-step: 1. Go to My Network places, tools, Map Network Drive 2. I choose "sign up for online storage or connec...

I am trying to take information from two different records and combine them to one record. See below: Record Key Depart Return 2351 12JUN 13JUN 2351 15JUN 16JUN These are two different segements of the same trip. I want to end up with Depart...

thanks is (strSource As String, strDestination) where the [FILENAME] goes?

Hmmm, Neither of these worked. I'm not sure where I'm supposed to substitute the filename in lameid's example. I wrote: Sub DeleteFile [newfilename] On Error Resume Next Dim FSO As Object Set FSO = CreateObject("Scripting.FileSystemObject") FSO.DeleteFile (strFile) Set FSO...