Search results for query: *

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

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

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

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

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

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

On a form I have a combo box that allows the user to select a record. In addition to the combo box, which I want to keep, I want to introduce the use of a bar code scanner to select the record. I have added the field "Barcode" to the table. The combo box is bound to column 1 (productId) If the...

I am using Access 2010 I am suddenly getting the error 3048: Cannot open any more databases The error occurs on the line of code: Set db = CurrentDb() Private Sub SetInUseFalse(TelesalesId As Long) Dim db As DAO.Database Dim rst As DAO.Recordset Set db = CurrentDb() Set rst =...

I need to set up an ODBC connection to a MySQL database I have installed the "MySQL-connector-ODBC-5.2.3" software. I am struggling with the MySQL Connector / ODBC Data Source Connection. Whenever I hit the "Test" button I get a failure message! Can someone please help me with the correct...

I have the table "tblCustomerOrderProduct". Its primary key is the field "CustomerOrderProductId" When I delete a record, from a form, I have certain instances when I need to delete an additional record in the same table. I know the value of "CustomerOrderProductId" for the additional record I...

If a user selects a records on a continuous form, and hits the delete key, I display a customised message is displayed asking the user to confirm if they want to delete the record. Private Sub Form_Delete(Cancel As Integer) Dim response As Integer response = MsgBox("Do you really want to...

I transfer files to an Internet server using the code below. The transferred file is imported into a MySql database, and sometimes records are missing. I need to solve this! I want to begin the troubleshooting by ensuring that the file is transferred 100%. How do I do this? Private Sub...

I want to filter the records in a combo box (cboSupplier) using the In() function. On the form I have an unbound control called "intFilter". It contains the following string: 23, 58 The SQL statement for the combo box is SELECT SupplierID, SupplierName FROM tblSupplier ORDER BY SupplierName; In...

I have the tables: "tblProduct", "tblProductType" & "tblCustomer" Tables "tblProduct" & "tblProductType" have a one-many relationship, using the field "ProductId" On a Customer Order form I want to limit the type of products a customer can order. for example, Customer: * ABC can order ALL...

I have a form that opens just fine. If I open it using a command button on another form it also opens fine. However if I open it using a command button on a 2nd form it also opens fine BUT, the word Calculating...... appears on the 2nd form's bottom left corner and Access hangs. There are no...