Search results

  1. C

    Question Backend Db Security

    My Db is split FE/BE. On my backend am using a module which prevents shift key bypass so users cant open the Db and see the tables. Is there a way to prevent unauthorised access to the backend. I have discovered that if I create a blank Db then I can import the tables from the BE Db. Thanks
  2. C

    Docmd.runsql UPDATE problem

    I've searched the forum and tried various syntax but each time the code runs I get a propt box to enter the value required as the updated value. DoCmd.RunSQL "UPDATE TblEnquirySource SET TblEnquirySource.EnquirySource =" & Me.txtSelected & " WHERE TblEnquirySource.EnquirySourceID=" &...
  3. C

    Type mismatch in expression datediff

    Thanks however I am a clot! The error was because of another field unrelated and an incorrect relationship between them in the query. It works as it was having solved that problem!
  4. C

    Error Cant Assign A Value To This Object???

    Hi Bob, thanks for the tip on that question which worked. I handt used Nz prior as there is no change that a record can be created in the table without its PK What did the brackets do?
  5. C

    Type mismatch in expression datediff

    I'm using the following in a query but I keep getting Type Mismatch In Expression Error. Regdate is a Date/Time Field in my Db. Expr1: DateDiff("d",Date(),[RegDate])
  6. C

    Error Cant Assign A Value To This Object???

    I'm using the following piece of code in my Db: If strIpType = "Static" Then MsgBox "This is a static IP Address" & vbCrLf & "Used For Dynamic IP's Only" Exit Sub Else Dim strTblRadsMacAddress As String strTblRadsMacAddress = DLookup("MacAddress", "TblRads", "PrimaryDataID =...
  7. C

    Tempvars not working in runtime version

    problem tested and solved
  8. C

    Tempvars not working in runtime version

    Think I found the answer, one of my Tempvars is based on a textbox.value and it's value wasnt decalred until after the tempvar itself was declared.
  9. C

    Tempvars not working in runtime version

    Having done a bit of tesging find that one of the tempvars isnt initialising...
  10. C

    Tempvars not working in runtime version

    The server isa remotely hosted - has to be that way in this case.
  11. C

    Tempvars not working in runtime version

    Hi Bob, its a split database where the front end and backend are on the same machine - just different directories. The machine is a Server 660 R2/64 and users will access it using web terminal services.
  12. C

    Tempvars not working in runtime version

    I have been able to successfully utilise Tempvars in my Db but having compiled it and packaged the solution the tempvars dont work on the production server which is a 64-Bit Server 2008 and running Access 2007 Runtime Version.
  13. C

    Question Record Locking Problems

    If, when I open a record I unfilter the form and use the record navigator to go to another record the error does not occur
  14. C

    Question Record Locking Problems

    Oh yeah, the database has been split.
  15. C

    Question Record Locking Problems

    On my main form exisits the customers address. The text boxes are locked to prevent users from accidentally deleting or changing information. I have a button which brings up an unbound form, uses DLookup's to fill corresponding edit boxes and then a save button with SQL Update strings to update...
  16. C

    Hide cmdButtons based on Variable?

    I have found a solution using Tempvars. This apparantly remembers the value whilst the database is open and seems to be useful too by saving have to create modules and functions. This is a solution new in Access 2007.
  17. C

    Stripping out spaces from a string

    Well with a bit of patience have found the answer so here it is. Dim strRemSpaces As String strRemSpaces = Replace(Replace(txtMobile, " ", ""), "-", "") Me.smsNotifyNumber = "+44" & (Right$(strRemSpaces, 10))
  18. C

    Stripping out spaces from a string

    My Db records mobile telephone numbers and provided users enter the number without any spaces i can use the following to put it into international format, which I need to do as the number also gets used for sms messaging. If 255 - Len(Trim(Me.txtMessage)) < 1 Then KeyCode = 8 End If so...
  19. C

    Time() Not working??

    Thanks Freshman, I will build that in to my Db during the course of its maintenance. I'd not heard it before so will have to gen up on it.
  20. C

    Time() Not working??

    Hey all thanks so much for taking the trouble to reply. 1) 3ammaksammer - I tried that, not that much of a newbie!! 2) Bob, I will test that out. 3) Gemma - you are a STAR!!! Yes, the issue was having another txx box called time. Changed it to txtTime (I usually put txt infront but on this...
Back
Top Bottom