Search results

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

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=" &...

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!

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?

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])

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

problem tested and solved

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.

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

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

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.

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.

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

Oh yeah, the database has been split.

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

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.

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

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

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.

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