Search results

Thank you for the guidance. I accomplished it as per your suggestions and it worked. I could do Data Entry, Edit and Print now. However, I face difficulty in searching. I have devised a form (sample taken from this forum attached) where any word or number can be searched in multiple fields...

Also another issue. The typed password is visible. It is not showing like ****** How do I get that?

After posting this, I removed the following lines of code: On Error.... Err.... Now it is working. But I have a question here. The post says to hide the label. In the Format properties of the label I chose Visible = No. The label is not visible but when I click on the space where I have the...

On searching the forum, I found the following post for enabling/disabling BypassKey. I did as instructed but on clicking the label, it gives 'syntax error with 'On Error Goto' in red color and highlighted. Hello af1112 welcome to the Forum... I use this code that ghudson supplied at the...

I don't know how to put this question. I have a date field formatted as 'dd-mm-yyyy'. How do I put the code to look up last record's year and if it is previous year's, block additions. Grateful for help.

I have searched the forum and didnt find an answer to this. I have an Edit Form. When it is opened, it displays the first record. I have a Combo Box where I select the specified ID and the relevant record is displayed in the form. What I want is that the Edit Form should be appear blank. The...

I have placed the following code in the AfterUpdate event of all text fields: Me.FieldName = StrConv([FieldName], vbUpperCase) Typed text in all the fields where this code has been placed gets converted to UpperCase, except the field 'Name'. In this 'Name' field, I get the following message ...

After looking at the replies to my post on the above subject, I realize that one needs to be an expert programmer in VB, SQL etc. to design queries/forms to filter records year-wise for all type of record operations. I know nothing about programming. So I have used these codes (of course, with...

I have been wanting to ask this question for long. Is it alright to put too many codes in the various events of the forms and controls? Will it affect the efficient functioning of Access? Will those codes result in any absurd behaviour? For example, I have DMax function in the BeforeInsert...

Mr John W, I appreciate the concern expressed by you. My DB is locked after 31st Dec and no data entry is possible unless the above command is executed. Thanks

Wonderful!! Wonderful, Sir, wonderful!! Your code worked. Thank you very much.

On the first day of January every year, I want to run a module to backup DB and then delete all records. If the date is not 1st January, then it should give a message. I want to achieve this with the click of button. I put the following code in the OnClick event of the button but it is not...

Thank you very much.

I have a field named TheDate with Format = dd-mm-yyyy and Default value =Date(). I created a query with criteria as under Like "*" & [Enter Date : ] & "*" When I run the query, the it asks for date input. After typing the date, it does not show any records of that date. Perhaps I have not...

So far I haven’t got help on my DB. I am attaching my DB. The DB has two tables: DiaryTable & RBCaseTable I want to resolve two issues on this DB First issue: The DyNo field will start from No.1 on new year (DMax function). Since there will be duplicate records with the same DyNo for every...

Thank you for advise and help As I am new to this Access Programming, I committed the mistake of changing the field to text. After The Doc Man's advice, I changed the DyNo field to number and retained the DMax code with single "0". I changed the format for the DyNo field to General number. I...

Thanks folks. It is for these wise guidance I love this forum.

I changed the datatype to Number - Long Integer. Now the DyNo field does not display any number at all.. Initially I had this field with Autonumber. During data entry, if the user cancels, the number is lost. The result is that I have a few missing numbers. So I changed it to text with DMax...

I changed the code as under: If IsNull(Me![DyNo]) Then Me![DyNo] = Nz(DMax("[DyNo]", "[DiaryTable]", "[TheYear]='" & Year(Date) & "'"), 0) + 1 End If Me![DyNo] = [DyNo] With this changed code, I am unable to do data entry after No.10. After 10, it repeatedly gives No.10. Please help.

But Sir, I need the Format function as I want the number to start from 1 on new year. If I remove, I may not get this feature. Any solution?