Search results

ok i get that which is why i guess it no longer allows me to click it But how do i get around the problem i tried loading the reference suggested but did not work Thanks for your help

thank you for your help This was written many years ago i have since stopped playing with access and just used the program as it worked brilliantly .My knoledege of access is now not very good now are suggesting rewrite this Dim rs As DAO.Recordset Dim rsFiltered As DAO.Recordset Dim...

Thank you for your help i have loaded that reference but still will not work do i need to alter the code were it refers to DAO

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 Unc No That is not the Case Each of the 42 text boxes are populated by an array the array has 3 columns the first row shows the customer surname the 2nd Column has the fitters surname the 3rd column has customer tele number I want to show only the fitters Surname in a unique colour not...

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 no expert but had the same problem see the next thread down from yours under John Thomas and jdraw answer it seems you must use .movelast and it all worked, really simple sure your prob is the same

Thanks guys yes movelast does the job regards john

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

Hi Moke I should have looked closer at your reply ,Sorry. Will give it a go and let you know All The Best John

Sorry moke I dont understand your reply I believe ts all about setting the early parts to dynasett or something like that as when a data base is split the tables become attached and cause the code to fail Thanks for your help

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

Solved.. Hi Doc Man Checked out what you said all is 32 bit so could not see the problem .was about to start checking other things that you said .and it suddenly struck me .This is a new computer .Could it be to do with sharing files . The problem Was I had not allowed sharing to read and...

Hi Doc Man Thanks for your help Jeepers it sounds really complicated. However when I get back to work Friday I will check out what you suggest . Your knowledge of Access astounds me . We downloaded this version of access so we dont have a disc ,can I get into the program somewere and alter it...

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

Hi CJ Read the link I will try to do better Next time Many Thanks