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

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

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

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

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

Hello, I'm trying to write a validation rule that will stop a user from continuing to fill in a from if they have not filled in the "Firstname" field. I am using this as a validation rule on that field but it is not working : i have tried, Not "isNull" i have also tried...

Hello, I have implemented some check constraints on my database but would like to know how to customise and produce more user friendly error messages. I am using VB to run my functions not Stored Procedures. Thanks

Hello, I have a combox box that i need to fill from within VBA. I have a recordset that contains the right data, i just don't know how to put the two together, Help ? :-)

Hi, Obviously when you click on a listbox, the value chosen is highlighted, but is it possible to do this via vba without the need to click with the mouse ? Thanks

Hello, I have two tables, tblStaff and tblSales I have a foreign key constraint in the form of a one to many relationship from tblStaff to tblSales. Problem is that when i try to delete a record from tblStaff, i get an error message saying that it conflicts with the foreign key constraint...

Hello, I'm trying to filter a recordset using ADO on a field of type "datetime" like so : rstACDetails.Filter = adFilterNone rstACDetails.Filter = "[LastUpdated] = " & Me.txtLastUpdated unfortunately i keep getting an error message saying Runtime error '3001': Arguments...

Hello, Does anyone know of a VBA function that returns the id of a NEW record added in a recordset as soon as it has been added ? It can be done using @@IDENTITY in a 'Stored Procedure' but i need to use it in VBA. Thanks

Hello, Does anyone know of a VBA function that returns the id of a NEW record added in a recordset as soon as it has been added ? It can be done using @@IDENTITY in a 'Stored Procedure' but i need to use it in VBA. Thanks

Hello, Does anyone know of a VBA function that returns the id of a NEW record added in a recordset as soon as it has been added ? It can be done using @@IDENTITY in a 'Stored Procedure' but i need to use it in VBA. Thanks

Hello, Regarding the ActiveX Control (Microsoft Forms 2.0 Listbox), i've got it working fine except all dates in the listbox display are in the American format i.e MM/DD/YYYY. I actually need it to use the format : DD/MM/YYYY the rowsource for the list returns the date in the DD/MM/YYYY format...

Does anyone know of a good free ActiveX Listbox control for ACCESS. The thing is that i need to control its data programatically from within VBA but am finding the whole Callback function thing hard going. Thanks