Search results

Thank you! Exactly what I needed.

I am pulling data out of a new system and need to import it into a really old legacy system. The format this old system needs looks like this (notice the leading space in the first row): 12,116050,4523, 000000253177 12,160310,0680,-000000030000 The last field is a number field that comes in as...

Ah yes, totally makes sense now. I just completely missed the fact that every other parameter was a variable except that one. A definite slap your forehead "DUH" moment. Thanks for the F1 tip, that will come in handy.

Finally figured this out but why this works, I don't know. When I step through code and highlight the spec name, it would show "specification file not found" or something like that. I put the specification name in quotes and it worked. For example: DoCmd.TransferText acExportDelim...

Here it is. I commented out some of the code because it goes to another database to get data. Go to frmEnterDate and enter June 30, 2011 for start date and end date and click submit and the vba code will export the files. Right now since I have some code commented out the temp file is not...

I set the Text Qualifier to "none"

I have vba code that writes data to a table and then exports that table. I need it to export without the double quotes around every field but I cannot get it to work. Here is my docmd code: DoCmd.TransferText acExportDelim, SpecCSVExport, tempTable, ExportFileName (tempTable and ExportFileName...

Thanks for the quick response! Sorry, I should have included this info in the first message. The data is stored as decimal number, I import it from another DB. My guess is, this is why none of the suggestions above seem to work (haven't fully tested all).

How can I convert a field from another database to include a decimal point. For example, 7983 should be 79.83. This seems like it should be very simple but I cannot seem to get it. Thank you very much.

Yes! That is exactly what I wanted and it works (I didn't need the chr(34), it worked without). Thanks so much for your help.

I have a table that has fields called counter1, counter2, etc up to 6. I need to move the data in one of those fields, depending on some selection the user makes, to a new table. I use a string variable glbCounter to trap which selection the user made and am trying to concatinate the choice with...

Thanks so much for responding. I changed it to a SQL string, eliminated all unnecessary '=null' and now it does what I want. This is, unfortunately, querying an external oracle database over which I have no control. This table that I am querying does only have payment information, i.e. each row...

I have a query that has 4 fields that are text fields in an external database. I have text boxes set up on a form which contain either null or >0 (depending on an option button selected). I want to pass that >0 to one field in the query and null to the other three. I have the following as...

I have a subform whose recordsource is tblIPAddress, which is a table with three fields-assetnum, IPAddress, Hostname. The table is a fixed list of all IP addresses available. I have a combo box on the subform whose control source is the IPaddress field and the rowsource is a "select" which...

Thanks sooo much for your help. For some reason your db gave me "can find project or library" errors but I just applied everything you did to mine and it works great. The [Forms]![frmEnterAssets]![cboAssetNum] in my query was what filled in the fields from my combo box, but your way works too...

Okay, I got the openform to work and my form opens fine. But, the fields on the form do not populate with the selected record. I've tried numerous things and none seem to work. I've attached my db in hopes that someone can look at it and see what I am doing wrong. Meanwhile, I'll plug away....

I have a search form that populates a listbox based on the search criteria. I want to doubleclick on one item in the listbox and populate another form. I've used the code that I found here but it does not work for me. The form I am trying to poplulate an EnterAsset form and is based on a query...

Oh, I get it. Thanks.

I added that line and while I see it's necessity, it did not solve my problem. It did however spark an idea and I figured it out. In the CLEAR button code I am setting the textboxes to "" but the rest of my code is looking for null. For I = 0 To Me.Count - 1 If TypeOf Me(I) Is TextBox Then...

I created a search form (using code from here) that searches serveral fields and displays the results in a listbox. I also created a clear button to clear the fields, including the listbox. I can search all day and it works fine, and the CLEAR button clears out the fields fine but once I have...