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

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

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,

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

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

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

Hi there, I am sorry if i posted this in missed category. I have update form "frmpro" in this form, I have 3 columns "ProducerID, Producername and Villagename". I use these to generate a serialno. Here is my functional code. =Format([cbproducer].[column](0),0) & Left([cbVillage].[column](1),2)...

How can i add 1 new record after last record instead of (a defaultvalue adding new record, it does not populate any incremential number till adding some value) by clicking a new record button on main form please? Here is my code: Private Sub New_Click() On Error Resume Next...

Hi there, How can i update name column for multi records where id = SA001 - SA010 in range? What i like to happen is: id name SA001 insert Tony ........ ............... ........ ............... ........ ............... SA010 insert Tony any help will appriciate please? Thank you...

Hi, Is it possible to insert many id number by one click on form button? The id number shouldn't be duplicated. eg. SA0001 ..... ..... ..... SA0100 Thank you

Hi there, I am planning to develop a database to monitor th stove production. I have production table contains 2 fields, called From No. and To No. Since there are a number of pieces of product produced on daily based. eg. I have 100 pieces, every piece needs a unique serial number. If i enter...

Hi there, I am creating a mini sample project for tracking inventory for my office. i almost finish everything except this last part. what i want to do is: I have a main form called formdistribution which also has a subform called item for issue. The subform bounds to a table which holds 15...

Hi there, I am trying to do a search on Crosstab query in main form. In my database, i have main form. in the main form has comb box called cboYear to add a searched criteria. below the main form i also have subform bounds to crosstab query called qrAppliances. Code: [Year]=[Forms]![Main...

Hi there, I have a main form. in the main form i have linked it to query. in the main i also have 3 unbounded combo boxes to filter for Provinces, Districts and Villages. My question is that: is it possible to run requery within the main form button please? Thank you in advance Cheers,

Hi there, I have a form called "main", in a main form has one text field called "employeename". I also have created a popup form "frmemployee" to link with employeename field in main form when i double click on employeename text field. What i want it to happen is that when i select or copy any...

Hi there, Please accept my appology if this is wrong categorised. My boss will have a conference call tomorrow Thursday 17 June 2010 at 12:00pm, he needs to setup a KX-TS7300 to call to 3 people in different coutries at same time. Could anyone direct me how to work this out please? Thank you so...