Search results

with the help from this site and others, i have cobbled together this code and have had it work. however, this site i wish to extract data from gives me an error 5. Private Sub Command56_Click() 'On Error GoTo ErrorHandler Dim rstSsn As DAO.Recordset Set rstSsn =...

The Master Sergeant wanted me to run a report at the end of the day, and then email it to him… easy enough. He also wants a summary of the report in the body of the email. :banghead: There must be a way to have access do this for me. So… I started with this code from Twinnyfo...

i am sure that i am missing something simple. i have viewed pbaldy's thread, http://www.access-programmers.co.uk/forums/showthread.php?t=205231 and http://www.baldyweb.com/wherecondition.htm but my code still is not outputting what i expect. my function is; Function ckIn() Dim dbs As...

I am still trying to learn how to use VBA I want to get the code from field "sidstrACT_STA_PROG" and return what i have in my select...case function. but i am getting the same return as the sidstrACT_STAT_PROG field. my code is; Option Compare Database Option Explicit Function...

I am stuck. I am trying to create a public function that will print a report so that i can call the report from different forms. i have this code that opens rptFlu (bound to qryClinicData - query is not filtered); Option Compare Database Option Explicit Function printFlu() DoCmd.OpenReport...

I have so many if...then statements that I am getting lost in my own code. In my attached file, I have 6 toggle buttons that make subforms visible=true and visible=false when clicked. All buttons work as expected when all toggles are visible, but not when only some toggles are visible. If you...

I am new to Access and to this forum. i apologize if this should have been posted under "Querys". i have been trying to create a query or VBA that will calculate time in service from the following table. this table consists of 10,000 records. strID separates time in service between members...

hello all, i am new to Access and do not know how to use VBA, but thanks to this site, i am learning bryan