My database has 2 tables: tblPatInfo and Timing with one to many relationship Timing table has the status of the records: Sent to Nurse, Letter to Provider,...

Hi, I am trying to use the dfirst function to pick the first description of a particular date. e.g first instance where the description 'NEF Grant'...

Hello experts, I'm designing a simple database for a small billard business and I'm having some problems with controls on forms. here's a little brief: * Two...

Hi! 1.How can I simulate pressing Access shortcut keys? I want to simulate pressing the Ctrl+' combination. 2. How can I trap pressing one of the F...

Hi! I want to add a button to the form so that if the user presses that button, access will open a new email message in outlook with a report showing only the...

Hi! I have a form with OLE field named "Attached_Document" which is actually a field in a table named "tblMy_Table". Each record in the form can have the...

hi. i want to open a application when i see a record for example for part number 211 i have many specification and i`d like to have a key which shows me the...

How do I supply the correct password to a linked tables? I've created a database with linked tables. The database with the originals tables, which is password...

I am using an 6 option groups as a scoring system in a form. Option 1 is for needs improvement, 2 for Satisfactory, 3 for exceptional and a 0 which stands...

I have made a field (B)in a form which is controlled by other field(A) using following expression = /2 I am able to see the value of filed in the form but not...

I wonder if some one could tell me how can we add a calendar button on a form to enter date..as we do while we book our ticket online on web...when ever we...

Hi guys, I have created a form in access and attached it to a access database and everythign is working fine, i want to know how do I create an icon on teh...

Hi guys, I have created a form in access and want to display the result in the same form, how do i do it?, coz once i enter the required and click on search...

hi guys i have written this query and attached it as a macro to an access form , SELECT DISTINCT ., ., ., ., ., ., ., . FROM dbo_businessNC,...

Hi, i have created a form in access and attached sql queries to it, now i want to generate soem hot keys, so that if a customer presses say F1, the application...

Hi Is there a way to find if the user has changed data in the unbound field of a form? I want to prompt the user to save the record when he moves to next...

Hi, I have RTF2 control within a Tabbed control on a form. Basically this control is used as a preview control to view a description text in RTF format. There...

Hi i have designed a shortcut menu like righ click menu on text box but i need to do some thing else with that menu like built in Filter For type of option...

Hi any one know how to create right click menu in vba like if i right click on text box then it show me a menu with some command thanks

Hi i want to design a form based on query not on single table..... ok i have done that but the actual problem is on based on query i cannt write any thing to...