Recent content by Garindan

Anybody? Please can someone help? Thanks.

Hi all, I know this should be simple but I can't work it out? I have a sharepoint database accdw which works well as I can update something and sync it to the server, and another user with the same database can receive the changes just by syncing. However, I want to share a version of this...

I've fixed this now! :p I realised that 'If blnSaveIt = True Then DoCmd.RunCommand acCmdSaveRecord' was preventing the record from saving. I added 'Else blnSaveIt = True' and now it works. I.e. Private Sub btnOpenAlarmFrm_Click() Call GetDate([Form]![txtCommentAlarm], 0) Call...

Sorry for slow reply... no, its bound. It just doesn't recognise an update when its been updated from the module :bang head: EDIT: I've tested it with after update, on dirty and on change. It doesn't recognise when its been updated!

Hi all. I have a button on a form which calls a module to show a calendar form. The user picks date and time, and saves it. The calendar form closes and adds the date and time to a text box on the initial form. At that point I want to save the record so that the underlying table/query is...

Brilliant! Thanks! Worked perfectly

Hi all. I have the following module in my database to allow for multiple alarms. It all works great, except before showing the actual alarm record called, the form first pops up showing the first record in its record source. I.e. it flashes up showing the first record in the table, then...

Great, thank you :)

Got it... I just changed LIKE to = and removed the asterisk. If Me.txtHouse_FlatNumber > "" Then varWhere = varWhere & "[House_FlatNumber] = """ & Me.txtHouse_FlatNumber & """ AND " End If That's right isn't it? They're all text fields. I get very confused with all the quote marks...

Sorry about this, I've been away from vba for a long time... I need to change If Me.cmbTown_City > "" Then varWhere = varWhere & "[Town_City] LIKE """ & Me.cmbTown_City & "*"" AND " End If to not be wildcard, i.e. only exact matches. But I can't get it :banghead:

Great thank you! All working :)

Thanks. This seemed to work well, except in testing I have found that if I first put something in a box and search, then delete what's in the box and search, it will still search. After deleting an entry from text/combo box it behaves like there's something still in there. This is a blank " "...

Sorry, one more question... How can I adapt it so something needs to be entered in each box? (there's 3) I've been trying to use 'If Not IsNull(Me.cboMoveTo) Then' but I can't get it. Thankyou! :o:rolleyes:

Brilliant! Thankyou!!

Hi all, this is my code for a search form. At the moment if searched with nothing entered into the combo boxes it returns all records. Could anybody tell me how I can adapt it to require something to be entered into the combo/text boxes? Many thanks! Option Compare Database Option Explicit...