Search results

I have a bunch of old Access databases that were written under 32-bit software. I now have a total unfriendly 64-bit system that will not let me use my old code. Sample errant code: ************ Declare aht_apiGetOpenFileName Lib "comdlg32.dll" _ Alias "GetOpenFileNameA" (OFN As...

I have several fields that require data entry, combo boxes and simple text boxes. When I skip one of the require fields and depress my enter command button, an error message box appears with a message similar to (Run Time Error 3314 you must enter value in the ‘MainTbl.MainPur’ field). I...

On a field in my Table, I would like to have a format (dd mmm yyyy) or (dd-mmm-yyyy) or (yyyy-mm-dd) because my data spans several centuries and I wish to sort on this field. "Medium Date" comes close but messes up the century changes. Is there a way of establishing this format in my table and...

I have several Combo Boxes in my current project and none advance to the next field after making a selection. I always used the mouse to position to the next entry. Is there a property sheet setting that causes advancement or an Event Procedure needed, but which action (On click, On Update, On...

Is it possible to place a numeric field on a form that is not associated with any Table? It would be used to calculate a value that would be written to a Table field. I am trying to convert field InVal that is regular Ounces or Grams and convert to Troy ounces via buttons event criteria...

I have a db with a Table PersonalT which has numeric values (1 to 5) in the field PoliticalPreference. In a Report I am attempting to use the codes (in Property Sheet field Control Source) to print an associated phrase. I have tried various code functions: Switch, Choose and Iff. When the...

I feel ashamed to post this question, but I have forgotten so much. I have a very simple Form with a combo box ("Stage" Property Name), a text box ("Select_Nr" Property Name) and fields that are Table defined. I am using Access 2010. The intent is take the values stage and Select_Nr...

After reviewing comments on Access 2013, I decided to go for 2010. I could not believe how hard it would be to find a legitimate site that actually had Access 2010. I ended up getting it as a included product of Office Pro 2010. This leaves me with several dilemmas (1) de-install current office...

I need advice as to where to start my retraining. I have 28 years experience programming for main frame aps (14 special languages) and I programed several Access database back around 2003 -2009. What I am looking for is a code reference card/or? that will allow me to look up the purpose of a...

My name is Philip, I am 73 years old and a retired main frame computer specialist. I have used Access since it was bundled in Office. Last January my 10 year old HP died taking with it My VISTA O/S and Office/Access 2003. My new PC has Win 8 and office 2010 with a free upgrade to Office 2013...