Search results for query: *

Hey now...!! I have a text file that is formatted like this: 00 120 SDF 1)Fuel pump inop 2)#2 Hyd pump leak 30 250 ONT 1)#2 Main wheel cut I'm tryin' re-format the file to look like this: 00 120 SDF 1)Fuel pump inop 00 120 SDF 2)#2 Hyd pump leak 30...

I am working with some code that - for some reason - it skips that last line in the text file...?? I just can't figure it out.... Below is what I am working with... Can anybody help me out with some suggestions or examples..?? Thanks in advance..!! jcw5107 Dim intFileIn As Integer, intFileOut...

I need to be able to select a column (column B always), and for each cell that has a "strikethrough", update the cell in column C (next to the "striked-through" cell) to "UC".. I have tried building a macro with the recorder, but I am having trouble getting the code to update the very next cell...

I need to be able to select a column (column B), and for each cell that has a "strikethrough", update the cell in column C (next to the "strikethrough" cell) to "UC".. Can't find anything posted regarding this... Thanks in advance...!! jcw5107

I have a form with a continuous subform. On the subform is a "checkbox" for each record. The checkbox is used to delete records from the subform. Also the checkbox is used to delete records from another table. I am tryin' to figure out how to use the recordsetclone property of the subform to...

I have a bit of code that I am working with that works with the items selected in a listbox. From there, I would like to add new part#s based on the items selected. This way I can assign 1 part# to several Task#s (if several are selected) at one time.... I am having "syntax" problems with the...

I have a form with a Listbox & subform on it. When scrolling thru the records on the main form, the listbox requeries to show right list with the main forms current record. On any given record the list box can have from 1 to 4 items shown. I need to have the subform requery based on a single...

I have some code I'm messin' with. I want to manipulate a text file before it is imported, this way I can minimize the amount of queries in my d/base.... I'm tryin' to insert the days date in each line of a text file. The problem I'm having is that the newly inserted text overwrites the...

Hey now..!! Below is sample code I'm working with. It replaces duplicate values in a single column only, leaving the 1st row of duplicates. I'm tryin' to make this work over several columns - columns B thru G to be exact. Any suggestions or examples..!! Thanks in advance..!! jcw5107 Sub...

Hey now..!! Below is sample code I'm working with. It replaces duplicate values in a single column only, leaving the 1st row of duplicates. I'm tryin' to make this work over several columns - columns B thru G to be exact. Any suggestions or examples..!! Thanks in advance..!! jcw5107 Sub...

I have a form with a drop down box. The drop box filters the forms recordset to the selected item in the drop down. In the drop down there is an "All" selection - that shows all records if selected. I have a listbox that I am tryin' to use to "jump" to other records within the form that have...

I have a form with a command button - that I use to update tables/records, append data to tables, or make new tables. My question is... Is there a way to tell which query is currently running? In the status bar, or a message box...??? The queries are being ran like: DoCmd.RunSQL ("Delete * From...

I have searched & searched - to no avail...!! I can't believe that my situation is different...!! Anyhow.. I have a field in a table that I need to split up & seperate the numbers and text. Example data: 9A/R 8 FT 8 AR 16ozA/R What I'm after - in seperate fields: 9 A/R 8 FT 8 AR 16 ozA/R...

I'm tryin' to speed things up with my d/base by hiding all forms. So far, so good. The problem I'm having is activating the after update event of a combo box on another form. The user will switch between forms, using Visible = true or visible = False. On one form the user uses a combo box to...

Below is an example of code I am working with. It compares to tables and writes the differences out to a 3rd table. The problem I'm having is when runs thru "For Each fld In tdf.Fields" part - it compares every single field in each table - I don't want it to. Is there a way to use select...

I have a text file that each line starts with: TC PR EO FC CK I need to write to a new text file only the lines that start with EO, TC, or CK - AND - the very next line for each EO, TC, or CK Below is what I'm working with... Any suggestions or examples would be much appreciated..!! Thanks in...

I have a text file that I need to add data into each line based on a if/then function... Below is a sample of the text file... Position 8 is where I need to look and position 14 is where I want to put the result of the true part of the if/then function.. Sample: 3719 N256UP KAMA 4030 N676UP...

Below is code that I am working with that exports a MS Access query to a MS Excel spreadsheet. Right now the way this code works is it fills the column headings (field names from query) with a color, and it fills in the range of data to Excel with a different color. Which is awesome..!! I just...

I have a text file that needs a bunch of "junk" removed from it before I import it into my d/base... There are 3 types of lines that I need - 1. Any line that starts with "N#*" 2. Any line that starts with "Acc*" 3. Any line that the 1st character starts at position 13 The text file is...

I have a text file where I need to add the line number on each line. I have some code that "cleans the text file up" before it is imported into a table. Is there a way to print the line number for each line (on the left or begining of each line) when the text data is written to a new file...