Recent content by hawzmolly

Did not know about "Cross Posting". Will try to remember to do same as your example. There are members of both sites that have given me very good advice and were able to clear up the same problem in different ways. Thanx

JHB As you requested I have attached 2 screen shots. “Screen Shot with Numbers (SSN)” and “Screen Shot 1 (SS). The zip file of the DB is also attached. You will be working with Table “TrainName” and form “frmTrainName” To explain: Open SSN. Also open SS. May I also suggest you open the...

:banghead: I have 9 unbound combo boxes on my form and I have 9 bound combo boxes. The purpose of the unbound combo boxes is to popup a list of choices for my staff to choose from. One of the 9 unbound combo boxes is a straight query to open the appropriate table. This combo box may be opened...

I had a form that has a combo box that I could open and click on a member whose data I need to change. This db is on a flashdrive so I can use it both at home and at the club. The club computer had an automatic update sometime between when I last used it and now. This form worked perfectly...

One last thing. Does this forum have a "Solved" key?

I got rid of the "ABV" field and replaced it with Field Name "TrainName". With the following code it all works as expected. Private Sub Combo161_AfterUpdate() Area1 = Combo161.Column(1) L1 = Combo161.Column(2) T1 = Combo161.Column(3) Text172 = Combo161.Column(4) End Sub...

Yes, I think that is my problem. I can not figure out why I can't get these three fields bound to the table. Please use the "Manifest - Build" form and actually click on and add any one of the dropdown values under "Pick up Train". Note how "ABV1" and "Train Name" fill in. Then do the same...

The db is attached per your request. Form of interest is"Manifest - Build" and table of interest is "tblManifest". Thank you.

Below is the code I am using: cbo161 is "Pickup Train", cbo107 is "Set out at", and "ABV" is a plain text field. cbo 110 & 161 do indeed fill in the ABV, ABV1, and ABV2 text boxes on the form but do not transfer to the table. Obviously I am using the wrong code in "ABV" boxes to have it...

:banghead: I have a table that I am using to create a train manifest for our model railroad clubs operating sessions. I need to print the manifest after creation for the guys to use. I also need to be able to save the manifests for future use. Here are the text fields I need to populate in...

I found the "ImportExportText" in Access 2010. However, when I click on this to add it to the macro I get "Unsafe Action". The macro will not work. In Options I have "Enable all macros" checked as well as I have added the location to "Trusted Locations". This MS security is BS. I am the...

I have Office 2010. I have tried to find "TransferText" in Access. Even with "Show All Actions" turned on the "TransferText" does not show up. I even started a new macro with "Show All Actions" on to no avail.

A little background. I need to export the results of a query I use to build a report. For Print Master software I need the "Field Names" in the text file as well as the data for a Mail Merge in Print Master (PM). The PM error: "The field name information in the file you have specified...

I am a retired Nuclear Power Plant supervisor. I have some experience with Access and will use this forum for answers and suggestions. I retired in 2001 after 30 years at the power plant. Before that I served in the Navy aboard Nuclear Powered Submarines under Admiral Rickover. For something...