Search results for query: *

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...

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...

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...

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...

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...

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...

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, ",")...

Hi- I was wondering if there is a way to make a text box (or the actual text itself) blink on and off? Thanks, Richard

Hi- I have created an Access form that shows summary level detail and when you click on a record a new form opens that has the detail information. My problem is that the main form is not closing like I want it to: Application.DoCmd.OpenForm "frmDetail", acNormal...

Hi All- I have a Word Document that uses VBA to get user input and then create a merge document based on this information. The user has the option to create an Excel file that contains all the data in the merge source document. Two fields that are being somewhat problematic are the Emp Number...

Hi- This is a bit more complicated than simply adding a graphic to a form. The graphic is the logo of a company. I want to set up my main form so that when I enter a company, their logo appears on my form. Also, as I cycle through records already entered, I want to the logo to change to...

Hi- I have a Access macro that runs 4 "Make Table" queries in succession. At the beginning of each macro, I get the "The Existing Table Will Be Deleted, Do You Want To Continue" warning. Is there a way through code that I can automate the response to "Yes" or bypass the message altogether.

Hi- I have a basic Access form where a user enters a from and thru date. When they click the button those dates are then converted and used as selection criteria in a query. This was working just fine until I added code trap for blank text boxes. Option Explicit Public Sub Command6_Click()...

Hi- I have created a Word document that pulls data from a database, writes that data to a text file and then uses that file as the datasource for a mail merge. I have set the code up to delete and recreate the source file whenever the form is run so that I only get current data. The form is...

Hi- I have created VB code that successfully pulls data from my data source and I have created a list view where I can see it. Now I need to put that data into a form I have created. It would work fine if I selected one person at a time, but I need to do print one form for each person in the...

I am using Access 2000 and have XP on my machine. I am trying to add a combo box to a form and I get this error. I also get the error if I try to add a list box or if I try to build reports, forms, etc... with the Wizard. I have tried Registering the ActiveX Components, but that had no...