Search results

I have recently migrated a customer's back-end data to Sharepoint lists on their 365 account. Good news, everything works as normal or at least I though it did. My customer has now reported an issue which I have traced to the following: When the SharePoint lists become disconnected (such as...

Hello again folks. I have been knocking this about for a full day and can work it out so any help would be much appreciated. I have a table with client records (tblClientList). I have a form which presents a list of all available clients in a multiselect listbox. I want to update each of the...

This is one of these occasions where I just can't see the wood for the trees. I am attemting to convert client records from a waiting list onto a live list via a userform. The userform shows the user the client details before they press the command button. The following code should take that...

You know that feeling when you are sure there is a really easy answer but you just can't find it? Well here's mine: I have just delivered my front end to the user. I have incorpoated a splash screen which uses the timer event and then a sign-in form opens. Trouble is, when the user opens the...

Hi, I have a form bound to a table and I need to display and edit records. I want to narrow down the records by applying two filters; one combobox to select the ClientID and another to select the date. What I have so far is this: Private Sub CboClientID_AfterUpdate() Me.Detail.Visible =...

Hi again, Could someone give me some advice about tables please? My database (A2010) has a table that contains client details with a primary key that is the ClientID. The ClientID is automatically generated in the form when the client is built. The customer wants the database to reflect as...

Hi Folks, I spent the last seven hours trying to get this to work - me and Google are great friends! I'm trying to get my bound form to populate a text box with a value (AppointmentDesc) filtered by the ClientID [ComboBox] and the Appointment Date selected in another ComboBox [SessionDate] My...

My database has been running perfectly for months but suddenly stopped recording new entries via my input form. Couldn't find anything wrong with the form but when I tried to enter a new record directly onto the table I realised that Access was trying to allocate a unique ID that had already...

Hi Folks, I am looking for some hope that my database is not corrupt. The first sign of trouble was when users could not add new records via the input form. No error messages - just lack of a new entry. I tried entering a new record directly into the table but the autonumber allocated...

Hi Folks. I have a select query that has 10 columns which are checkboxes (yes/no) from the original table. I can apply filters for individual columns but I want the query to show records with ANY of the boxes checked and only omit those with NO boxes checked. I have spent the whole atfernoon...

I have an unbound combo box on a form that is used to select a record by surname. The complete record is then displayed in various controls on the form. I realised after completing the project that there are multiple instances of the same surname i.e. 5 Smiths. When any of the Smiths are...

Hi Folks, I have a series of textboxes on a form that act as labels for other textboxes that display information. The reason I am using textboxes rather than labels is that they are dynamic i.e. the 1st one is Date(), the second is Date()+1 and so on. They are formatted 'dddd' so that they...

Hello again folks. Having spent a week building my database and everything is working as expected - I set the 'startup' properties and now Access won't save or quit from the main form. In order to close I have to select 'form design' and then the 'X' will work. This goes for all the methods...

Hi Folks. Should be simple enough, but I'm going cross-eyed researching this: I've got a main form that displays records of individuals (selected from a combo box) Part of the data requires that I store 'from' and 'to' dates and as I need to keep a history as new periods are entered, I am...

I am adding some finishing touches to my database. I want a 'Welcome' form shown as the database is opened and a greeting like "Welcome *****". My problem is this: by using =environ("Username") I get the right result except that my network logs everyone in as a staff number, ie 45812457. I...

Hi folks, I'm new here - pretty hot at Excel but a total newbie at Access, So.. OK, I've got my database up and running. It keeps records of about 500 staff - everything is working fine but I now want to do stuff beyond my capabilities.. I've got a master record (Master Staff List) and a main...