Search results

Dear, gemma-the-husky I have tried adding autonumber field and empdt as primary key in tblTime and tblEmp, empId as a primary key. I have made a relationship with field -empId. In tblTime - I have enter data on daily basis as Autonumber empId empdt empHours 1 1 01-06-09 8 2 4 01-06-09 9 3 2...

Dear, gemma-the-husky I have tried adding autonumber field and empdt as primary key in tblTime and tblEmp, empId as a primary key. I have made a relationship with field -empId. While entering data in the tblTime. It is showing error msg as: "The changes you requested in the table were not...

I have 2 tables: 1 tblEmp, 2tblTime tblEmp consist of empid empname where empid is primary key tblTime consist of empid, empdte, empHours Here When I am entering data tblTime it should be in on particular date empid and empdate should be allowed and it should not be dublicate date of the...

Mr.Galaxiom Thanks for your correction in the reply. My main aim is that, I want to navigate the records in form, I have locked all the bound text boxes. while navigating the records if find a record that is to be edited, that time the form should allow me to edit particular text boxes...

Thanks for your kind reply. I have tried as per your reply, in Form properties "Record locks" It has options : "All Records, No Locks and Edited Record". I have selected All Records from the drop down list. But it is not working, It is not locking the data. Please advise me I am fresher.

I have created a form, which is consist of "Submitteddate, Accepteddate and Respondate" Text boxes and etc. When ever this form is opend or moves the records by pressing first, next, previous and last. The displayed in the form should be read only. Please adivse me.

Thanks & I have tried it by converting, I got the result. I have form which is having details of employee whose date of join name etc. on that form it self i have a find command assigned. "Search form" will put data from the table or will it search forms. Please let me know further...

Thanks to your reply Now it is working out, Its very fine.

Dear, Thanks for your kind reply, Still it is showing the same msg "Not Found". I have checked it the date type is Date\time (medium date) in table and in the form it is medium date. It is not showing any error in the code but it is not pulling the data. Please do the suggest me.

The following code is showing only "Not Found", what is error in the code. please advise me. Dim Strsql As String Dim DtCri As Date Dim X As String X = rst.Fields("SUBMITTALDATE").Value DtCri = InputBox("Enter the SUBMITTALDATE", "Enter the Date/", "Question/") If Len(DtCri) = 0 Then MsgBox...

Please check "form find date" thread i have send please.

Since the code was not working properly hence i putup a question. I think some where there is a mistake in the code.

Please let me know clear, I am a fresher to this programming. Kindly go through the code, to put the data.

Dear, I have tried several ways but it is not pulling the record. "Not Fund" Msg is displaying. I have tried entering date as dd/mm/yyy, mm/dd/yy and dd/mm/yyyy. I table "SubittalDate" is date type and Medium date in display so Please heop me. Dim Strsql As String Dim DtCri As Date Dim X...

Dear, Thanks for your reply. The code what you have send I have pasted as per your instruction. Now it is working, but I have done the same. why it was giving me an error. Please suggest me so that in future i can trace myself the problem. Thanks once again.

Thanks I got it. I did the same thing but it didn't workout. After pasting your code, it workout. what mistake did I did Iam trying trece it. Now I am trying to find the date as per your earlier reply I wrote the following code: Dim Strsql As String Dim DtCri As Date Dim X As String X =...

Thanks for your kind reply, I appreciate your quick rensponse. But dear it is not working it giving a error: " Runtime error '3077':, Syntax error (missing operator) in expression.

Dim StrSql As String *Dim lngCri As Long* Dim X As String X = rst.Fields("Sr#").Value *lngCri* = InputBox("Enter the Serial NO", "Enter number/", "Question/") If Len(*lngCri*) = 0 Then MsgBox Prompt:="No Criteria Specified", Title:="Search tblEmp.MDB" Exit Sub End If StrSql = "SlNo=*" & lngCri...

Hi, I am a freshner in Access Programming from Dubai. My name is RAJAMALLU. Just I have posted one query please help me out. I would like to you to add my list.

Dear Frinds, I am very freshner Iam trying to find Serial No of Employee register. SlNo is Long Integer (Data Type) Dim IntSql as integer Dim StrCri as String I am trying, it is showing error Run time ‘3464’: Data type mismatch in criteria expression. I tried SlNo to Text (DATA Type) As...