Search results

Since the code is written using a wizard there not setwarnings parameters(at least that I can see) in the code or anywhere in the module itself.

I created a command button from using the wizard so when I click to delete the record the button is for, a window pops up asking if I am sure I want to delete the record. Is there a way to not have the button pop up? Here is the code: Private Sub cmdCompleted_Click() On Error GoTo...

I currently have this code that opens a form when the button is pushed, Private Sub cmdWorkOrder_Click() On Error GoTo Err_cmdWorkOrder_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "New WorkOrder" DoCmd.OpenForm stDocName, , , stLinkCriteria...

I sincerely thank you for all your help. Unfortunately when I took this job these databases already existed and they are so intertwined and spiderwebbed it is extremely difficult to muddle through them. I have built a few of my own(very simple) databases that don't require as much to administer...

I was wanting the bay number and reason code info to show in the: Description of work to be performed box. The date would not need to be entered. I have included the work order table.

The button on the frmBayDownReport that says open new workorder is the button i am trying to get to add the data from the frmBaydownreport to the new workorder form. I have enclosed a copy of the db.

I created a form that when it opens it shows data from a query linked to a table. On the form I have a command button to opens a workorder form that is used to create work orders. How can i get the information from the new form when it opens to be copied over to the work order form when I click...

Thank you for clearing that up!!

I was wondering if Delinquent: IIf(Date()>DateAdd("d",[Date Generated],[# of days]),"Y","N") this means....... If the current date (Date()) is greater than the DateAdd- which is a combination of the day, Date Generated, and # of days = yes this it is deliquent otherwise it is not?

I apologize for being confusing. Right now on Sunday night/Monday morning at 12:01 AM we have scheduled PM's that print off when the database is opened and I am trying to change that to print off on Sunday morning/Saturday night at 12:01 AM

ok... so if I change that "1" to a "7" then the PM's will generate on a Saturday when the db is opened initially instead of the sunday they are currently generating on... thank for all the help!!!

so what you are saying is that 'decide which version to use If DatePart("w", Date) = 1 Or DatePart("w", Date) = 7 Then strQuery = "PM Print List Append Weekends" Else strQuery = "PM Print List Append" End If the "1" in this code annotates Sunday...

One question I do have though... 'decide which version to use If DatePart("w", Date) = 1 Or DatePart("w", Date) = 7 Then strQuery = "PM Print List Append Weekends" Else strQuery = "PM Print List Append" End If I believe... if I am reading this...

Thank you. I believe I found what you are referring to.... Option Compare Database Option Explicit 'module to auto-generate PM's into table 'is run by the timer on the switchboard form 'note this means that the first computer to 'run the switchboard after midnight will auto-generate. 'last...

I was wondering.... If I wanted certain forms or reports to print out at a certain time each day without any user interaction where would I go to do that? Would it be in vb code, in the actual form or report, or somewhere else?

I realized what the issue was. When a new switchboard option is created, users have to be added in order to view the page. The vb code was setup before I took over and I didnt realize that is what was happening.

I have a switchboard that has been in use for many years. Within the main switchboard I have many sub pages that open forms, etc. On one of those pages I added another option in order to open a form, but when I go to use the switchboard and go to that page, that newly added option is not showing...

I didnt realize that the DoCmd.OpenReport "Daily Production Rpt -1st shift", acViewNormal would actually open and print the report at the same time. Answered my own question.. How cool is that?

I am trying to print some reports through vb Private Sub Command173_Click() DoCmd.OpenReport "Daily Production Rpt -1st shift", acViewNormal DoCmd.PrintOut DoCmd.Close acReport, "Daily Production Rpt -1st shift", acSaveNo DoCmd.OpenReport "Daily Production Rpt -2nd shift"...

If I have a procedure that says Private Sub Form_GotFocus() DoCmd.Maximize End Sub and a procedure that says: Private Sub Form_Activate() DoCmd.Maximize End Sub within the same forms vba, dont they do the same thing by making the form they reference the maximum size?