Search results

After Case vbYes Add If isnull(me!list3.column(11)) Then 'Case vbYes Code Else MsgBox "Cannot Delete as column(11) is not null", vbOkOnly End If Regards Jon

Thanks Mile I checked the names of all property procedures with the object browser and could find no clash. If there was a clash I would expect to have seen it here. There were also no repeats of names in the property procedures. Also I had not actually got round to instancing any of the...

I am not an expert but it seems that you are making a change on a form and creating a seperate recordset with the pointer on the same underlying record and specifying a change on this. As the recordset has changed records on the underlying table or has changes stored in the buffer access sees...

Class modules - watch out when naming properties I have just encountered an interesting naming clash when adding some class modules to an existing database to enhance the forms and reports. I am not sure why it happened not being an expert in access programing. All the properties were defined...

ADO Parameter Syntax Thanks I had tried searcing prior to posting and couldn't get the examples to work with ADO as all the examples here are for DAO I have posted the bones of the ADO code I used. I eventually found a side note ref to ADO Syntax in the Desktop Dev Handbook 2002. For those...

Can anyone help I have a stored parameter query that I use as with an ADODB command object to return an ADODB Recordset. There is alot of SQL in the query so I don't want to use an SQL statement in the code . As this function is used by several forms I cannot set the Parameters as form...

ADO Recordset Clone - Type Mismatch If you are using a forms recordset clone you must use DAO in MDB files. The ADO syntax always gives a type mismatch error in 2002 and below. Not sure whether this has been fixed in the latest release. It works OK in ADP files. Jon

To save on the amount of SQL statements I require to write for recordsets. I have stored all the queries that I am using as generic parameter queries all having reference to an unbound form with text boxes for the their parameters.(frmParam) controls txtParam1, 2, 3 etc This form is open all...

I agree with Pat Hartman, leeds are not worth very much but sales are. You could set up a forum which people pay per lead or pay a fixed monthly fee to access the leads. I don't really like this idea as this the great thing about this site is the free information exchange, having the same...

Top Job - Works Perfectly Thanks Wayne I tried searching but on VBA Arrays Even better than I wanted, I have taken it out of the form module and made it a public function so I can use it on other list boxes too! Jon

Happy New Year folks, I have a form showing a certain source type. On this form I have a sub form which shows all categories available to this source type. The sub form is set up with two list boxes one showing available categories but not yet assigned to this source type(lst1); the other list...

I've Sorted it Before anyone replies. I just had to specify both fileds in the join window simple really. Must have had more beers than I thought last night Happy Xmas folks

Can anyone help. I have posted the relationships out of a db that I am creating. I have just about finished and there is one particular field that is causing me a headache. The project is to create a financial tracking system. Everything works but I have fudged the fldAmountpaid and as 97%...

I have a database with two data tables linked in a many to many relationship by a joining table containing the two primary key fields of the data tables as Foreign Keys and its own PK. The joining table PK is set to Text and the PK's in the data tables are Programatically numbered sequentially...

I agree with Calvin I have had a similar problem in the past. The Do Loop seems to register EOF on the last record and omit it. I always use UPDATE for ammendments or INSERT INTO SQL statements for additions. I usually try to save the query and open it as a recordset object as it seems to work...

I have used MySQL with PHP and for most DB driven web sites it works fine. I would say the big plus point is that it is free and simple to learn. The big drawback is that some of the more advanced functionality in access is not present in MySQL. I must admit I have not tried to use PHP with...

Can someone help me out in fully understanding the life time of Variables and Objects in VBA. I am currently developing a project for a client, as some of the machines the application side will be deployed on are pretty old, I need to watch the memory useage. Where possible I have stored...

Jons inelegant subs Dwight, just to let you know that the sub I wrote for you was done v quick. When I looked at it after your reply I noticed that Me.[control2] = stldate should be after the end if. Instead of being duplicated within the If statement. I should also have used "!" operator...

Thanks Thanks for the help folks, I always get a type mismatch when I try to use ADO recordsetclone and I thought I was doing something wrong. I have a tendancy to get the ADO and DAO syntax mixed up and end up doing a lot of debugging if I try to mix them. I would just like to use ADO and...

Check out the weekday function built into Access. This returns the day of the week as an integer. The basis of your code could be: Dim tradedate As Date Dim stldate As Date Dim response As Integer tradedate = Me.[control1] response = Weekday(tradedate, vbSunday) If response = 6 Then stldate =...