Search results

In the attched spreadsheet I have a master Tab, where I copy all the data, the type column is the identifer of each row. There are two things I need to do and have no idea how to do it, 1) split the data from the "Master" tab into its repective tabs (based on type) the key here is to split the...

Hi all I am trying to set up a simple db which records errors that occur on a systems. These are the fields required Error Title Date occured Fix 1 Fix 2 Comments I am not sure how to design the tables so that each title is unique and references a the fixes any help would be great thanks

To find all records that begin wih a a certain Number do I use this dim rst as recordset set rst = Me.recordsetClone rst.findfirst "EmpNo = " & seach *

I have a sub form which shows data of orders. I want to have a button on the main form that will loop through the records in the sub form and check that there are no null values. can some one explainm how to do this thanks

If you select to open a form from your custom menu bar, can you close the form that you were previously on thanks

I have a "general" menu bar with some common fucntions that are used on every form I want to be able to apply different functions to the same button and then using Screen.active method the correct function will be called for the right form I have no idea how this works so any help would be...

I am using this code to delete a record Private Sub CmdRemove_Click() If MsgBox("Are you sure you want to delete Part Number " & Me.PartNo & " from the order", vbYesNo) = vbYes Then DoCmd.SetWarnings False DoCmd.RunCommand acCmdDeleteRecord DoCmd.SetWarnings True Me.Requery Else End If End...

Hi i have a button on a main form that confirms an order In my you can add parts to that order.if the user gos to add another record, but then dosent. When i press the confirm button is brings up my default error is method to put on the confirm button in the main form, that when pressed will...

when you have searched for a recod is there a way to highlight the fields in say "yellow" once they have been found

I have a table of customers. In the customers table there are details like, Name, Address, Telephone and discount. What I want to do is when a new customer is added their discount is 0 every 5 times they place an order their discount increases by 1 (which means 1 percent) and ideas thanks

Hi I have a main form which display customer info, I then have a subform (sub1) which displays each customers order numbers. I then have a second Subform (Sub2) which shows the contents of each order. In am trying to link Sub2 to Sub1. In the Linking fields. I used...

I have a form that is filtered, i then have a search which allows the user to select a record form a combo box, at present all the records are shown in the combo box . Can i just show the records remaining after the filter in the combo box

I am not sure if u can do this, I have a sub form, which shows a list of cars. I want to put a chk box in the sub for each record to state whether it is clean or not clean (True, or false) I don't want to store the value in a table, but when u change on chk box the rest of them change ??? will...

I keep getting the error 2467 the expression you have entered refers to an object that is closed" how do fix this thanks Private Sub CmdDelete_Click() If IsNull(Me.CustomerNo) = True Then If MsgBox("Press Yes to start a new order, Press No to go back to the Main Menu"...

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