I'm using Access 2003, and trying to use AD0X.catalog in VBA, but I get the "user defined type not defined" error. I've looked in references, but see no...
90856
Bill Mosca
wrmosca
Jun 1, 2011 8:57 pm
Rob I've had that reference get out of alphabetical order in the References dialog. Try looking up near the top below the ones you already have checked. You...
90857
Jim Wagner
luvmymelody
Jun 1, 2011 10:16 pm
Bill It crashes on the line aryTotals = Split(.Fields(1), ",") Jim Wagner ________________________________ ________________________________ From: Bill Mosca...
90858
Jim Wagner
luvmymelody
Jun 1, 2011 10:20 pm
Bill, Here is my table design with sample data. I wish we could get it in another format. But this is what I get. Breakdown_TotalCharges_CostCenter = JA 1001 ...
90859
Jim Wagner
luvmymelody
Jun 1, 2011 10:28 pm
Bill I created a database with the table and I am uploading it to the files section Jim Wagner ________________________________ ...
90860
MS_Access_Professiona...
Jun 1, 2011 10:32 pm
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
90861
rivera_vazquez_edgar
rivera_vazqu...
Jun 2, 2011 12:20 am
Hello again, Edgar here... So I made all my tables and relationships, followed normalization rules and starded to make my forms. My main table is tblCompany,...
90862
jrv2110
Jun 2, 2011 2:06 am
Hi Edgar, First you should make sure you have in tblAddresses a field that you can use so reference to frmCompanyDetail. You would link it to IdCompany on the...
90863
John Viescas
johnvmvp
Jun 2, 2011 5:47 am
Edgar- I assume you designed it that way so that each customer can have more than one address. You need the IdCompany as a foreign key field in tblAddresses....
90864
Duane Hookom
dhookom
Jun 2, 2011 12:24 pm
Jim, You stated: ======================== The data has the following records JA21001 768.59,3.31, .00, 45.42, .00, 817.32 JC11001 159.35,...
90865
j1eggert
Jun 2, 2011 1:30 pm
Fathan, A while back you requested that I uploaded the Excel spreadsheet that queried data from Access 2007 so you could review it and provide sample code for...
90866
ka0t1c_ang3l
Jun 2, 2011 1:53 pm
Good Morning! I'm having a problem with the code I have set up when I login into my database. The code is supposed to let me know if there are any contracts...
90867
John Viescas
johnvmvp
Jun 2, 2011 2:13 pm
Kat- What is the SQL for your Expired Contracts query? You really shouldn't open a table or query directly in an application. You should open a filtered form...
90868
ka0t1c_ang3l
Jun 2, 2011 2:21 pm
John - This is the SQL for the query: SELECT [CONTRACT INFORMATION].[CONTRACT START DATE], [CONTRACT INFORMATION].[CONTRACT END DATE], [VENDOR...
90869
Rob Whitney
r_l_whitney
Jun 2, 2011 2:25 pm
Bill, Re-registering the DLL did it ... Thanks! Rob ________________________________________ From: MS_Access_Professionals@yahoogroups.com ...
90870
John Viescas
johnvmvp
Jun 2, 2011 3:06 pm
Kat- Is there anything in the txtNotify control on the Contracts Expiring form? And where are your joins in the query? You're getting the cartesian product of...
90871
Jim Wagner
luvmymelody
Jun 2, 2011 3:21 pm
Duane Sorry, I thought I mentioned the commas. The table is a downloaded xml file from verizon website for our employees phones usages. Jim Wagner ...
90872
Bill Mosca
wrmosca
Jun 2, 2011 3:33 pm
You're welcome, Rob. Bill...
90873
ka0t1c_ang3l
Jun 2, 2011 3:43 pm
John - The Contracts Expiring form asks me to enter a number then when I hit the "Run" Command Button, it sends an email notification to everyone who has a...
90875
John Viescas
johnvmvp
Jun 2, 2011 4:07 pm
Kat- Are you saying the query prompts you with [Forms]![Contracts Expiring]![txtNotify], or is the Contracts Expiring form open? And you didn't answer my...
90876
ka0t1c_ang3l
Jun 2, 2011 4:16 pm
John - When I first open up the database and login a msgbox pops up telling me I have contracts that are about to expire, and then it asks if I want to view...
90877
John Viescas
johnvmvp
Jun 2, 2011 4:31 pm
Kat- "I looked at the query in design view and I don't see any join lines between the tables." THAT is your problem! You must link the three tables in the...
90878
ka0t1c_ang3l
Jun 2, 2011 5:54 pm
John - I uploaded an updated database for you to look at. I took out the modules so you don't get the errors for groupwise. I added in the joins in the query....
90879
jfakes.rm
Jun 2, 2011 5:58 pm
I know there has to be an easy way to do this, however, I haven't been able to figure out how to do it. I have a report that has a form open with a list of 100...
90880
Bill Mosca
wrmosca
Jun 2, 2011 6:45 pm
Jim I got your sample and will look at it. Bill...
90881
Crystal
strive4peace...
Jun 2, 2011 6:55 pm
Hi Jim, Thanks, Jim. You didn't miss anything, I did. I normally save a record before moving to another one ... but this code is behind an unbound form. The...
90882
Crystal
strive4peace...
Jun 2, 2011 6:57 pm
thank you, Bill <smile> I fixed a bug and added a lot more comments. DB_RandomPicker_Crystal_110602__ACCDB_TXT_PNGs.zip ...
90883
John Viescas
johnvmvp
Jun 2, 2011 7:02 pm
Kat- Completely and utterly WRONG. Why would you link the ID from employees to Contract ID? Why do you think Vendor ID is related to Contract ID when there's...
90884
Bill Mosca
wrmosca
Jun 2, 2011 7:29 pm
Jim I changed my code after I saw that your table actually had separate fields instead of one field with commas. I’ve uploaded a file to your folder. All I...
90885
ka0t1c_ang3l
Jun 2, 2011 7:49 pm
John - Thank you for helping me with the joins for the query. As I've stated before, I'm new to Access, I've never really worked with it other than with this...
