Search results

CBrighton: How can I create these functions? I'm just a beginner, I don't know how to do that :)

hiya, I have a 2007 front-end/back-end access database that uses and username/password authentication method based on a form, all is working fine and well, but the problem is that the passwords are stored in the table as simple text, and even when using a Password input mask, anyone who manages...

Hi, I have an Access 2007 dbase that is split into a front-end/back-end configuration. My back-end file is stored on the file server, and front-end file is stored on the user's computers. Thus, the back-end file is linked to the front-end file via a network share, ie...

vbaInet Yes, I agree, it is not good practice at all, but that's what the boss wants, sigh. he wants to see the data in the table as it appears in the form. its pointless, I know, but well, some men you just can't reach.

Hiya, I have a question regarding input masks, I'm currently used an input mask on a control on my form to store the value in the form of ( DL00-0000 ) eg: DL10-1874 or DL11-2547 -The DL part is constant, ie: always = DL -The two numbers following DL can only be digits from 1 to 9, ie : 11 or...

Taruz: You're an Access Guru! All is working fine now, Thank you very much :)

Taruz: You are great, Thanks, But, still something is missing.. in Vendor combo or Received_By combo, when I click on the blank, it doesn't retreive the blank fields.

Taruz: But where did the blank records go? I mean there were some entries with some Null values in [Vendor] and [Received_By] and others, They don't show up anymore. but i need to see the blank values also.

Taruz: Thanks, That did the trick. But now i have another problem. when I filter the form by the combo705 which filters by [item] If there is no blank fields corresponding to an item, the form comes up blank and doesnt fetch any results. I'm not sure how to explain the problem. Edit: I've...

Taruz: I found an error. The code works fine now for a single combo box, As I said I have several combo boxes, When I add the code to the other combo boxes, I get an error. such as: run time error '3075': sysntax error (missing operator) in query expression '[Received_By] is nulland...

Taruz: Works great. Thanks.

Heya, I have a Continuous form that is filtered by a number of combo boxes, it all works fine and well, But my problem is that when the value in the combo box is Null, the Continuous form resets (shows all records). Want I want it to do though is show the corresponding fields in the form that...

OK OK So very sorry, I was mistaken. it works just fine heh sorry for being annoying :)

No wait ! I'm so sorry, I spoke too fast. It did not work :( now the cboEmployee is blank :\

Thanks Taruz, its all working fine now!

Taruz: Thank you, it worked! But now I'm getting the error: "can't move the focus to the control txtPassword" So i deleted the line : Me.txtPassword.SetFocus but now the focus is on the txtUser field, and I need it to be on the txtPassword field. I've tried re-instating it at several places, but...

Hiya, Newbie here. I am using the Login screen described in this article. and it works fine. since I am on a domain network, I also added 2 text boxes to display the Username and Computername. Me.txtUser = Environ("UserName") and Me.txtComp = Environ("ComputerName"). which also work fine. Now...

It would be awesome if it was possible.

wow! I was just tickering with the exact same thing yesterday!

I've been lookin for a form like this, this one seems to fit my needs.