Search results

  1. S

    Question HELP!!!!! I've locked myself out of my database

    HI Guys, I have made a serious mistake. I used the code in this thread http://www.access-programmers.co.uk/forums/showthread.php?t=51479 To disable / enable shift key override. As explained I set the Bypasskeyon function on my database logo. Only I used the doubleclick function...
  2. S

    If controls are null exit sub else run search

    Hi Guys, I pinched some code from another thread but I thought I would start a new one as the other thread was quite old. For Each ctl In Me.Detail.Controls If ctl.ControlType = acTextBox Then If IsNull(ctl.Value) Then MsgBox "No information has been...
  3. S

    Search form with Unbound listbox

    Afternoon Guys, I am a bit baffled at the moment. I am trying to create a search form that will provide the entries in my unbound textboxes as results in an unbound listbox. The textboxes I have are: txtCustomerForename - Text txtCustomerSurname - Text txtPostCode - Text txtAccountNumber...
  4. S

    Create an Autonumber for each ID in table

    Morning All, I have having a little difficulty here. I have a user form where users will add a number of accounts for one person. Each person has a unique ID. What I want is when each account for this person is added to the form for some type of autonumber but for the autonumber to restart...
  5. S

    Export field names to certain cells in Excel Template

    Hi all who wish to help, I have created a database that contains five different tables. Each linking to a main table through an ID. The database opens asking for an ID. When ID is input and the relevant command button is clicked a form opens spplying details for this individual as well as...
  6. S

    Split first two words of string into new field

    Morning All, I cannot find the answer to my question anywhere. I have an address field named 'ADDRESS'. I want to run an update query so that the first two words of the address are split into a new field named 'AddressSplit'. Therefore if the full address showed the following 'Ruby Cottage...
  7. S

    Form to Load automatically Showing Users Records

    Morning All, I have a form that users access where they can deal with their own records. Currently the form shows all records for all users. I am trying to use code that will retrieve the users logon ID and match this to their name in a table. I want the form to use this to automatically...
  8. S

    Flat Tab Control

    Hi All, Could anyone help. I am sure I previously created a database where I used a tab control that was flat on the form. I have created anew database and cannot seem to find out how to get make tab control flat. It is raised on the form making it look a little stupid. Would be grateful...
  9. S

    Changing Data Format in Table

    Good Afternoon, I am hoping to get some help here. I have a table where one of the fields are a six digit sort code. I want to change the sortcode so that it is in the correct format. 12-34-56 rather than 123456. I have tried to just change the validation rule to Like "**-**-**" but this...
  10. S

    Query Counts records not Companies

    Hi, I'm new to using queries in Access and am stuck on trying to run a query from a table. I have thousand of records with fields such as customer name, Company Name, Company Country and Balance. What I want to do is run the query to count the number of Companies within a country. I use...
Back
Top Bottom