Looking foward to it. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==>...
My form filter quit working this week and I am not sure why. The only change was from Windows 2000 to Windows XP. I have checked all references and did not...
Is the DAO 3.6 checked in your references? May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases ...
Hello all, I am developing a database for computer inventory regarding several departments in different buildings. There are 3 buildings and 10 departments....
I will check on Tuesday Lonnie when I return to work....I was so intent on seeing a missing reference marker that I forgot to check for one that just wasn't...
Jim, In general you are not putting the correct foreign key in the tables such that you can figure out where things are and to what they are connected. Just as...
That did the trick Lonnie! Thanks...Clicked on DAO 3.6 under references and everything started working immediately! We just changed from Windows 2000 to...
Asalam O Alaikum I need advice of tax expert, my problem is as under. We are Commercial Importer and we import the goods under H.S.Code • 2710-1992 •...
Is there any way to have the name of the particular routine being used stored as a variable? Example: Sub GetMonth(MyMnth) Dim Y, MnthNum Y = Now MnthNum =...
I have a table where I have ID and total fields. I want to get top 80% values from total field. Also, anyway of getting the remaining 15% and 5%? Thanks in...
I am doing a financial application , my manager told me to make the closing time of the day after the day ends by 6 hours - which means the day ends 6 a.m on...
My Access project is getting too large, it's over 19MB, yes i've compacted & repair. I'm considering breaking it up into 'modules' and create an adp for each...
Jim We design tables to produce reports, agree, cool, So always consider what the report should look like before you attempt to design a table. this will guide...
Jim, There are at least two valid approaches to physical database design. The top-down (outside-in) approach and the bottom-up (inside-out) approach. I...
Dear all, I have a case like this. I have a combobox and another field to entry the data. For example, Private Sub cboObv_AfterUpdate() If cboObv = True Then ...
Any one can help me? _____ From: AccessDevelopers@yahoogroups.com [mailto:AccessDevelopers@yahoogroups.com] On Behalf Of Achi Rachimuddin Sent: Thursday,...
Achi, Are you trying to code cascading combo boxes - - the selected items in the first box constrains the list in the second box which constrains the list in...
I am also interested in cascading como boxes. Could you give us all a detailed outline of how ti do? Ove ... From: Dick Root To: ms_access@yahoogroups.com ...
Hi Dick, It could be better you post the code. My problems actually like this I have one field name cboObv and the other field name SafObv data type Memo. When...
Ovi, Achi, I will post the code as soon as I can, maybe later this evening (PST). As I recall the code is in the middle of some complexity that I should...
Achi, Ovi, The SQL WHERE clauses with the "cboCustomer" and "cboProduct" work because the required key is in the first position of the prior (superior) Combo...
The best website to learn MS ACCESS for free http://msaccess.batcave.net This contains all details which u will require to design all tables, reports, forms...
Hello Dick, I thougt the conditions in the Achi problems could be transferred to my situation but I cannot come through. I am not enough experienced. So I...
First, Achi's problem. Achi - it sounds like you want the user to pick values from a combo box and have the value selected appear in a memo field - without...
hi - started a db, made progress - - need aid getting finished and to be usable! Legit time sensitive need please. Someone who has time and the expertise to...
Dear E- I see you also posted this in MS_Access_Professionals. Same answer: You'll get lots of help on this forum - one problem at a time - but few of us have...