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!

Search results for query: *

  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
  15. DevelopV

    Is Printer online?

    I am looking for code that will return the status of a printer. I need to know if the printer is turned on and is online so that I can print a report to it. The printer is NOT the default printer. Thanks in advance
  16. DevelopV

    Fill conbo box with list of fonts, including font file name

    Most of the code shows how to get a list of the fonts. What I am struggling with / cant find, is how to obtain the fonts file name. Thanks
  17. DevelopV

    Fill conbo box with list of fonts, including font file name

    In Access 2010, I need to a list box to return all the fonts installed on a computer, including the fonts file name. How do I do this? Thanks in advance
  18. DevelopV

    Compare Dabases: Get Properties Of Each Field In A Table, Access 2010

    To help when when developing on an active database, I use the following to compare the fields in all tables in 2 databases. Function TableInfo() Dim PrimaryDatabase As String Dim SecondaryDatabase As String Dim Response As String Dim Table As String Dim TableNumber As Integer Dim TableCount As...
  19. DevelopV

    MScomm32.ocx not avialable in Access 2010?

    I need to send commands to an external device using a serial port. My understanding is that that I need to select the reference to the Microsoft Communications Control (MScomm32.ocx). But is not available in the list of references! What do I need to do? I am using Windows 7 64 Bit & Access 2010...

Part and Inventory Search

Back
Top