Search results

Hi there, Thank you for saying Happy Birth Day to me. By the way, my FO line manager wants an IT report, i am wandering if there is any posibility to search and export users. The report should show in the status column who are disabled, who are enabled, date created and date expired in date...

You are right. Thank you Vassago.

Hi Guys, Disappear from this forum for sometimes. Hoping all of you are doing fine and weathy. I am interested to learn SQL server, now i own 2008 standard edition version. Just got it downloaded from website. I do not know anything about this. Firstly, what I would like to do is: I am...

Hi there, In query, i am concatenating 3 diffirent row values: StoveID: [tblUser].[ID] & [tblUser].[usercode] & Format([tblProductions].[ID],"000") ex: 1 + PCBT + 001= 1PCBT001 for User 1 2 + PCBT + 001= 2PCBT001 for User 2 So on...... The above works fine. But there is a problem when...

Hi there, We use ADSL internet at our office. 1m download 512kb upload. Sometimes, it feels like internet very slow espacially when there are more users at the office. I assume that some of them may download huge files eg. video, music, etc.... We run DHCP protocal from ADSL Modem Router, 2...

It works great. Here is the code: ElseIf DCount("SerialID", "tblProductions", "SerialID=" & Me.txtStartno) > 0 Then MsgBox "There is some duplicate records. Please check.", , "Warning:" End if I really appriciate. Thank you so much for your assistance.

I am sorry, but could anyone help please? Regards,

Hi, I need to append multi records from append query call temp to table tblProductions. In fact, they seems to work fine but i like to happen if any record in both columns found then message "There is a duplicate." else run the query. I have a button to run this query in a mainform. below is my...

Hi there, I have a subform sfmain which bounds to tblrsales. In subform, i like to block a data entry person not be able to edit record(s) after he entered in last 3 days. But the admin person can do changes. Do you have any idea please? Thank you Regards,

This is something not easy to work out. I can simply create increment number by using Dmax() function. Since my case is that i need to add multiple increment numbers at the time depends on append query. I think i will leave it as what it is. Thank you so much for your valueable time and advice...

Thank you vbaInet. That's good point. In fact, I like to apply a proven approach to a wholesaler sales table which has different columns. when user does wrong data entry, he has right access to delete. at same time, once new record is added a consecutive no should be used. The sample given was...

Thank you for your advice. But I really like to do this. What i create one more column called ID2 (number) and add consecutive number from there by using append query is it possible? Thank you in advance. Regards,

Hi there, Is there a way to add a consecutive no to a ID field in table? I have a database contains a table named tblemployees. I have this link to a form which i use this form for editing and deleting records. When record(s) was deleted in PK field shows missing numbers eg. 123...6...9.. i do...

This works fine on my project. Thank you for your advice.

Hi there, I have created a logon form for different level users to login to access database. After user enters username and password will open up the mainform. In the main form, there some command buttons. I would like to disable some buttons when guest user in read only group login. at the...

Sorry posting such stupid question above. I should have found and read what many people posted on google excessively. I finally found the solution for that. But my next question is that: How can i manage the permission to user. I have a main form. there are 3 parts in it (Data entry, Report...

Hi there, I am having problem with user level security. I am creating a small database in MS office 2007 but save it as MS office 2003 compatibility. Access 2007 allows me to set user level wizard. In fact, it works fine on a machinve which i use for database development. But when i save it onto...

Hi there, I am having problem with readonly user loged into form data, when he tries to change or update record. it appears run-time error '3107' and many other error messages as he clicks different command buttons. What i would like to do is: If run-time error = 3107 then MsgBox = Sorry, you...

Thanks mate for useful hint. But i could not apply to my project. I think some thing with my database structure. can i send an attachment of what i've been doing so that you can commend it please? Cheers,

Thanks Galaxiom, I found it http://www.access-programmers.co.uk/forums/showthread.php?t=179108 But i still can not work out. I feel i need something like: Search ProducerID for unique ID then search for last record (Dmax) after that add one more record after. Do you any good sample for newbie...