Search results

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

I am using Access 2003. I used the following code on Key Down event of the form and set the KeyPreview to Yes. Private Sub form_keydown(KeyCode As Integer, Shift As Integer) Select Case KeyCode Case vbKeyF12 KeyCode = 0 Case Else End Select End Sub On hitting F12, I still...

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

Thanks, it works.

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

Many thanks for the reply.

Dear Bob You mean I need to put this error handler for each event?

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

Thanks to everybody. I will seriously look into the firewall thing. I have Norton but I dont know how it didnt detect the virus. Thanks once again.

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

Thank you, it worked.

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

I created a personal database for keeping track of my meeting schedules. My table has Date field, Time field and Subject field. I have made several entries. On a given day, I have several meetings at different times. I created a combo box in my form to choose the Date and see that day’s...

Please have a look at the following code (I am not good at VBA or SQL). Me.[txtBox] = DLookup(“[SNum]”, “[Table1]”, “[RecID]) If Me.txtBox =>2 Then Condition if true Else Condition if false End If I type a value in my [txtBox], a number. I want to evaluate if the typed value meets the...

I need help please. 1. I have a [CmdBtn] to do some calculation on the first day of every month.(The Btn and calculation code are ready and working). 2. On clicking, the [CmdBtn] will look for [FieldTotal] entry. If no entry, it will execute.(This code is also fine and working). 3. While...

I have a command button which will work on a specified date of every year. After the user clicks it once (which will carry out calculations), I want this button to be disabled so that it is not available for second click. Is it possible?