Search results for query: *

Hello, I've got two tables : tblTimetable : ClientID, Mon, Tue, Wed, Thu, Fri, Sat, Sun tblTimetable_Timeslot : ClientID, TslotID e.g: tblTimetable : ClientID Mon Tue Wed Thu Fri Sat Sun 404 10 2 20 0 0 0 0 tblTimetable_Timeslot : ClientID TslotID 404...

yes i've included all the other parameters in my code, i tried changing the output parameter name to @ClientID but still i get the same error. The function is actually being called from a COM/.dll object, do you think this might have something to do with it ? Thanks :-)

Hello, thanks for your help I'm using the sproc in VB like so ? Private Sub LoadParametersForInsert(objCommand As ADODB.Command, objClient As clsClient) On Error GoTo ErrorHandler Dim objParam As ADODB.Parameter With objClient 'Load the parameters for the Client object...

Hi, I'm using a stored procedure that outputs an @@IDENTITY value like so : ALTER Procedure spClientInsert @Soscis int, @firstname varchar(50), @lastname varchar(50), @address1 varchar(50), @address2 varchar(50), @address3 varchar(50), @PostCode varchar(50), @HomePhone varchar(50)...

Hello, I have two tables tblProgrammeTimeslot and tblProgramme tblProgrammeTimeslot : ProgID, tSlotID record e.g ProgID=278, TslotId=2550 tblProgramme : ProgrammeID, Mon, Tue, Wed, Thu, Fri, Sat, Sun record e.g ProgID=278, Mon=2550, Tue=112,Wed=0,Thu=560,Fri=0,Sat=100,Sun=0 I'm trying to...

Thanks mate, i'm still not done yet 'cus my form is unbound so even though it requeries just like you suggested, i need to call my DisplayCurrentRecord() function which is local to formA in order to display the requeried data. So i need to call a function local to formA from within the...

Refresh/Requery an open Recordset from a different form Hi, Form A is 'unbound'and i'm using a recordset as its recordsource. When you click on a certain button on Form A, a Popup form opens where some details are changed and saved. When the details are saved on the Popup form, id'd like...

Hello Guys, Thanks for all your help and you're all right ! I've been an idiot, the problem was not with the way i was referencing the field in the recordset, the problem was that the control was NOT named exactly the same as the field in the recordset, the control's called 'cboMonAM' and the...

Yes, the recordset is created and opened in the forms_Open event. Unfortunately i get an error that says, "Item cannot be found in the collection corresponding to the requested name or ordinal" when i use this : rstprogramme.fields(TimeSlot).value = 0 I think that the system...

Thanks guys, i'm using a recordset. I've tried rstprogramme.fields(TimeSlot) but i get a 'Compiler error' saying 'Invalid use of property'. It seems that that this property is Readonly ?? :-)

Hello, I'm passing a control into a function because i will need to run this function many times over. i can access the name of the control quite easily, the name of the control is the same name of a field in a table. See Below : __________________________________________________________...

i have a combobox setup as using a 'value list' for data with these values : "YES";5;"NO";3;"DONT KNOW";1 the bound column is set to 1 so that the actual values stored in the db are "YES, NO, DONT KNOW" etc. however i'm using column 2 to store values to...

Hi, I'm using an array to hold data for my chart like so. arrPrices(1) = 1 arrPrices(2) = 2 arrPrices(3) = 3 arrPrices(4) = 4 arrPrices(5) = 5 arrPrices(6) = 6 i then call the chart like this : ChWasherProfile.ChartData = arrPrices No probs so far, however i need to...

Thanks guy's for all your help, i finally figured it out. All what you sugested was right except all the time i was concerned about the date being in the future in my validation check, i forgot to check to see in the value was a null or zero length string !! DOH !!! allanon, i just read your...

CDate(Me.txtDOB) was the first thing i tried guys, it still doesn't work. :-(

Sorry, the error message i get is "Type Mismatch"

Hello, I'm using the code below to perform a validation check on a field. unfortunately i keep getting an error13 message that says 'There seems to be a problem with your date' Any suggestiong ? Thanks ******** CODE ****************** 'DOB must not be greater than today If...

Hello, i was being a bit lazy last time. basically i've got an Unbound form, with a name field. I've also got a validation rule for name in the properties section on the form, stopping it from accepting zero length strings values. Here's the thing : if you open the form, leave the name...

Does anyone know how to force a control to run it 'Updated' method in vba ? Thanks

Thanks, i can do it in code but i need to do it in the validation rule properties box on an Access Form. :-)