Recent content by Stangleboy

Perfect, I didn't think about doing the work on the subform and then displaying it on the main form!!! Thank you!

I have been through several posts on the site searching for a code to count the number of records in a SubForm and display in a field on the main form. There are several posts but they are parts and pieces of bigger code. I wrote a simple piece of code on the display field on "Got Focus", but...

So in the direction above using the SpecificationName; I would have to change my query to a "Make Table" to make a temporary table then run the "Export" wizard from the temp table and save the wizard. Then use the code above pointing to the name I gave the wizard and add more code to delete the...

I am not familiar where to use that, is that in the original code or a new line in the code? thank you!

I have been searching posts and FAQ but have not found any solution to an issue I have using the TransferText command in VBA. My code works but the resulting text file I produce has qoutes ("") at the beginning and end of each record. Can I strip or delete the quotes in VBA code prior to it...

I decided to go with an If statement, thank you both for your time and help, I couldn't get the last character of the employee right without your feedback and answers!!! Code Used: Private Sub EmpNumber_LostFocus() If Right((EmpNumber), 1) = 0 Then EmpGroup = "3" ElseIf Right((EmpNumber)...

Oops, missed the cross thread traingamer; I used to use Select Case when I needed to group but it is not working. What am I missing here? Private Sub EmpNumber_LostFocus() Select Case EmpNumber Case Right((EmpNumber), 1) = 0 EmpGroup = "3" Case Right((EmpNumber), 1) = 7 To 9...

Thank you for your fast replies: Traingamer- when I add the code into a query it places quotes around the field name and I get an error, I switched it to brackets around the field name and get no results. Also where would a '0' fit in group 3? Also every time a new employee gets added do I...

I have been out of the VBA scene for a long time and this seems easy but I have been searching the FAQ and other posts since 8:00 am and have not found code that can help me. Any help would be appreciated. I want to populate a field in a table from the data entered into another field in the...

These are great answers I will try them all to see which ones works with the flow, thank you all for your time.

Great suggestion, and I tired that but then the job fails and if they were adding a group of 50 employees through InfoPath or Access control, and there was only one duplicate, then none of the employees get added.

Alright this is going to be a little difficult and I do not know where to start and what forums to use (VBA, Access Forms or SQL) but I believe the answer lies in VBA coding so I am posting on this forum. I have an Access database with a SQL back-end for training function. I had the system...

Will do, give me a few I will let you know the results, thank you.

I belive this will still require me to run three separate times for each month when I want it to run one time and give me the results for each month. Maybe a temporary table for each month inside the main query?

I am trying to get the same data retrieved for different months, but not sure how to code it. It works fine for 1 month (May in this case) but I need to know if the person made a payment in full for each month for April and June also in one query. Thank you for your time and patience: SELECT...