Recent content by ct2013

Thanks. Any hints or examples of similar scenarios that can help me? Cheers

Hi, I have a database i use regularly and think i have a poor design for what i want to do next but need to work out the best way to make it work in its current setup. I have a table recording enquiries which asks lots of information such as name, phone number, pets, date looking to book... I...

Hi. Looking at your db now. Not exactly sure what you want? Please reply with clear instructions what youre after. Thanks

Hi. Just updated my pc to windows 10 and all my standard currency gone to $ and no option of £. I have checked keyboard and it is set to UK so is timezone set and pc set to UK. Any one else had the problem and what is the fix? Many thanks

Maybe create it as a dropdown list and then limit to who on the list you allow to add and ensure that you tick this field may not be left blank otherwise you would have defeated your point. If you want to send a sample database i can try look at it. (make sure to take out personal info)

Thanks for prompt reply. Tried that but doesnt seem to help!

Not exactly sure what you mean. Is it working with a dropdown or combo box this field called review type?

Option Compare Database Option Explicit Public lngUserID As Long Public strNetUserName As String Public strUserName As String Public bytUserSecLevel As Byte Public bolUserStatus As Boolean Public bolAddRecs As Boolean Public bolEdtRecs As Boolean Public bolDelRecs As Boolean Public lngPeopleId...

Hi. Another dead easy simple question! Got a query. Trying to use the sum option. I have records in a table that are showing charges. E.G. 8/12/15 £6 9/12/15 £15 I want the sum to add all these up but using a criteria of between [start date] and [end date]. What i receive when i run the query...

DoCmd.OpenForm "Frm2ndContact", acNormal, , CompanyName = "'" & Replace(Me.CompanyName, "'", "''") Try this maybe

can you send a copy of your db? I usually place acnormal and acedit but would need to have a try on yours as it ios a replace and i dont usually have such forms.

Thanks mate. Thats it. Nice and simple!

send me the code of the button used to open the second form

check that the command is acEdit and not acAdd!

Are you using a query based form??!?!? If that is the case a lot of times when you open a form from another form on a query it will just be looking up the data hence may not allow you to edit data. Also check in the property sheet in the form that under the tab "data" the locked is set to...