Getting Started
in [Access]
|
Linking Excel Files in Access I have 4 CSV files that I need to somehow link together so that I can query the data. I could manually add the data together but would prefer that is was linked via Access so that it can be automatically updated each month (via Peachtree). Some of the columns in each spreadsheet are the same (G/L Account, Amo... 27 May 2010 18:11
Help with Function: Between Time Hi, Why this function is not working? If a time follows between 12AM and 3PM it should show Day shift, anything else Night Shift If Time > #12:01:00 AM# < #3:00:00 PM# Then MsgBox "DAY SHIFT" Else MsgBox "NIGTH SHIFT" End If ... 27 May 2010 11:31
totals do not display unless user clicks on text box I am relatively new to access. I am using access 2007 to create a report that contains subtotals. When the report is displayed on the screen the subtotals are blank. When the user clicks on the subtotal text box then the value appears. The user has to click on each subtotal in order to make the value appear. ... 28 May 2010 12:40
Is it worth it for me to learn Access? Hello everyone, I've been wondering this question for a few weeks now. My situation is that I generate many "runlogs" from my reactor that have various outputs, such as temperatures, sensor data, etc. versus time. Very frequently, I want to compare one runlog to another. Sometimes I want to average the outp... 26 May 2010 11:22
Query joining two tables with different dates I'm sure there is a simple solution to this, but being fairly new to Access I would appreciate some assistance... I have a query that joins two tables. One table has call details for each day that an agent works. The other table has details for each call that is graded for each agent. However, calls can be graded... 28 May 2010 13:46
Filtering Records Hi, Problem : I have a DB table with 56 fields and form is on 1 screen. If I filter records I need result of filter to display in form view. I know it is possible in datasheet view - but it is not good for me because I need see all fields and in datasheed view with 56 fields it is a very long row an I have to use ... 25 May 2010 15:47
Combine number in a Table field Is the following possible I have Table 1 with Field IDTable1 [autonumber] [and other fields] and Table 2 with Field IDTable2 [autonumber] and Field GRV set to text [and other Fields] Is the following posibble: Can I automatically generate a number that can be used in GRV field of Table 2 consisting out of a ... 25 May 2010 09:07
MassageBox I create a program Audit Tools...and I want Make MassageBox if my subform empty...I want make massagebox "No Data Found"...What Should I do???? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/201005/1 ... 24 May 2010 15:44
Bill of materials - stevie is pimping again. "Steve" <notmyemail(a)address.com> wrote in message news:uxSFJhg%23KHA.1892(a)TK2MSFTNGP05.phx.gbl... Hello Chris, If you want, I can create a BOM database for you. I provide help with Access applications for a very reasonable fee. My fee to help you would be nominal. Contact me if you would like my help... 22 May 2010 22:33 |