Search results

The way I have it at the mo is A manager who has access to all levels is assigned a "0" Sales staff are assigned a number frm 1-what ever the forms then use a Case Select method Case 1 show only salesman 1 data When I go to add new users. If the user is a manager then are assigned a 0 if...

I have a table which is used for access levels there are two types If the user is an operator they are Assigned a Number i.e. 1 If the user is a administrator the are assigned "Manager" In a form that allows certain users to update this information I have a combo box wher I can select if...

I am developing a sales Db. for each that is added, is the date is was date it was generated. I have a report avaiable for each order. I have a dlg box with txtdateBegin e.g. 01/01/01 and textdateEnd e.g 01/03/01 How do you filter the reports between two dates. Thanks

I am trying to update a set of records using the folowing Private Sub CmdUpdate_Click() Dim strSQL As String strSQL = "UPDATE Link SET Status = Forms!frmMain!SubfMarks.Form.status.Value WHERE Employee = Forms!frmMain!SubMarks.Form.Employee.Value" DoCmd.SetWarnings False DoCmd.RunSQL strSQL...

Hi I have a word document that is saved as a HTML doc. How do I open it from my DB. it is in a certain folder thanks

I have a sales order form. The user adds parts to a customers order. The form then calculates the total price using this formula Total Price = Sum([SellingPrice])*([Quantity]) the problem is that is the user add parts to the order and the Quantities are are the same e.g. one of every thing it...

Hi What is the difference between On Error Goto & On error Resume Next How do you know when to use one

I am trying to reset/requery a form from another form I am using Dim frm As Form Set frm = Forms!SubInvoiceLines1 frm.Requery but this dones not work it states that it can not find the form SubInvoiceLines1 is a sub form of frmMainOrder Thnaks for any help

hi I am using this code to call and apply a filter. If the are no records that match the filter search then i would like a msgbox that tell the user so and the form show all the records. At present is there is no records when the filter is applied I get a blank form. Public Function...

I have a form that has a list box on it. The list box has two columns User ID and Password and is called ListID On another form I have to fields (frm Password) txtID txtPassword I want to be able to double click on the record in the list box and the data is place into txtID and txtPassword...

Hi I am using a group of options to in a dlg form to filter records in a report, when the suer click a option the appropiate combo box appers and they can make a selection. They press ok and the report comes up, If the press the button again to open the dlg form. the default option is selected...

Hi I have a form which lists employees. Each employee record has a link to a folder on my computer that contains a picture of the employee. I use a picture frame to = the field that contains the link eg C:/Mydocuments/Mypictures/Emplyees.... The problem is that this folder is not stored in...

hi Is there a way to press a button on a form and lock all the field from the recordSet in the in that form

Hi I am trying to set a field on a sub form to locked. From another form. I am using dim frm as Form SET frm = Forms![MainForm]![SubForm] frm!Payment.locked=true But it does not work, Any Help

I am using the following code in the OnCurrent event of a Subform The code looks a the field Module Result and if the field is Null or = 0 it is ignored else it increments a count The problem is that if you select a record on the Mainform And the field Moduleresult for all the related...

I have also tried to do this I used Do Until EOF = False DoCmd.GoToRecord , , acNext But did not work Any suggestions?

Hi I have a DB which is used by lots of different PC with different Screen res. Is there any code that will detect what the DB was designed in and change the computer to that res Any ideas?

I want to do this but not sure how to code it If me.chkUser = True Then MsgBox " Do you want to update If yes then Run SQL If no Dont run SQL thanks in advance for the help

on the form it is the button I am trying to hide

I have a form which asks the user to enter a user ID and Password. This form then performs a Dlookup and then opens a the form "Master" The form "Master" Is set up with CASES Case Admin Case User On CASE Amin Complete access is given On CASE User Not all forms open and on the forms that...