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

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],"* ?","* ")...

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

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

Yesterday "HTH" taught me how to convert a file name in VBA. Thanks HTH!! The problem I have now is that if the filename already exists, I have to go to that folder and delete it before runing the program. Is there a way in VBA to have it overwrite an existing file rather than giving me the...

I'm reposting this because the only answer I received dealt with VBA. I need to get this done through an Access Macro. Unless someone can what me through VBA. I'm trying to use a macro to export a table to dilimeted text. It works but will only accept .txt as the output file extension. It...

I'm trying to use a macro to export a table to dilimeted text. It works but will only accept .txt as the output file extension. It would be great if I could get it to export to filename.kml. Is there a way to do this or to subsequently have a macro change the file name? As always, thanks to...

I am trying to use access to write KML code. There are a lot of lines that are the same for each record and I'm simply adding those lines as text in the field. See example below. Text1: "<?xml version="1.0" encoding="UTF-8"?><kml xmlns="http://earth.google.com/kml/2.0">" I thought that...

I am working with latitudes and longitudes and need a query to make some values fit the format of latitude/longitude that the client program will recognize. All figures need to be 6 digits (some may have a negative sign at the front) and have a period after the first two numbers. So the...

I have a column in an excel sheet with date time formated like 02/09/09 03:31 This is in GMT (zulu) time and I want to convert it to Eastern time. So I need a formula to subtract 5 hours from the GMT cell and end up with EDT Date Time. 02/09/09 03:31 should result in 02/08/09 22:09. It...

I have a table that I'm using in a query. The table has 24 fields which are Period01, Period02...Period24. Depending upon what the user selects in a form I want the appropriate field to be put into the field box in the query. The only thing I could find that works is a nested "IIF" statement...

I need to import an interbase (.gdb) database into access or convert it to a .mdb. Is there anyway to accomplish this? Is there as conversion utility? Thanks, Dave

I need to try to get data from an Interbase 7.1 database using Access. Will Access import this database type? I don't want the client to send their database if Access won't work. Thanks

I'm trying to export a file per a custmomer spec. In the Access export wizard the file (Text- comma delimited)looks fine. But when I open the .txt file it has changed. Specifically this is the desired format and what it looks like in the wizard...