Search results

Help Please when try to open a calendar on my database I get the following Message and the calendar will not Open Dim db As DAO.Database Dim rs As DAO.Recordset Dim rsFiltered As DAO.Recordset Dim StrSQL As String Dim i As Integer Plus I get a message box with Compile error user not...

Hi all im looking to put together an accounts database for my small business. I cant find much on the web for this subject Im looking at the tables and what i need . I know I am going to need a chart of accounts Table and also a table with the clases of account eg sales outgoings ect i...

Hi Help please I have a continuous form that i use for tasks i have a date opened box .I am trying to turn the box a differnt colour say amber if the opened date is more than one day old and red if 2 days old and brown after that Just cant seem to get any sense out of it

Hi I have made a calendar using 42 text boxes which works brilliantly .It uses an array with 3 columns .The second column shows the installers Surname .What i would like to do is colour each installers name with there unique colour That way when looking at the complete 42 text boxes the various...

Hi im New to record sets and have copied this code as a test Option Explicit Public Sub LoadArray() Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("chimneysweep") With rs Debug.Print .RecordCount .Close End With Set rs =...

I m new to record sets and need help Please The code underneath works well in a unsplit data base but in my split data base does not work I tried to find the answer and it seems you have to alter the code for split databases Would it be possible for someone to alter this code so that it...

Hi I have done something to my vba editor and now my projects pain and the pain where you write all the code Stretches across the screen .How can I return these paines to noemal view

hi Help please I have a simple query that pruduces a list of payments .I need to total this list Regards John

Hi i have a split database using access 2010 just had to buy a new version of access for one of my computers .access 2016 I am getting the folllowing message you may be at the end of a record set when trying to open a form . I have tried loading the back end (access2010) on diffrent machines...

Help please I have a split form to display all my Invoices Currently the underlying Query displays all Invoices I Want a a combo box to display various numeric ranges .The combo Gets its ranges from a table where they are stored as text . My prolem is that no matter what I try I can only...

Hi i have a report that I use for an Invoice I have the price deposit balance due ect in the page footer Tried the report Footer But it Moves up the page and doesnt look professional The page footer is always in the right Place at the bottom of the Page .But if my invoice detail goes to 2nd...

Hi have a subform called Newordersid and a table called NewOrdersID I use Dlookup to populate the sub form on afterchange event of a combo box It does this but does not populate its table I use dlookup for otherfields in the subform and table and they all work I have checked the spelling and...

Hi Is there a way to stop my report footer riding up to the last detail .i really need to anchor it at the bottom of the last page

Hi i have a report that i use as an Invoice .I have all my totals in the page footer but if my invoice goes to more than 1 page I get the totals appearing on the footer of each page . I need a way to only have the page footer show on the last page . I think it may be something to do with the...

Hi Have a continuous form with 2 date fields in each record . If dateField1 is empty ,Then I want a way to make DateField2 Take its Place . I know how to make things happen with conditional formatting on one field by UsingIsNull , I have tried sending datefield2 to back.But cant work out how...

Hi I have a split database ,and I need to update the Table default value of a field Rather than go into the table I would prefer to use a form I found this code but it wont work,I presume becouse my data base is split Private Sub UpdateInvoiceReportNumber_Click() If Not...

Hi is there a way to use vba to close the currently open report on the screen without specifying its name Thank you

Hi I Have a report which is an Invoice I have a details section for the invoice orders and i have a report footer for the total sum ect the idear being if the invoice is more than two pages long the report footer will always be in the correct place to display the total ect The problem is the...

Hi I have a report which is an invoice I have a button on the report to reprint It . Now if this is a duplicate Invoice I need to add a background Image ,something like a duplicate stamp . I have added a message box which says" is this a Duplicate Invoice" .If the answer is yes then I want...

Hi I have a report that thats record souce is from a query run from a form I want to use the same report but run it from a different form using a a differnet query How do i automatically change the record souce when the report is opened from my new form code Private Sub Report_Current()...