Search results

I have form which I have converted to a report using the guide here: http://blogs.techrepublic.com.com/msoffice/?p=374 I have set it so it only opens a report with the ID of the current record the form is on. My problem is that the form the report is being generated from contains 2 subforms...

Basically I have a report which I need sorting. This sorting should be controlled by 3 drop down sort options on the form 'Main Reports' (Sorting1, Sorting2, Sorting3). The code for the report is: Private Sub Report_Open(Cancel As Integer) mainsql = "SELECT Quote_Number, Company_Name, Date...

Basically I have a form where you select 3 types of quipment to add to a table, but when you try and add the equipment you get the following error: Run Time Error 3075 Missing Operator I have looked this up and from what I can gather its a syntax error somewhere, but my coding is not great so I...

I am working on a report and I am getting a run time error 3061 whenever I try and print off the report. The debugger says the error is in the code below but I cant figure out what is causing it Dim TableRecords As DAO.Recordset Dim consumableSQL As String consumableSQL = "SELECT...

I am using Microsoft Access 2000 and when I try and import a table from an older version of the database I get the fllowing error: 'the decimal field's precision is too small to accept the numeric you attempted to add' I have been working on a database for a friend over the last few weeks and...

I have a form at the moment that has next record and previous record buttons but I want to add a 'Go To Record' button. When this button is clicked it should open an input display which says 'Enter Quote Number' (Quote Number is a field, it is not the same as record number). The when an order...

I am having difficulty getting my sort function to work on a report. Below is the code being used in the report: Private Sub Report_Open(Cancel As Integer) mainsql = "SELECT Quote_Number, Company_Name, Date, Contact_Name, Contact_Number, PreparedBy FROM Quotations " addSQL = "" If Forms![Main...

Hey, I am having some trouble with an Iif statement. My current one works but it is massive, and impracticle. Here is the problem: The Iif statement is supposed to generate an address depending on which department creates the invoice (one department is in Slough, and the other is in London...

I am working on a database which requires an invoicing system. Sometimes a discount is including in the invoice and ideally this discount should be entered as either a % value or a £ value. I have given this quite a bit of thought and haven’t really managed to come up with a practical solution...

I am getting the following error: Run-time error '3134' Syntax error in INSERT INTO statement This is the piece of code I am directed to: Private Function addSuite() If suiteName = "" Or Description = "" Then MsgBox "Please enter a name and description for this suite!" Else If equip1 = ""...

I was wondering if it is possible to have a drop down box where you can select a list of options but at the same time be able to enter a value manually without having to choose from the list. Currently I have a drop down list when I click on the box and if you try and enter anything manually...

Hey, I am currently working on a database which was made by someone who is no longer contactable to help and my VB is not great. Basically within one of the forms there is a 'GoTo' button, which when clicked prompts you to enter a 'Record Number' which is not as simple as being an autonumber...

Hi there, I am having great difficulty adding a simple '1 of x' display on one of my forms. I am not talking about the automatic one that Access has in the very bottom of the form (for some reason this is hidden anyway). I am looking for one which will appear at the top of the form or anywhere...