Search results

  1. C

    Populating Textbox Within Embedded Form on Tab Control

    I have a sub form (SubForm1) embedded in a Tab Control on Form1. Subform1 includes a text box called Date1. When the user clicks in Date1 a Calendar form opens. When the user selects the date on the Calendar the date should be populated in Date1. Instead of that happening the following error...
  2. C

    Display actual chart data in design view

    I have created a report that consists of a line chart When I view the chart in design view (including the datasheet) the data that feeds the chart is not displayed. Instead some default data on East, West and North is displayed. I need to see the actual data in design view as I need to format...
  3. C

    Sum Daily Data into Rolling Weekly Totals

    I have a table of data which contains daily sales achieved by employees I am trying to put together a query that sums each employees sales into weekly totals: Week1 Week2 Week3 etc. John 12 7 8 etc. Paul 6 12...
  4. C

    Query Output To Update Table

    I have two tables, A and B I currently run an update query which updates table B with data from table A. Table A is constructed using a make table query. The question I have is would it be possible to update a table directly using the output from a query? If so a point in the right direction...
  5. C

    Query Criteria From Table

    I have two tables, table 1 contains 3000 staff records and table 2 contains 300 staff id's. I need to configure my query so that when it runs the staff records are returned not including the 300 staff id's in table 2. I thought this would be as straight forward as pointing the criteria to the...
  6. C

    Identifying and replacing numbers in string

    I have a table containing names and addresses. I need to replace the house numbers of the addresses with asterisks- 35 John Road 891 Gray Street Update to * John Road * Gray Street How would I achieve this?
  7. C

    TransferDatabase method with linked table

    I have an odbc linked table in database one. Using the transferdatabase method I want to copy the table into database two as an embedded table (not linked). I have tried to do this but an odbc linked table appears in database two. Database two will be sent to users who are not based on the...
  8. C

    Automate MDB to MDE Conversion

    I have over 30 databases that must be sent to external users on a daily basis. The databases must be sent as MDE files. The current process is to manually convert them. Is it possible to automate this task using VBA? A point in the right direction would be appreciated. Regards C
  9. C

    Save Database With New Name And Then Close

    I have a database called Control.mdb. A form within control.mdb opens a database called Template.mdb using the following code. Dim appAccess As Access.Application Dim dbPath As String dbPath = "C:\My Documents\Template.mdb" Set appAccess =...
  10. C

    Update Query On External Table Without Linking

    Is there any way of updating an external db table without using file-get external data - link table? Thanks GC
  11. C

    Error When Inserting Null Value Into Numeric field

    I have several text boxes which hold numeric values. Using an INSERT INTO query (which is activated on a button click) the numeric values are inserted into a number fields within a table. If one or more of the textboxes are empty and the button is clicked an error is returned. I have set the...
  12. C

    Run Time error with Update Query

    I have the following piece of code that updates a field in a table with a selected value from a list box Dim varItm As Variant If IsNull(Me.tb_Other1) Then DoCmd.RunSQL "UPDATE Tbl_Section_1 SET Tbl_Section_1.ProgUsed =" & Me.Lb_Programmes.ItemData(varItm) & _...
  13. C

    Displaying all records in a form from an open recordset

    I have the following piece of code that returns data based on the value of ComboBox1 Combobox1 contains a list of numeric values that also include operators. the list is as follows: <=100 <90 <80 <70 <60 Dim Rs As ADODB.Recordset Set Rs = New ADODB.Recordset Rs.Open "SELECT Table1.* FROM...
  14. C

    Error when concatenating combobox value to SELECT query when opening recordset

    I have the following piece of code behind a combobox on a form in Access 2003: Dim RS As ADODB.Recordset Set RS = New ADODB.Recordset RS.Open "SELECT field1, field2, FROM table1 " & _ "WHERE field1 =" & Me.combo1, _ Application.CodeProject.Connection, adOpenStatic...
  15. C

    Drop down list data for query criteria

    I have a drop down menu within a form that lists operators that will be used as criteria for a query. The list is as follows: <=100 <90 <80 <70 I have a query with a field called score. Using the expression builder the query looks at the selected value in the drop down list and filters the...
  16. C

    Opening Continuous Form as Report

    I have a continuous form set up that returns data on over 100 records. I have set up a command button that opens the form in a report template. The following code triggers the report: DoCmd.OpenReport "Rpt_Test", acViewPreview, , "[cohort] = [Forms]![frm_pupil_dets_ndcArea]![NCY]" The...
Back
Top Bottom