Search results

Hi I have a formula constantly calculating in Cell M3 I would like to make a record of this every 30 seconds in column P Thanks

Hi if you can help i would be really grateful I have worksheet with 6 columns for each row of information. If I type say the number 3 in the status column, then the row of information should transfer to a separate 'closed account' worksheet, and automatically filter by date. There are formulas...

Hi I was wondering if anyone could help. I am trying to write a formula and not sure whether the IF function is the correct one. I would like the following: If say cell A1 has a range of -10 to 10 then Cell A2 will return a 0, if it is between 10 and 15 retrun a 1 and if over 15 then return...

Hi I would like some help with the Vlookup function and I will try to explain as best I can. I have sheet that lists company names in one column and then costs in another column. e.g company 1 - 1200 company 2 - 1300 company 1 - 1000 company 4 - 300 company 1 - 600 etc On another summary...

Hi I would like to specify more than one criteria of an if statement. e.g, if = ? then ? but i would like to add more critreria as i have more than one selection in my combo box. Thanks in advance

Hi I double click a combo box which takes me to a new form. e.g. a purchase order form does not have an employee so they need to be added. When the employee form is closed i would like to refresh to combo box so the new employee appears in the combo box. Please help Thank you

Hi I have recently started using queries to base my forms on. Even for basic forms i am using the query as the record source. If for example i have a standard query with no criteria e.g. a employee form. How would i then use that query to create a report that filters for example a list of...

Hi I am wondering why you would use a query as the record source in s form and not a table? could someone just clarify this for me - or point to where i could read up on this to uderstand it better. Thanks Another quick one - when for eg. i have two table linked - do i select the foreign...

Hi I am trying to set up a table structure for timesheets. I have read through the forums and found some good advice connected with what i can do to develop the db, however i am having trouble with the table structure e.g. in a day you can work RT, OT & DT. I have a tbltimecard which will be...

Hi I have a timesheet db. An employee can have upto classification for hours - 1. RT - Normal time 2. OT - Over time 3. DT - Double time I have a main form which the theme is on the task and per day and this can have many employees, which is the sub form. If someone works RT, OT in a day it...

Hi Appreciate your help in advance. The db is related around timecards. I have a tblcompany & tbl employee, these are not linked (maybe they should be) but tblcompany is linked to tbltimecard. Tbl timecard is linked to tbltimecardhrs and tblemployee is linked to tbltimecardhrs. Now...

Hi Could someone help with showing me how to sync a DSUM to a record as i am currently summing all the records instead of the ones i need? Thanks

Can anyone tell me how i disbale mosue wheel scrolling in a form? Thanks

I would like to do an in stock query on the database. I have 109 products, however only 91 have had transactions against them in the transactions table.. I would like the query to report the 91 records stock take and show the rest as zero stock. this table as # ordered, # received, #...

Hi If you could help that would be great. I have a main form which has two sub forms: Main form has the following calculated fields: 1. Units in stock=[Products Subform].[Form]![UnitsInStock]-[stockcontrolsubform].[form]![netstock] 2. Units on order=[Products Subform].[Form]![UnitsOnOrder]...

Hi I have a combo box to select a record on a form. I would like then record to lock once it is selected via the combox box and the combo box to clear. If a records is slected again from the combo box it will then show the new record and lock it again. The problem is users are sometimes...

Hi If you could help that would be great. I have a main form which has two sub forms: Main form has the following calculated fields: 1. Units in stock=[Products Subform].[Form]![UnitsInStock]-[stockcontrolsubform].[form]![netstock] 2. Units on order=[Products Subform].[Form]![UnitsOnOrder]...

Hi Ihave the following code Private Sub QuauntityOut_Enter() If IsNull(Me![EmployeeID]) Then MsgBox "You must enter an employee and transaction type before you can book stock in or out" Me.EmployeeID.SetFocus End If End Sub I would like to add another control that If IsNull after the...

Hi I have a datasheet subform on an unbound form. but the data on the subform will not sort in ascending order. I have used the ORDER BY in the table and form but it still will not do it?? Thanks

Hi If you could help that would be great. I have a main form which has two sub forms: Main form has: Units in stock=[Products Subform].[Form]![UnitsOnHand] Units on order=[Products Subform].[Form]![UnitsOnOrder] 1st Subform - Products Subform has the following hidden controls. Units on...