Search results

I am not sure I understand the benifit of a FS / BS System? I mean wouldnt I have to secure both the front and back part of the system from getting access? Please explain! Where would that be if I had that version? And I am very aware of backing up I have a macro setup so that everytime the...

I created a big database program for a company. I want to protect it so that if any changes need to be made they have to either pay more or contact me to do so, I want to make it so that what they use is the user end version that is not editable or changeable but they can of course still use...

well I was hoping cause I use the same button in 5 forms or more and every time I change 1 thing I have to change it 5 times which is why I was hoping I could create a module to do the same and only have to change it once and all would be reflected

I see I was just hopeing this would work, I have 6 buttons in 5 forms the 6 buttons are always the same but are form dependant (needing info about the form) for example Private Sub Print_Preview_Click() 'Button On Error GoTo Err_Print_Preview_Click Dim stDocName As String Dim...

Ok is there a way of making it know what form is already open so if the form name is myform then it would automatically be Forms![myform].Refresh but if it was notmyform then it would be Forms![notmyform].Refresh

I created a function and wanted to use Me.Refresh what would be the equivlant for a module?

It does help! ;) However I just need more guided advise lol :D

Ok so what you are saying is to create a module and reference to the module everytime I want to use that perticular button?? but how do I make code form generic like this one Private Sub Email_Critical_Criteria_Report_Click() On Error GoTo Err_Email_Critical_Criteria_Report_Click If...

I use the same buttons in almost all of my forms none of them change is there a way of only having to write the code once and reference it on all of them so that if I change it! the all change here is the code that is looped Private Sub Previous_Record_Click() 'Button On Error GoTo...

Ok so I made a desision and decided that it will open the report instead of the form solves the need to change filter problem however my syntax is incorrect and I need help I have tried this DoCmd.OpenReport "Inbound_Report", acPreview, , "[Inbound.tblInitials] = """ & Me.tblInitials &...

Thanks for the clean up however it doesnt solve the original problem I still cant go to previous record or next record because of the tblrround being filtered to 1 record Is there a way to stop the 2nd half of the filter I have tried show all records but that wont filter the name

The following code is used to open a form with specific criteria problem is that once the criteria is met and the form is open if I want to goto the next or previous record of that employee it wont let me how do I remove the second part of the filter once its used on open DoCmd.OpenForm...

where it shows this tblInitials Inbound Inbound.tblRRound Outbound Outbound.tblRRound Critical Criteria Data Helpdesk IRO AAS 2/10/2004 1 3/23/2004 2 AAS 2/10/2004 1 6/29/2004 3 it should show this tblInitials Inbound Inbound.tblRRound Outbound Outbound.tblRRound Critical...

but I need one that shows all 5 or do I need to make 5 individual ones and call them accordingly

the following sql doesnt quite do what I am tryinh to achieve SELECT DISTINCT Employees.tblInitials, Inbound.tblDate_Review AS Inbound, Inbound.tblRRound, Outbound.tblDate_Review AS Outbound, Outbound.tblRRound, Critical_Criteria.tblDate_Review AS [Critical Criteria]...

the other program we use at work when the esc key is pressed it closes the window so I was trying to make them the same

Thankyou for the info if anyone knows a way to turn of the default for undo with the esc key please dont hesitate to post it

That seems to work however when i use the esc key it undos the change and doesnt work right but I changed it to the spacebar just to test and it works great why is the esc key being a problem?

If I put checkme = true on the command like that even if data has not changed it will ask I only want it to ask when data has changed? reason for the before update

When I use the following code it does not run the before update Form_KeyPress Private Sub Form_KeyPress(KeyAscii As Integer) If KeyAscii = vbKeyEscape Then DoCmd.Close End If End Sub but when I have it run through this code CloseForm_Click Private Sub CloseForm_Click()...