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...

Just for the sake of closing this thread in a helpful way - The problem was indeed in the data that was being passed to the new table. The Address field in question had an entry that included an apostrophe (') i.e. "5 Martin's Way" The sql saw that as an end of field hence the error. I...

Apologies. The immediate window displayed confidential information so I set up a dummy record that I could post from the immediate window. When I pressed the button to convert the record it worked perfectly (no error). So I'm guessing the problem lies with the data in the sending table not...

Mmmm. Same error.

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...

Thanks guys. I just gotta get round all the machines and set up trusted folders then get the user to save new versions there. Makes sense. Thanks for your help.

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...

Yes I did see the links, I as just answering the previous question. The Allen Browne link did the trick. Many thanks.

ClientID is text. Both the combo boxes are unbound and the filter works fine in that only the relevant dates show up in cboDate but when one is selected some retreive records and some don't. Foramtting is all fine and records do exist for all dates.

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 =...

Yeh, I suspected this might cause some confusion. As I said, the customer wants the database to mirror their current clerical system. They don't allocate client IDs until they transfer from the waiting list to the client list. I know it doesn't make a lot of sense.

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...

I seem to have cracked this problem. I had all my controls bound to the query - undid that. then I changed the syntax to this: Me.SessionType = DLookup("[SessionType]", "[qryMissingNotes]", "ClientID = '" & Me.ClientID & "' AND DateValue(SessionDate) = #" & DateValue(Me.SessionDate) & "#")...

Thanks for that but I still get the same error.

Aplologies. I am working in A2010 which refuses to save in A2003 because I am using features....etc.

The Client ID is set to Text in the table. As far as I can see the code you suggested is the same as what I posted without the brackets that are only there for clarity - they don't do anything and removal of the .Value extension. Anyhoo - did that and no dice! Same: Syntax error in date in...

Thanks for the quick reply. The control where you removed the single quote marks is not numeric. It is alphanumeric e.g. SW/13/001. Maybe I should have mentioned that.

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...

Bob, thanks for that signpost. I think I will review my structures in the light of the information given in the post. I do have a number of subforms attached to the main form. Looks like that could be part of the problem. Rabbie, Access 2000 on XP. It's on a Government system so I'll be...