Search results

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

Hi. I have been studying and been off DB's for a year. but getting back on DB'S now!!! Some dead simple help required. I have forgotten how to get data auto input on my form. I have 2 tables. 1 called staff and another called sessions. Table staff has fields~: ID Name Address Hourly rate...

Otherwise create a dialog form that pops up when you click on "reports" which will have all the options you want! ---------------- Give us a thanks when we've helped!

Do they have to see the field after input? If not try this: Private sub nameoffield_AfterUpdate() Me.fieldname.Visible = False End Sub ------------------------------------------------------------------- REMEMBER Give us a thanks that gets us a long way if we helped you!

Hi, Does anyone know of a sample database or coding on how to make it that on the first startup of a database on a different pc it requires a activation code which the developer would have to give them? Ideally a different activation code each time. e.g. if they give me a code which pops up...

Hi there, I am about to start creating a db where the client wants me to afterwards make a template which at the click of a button in a form they will be able to select that file and it will directly import it into the correct fields i set it to. Is this poss and if yes can you please advise...