Search results

i need to automaticly Generate a Primary key for RMA Numbers so i want Previous forms number + 1 and i want to start with Number 10832.

take the easy way out like i do, make a hidden form

i want the user to have to change the location of an item if its location is at the wherehouse how do i pause it till the user presses "ok" on the popup form? Private Sub Command6_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("Main...

Create a Query and have the Criteria set to the team. You can do this several ways but the one i suggfest is create a hidden form to "Store" information on the person who is logged in. and point the criteria to the test box on that hidden form. (to make a form Hidden make another form open it up...

Your wisdom is infanate.........anyone care to actualy answer rather than killing time with open ended answer....

How do you create a button and attach a macro to it? PS. im using 07

How can i have multiple people entering data into a database, also there is an excel file that imports the info every few min, if i have that open i cannot enter data into the database. theres going to about 4-5 users plus the excel file.

Make a Query see my post here http://www.access-programmers.co.uk/forums/showthread.php?t=147161

no, you cannot export filterd data, you have to make your subform a query Add the items you want from your table then in the blank Rows Put a expression in the field row, [Your Field name in the query]=[Forms]![Your Form Name]![Control on form] Or [Forms]![Your Form Name]![Control on form] Is...

what ver of access are you running?

Humm what i did was, linked the data to excel because the data will be munipulated in meny diffrent ways and wrote this macro in excel dose not work tho, it loops fine, but i cannot get it to store vales in cells, or lookup values that calculated Via (counta) Sub A() Dim WB As Workbook Dim ws...

Turnover rate is [number of employees that left that month]\[Number of current employees] so it would have to work out as : [number of employees that left that month]\[Number of employees the previous month]

the nuts and bolts of it im trying to figure out turover rates for each month. i have List of employees and there start and end dates and i need to get the turnover rates for each month. this has proved to be more difficult for me that previously thought how is a better way of going about this?

Trying to compare start and end dates using a query so this is what i have but nothing is comming up wrong way to go about this? i need to do this for every month till 2012 Expr1: [Start Date]=[Start Date]>1/1/2008 Show: No Criteria: True Expr2: [End Date]=[End Date]<1/1/2008 Show: No...

thanks bob!

How do you hide, unhide a dropdown or object in VBA?

What in the VBA code to delete current record?

so im trying to replace some data on the subsheet on its current record, on update of a combo box i want to update a race number. Private Sub Race_Number_AfterUpdate() Dim Racenumber As String Dim Current As String Racenumber = "" Current = "" Racenumber = Forms![Stats]![Race Number]...

There is a paperclip button that you can use to put attachments on your post Click on go advanced and click the paperclip. It will have to be in zip format, just right click on the file ->send to -> zip file. As for your part numbers and specs, not relate them by serial number if your doing it...

you use the Relationship manager to link the "Part number" field on all 3 tables, make a form for each of the tables so you can add/edit the information. On the material and specs forms make a dropdown that is bound to the part number field on its respected table, then lookup the information...