Recent content by gear

Sorry for late reply, Mr. Kafrin At first I could not grasp the underlying concept in what you have written. Hence I got confused. I thought over it again and now it is clear. I have implemented it and it is working perfectly. Thanks once again.

Thanks for your reply. This is what I understand from your reply. 1. I need to add two fields (say StartMonth & EndMonth) to my table wherein the first day of the month and year will be inserted after filling up [StartDate] and [EndDate]. 2. I need to use these two fields in the search...

I need help on my query. I have made an employees leave plan database. This has two text fields [StartDate] and [EndDate]. I want search by month/year (like Jan 2009, Feb 2009 etc) and my search should give me a list of employees on leave during the current month (or future month). This will...

Thank your very much. This exactly what I was looking for.

I have a text box in the report footer which displays the sum total of the amount in figures. I have also created another text box in the report footer to display the amount in words like 'three hundred', 'six hundred seventy' etc. My attempts failed to achieve the result for the word display...

Worked great. Thanks

My table and form has the following fields Rec_ID - Autonumber Ser_No - Serial number generated when form is opened for data entry 2 text fields When the user opens the form for data entry, Ser_No displays the next serial number. After filling up the text fields, the record gets saved when...

My DB is split into BE and FE. I have linked the tables. When I use Compact and Repair from FE, it only compacts FE and not the BE. Is it possible to compact the BE from FE? If so, would be grateful for help on code.

Thanks for guidance. I will do it.

I have the same issue as Berti's. I created a find duplicate query through wizard. It identifies the duplicates. When I converted the same query to a Delete query, it deletes all the records. For example, it displays the two duplicates records ABC 7745 ABC 7745 When converted to delete...

I want help to make a query in my database. The fields are : [RecID] [TheDate] [SerNo] [TextField1] [TextField2] (Autonumber) (Date) (Number) (Text) (Text) [TextField2] is not filled up at data entry stage and is done later. I want the query to search records date-wise (for a period I...

My Access DB has two Number fields and five Text fields (each having field size of 200). They contain text. The DB is organised year-wise. I have now crossed 15000 records. I find that the search is very slow. Search is done on all these text fields for each word typed. Some one suggested...

Your code works. Thank you very much.

I have ‘S_NUM’ field in my Table1. This field assigns sequential numbers to records. Sometimes it needs to be changed to start from a different number. I created a new table (tblAppend) with one field (S_NUM). Then I made an Append Query. I inserted a new number in ‘tblAppend’ and run the...

Combo box behaves wierdly Thanks for your reply. I got it done. I have 34 items in the list and my combo lists all the 34 items. But it is not taking some of my selections and instead it selects something else. I list here the item number I select in the drop down list and the item number...