Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bravo6

    ACCESS settings in the registry

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

    Append query help

    ...name rather than middle ititial (something I didn't realize in my first post) so the field could be: "Mary", "Mary B", or "Mary Beth". The query below converted them all to "Mary" fname: IIf([TableName.fname] Like "* *",Left([Tablename.fname],InStr([Tablename.fname]," ")-1),[Tablename.fname])
  3. bravo6

    Append query help

    ...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],"* ?","* ") should work but it doesn't. What am I missing?
  4. bravo6

    breaking rows (records) in a table into two different tables

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

    breaking rows (records) in a table into two different tables

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

    breaking rows (records) in a table into two different tables

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

    breaking rows (records) in a table into two different tables

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

    breaking rows (records) in a table into two different tables

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

    Using an update query to change part of a field

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

    creating a last year date range from current date input

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

    selecting string from delimited field

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

    selecting string from delimited field

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

    autoexec macro

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

    Designate a file extension in transfer text

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

    Designate a file extension in transfer text

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

    Designate a file extension in transfer text

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

    Unable to add network place

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

    Combining information from two records in a query

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

    Replacing a file with VBA

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

    Replacing a file with VBA

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

Part and Inventory Search

Back
Top