Search results

sorry for taking so long to reply. Thanks for your help.

thanks for the respone. Anyone else have an idea?

Hello folks- I have a form below that is used to filter a table based on criteria in the text boxes. The listbox is filtered based on a query "mainquery". I would like to add a subform or textboxes, not really sure which is appropriate, to show the contact info and address (last 2 columns...

This is probably easy to do, but I can't find the solution anywhere. I've got a listbox that displays a query reslut. The problem is that there are some fields that have more than one line per row and are not visible in the listbox eg; field1 field2 row1 line1 line1...

iwas wondering if anyone could hlpe with splitting a songle column into several new columns. The data is from an access file in which the flields have the following format: 1231222 1@yahoo.com 42424242 2@yahoo.com So, whwn I import them into excel they have the format: 12343434||1@yahoo.com...

OK. I've exported the db to Excel. I've got he column values as: column1: 1232333||one@yahoo.com two@yahoo.com||1234567||three@hayoo.com I've tried the "text and columns" menu, but that only seems to seperate the first line of the column (eg: 1234567 and two@yahoo.com have been seperated...

Thanks for the responses. I am interested in the Excel approach. Any more tips? I'll look into splitting the fields as baldy suggested. I'm sure I''l have a lot more questions! Cheers! -Tom

I was wondering if there is a way to separate information I have in a database. The database was originally designed with a field called "contacts" At first only phone numbers were entered, but as time went on email addresses were added on separate lines eg: 123-345-6789 one@yahoo.com There...

Hey- Thanks for the response. I'm trying a FBQ "how to" and it seems to be working well, but setting up the query is a little bit of a pain. I don't have ay experience with SQL statements. I guess one concern is the time it’s going to take to run the query when the table is filled (about...

Hello all- I've seen a few examples on this forum, but I still would like some ideas. I've got a listbox that I would like to filter based on text boxes. I would like to be able to filter the listbox with any single textbox or a combination of the textboxes. Ideally I would like to be able...

Hello- I was wondering if anyone here could help me modify the following code. I would like to use several unbound listboxes in a form to display several queries based on one uploaded table. I can't seems to get the code right so that the listboxes refresh after the Hot Sync completes. I've...

Hello- I was wondering if anyone here could help me modify the following code. I would like to use several unbound listboxes in a form to display several queries based on one uploaded table. I can't seems to get the code right so that the listboxes refresh after the Hot Sync completes. I've...

Hello- I’ve searched the forums and was not able to find the answer, so I was hoping someone would be able to help with this. I would like to open multiple forms (cascade) in the same .mdb file when the first form is opened. There are a total of 4 forms. This is probably a very simple thing...

Thanks for your help. Your tips sound promising. Would you happen to know if referencing the same cell repeatedly would slow the file down? For example using the following formula in consecutive rows: =$AF$10+TIME(11,30,0) =$AF$10+TIME(11,40,0) =$AF$10+TIME(11,50,0) The same cell is...

Thanks for the response! We have over 200 formulas for sure. The spreadsheet is used to calculate times that are then linked to checklists in Word. It seems like the more Word documents we link the bigger the .xls file gets. Which I've read is true for OLE. Does anyone know if there is a...

Hello Folks- Just wondering if anyone here has a tip for my problem. I've got an Excel file that is being used to fill in word documents via linked objects. The problem is that the excel file is growing exponentially, and seems to crash frequently. Right now the file is about 15 megs, and...

Hello folks- I’m posting here because I have received great help in the past (for other questions). So, I was wondering if there is anyone out there who could help me with this one.:confused: I have a form control that imports data from a PDA to an active form. It works great. So much so...

Thanks for the response. You were correct. I just had to change the format properties for my query. I'm just getting started w/ Access so the little things still throw me for a loop. Cheers!! -Tom

I've posted this question in the Excel Forum, but maybe it's better suited here. I need some help with an excel file that is created from an Access Query. I’ve managed to create a button on my form that creates the .xls file and open excel, but the formatting is wrong. I need to define the...

Hello folks- I need some help on a file that is being exported to excel. I have a button that does the following Private Sub cmdExportToExcel_Click() On Error GoTo Err_cmdExportToExcel_Click Dim strQueryName As String Dim strExcelDetail As String Dim strDTSaved As String...