Search results

I have a report showing products and their selling prices Most products have only one selling price, however a few have more than one selling price To cater for this I have created a group called "Products" The selling prices are then in the reports' "details" section. Works well, except that...

I tried this but it returns: ArialBd.ttf for Arial Bold Arialbi.ttf for Arial Bold Italic Not very helpful to the user

I need to give users the ability to change the font of a field in a report. The field shows a barcode. I thought of using the CommonDlg class to show the Windows font-selecting dialog box, but installed barcode fonts show as a barcode. I need to show the font name. So I need to populate a...

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

I have a cash drawer with a RJ11 plug How do I: 1. Connect it to a computer 2. What command do I issue to open the drawer? Thanks in advance

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

Found the problem! I had an endless loop in my code Private Sub SetInUseFalse(TelesalesId As Long) Dim db As DAO.Database Dim rst As DAO.Recordset If IsNull(TelesalesId) Then Exit Sub Set db = CurrentDb() Set rst = db.OpenRecordset("Select InUseBy from tblTelesales where Telesalesid =...

Thanks lagbolt I don't know! The front-end is obviously connected to the back-end. I never have more than 5 recordsets open. I always close them when I am finished with them Is there a limit to the number of queries that a database can have?

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

A typo in my post. Sorry about that. It is correct on the form

I have changed the Control Source of PaymentsMade to: =Nz,DLookUp("SumOfPrePaymentValue","qryInvoicePrepaym entSum","InvoiceId = " & [InvoiceId]),0) This will ensure that PaymentsMade is never null Still get #Error Because "qryInvoicePrepaymentSum" is a totals query. If I join it, I cannot...

On a form I have the following field: Name: PaymentsMade Control Source: =DLookUp("SumOfPrePaymentValue","qryInvoicePrepaymentSum","InvoiceId = " & [InvoiceId]) In the form's footer I have the unbound text control: Name: SumOfPaymentsMade Control Source: =Sum([PaymentsMade]) SumOfPaymentsMade...

I have the following code DoCmd.RunSQL "INSERT INTO tblInvoicePrepayment (InvoiceId, PrePaymentValue, PrePaymentDate, PrePaymentCash, Driver) VALUES " & _ "(" & Me.InvoiceId & "," & sngInvoiceBalanceOutstanding & "," & Me.InvoiceDate & ", True, True)" In this code the field...

Ok thanks The other option is to use a Dlookup or Dsum Would it be more efficient to: 1. Create the totals query and then use Dlookup to display the total or 2. Use Dsum to display the total Thanks

I have the following tables: tblInvoice tblInvoicePrePayments They are related with a one-to-many relationship. The related field is "InvoiceId" I want to create a query that shows selected fields from tblInvoice and the sum of field "PrepaymentValue" from table tblInvoicePrePayments. I want...

Solved it! Changed the data type to Text. This works for me, but would still like to know how to prevent the time from being added for future reference

I need to export a table to a .csv file. One of the fields in the table is "Posting Date". Data Type: Date/Time. Format: Short Date All records in this field are dates. Format is "dd/mm/yyyy". None of the records include a time. When I export the table to a .csv file, the time is added to the...

I need to check if the date in a field is today's. The table containing the field only has one record, and will never have more than one record. I have tried two pieces of code: Dim dteLastLogInDate As Date If IsNull(DLookup("LastLogInDate", "tblCompanyDetails")) Or...

The attached sample database refers. The database has one form. If a user selects a records, and hits the delete key, a customised message is displayed asking the user to confirm if they want to delete the record. If the user selects "Yes", Access displays message that a record is going to be...

On a report I have an image. Its properties are: Name: OLEUnbound9 OLE Type: Embedded OLE Type Allowed: Either OLE Class: Microsoft Photo Editor 3.0 Photo Class: MSPhotoEd.3 When I try and delete it I get an error message: The OLE server isn't registered. To register the OLE server, reinstall...