General
in [Access]
|
Inventory/Sales/Warehouses Hello, I am creating a shipping and logistics database in Access 2007 to keep track of sales, inventory, shipping costs, etc. We have 4 warehouses that handle shipping to distributors. I am probably making this more complicated than necessary, but this is tripping me up in designing the query that I want.... 30 Apr 2010 17:26
Tables: Appending Data, Link or Not to Link, That's My Question... I am sure that someone has asked this at one time or another, but haven't found it out here yet. I have several inter-related databases, some of them have linked tables while others have queries appending to tables which they are not linked to. What is a good rule of thumb for when it makes better sense to li... 1 May 2010 09:49
Form with combo box to set criteria for query and report Using Access 2003 a form has been created with a combo box to select the name of a practice. The criteria row in the query shows the form information. When the command button in the form is clicked to run the report the report runs with the labels appearing from the underlying query but does not show any of the... 30 Apr 2010 15:10
Parsing a string problem I'm inspecting/parsing a user input string, starting near the end and working to the beginning. code: i = Len(strApplication(iRecords, 1)) While Asc(Mid(strApplication(iRecords, 1), i, 1)) >= 48 And Asc(Mid(strApplication(iRecords, 1), i, 1)) <= 57 i = i - 1 Wend end code The ... 30 Apr 2010 11:44
My Favorite Feature My favorite feature about Windows Vista is ablilty to use different programs and the new style to it. ... 30 Apr 2010 09:29
Help with special query, confused Hello, I have two tables. Table1: Date/Time Number Product 12/03/2009 7870055 PLANA 12/05/2009 7870055 PLANA Table2: Date/Time Number Product 14/04/2009 7870055 Done Well as one can see, the number is common in both tables. I would like to return a query with follo... 3 May 2010 19:51
Query Designer font is so small. Hi, Many times I tried to test my queries in Query design. However, the fonts there are very small which is so hard to read. Is there a way to make it bigger without enlarging other fonts? Others are OK to read. Thanks. ... 30 Apr 2010 02:56
How to reach through subform to underlying table? With VBA I've learned to pull data from fields on my subform like this: sbfVendorDetail.Form.[Start Date]. However, fields such as the ID may not be on the subform since the user doesn't need to see it and it would take up space. Is there a way to read the ID field of the current record of the subform without... 29 Apr 2010 21:29 |