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...
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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.