Search results for query: *

Many thanks for the response, the overlap was the issue.

Good Afternoon- I have created a project status report that contains three sub-reports: One for tasks completed, one for work yet to be done and one for issues. Each of these reports will have varying numbers of entries on any given month. The issue I am having is that if there are too many...

Good Morning- I have a database that is used by our Mat Mgt Dept for printing stock labels. Currently the user will enter criteria such as facility and inventory to generate a list of stock labels to be printed. Now the users would like the ability to enter one or more indivual stock numbers...

Good Morning- I want to be able to program a form on my database to flag blank fields by making them yellow. I have added the following code to the "On Current" event of the form properties: Private Sub Form_Current() With Form_frmMissing If IsNull(Me.STEP.Value) = True...

Thank you for that valuable post...I had a couple small bugs to work out, but you put me on the right track. Thanks so much.

Greetings - I am pulling data from our HR system and need to split the name into separate pieces. Currently, the name field is in the following format: DOE,JOHN Q (there may or may not be a middle name/initial). I can get the last name and the first name/MI but I can't split the first name...

My apologies..I posted this query to the wrong forum

Greetings - I am pulling data from our HR system and need to split the name into separate pieces. Currently, the name field is in the following format: DOE,JOHN Q (there may or may not be a middle name/initial). I can get the last name and the first name/MI but I can't split the first name...

That did the trick... thank you very much for your help. I am not familiar with "master..spt_values" and would like to understand what is happening when this query runs. Could you explain? Thank again, this will be enormously helpful.

Good Afternoon - I have a table that lists pay date by payroll. What I need to get is a list of the all the dates that fall within a pay period. Pay dates are every two weeks, so I am able to reliably capture the starting point of each pay period. Here is my code thus far: Select payroll...

Good Morning- I need to create a SQL statement that retrieves data from a table based on yesterday's date, formatted as YYYYMMDD: SELECT Data1, Data2, Data2 FROM Table1 WHERE AuditDate = 'YYYYMMDD' I started with the GetDate() function to retrieve the system date, but I am having trouble...

Hi Skip- I wanted to say thanks for the input. I never could get the merge to work from Access. It would only merge the first record and I could not figure out how to write the code so that each record in the text file would be merged (the perils of being a self taught newb). I was able to...

Hi Skip- Thanks for the information. I tried to do this but I can't get find an option that allows me to merge the document one record at a time. As soon as I click "merge" the whole merge is completed, and I am left with the code I already have.

Hi- Thanks for the response. The source file has 30 records in it. When I run the code, only the first record merges. Nothing happens to the remaining records. A colleague of mine suggested that I try using For..Next to cycle through the text record, but I don't know how to make it work (or...

Hi- I have a database that creates a text file that serves as the datasource for a merge letter. I have created a form in Access with a command button that when clicked opens Word and the merge document and also performs the merge. However only the first record merges, nothing happens with the...

Thanks for the help. I will these suggestions out and see how they work.

Hi- This is a finesse question. I have code that pulls data from our hr database and writes it to a text file so that if can imported into a scheduling system. Due to a number of factors, I can't pull by corp/dept, I have to pull the data by a change date and then filter out only those...

I ended up using PHV's suggestion and it worked like a charm. I know that I will have the two word last name scenario to deal with so using a two step approach to splitting the name seems to work best. Many thanks to all for your assistance. Richard

Hi- I have a name field that I need to split into first name, last name and middle initial. The format of the field is LASTNAME,FIRSTNAME MI. I have an array that first splits the LASTNAME and FIRSTNAME MI: SName = rs!Name nmval2 = Mid$(SName, 1, Len(SName)) MyArray2 = Split(nmval2, ",")...

Thank you, that thread put me on the right track. Now I've got all kinds of ideas.