Search results

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

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

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.

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

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

I have created a table with customer name, address Second table with product name, unit price I also created a third table with fields from these two tables and the last field Total price. I created a form for data entry with fields from the third table with combos. What I want is if I select a...

I don’t know much of VBA/SQL. There are many commodities in my DB for which I need data as under year-wise upto a year from a year to the present year between certain years I export the query result to Excel to make a table/chart which will be printed. I used the following for all my text...

I found that a new table by name 'Name Autocorrect Failures' is appearinbg in my Objects window. I did not create this table. On opening the table, it gives infor as under Object name - Form2 Object type - Form Failure reason - could not open Time What is this? Is it anything todo with...

I need to see the records of a specific date very often. I have designed a simple query (Field : My date field; Criteria : Enter the Date) and it is giving info I want. However, sometimes it shows no records making me wonder where all the data had vanished. On checking up further, I discover...

In my Access DB, I have a field named ‘REFNO’. This contains reference numbers of some communications. I have a Combo Box to search records with this ‘REFNO.’ It so happened that there were two communications with the same REFNO. When I typed the wanted number in the Combo Box, only one...

For my Access DB, I have unselected the relevant options in Tools – Statup to hide the Objects window so that inexperienced users don’t corrupt the design of the forms, reports etc. However, I find that hitting F12 key brings a pop up window ‘Save Form (name of the form open appears here) To...

In order to prevent inexperienced users corrupting the design of the Forms, Reports etc. of my Access DB, I have unselected the relevant options at Tools – Startup and it doesn’t display the Objects window. However, I find that when I press F12 key, a pop up window appears with ‘Save As’ ‘Save...

The last field in my table is 'Comments'. I want to find if any record or records with 'Comments' field empty. I created a query and added all fields from my table. In the criteria section I typed Like "null". But the query is not returning records where 'Comments' field is empty. I have...

I am asking this out of curiosity. Is there a way to block the appearance of Visual Basic Editor? Whenever there is some mismatch or error in the operation of Access DB, the VB Editor displays the codes with ‘End’, ‘Debug’ & ‘Cancel’ options. What I feel is that inexperienced users may fiddle...

Yesterday, my Access MDB didnt work properly. On scanning, I found a virus infected Access EXE file. After cleaning, my MDB works fine and data was intact. This has prompted me to ask these questions. 1. Can a virus attack an MDB? 2. Is it possible for data to get corrupted if I work...

I made an Access DB program in my PC. I have 17 inches monitor and so I designed everything to fit in that screen. When it was deployed in the user's computer, it did not fit in his screen as he has only 14 inches monitor. The command buttons and other things were not visible and were out of...

In my DB, I have a date field. The default format is set as 'dd-mm-yyyy'. I have made query to view the records of a particular day. On hitting the command button which is linked to the query, it asks for the Date input. Now comes the strange behaviour of the query. If I type 04-06-2007...

I have a query SELECT ......... WHERE ........ ORDER BY MyTable.DateRecd [DateRecd] is a date field in my table. This query returns records I want in my form, the oldest date record being the first in the list. How do I change the query so that I get the latest entered record to appear first...