Search results for query: *

I am bumping a rather large recordset (8000 + records) to find records in another table using DAO. What I have set up will take 30 hours to run. I think there has to be a better way. <code> Set rsSource = db.OpenRecordset("SELECT TNResidentsTest.*" _ & "...

I have a bound form where the record source query prompts the user to enter a value to filter the recordset. The Values are SH or NP. After the user enters a value all the correct records are available for edit. What I want is IF the user clicks on the add new record button to have the text box...

I finally got a VLOOKUP to work: =VLOOKUP(D4,PREVIOUS!D4:AN115,37,FALSE) This brings in the correct value. But since I have heard the Index and Match combined is a better method I am trying to figure out why this does not work...

I am able to apply an autofilter to a worksheet, then copy the visible rows to another Workbook (New) just fine. I need to, when I return to the filtered worksheet, add data to a cell outside of the .AutoFilter.Range for only the visible rows. (Col M). I could loop through the entire worksheet...

Hi All, I need some help. I inherited an Excel Macro system set up for payroll and financial evaluation and suddenly I have encountered a problem with an established routine no longer performing as expected. We write to a file: Public Function WriteExc(filename, sht, rng) 'Writes data to file...

I am finding Chr(160) and Chr(157) in recent spreadsheets to format. I decided to set up a Clean sub to call to remove unwanted characters. At first I tried removing all non visible characters and cleared all the cells. I am narrowing down the offensive characters and was hoping someone would...

I am importing 2 csv files into the same sheet. The first set of dates writes to the cell formated as General and displays as mm/dd/yyyy. The next csv with the same date is written to the cell as custom '*m/dd/yyyy'. I can see in the process the dates held in the variable before it is written...

Windows 7, Access 2010. On the Subform I have a combo that displays values 1-4 based on table CalcType. Previously we have been storing calculated values in a table, not a temp table, and using the values. The problem is updating the 4 values involves a few calculation sub's and slows the db...

I have been updating a BE with a conversion Db to add/alter fields and the code I was working with stopped working with no change to my OS or Access ver. Windows XP, Access 2010. This worked previously: PubstrFilePath is the path to the BE Db. Set db = OpenDatabase(PubstrFilePath)...

Hi All, I have been trying to get the API calls for a common dialog box to work for both the 32-bit and 64-bit Access versions and it works fine for the 32-bit applications but won't compile in the 64-bit environment. I have found some code recomended for this but I can't get it to work. Here is...

This problem was presented to me at work. I do not know if it is even possible. Any input appreciated. We have data going into the cells with 3 or 4 different colors. Is there a way to use the font color in the cell to base calculations on? Thanks in advance for looking Joel Joel

This may not be possible, I've been trying. Access 2010 in 2007 mode. OS XP SP3. I have a form with a tab control with 5 tabs, all the tabs are continuous forms with text and combo boxes in the detail section. What I am trying to do is make 1 of 3 fields visible on one subform based on the value...

I have a form where the data is showing in the detail section and I am able to select mutiple rows. Is there a way to iterate through the selected items? I've been looking at the properties and nothing seems to work. Probably simple but it's been a long day :-) Joel

Hi All, I am trying to set up a conversion Access database that upon opening you select the BE database, it alters 3 tables and then runs some update queries. I am having a problem with this error. I get it after I alter some tables in the BE database when it tries to run the update queries I...

Hi all!!!! I have a form that I update a comment field using the Lost Focus event. The problem is the the Lost Focus event causes the program to lose the event that caused the Lost Focus event in the first place. Say the user changes the comments and then hits Close. The comments get updated...

I am having a problem with a forms behavior. I have a Part Munber search text box that, when there are no rows returned from the search, makes the form detail section invisible. The problem is that when there are no rows returned, the Detail section is made invisible but I can't seem to get the...

Hi, Is there a method or a setting that will, when the user presses the Tab key to have the cursor or focus move to a specific cell? I've been searching the forum and Help and can't figure it out. I am looking for something similar, I think, to the Tab Stop in Access but may be way off, more...

Hi All, I have a form with a tab ctrl with 5 tabs that I want to highlight the entire row when any tab is selected. Each tab is a subform. On the main form I have a hidden txt box holding the Part Number value which is also on all 5 tabs in the tab ctrl. In the Form_Current event of each subform...

Hi!! I have a listbox on a single form that is not cooperating. I searched through the threads and found some info but can't make it work. Using Access 2010 in 2007 mode. I am only working with the Case "lblPartNumber", the rest is waiting for this solution. I had it all set up and working with...

Hi, I have a form with a combo box that controls the results in a tab control with 4 tabs. In the AfterUpdate event of the combo box I am able to correctly display information in the 4 tabs. On this form I have a button to modify records which brings up another form. Upon a successful mod I want...