Search results

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

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

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.

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

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

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

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

I apologize for asking yet another question about autolookup but I have poured of Pat Hartman's example and all the posts in this forum and still can't seem to make it work. I have attached my db. I want to type in the asset number and autofill the rest of the form. Can someone please look at...

Help! On my form, when users enter an SID, I want to first verify that the SID exists in another table (tblSISAR) and second, to fill in the name (from tblSISAR) associated with that SID. tblSISAR has 25,000-40,000 records in it so I don't think a combo box is feasible. I've tried dlookup in...

I am having trouble with filtering a report by date. Users that select 'run daily report' are then promted for start and end dates. My problem is that once dates are entered, the 'Enter Parameter Value' box pops up. If you click ok, the report runs and filters properly. I've used a query as the...

This should be very simple but I can't seem to figure it out. I have a startup form in which I have 2 comboboxes. I want the user to select a choice from each box and then pass those choices to the next form which is a data entry form. Users will be inputting several records but those two...

I am trying to loop through a recordset and update a currently empty field in a table with something depending on another field. After hours of frustration I can't seem to get it to figure out what I am doing wrong. Only the first record is updated though I know it is cycling through all the...