Recent content by livvie

CORRECTION ON ABOVE POST I am using me.dataentry = false on Save of one form in a tab but when I do it causes another form to be requeried which I do not want as the records do not match up then. One form is showing a list and the second has the details of the record so clicking on a record on...

Using me.dataentry = False causes my program to go to the OnCurrent function of a form - how do I stop it doing this.

I need to use a UDL to specify my connection details for an Access application. I have done this succesfully everywhere that I have explicitly connected to the db via code but I also need to be able to use the UDL when the application (and subsequent forms that are based on stored procedures or...

PaulBricker I am trying to add hrs and minutes and display them as short time using your code but I am using Access 2003 .adp and I am getting the error 'Int is not a recognised function name ' Any ideas what the syntax for .adp is.

Try changing Cycle property of form to Current record

Just found out very simple really. Tools Options Advances Max Records

How do I get rid of the max records on a combo box in Access 2003 .adp If I convert to a2K it's fine I can just change the max records on the query but in Access 2003 .adp it will not save this change???? Also does autoexpand not work for numeric fields ?

I am getting the following error sporadically on two forms when I ty to enter data into the first text box on the form (DataEntry form) "you can't assign a value to this object". Once you click OK it accepts the value anyway. This is very annoying and users will not accept this - what is...

I saw that box alright but it's greyed out only the Menu and Toolbars one is available.

This doesn't import the keys relationships etc

I need to copy a database without the data. I need to hold the keys and relationships etc. I also need to be be able to copy Views and queries ?

pbbriggs this didn't work. The record I am using is actually read only. The select button is a command button that takes some of the details from the selected record and passes them to another table. So unless I write to the rec when the select button is pressed I cant change the format if I...

Thanks pbbriggs that should work.

CAnt use this I'm afraid as I already have an autonum field in my table. I might be able to manipulate it a bit. It's a lot of code for a small functionality but I mihgt have to do it.

I have a continuous form with a select button on it, I need to be able to change the colour of the select button or something else in that record, when the select button is clicked. I can change the backcolour on click but it changes it for all records not justthe one chosen. Any help would be...