Search results

Hi, I want to be able to program some sort of security for a database I have created. There is allready code in the database that detects the domain username, so I was thinking of creating a table that holds info on each user and what forms they can access and certain options that they can do...

Hi, When i try to create my own variant of this code for my database it tells me i don't have the required license to use this activex control?!? What do i do?

Yay!!!! All fixed, the 'AR_Number' field was set as 'TEXT' in the table when it should of been a 'NUMBER' Thanks all!!

Thanks for the code, I gave it a shot and got the error 'Data Type Mismatch in criteria expression'. It gets futher than it did before the second form acctually opens but after the error only bring up the first record.

Here is my code for the main form, including how the listbox gets its data: Option Compare Database Option Explicit Private Sub Form_Load() Dim strSQL As String If Me![lstAR].ListCount > 0 Then strSQL = "SELECT tblAR.* " _ & "FROM tblAR " _ & "WHERE...

*bump* i'm still lost

Hi, Thanks for your help. I tried that code but got the same error. There isn't really any other code on the form as of yet, so i'm not sure what other code could be causing a problem. Cheers

Hi All, Trying to open another form from a list box and have it carry the value over to select the correct record. But i keep getting 'The operform action was cancelled' error. My Code: Option Compare Database Private Sub lstAR_DblClick(Cancel As Integer) DoCmd.OpenForm "frmMaint"...

Wow Wow that works great. Your assumptions were pretty much correct except for: A Branch can belong to more than one division & I only wish for the department code to be saved to the table. At the moment I have it all working apart from after the department is selected the department code...

Hi All, Having a little problem with my combo box setup. I have 3 combo boxes, 1st is division, 2nd is branch, 3rd is department. They all refer to a table which has 4 fields... they are the 3 I just mentioned and a 4th which is the department code. The 3rd combo box contains the last to...

Hey Tim, I couldn't get that code to work, not familiar with that stuff yet... Thanks anyways

Hi Wayne, Tried that, still the same as before. Updated code: Private Sub Form_Open(Cancel As Integer) If Form.RecordsetClone.RecordCount > 0 Then MsgBox "There are no requests awaiting your approval" Cancel = True End If End Sub

Hi All, I have a form that will sometime contain no records for different users and I want a mesage to appear when there are no records waiting for them. I have code in place to close the form when they run out of records to approve, so I copied that code thinking it would work on the form...

Thanks again Wayne, the scroll thing works fine now :) Not quite sure what you mean about the clone recordset tho, I had a look in the help files, but couldn't make heads or tails of it. Cheers, Ryan

Is it possible to save data to a field which isn't on the form Say i have an inputbox and want to data to be stored in a field that isn't present on the form but the table the field is on is part of the control source. At the moment I just have the field on the form but hidden, this is not...

Just an update: The code works nicely for the approval button, but I can't quite understand where to put the other code you described. Couple of things tho, with the approval button it has an error when there isn't another form to goto, is it possible for it to just close the form and display...

Thanks for the reply :) I want to keep some order to the approval process so would rather they finish with there first record before moving to the next record... So my theory is once they have approved/declined the record won't be vaild in the query (as the query finds unapproved records only)...

Hi All, I have a form where a user reviews a request or declines it, they have a approve and decline button to choose from. The results that are shown to them are from a query which breaks it up into requests that come under there control. What I want is for when they click approve or decline...

Hi All, I'm just wondering weather the 'Switchboard' is a feature in access 2k? I'm making a db that will be running on runtime 2k and I'm using 2003 for the development (2000 file format) and want to know if I can use the switchboard feature still. Cheers, Ryan

Hi All, Thanks norm that worked great, all appears to functioning correctly now! allthought I had the same problem with the DoCmd.GoToRecord , , acNewRec command, so I removed it and all appears to be working fine now :) Ryan