Search results

check the colum widths for the list box e.g if you have 2 colums in the list box and the data you wish to display is in the second colum set the colum widths for the list box to 0cm;3cm this will not display the information from the first colum, but from the second only

have you tried it in the on load event instead? I created a form yesterday where I wanted a value passed into a field, it didn't work in the on open event but did in the on load.

DoCmd.OpenForm "frmblahblah", , , NewRecord might work :)

would delete record do the job?

set the Data Entry property of the forms to Yes, this will make the form open to a blank record. would subforms not be a better way of linking the other forms?

Spacebar checks check boxes

yeah, that's as far as I've got too

Hi I would like to be able to create a spreadsheet based on a table, I have the Access 97 Developers Handbook which shows how this is done with MS Excel, the company I work for does not use any other Office applications and can not find a way of creating a Lotus spreadsheet using these methods...

I have an annoying database and I would like to do some detailed 'stuff' with a field in a table. I would like to split the field into parts as each part represents certain information. eg - 175393843 I would like to split into seperate fields eg - 1753 - 938 - 43 I would like this done...

ta

Hi I am writing a db where information is being transferred from another machine using ODBC. the problem is how the machine reads dates. the dates come into Access as 1020913 but I need to view this as 13/09/02 is there any way in Access that I can change the number into the required date...

thats where I got it from, thanx I forgot the URL :)

I can't remember the site I downloaded this from but here's a fe/be database demonstrating logging people off a database with a message.

I have the following code to calculate times Public Function GetTimeCardTotal() Dim Db As Database, Rs As Recordset Dim totalhours As Long, totalminutes As Long Dim days As Long, hours As Long, minutes As Long Dim interval As Variant, j As Integer Set Db =...

Let me see if I can explain this in an understandable way here's some code Private Sub cmdEdit_Click() On Error GoTo Err_cmdEdit_Click Dim stDocName As String Dim rst As Recordset stDocName = "frmEpisode" DoCmd.OpenForm stDocName Set rst = Forms!stDocName.RecordsetClone rst.FindFirst...

Hi all I have created a db which is used by around 80 people, there is a problem which happens frequently, but in order to fix the problem, I need to know how it occurs. Fixing it will not be a problem, I know the general area of the problem but can not pin it down. each person logs onto the...

Here's my first thought create a field call it BookFlag or whatever. then when the room is booked, add code to make the BookFlag field = 1, (add the flag against the room and time slot) then add code to check this flag e.g. If Not IsNull(BookFlag) Then MsgBox "This room is not available for...

have you tried a delete query?

yes create a query then right click and select Append Query from Query Type, you will then be prompted for a table to append the data to. so, set up a Archive database, and create tables in it for the tables that you wish to archive and set the tables up exactly the same. Then when your...

http://support.microsoft.com/default.aspx?scid=kb;en-us;q88657