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