Search results
-
A
date vs now
Hello I am not too sure what is the technical difference between the functions date and now. Which one has more advantages. Thank you VC -
A
How to format a null value to 0?
Thank you , Rich.. it was simple, but life-saver for me.. thanks. Also, can you please tell me how can i format a numeric field on the fly in a query. Like, I want to list the decimal places to 2 (99.99).. apart from defining in a table or form, how can I do this in a query, which I will use in... -
A
error in making mde file
Hello When I try to compile an access 2000 mdb file to make it into an mde file, I get this message" Microsoft Access was unable to create an MDE application. It does not give any other msg. This is the first time I am doing this. Pl help with your ideas. Thanks VC -
A
How to format a null value to 0?
Hello I am using a query in a list in a form. The query fields depends on some values from another form. If the data is not available in the other form, the query is returning 'NULL' value. Their data type is integer. How can format the 'NULL' value fields to a 'zero' value, in the SQL... -
A
how to trap Mousewheel key?
I am trying to disable the mouse wheel (the small wheel in between the left and right mouse buttons). this is taking me through the records, and I would like to disable this feature of navigation. I tried to find the keycode for that in the keydown event, but I was not able to discover how to... -
A
can we lock form in Access like in VB?
Hello I remember in VB, we could lock the controls on a form, so that we do not move the controls by accident. This was helpful. Is there any feature like that in Access? I looked, but could not find a similar feature in Access so far. Thanks VC -
A
Cancel event is saving the record, anyway.
that was a useful lesson, Thank you Pat. -
A
shortcut keys
joeyreyma It worked like a charm.. thanks very much for the hint.. Stafford. Thank you for the idea.. I did not have enough time to figure to do with a macro.. I am sure it must be possible some way.. Thanks again. VC -
A
Cancel event is saving the record, anyway.
it worked.. thanks ... Dear guys It worked.. thank you so much.. I really mean it.. it made life much easier for me today.. regards vc -
A
Report going behing modal forms, when opened.
Greetings. I have an issue with my first report for the application. When I open Access, Form1 pops up. Then Clicking on a button, Form2 comes up. Clicking on another button, Form3 comes up. All these 3 forms have the modal and popup properety set to 'Yes'. Then I click on another button on... -
A
shortcut keys
Hello All I would like to keep some shortcuts in my application for the user. But I have not been able to suceed yet. Can you please help? The form I am using this has 5 pages in one tap controrl. I would like to assign one shortcut key for each page in the tab controrl. I wrote this code , to... -
A
Cancel event is saving the record, anyway.
Hello, I am using the Docmd command to close a form. I use this in the cancel button for the form. I hoped that the following line will do it, without saving the information. But it does save the record changes anyway. DoCmd.Close acForm, "frmDailyLog", acSaveNo I would like to avoid it... -
A
using 'AND' in query only if not null
That worked..!! I used it for a recordsource, instead of a query. But it was the same idea. thanks a bunch. VC -
A
using 'AND' in query only if not null
Dear Team I am using a unbound form, to get the criteria for a report, and then calculating the records for the report. For example, let's say the 3 fields for criteria is City, Married_Status, Retired (Y/N). They user needs to select at least one criteria. My query's uses an AND operation to... -
A
Any use of linking data, in a non-network environ?
Dear All, Is there any advantage to link MS-Access to another MS-Access Database though linking. I know it has many benefits in a multi-user /network environment. But in a small application or single user environment, does it have any use? Please let me know. Thank you very much VC -
A
a field value to default for next record
Dear friends, my question is how to make a field value default(copy over) for the next record automatically? i spent few hours working around the DefaultValue property. In the Afterupdate event, I wrote Drop_In_Date.DefaultValue = Drop_In_Date.Value, but that did not help. I also tried it in... -
A
Run-time error 2450:can't find form
Hello, I am getting a error msg in one line of my code: Set rst = Forms!author.RecordsetClone 'author' is a legitimate form I have in my database window. The error is Run-time error 2450: Microsoft Access can't find the form 'author' referred to in a macro expression or VB code. I can open... -
A
record count within a form
Hello, Apart from the navigation arrows in the bottom of the form, is there any way to put some control in the form which will tell which record it is (like '2 of 8 records' etc). I thought I saw this somewhere, but do not know how to implement it. I am trying to avoid the navigational arrows... -
A
multiple tab controls within each other.
what if different subform use different tables? Thank you for that. I tried that, but then the problem is I have more than one form in the tabs within, and they need to use different tables. These tables are not related to each other necessarily. So what is the sourcecontrol for the main form...