Search results

yes, thank you... I needed to use DAO :-)

Hello This is my first time using a record set and I am not sure I have it set up correctly... I keep getting the following error 'Command text was not set for the command object"... I am hoping that someone may have experienced this error themselves and could point me in the direction of...

I have another question now that I am onto the next part of my plan... again, hoping someone can help. I now have the User ID numbers showing nicely in my text box, all split by commas (e.g. if there have been 3 users picked it might be something like this [4,1,2). For the next part of my task I...

Took some playing around but I've got it working... thanks! :-)

Good Morning all Quick question; I have a simple form consisting of one list box (2 columns; UserName | UserID). I then have a text box which as the user clicks on the UserName will be populated by the corresponding UserID. I have this code on the list box Private Sub LstUserName_Click()...

Hello I have a sub form (continuous form) which shows conversation logs. Fields on the form include; Date / Time / Correspondence Type / Contact Name / Created By / Created When and Notes I have record selectors on so that the fields are searchable (i.e. if you are looking for all...

Thanks! I have sorted it now, its working really well! Thank you for all your time and advice today

Thanks for the advice NickHa. I have followed the suggestion from PeterF, I already had something similar set up for both the visible and enabled properties so it is useful stuff. I just cant work out now why I am getting stuck on the controls and it wont let me enter another field.

I now have this Private Sub SetProperCase() Dim ctl As Control For Each ctl In Me.Controls 'set a property of the control based on the value 'saved in the "Tag" property of the control Select Case ctl.Tag Case "proper" 'if the "Tag" property of the control has a...

Thanks, I got the event to fire however it is now having problems in setting the focus to certain controls - possibly because they are disabled / invisible I'm not sure. I'm thinking now of rather than having a For / Next whether to have it check the previous control... I have tried...

Thanks, I really appreciate the help, I am still quite new to this. I have used the code above, and put it on the before update event as suggested... it doesnt appear to be working for some reason.. I have put a break point in the code and it is not even going to that? Not sure why? This is what...

its telling me I cant reference a property or method for a control unless it has the focus

Thanks, would this go on the forms load event or on the before / after update event??

Morning Can anyone help me, I would like to make certain fields on my forms have the first letter of each word as upper case. U have used Me.TextBox = StrConv(Me.TextBox,vbProperCase) and it is working really well. However, rather than list all the controls that I would like to use this on...

Hello thanks, but that gives me; INSERT INTO Tbl_ContactDetails ( CompanyRef, Forename, Surname, CreatedBy, CreatedWhen, MainContact ) VALUES ( 0, '', '', '', Date(),0) Am I wrong to expect the actual date to appear in the immediate window when I step through the code e.g. 17.02.2012...

Hello Can anyone tell me where I am going wrong with the date part of this lsSQL = "" lsSQL = lsSQL & " INSERT INTO Tbl_ContactDetails ( CompanyRef, Forename, Surname, CreatedBy, CreatedWhen, MainContact ) " lsSQL = lsSQL & " VALUES ( " & ICompanyRef & ", '" & lsForenames & "'...

Its not that the user cant enter the time themselves, they can. I thought that would be sufficient but the director wanted this extra option of being able to scroll through to pick times... I dont get it personally but hey... he's paying me so I have to do what he asks :-) Thanks for the code :-)

Good morning all Hoping someone can point me in the right direction, I'm still quite new to VBA ... I have a form which is to record conversation logs (e.g. date of call, time of call, what was said etc). I have a time field on my forms which is set to default at the current time (which is...

Hello I have recently changed the Data Entry property on a subform to 'Yes' (so that it will always open at a new record... I have tried DoCmd.GoToRecord,,,acnewrec on nearly every event procedure and it just isnt working... so I opted to change Data Entry to 'Yes'. This is now working exactly...

Hello I wonder if someone may be able to give me some advice on the following... I am trying to get it so that if the user clicks cancel - and chooses that they DO NOT want to save the changes... that the changes are not saved (sounds simple enough... or so I thought). I have tried a few...