Search results

Hi All, Coming back to access after a long break and I'm sure this is a simple one. I have a table (tblPriceList) and a form (frmPriceCalc), the form is used to calculate prices. I need to perorm the following calculation:- txtCPU * [tblPriceList.Unit Cost(£)] where type = Memory At the...

Does Access keep a history of when a record was last updated, and if so can I perform a query on this value. Cheers, Nigel

Hi, I'm exporting a table to a .csv file. The table contains phone numbers with a data type of 'text'. When I look at the csv file strange things are happening e.g Phone number 08705329877 appears as 8.7E+09 if I expand the width of the field in the csv it changes to 8705329877 (miising the...

I've seen a few posts when searching on this but none which solve my problem. Private Sub Combo0_Change() Dim db As DAO.Database Dim rs As DAO.Recordset Dim emp Long emp = Me!Combo0.Value Set db = CurrentDb Debug.Print emp Set rs = db.OpenRecordset( _ "select daystaken from tblholstaken where...

I have a form which has three command buttons. cmdSaveAndExit, cmdExitNoSave, cmdClear. These are the last three controls in the forms tab order. How do I prevent the user from using tabbing right through these controls to a new record. Any help would be appreciated.

I am fairly new to VBA and would like to know if the following code could be simplified using arrays. The code fires on the click action of a SAVE command button. It is checking that all fields have been completed. Any help would be appreciated. Private Sub cmdSaveExit_Click() 'Declare...

I have created an asset database, the main form contains details on all assets. Within the main form there is a sub form, incidents, this details any incidents associated with that asset, the one to many relationship is set up using the asset id. I want to perform searches on such things as...

I have an option group set up for status. 3 toggle buttons:- OPen Pending Closed. If closed is selected an input box requests closers name. If cancel is selected on the input box a message box is issued saying 'incident will remain open'. My problem: If the incident remains open I want the open...

Hope someone can help. I am setting up an employee database in Access 2000. Initially I am just interested in holidays. My sub form (FrmSubHol) has three fields; Holidays Taken =sum([days taken]) Holidays Acquired =sum([days acquired]) Holidays Left = 25 - [days taken] + [days acquired]...

I am trying to code a generic query that will use a year provided by the user on a combo box. The user will select a year (I hope to do this for months as well) then the query will run using the between function. My problem is supplying the dates for the 'Between' statement. Here is one of my...

The text editor doesn't always remove character when using backspace. Is this problem local to me or a 'feature' of Access 2000.

I have a table which requires start date and end date. The feeder form has combo boxes for Start Date i.e day month year and the same for End Date. How do I concatenate the dates and transfer them to the table & ensure the end date is later than the start date. ACCESS 2000 [This message has...