Search results for query: *

I can't find the AllowEdits property!

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

How do I get SupplierProductId to show as long integer?

Thanks PHV!

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

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

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

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

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

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

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?

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

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

no, because I don't know how too!

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

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

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

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

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

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