Recent content by harrisw48

Done all that but can still see the menu bar at the top of the form. The form is also full screen and I need it to resize and display in the middle

Im new to Access 2007 and am trying to create a form that opens on startup and then displays in the middle of the screen without seeing the database. How do i do it? Thanks

Im trying to update a field that contains NULLS using the concatenate code below dbo.[Current Extract].[field1] = isnull(dbo.[Current Extract].[field1], '') + dbo.[Current Extract].[field1] + '-1-' The code appears to work but it doesnt update the field, it still contains NULLS where you would...

Im using the cose below to add a new field to a table: Public Sub AddFields() Dim Dbs As Database Set Dbs = CurrentDb Dbs.Execute ("ALTER TABLE TEMP ADD COLUMN TESTER TEXT(20);") End Sub How can I set the new field to allow zero length? Its default seems to be set to "NO"

I tried that using the code below Public Function OneContact(strSalutation As String, strFirstname As String, strInitials As String, strSurname As String) As String OneContact = strSalutation & strFirstname & strInitials & strSurname End Function When I try to use the OneContact...

What would the SQL look like to run the process. If you can point me in the direction of the threads you mention that would be great

Ok ill try and give you more info I have 2 tables in access one holds data one holds critera (counties) i want to write a module which basically runs down the counties table picking out the top 300 records from the data table in order of employee size, highest first and then add the 300...

How would this look if the criteria was a variable ie another field in another table Thanks

I am getting errors with the statement below sql = "select * from [tablename] where [fieldname]="criteria"" set dbase.openrecordset(SQL) It appears to be the sql statement that is giving the error. How can I enter criteria with the "" double quotes Thanks in advance