Search results

Greetings all. There are several customers which use a service booking database and it works very well, but it would be great if it could link to outlook for certain things. I have added a few functions within access already that different things, listed below, may help people. But what I...

search for cascading combo boxes there are a few examples of this already on this site.

try accessing your recordsets this way instead rst.open "SELECT * FROM tblStudents", CurrentProject.Connection, adOpenKeyset, adLockOptimistic

Thanks, sometimes I look to hard and miss the right way :}

Dim CtlSource As Control Dim IntCurrentRow As Integer Set CtlSource = ListName For IntCurrentRow = 0 To CtlSource.ListCount - 1 CtlSource.Selected(IntCurrentRow) = False Next IntCurrentRow

I have created a beforeupdate event for a form to ensure that data is correct, however, on the last control on the form I have the following after update event HiddenControl = "Stuff" DoCmd.GoToRecord , , acNewRec myList.Requery The problem I have is that when the beforeupdate event runs I...

well that was easy enough (Used 'oDatabase.ExecuteImmediate "SET IDENTITY_INSERT " & tdf.Name & " ON"') But I'm stuck on 1 more thing. Not all tables have an Identity field and error on the above code if it does not, so i need to see if a table has an Identity value before setting the...

Happy new year all! I am currently working on creating an MS Access > SQL conversion script for our customers to use, the conversion will be run on machines using runtime access so they can not use the upsizing wizard. The script works correctly making it very easy for the users to convert to...

Are you trying to store the values in seperate fields or just splitting the 1 field for displaying? If it is for displaying in a query you would enter SELECT Left([Case/Member ID],9) AS [Case], Right([Case/Member ID],8) AS [Member] FROM Line_01; If you are storing the values in a field in a...

If the data length is static you can simply do the following Case: Left(Field,9) Member: Right(Field,8)

Thanks Len it was set to no locks, this has been changed and hopefully this will not happen again.

here is the code behind the form Private Sub Command27_Click() If IsNull(Me.DelDate) Then DSPMSG "You must enter a delivery date" Me.DelDate.SetFocus Exit Sub End If If Me.CustCode < 1 Then DSPMSG "You must enter a customer" Me.CustCode.SetFocus Exit Sub End If End...

I have a slight problem with a database table, this is the third time in a week that this has happened and I can not see why. 1 record in the table appears to become corrupt, #ERROR appears in every field (15 fields in table, 1 autonumber, 4 number, rest text, 6000 records total) every time...

As said, I have absolutley no say / control over this, the lisence is not a problem as we use the developers edition and all users access databases using the run time version. I can't consolidate the databases, some of them are not little so would not all fit a 1 database, all tables / queries...

Here's a little problem I have and wondered if anyone knows a way around it. I currently have many databases that I have created for work and they are quite happy running away doing what they are meant to do on a 2000/NT setup, we will soon be switching to our parent company's network...

Howdy I know that you shouldn't store totals in Access, but I can't think of a way around what I want to achieve and wondered if anyone had any ideas. An item on stock will move from one location to another, I will need to list the 'balances' of this stock at each location, easy enough to do...

I've been working on a crosstab query to display data on a form to improve the current method of having 118 DLookups in the form, I have part of what I want but not all and I can't seem to find a way to do it. The form is a reference form and is displayed in a graphical way and needs to be...

I currently have 1 form which displays the content of 118 bays on a trailer park, it also changes the background colour based on the status of each bay. The content is gathered by using DLookups in each control and the colour changed using code (Access 97). The form gets used a lot and the...

re-created now. Importing didn't work, no matter what I tried to do it said I do not have permission to do it!

I created a database in Access 2000 and converted it to Access 97, I made a few changes in the 97 version last week and was all running well. I came into work this morning and tried to use the database and it says I do not have permission to open the forms, in security it says object owner...