Search results for query: *

I found the issue!!!! ' Set to Break on all Errors Application.SetOption "Error Trapping", 0 This code prevents the error from continuing on and forces a break. I removed the code and reset the option to Break on Unhandled Errors under Tools - Options - General. Thanks for your input as I...

I actually tried to to it but the data is coming from a stored proc. This is an .adp (Access project) but i am not sure how to send the string to the sp for it to run using DoCmd.TransferSpreadsheet. As I was stepping through the code today, I noticed that the culprit of the issue is that the...

But why is the code working w/o issues on those computers that have not run the export to excel code above? So I know the code works for formatting the fields. It almost looks like the code did something to the app....just don't know what.

By the way, I also noticed that the code fails on odd numbers for (I) not on even numbers... The part that has me puzzle is that this happened after running the Excel export code.

Hi kjv1611, Good point. Let me explain, I have a main form and a subform. The forms actually begin to load but when it gets to the code that formats fields on the subform, the code hangs. This code is on the subform. The subform is displayed as a datasheet. Here is the piece of code that it is...

Hi, I am in need of assistance. I have created the following code to export data from an access project to Excel. After running the code and creating the Excel file and then closing the form that calls the code, I am no longer able to re-open the form. Some of the code that is used to load...

Hello everyone, I have created a similar search form as the one used when pressing ctrl f. I know want to add the same functionality to an unbound combo box, of saving the last 5 search items. I tried adding it through code using value list as the source but I'm unable to do it. Any suggestions...

That did it, Thanks Remou!!!

Thanks! Half way there!! I got the Screen.ActiveForm to give me the name of the form but when I select Screen.ActiveControl it gives me the actual data in the attribute. I need the name of the attribute. For example The attribute name is FirstName and the data is John. Screen.ActiveControl...

Hello everyone, I have developed a search form that users can call within the active form by pressing Ctrl + F. The search form is composed of a combo box with the column names of the active form and a text box for the search criteria. I currently pass the name of the form and named of the field...

Hi All, I have setup the database mail for users to send emails without problems. Now the need is to also have it send attachments. I have setup a user account with the specified rights to the network folder where the attachments are located. I am able to send the attachments w/o problems since...

This is exactly what I was looking for. I really appreciate it Remou!!

I guess what I mean is that on the entry form, the list box displays all records and the user selects the items from the list. The code then pastes those selected records on a field. Your code works great displaying those selected records but what if the user wants to edit selected records or...

Though the above code worked great in selecting only those items that are currently on the field, how can I pull all the data from the Product (Source) table but highlight only those selected in TableA? Thanks! Z

Thanks Remou, worked like a charm!!!

Hey everyone, I currently have a list box in a form that populates the ProductID field based on the multi select options. TableA RecordID = 100 ProductID = MEH, AGH, PVH USER = jdoe I now want to populate and sort a list box on another form based on the values stored on the ProductID field. I...

I created an AutoNumber field to preserve the order and then I implemented Golom's code. Thank you both for your help! Z4

I will give this a try. It's a long weekend and I have to go. I will post next week. Thanks for the help!!! Zionman4

Thanks CMP but I already have the data in an Access table so I don't need to re-import it again. All I need to do is fill in the blanks... Zionman4

Hi Everyone, I currently bring in a text file into Access. After deleting all unnecesary data I am left with the following table: Description Totals GroupSet CycleDate Cycle Date 05/19/2006 LOB010 010 OFFSET $500 HISTORY...