Search results

OK Luddite is back again, now with the following issue......... Database access is configured to an individual's SAPID and logon is managed through Environ("USERNAME") linked to the SAPID. I have now created a Form for assigning actions to individuals, but I want the individual user to only...

this is the code that is in the main form (frmMOS-main) Option Compare Database Option Explicit Dim intCurrent As Integer Dim intPrevious As Integer Private Sub TabCtl0_Change() If IsNull(Me.Title) Then MsgBox "Title cannot be empty", vbExclamation Me.Title.SetFocus End If End Sub Private...

Nope :-( tried that a few times last night, still opens up the main form to a new record. :-(((

Yes I want the form to always open to MOSID 5 for everyone and not be specific to any individual user

The confusion here is that this code is for the login screen. The login takes the SAPID from the employee table and matches it against the computer ID with environ ("username") then when the database opens it opens the main form. When the main form opens I want it to go to a record defined by...

The form opens fine with the existing code ( Guess I didn't explain myself properly) When the form opens I want it to go to a specific MOSID (not a SAPID) but it always opens to a new record What I want is the form to open up to record (MOSID) number 5

No the SAPID field is in fact text (Some people have names) The MOSID (which is what I'm looking to find) is numeric. SAPID is purely for logging in

Can't get this to work :-( Here is my basic code: Private Sub btnlogin_Click() Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("tblemployee", dbOpenSnapshot, dbReadOnly) rs.FindFirst "SAPID='" & Me.txtSAPID & "'" If rs.NoMatch = True Then MsgBox "You are Not Authorised to Access This...

OK Tried a few things and its not going according to plan :-( Created a table called tblApprover, which has all the people that can approve quotes and their SAPID, which is the Environ ("USERNAME") The combobox pulls the data from tblApprover depending on how I write the code I can either allow...

Yep works perfectly thanks. As to why I'm doing it in short I only want 3 people form the list of 20 employees to be able to choose an approver for the quotations, just seemed doing a requery worked and ensures that the combobox doesn't list an entry Like i said, probably not the best way but...

Its the Luddite again here, database is working ok but now want to add a few tweaks. I only want certain people to be able to approve a quote and it almost works but when I add more than 1 ID I get a mismatch error. This works fine: Private Sub Approvedby_Click() If Environ("USERNAME") <>...

sorted!!!!! thanks so much

so how do i fix it? can you fix it and send it back and I can look at what you've done and copy it into my master file?

ok not sure what happened there and again getting closer, but the disciplines still don't match the tasks, see attached

OK getting really close now so progress indeed, I don't get the error message any more, but...................... now the requery macro doesn't work so I can only see the same list of tasks for any of the disciplines. Updated DB attached You must think I'm so thick:eek. :banghead::banghead:

OK, Remember the bit where I said I was a luddite. Tried using this but it comes back with..... Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', or 'UPDATE'. AS you can see I really am dim at this stuff, but so close now to getting this going which is why its frustrating

Tried that still doesn't want to work&#55357;&#56875;

Hi I've built a DB in access from scratch and almost ready to start using it but have one last problem to solve. In the attached completely stripped back DB I have the following issue If you open frmTaskDetail you can see that if I choose a discipline I can match the tasks to the discipline...