Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by DevelopV

  1. DevelopV

    Limit Editing In Subforms

    I can't find the AllowEdits property!
  2. DevelopV

    Limit Editing In Subforms

    I have a form called "frmOrder" It contains a subform called "frmOrderProducts" "frmOrderProducts" has a sub form called "frmOrderProductDeliverySchedule" "frmOrder" has a boolean field called "bolPO" If "bolPO" = True then I don't want the user to be able to edit any records in...
  3. DevelopV

    Union query - place data into an imaginary field

    How do I get SupplierProductId to show as long integer?
  4. DevelopV

    Union query - place data into an imaginary field

    Found the solution!SELECT tblRecipeIngredients.RecipeId, tblRecipeIngredients.SupplierProductId, "" as OwnRecipeId, tblRecipeIngredients.Quantity, tblRecipeIngredients.DenominationId from tblRecipeIngredients UNION SELECT tblRecipeOwnIngredients.RecipeId, "" AS SupplierProductId...
  5. DevelopV

    Union query - place data into an imaginary field

    I have two tables: tblRecipeIngredients fields: RecipeId, SupplierProductId, Quantity, DenominationId tblRecipeOwnIngredients fields: RecipeId, SupplierProductId, Quantity, DenominationId I want to create a union query that includes the "imaginary" field "OwnRecipeId" Records from the table...
  6. DevelopV

    Only allow specific Excel cell ranges to be edited from Access

    I send data to a new Excel spreadsheet. I would like to prevent wholesale changes to the spreadsheet by: * preventing column / row deletions / additions * only allowing certain ranges of cells to be edited. how can I accomplish this? Many thanks in advance
  7. DevelopV

    Use Excel MS-Query from within Access (2010)

    I want to make use of Excel's MS-Query, but would like to automate it from an Access DAO module: Data To Excel 1. Export a table into Excel using MS-Query 2. Declare the Excel cell where MS-Query will begin 3. Select a range of cells in Excel, merge them and insert text 4. Select a column and...
  8. DevelopV

    Create Speadsheet Type Form Showing Historical And New Data

    Hi lameid Thanks and sorry for late reply. I have the following fields in the table "tblProductionForecastData": ProductId Quantity MonthYear I want to show the data in a spreadsheet format with: ProductId as row MonthYear as column Quantity as data. Similar to crosstab query, BUT: 1. I...
  9. DevelopV

    Create Speadsheet Type Form Showing Historical And New Data

    I am using Access 2010 I need to create a production forecast form based on previous sales history. The history is based a sales and grouped by month & year So on the form, which needs to be a continuous form, I want products to show as rows and months as columns The sales history per month...
  10. DevelopV

    Check Fields In An Append Query

    Rather than have a append query, can I not simply use: docmd.RunSql "INSERT INTO tblArchive SELECT * FROM tblOriginalData;" Provided the field names are the same in both tables, job done? I have tested this and it appears to work. Is this correct?
  11. DevelopV

    Check Fields In An Append Query

    I have code to get a list of all the fields in the original and achieve tables With this I can ensure that each field in the original table exist in the achieve table and thee field properties are the same. I now want code to look at the append query and ensure that each field in the original...
  12. DevelopV

    Check Fields In An Append Query

    I have the need to archive data in certain tables. To do this I run an: * append query which adds the data to an archive table. * delete query which deletes the records from the original table. I run code that compares the the structure of the original table to the structure of the archive...
  13. DevelopV

    Send command to RS-232 serial port

    no, because I don't know how too!
  14. DevelopV

    Send command to RS-232 serial port

    Using Access 2010 How do I send the command "^G" to a device conencted via serial port (RS-232) number 3? Many thanks

Part and Inventory Search

Back
Top