Search results

Hi, I have a a sub form where records are viewed but need to change the properties to allow edits and data entry. If there is no current record then the form is not shown and so I need to go to a new record and so was using Using the OnClick Event of a Button on the Main Form. I have tried...

Hi, Maybe this is a stupid question but I am trying to run debug on some code behind a form but everytime I press F5 some Modules screen pops up? Do I have to have some sort of seetings from the View and Debug Menu?

Hi, Can anyone tell me what I have done wrong here please as I cannot get it to work. Private Sub dateTO_Change() If Me.dateTo < Me.dateSTART Then MsgBox "The date you have entered is and earlier date than the Start Date" Cancel = True End If End Sub Thanks

OK, Hvae tried to connect to my db from an Excel speadsheet and understand that I need to change the properties of the Data Link to include the pathway of the .mdw file however I cannot find the right property. Have attached a screenshot of the two forms and would be greatful if someone could...

Hi, I have a combo box that includes 2 columns one being a Autonumber and the other is Name. I want to be able to add a Name to the list but cannot set property of "LimitToList" to No. When I try it says that "The first visible column, which is determined by the ColumnWidths property, isn't...

Hi, Am trying to get this to work but for some reason it doesn't. Can anyone tell me what I have done wrong please? If Me.StartDate >= (1 / 1 / 2006) Then Me.lblContract.Visible = True Else Me.lblContract.Visible = False End If Thanks

Hi, I'm trying to create a stock and ordering system and have a value for number of items ordered named [Quantity] Have a control on a subform that records goods received named [TotalReceived] On the parent form I have a control called [Outstanding] which is obviously the sum of [Quantity] -...

Hi All, Have been trying to create a line graph that compares sickness levels for 2006 and 2007 by month but the problem that I have is that I cannot sort the month's into correct order because: 1. Obviously they are not alphbetical 2. Cannot sum totals in the last query if using actual dates...

Hi, Am trying to create a query for a chart where I can total the employees over time but am having real trouble creating a running total from the "Total" field within a query but cannot seem to get it at all. Total StartDate LeftDate RunningTotal 1 26/03/1957 1 21/03/1971...

Hi, We currently have all our work rosters in Excel and are looking at the possibility of moving them over to Access but am really not sure how to start with the design of the tables.Have been looking everywhere but cannot really find anything that will help me get started. The over view is we...

Hi, Trying to run an append query for a specific record on a subform but won't recognise the subform control. The Master form is fmSickEdit do I have to reference the Master file in the SQL? The SQL for the query is: INSERT INTO tblDisLetter ( SickID, DateAdvisedDisciplinary ) SELECT...

OK what is the obvious mistake here ? It won't run for some reasom and won't keep the brackets either. Private Sub Report_Open(Cancel As Integer) If Me.Date_From = Date Then Me.Date_From.ForeColor = vbRed Else End If End Sub Cheers!

Very New to VBA and keep getting a runtime error, can anyone tell me what I am doing wrong please?:confused: Private Sub Command0_Click() Dim TensorData As Excel.Application Dim TensorWb As Excel.Workbook Dim TensorSh As Excel.Worksheet Set TensorData = New...

Hi, Using code in Access how is it possible to delete an Excel File. Have tried the Kill statement but cannot get it to work. Any advice greatfully accepted!!!:confused:

Hi, I have two tables one tblContract and tblServices. tblServices includes ServicesID and ContractID. If a new service is required to be added for an existing contract I want to be able to predefine the control ContractID on the fmAddNew but because the forms properties are set to Data Entry...

Hi, Have inherited this database and they would like me to come up with some report figures. Trying to add together field values which I thought would be easy......but stangely enough it isn't. Think I need to use a crosstab query but tried the wizard and had no luck at all. Can anyone offer...

Hi All, I have the criteria in the expresion builder: [Forms]![fmEmployeeIntro]![EmpKey] Or [Forms]![fmPersonalDetails]![EmpKey] which should allow me to access the same form from either the fmEmployeeIntro form or the fmPersonalDetails form but whatever form I come in from it requests the...

Hi All, Am using a number of combo boxes as selection criteria for a report. The combo boxes are linked to a table, obviously there will be times when no criteria is required and will want to select "ALL" when left blank. Is there a simple solution ? Cheers

Hi, Having a problem expanding this expression: ContractA: DCount("[EmpKey]","tblEmployees","[StartDate]<#01/05/05#" & " AND [LeftDate] Is Null") That works great but when do the expression below says syntax wrong......WHY? ContractB...

Hi, Have been developing an Employee DB which includes sickness records and interview information. Have mangaged to sickness records but now I need to link interviews to these specific records which is where I am having a problem. All sickness records are shown on a sub form and I attached a...