Search results for query: *

Regarding a launch from Access: Here's one I did with a control ... has a little bit of error handling. Cares where Word file is but does not care where app is ... Private Sub RunMswordInScool_Click() Dim LWordDoc As String Dim oApp As Object 'Path to the word document LWordDoc...

We have a form in our Discipline database that is used to update (attendance and what they did) our "Saturday School" (You're bad .. you go to school on Saturday) We have a combo that is populated by a query that gives unique dates of all Saturdays where updates are required. The form is based...

Thanks Duane! That did the trick! Now that I see the code it sure makes sense. I did have to go back to the forms and set the default on the group to "0" when the initial record is made. It was null, and the function parameter wants an integer. All the blank fields yielded #error in the query...

I set up a number of 3 value group controls on 3 forms in an Access database. I now have a column with values between 1 and three. That's what I expected. Here's my problem. Friendly reports ... How do I get the values to display as text on a report. Eg.1="Present" 2="Absent" and 3="Sent Home"...

Richard: You were right about the theory; I was aware of that. The link you gave me shoots me back to the forums though and nothing in specific. Is my answer there? I actually discovered the following: I seems that I had to remove lookup properties in the firstname and grade fields in the...

I have a form that fills a table. There are 3 fields that are from another table. Firstname, LastName and Grade. The Firstname and lastname have been setup as lookup fields in their table of origin. I can go to the lastname field in the form and start typing to get the name or pick it from a...

When you have a Query in MS Access you have a "dynaset" that means it is a set of data that behaves just like a table. You can use the wizard to create forms. It makes it easy to set the fields up by picking. If your form requires information across tables and requires conditions then a Query...