Recent content by Neo

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 *

it almost works but still only check the first line

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...

sory and another going back to the first.. can you get in to highlight a specific bound txt box in a sub form " i.e.the current record rsther than the whole lot

Thanks thats great. Can I ak another question? I have a report that show what each saleman has sold and the total profit they have made. can I put a button on a form whcih will print of the the saleman report with the highest profit

sorry.. form View

how do you mean

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