Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rickm4
  • Content: Threads
  • Order by date
  1. rickm4

    Is this easy?

    I have a report i am generating that has 2 columns(for example purposes) REG1 Clocked Hours REG1 Non clocked hours The department heads want to see a "Total" of REG1 hours, They don't care if they are clocked or non clocked. How can I have 1 column named REG1 hours...
  2. rickm4

    D-Link 704 VPN Problem

    Hi, Here is my VPN problem, I have a PC at home running XP Pro. I have a D-Link704 Router connected to my pc. The network guys gave me the VPN client software to load at home, I did. Here is the weird part, I can hit our VPN because i get a msg. that one of the network guys put in to show that...
  3. rickm4

    1 Crystal report for Multible departments

    Hi all, I am very new to Crystal Reports (8.5) so please be patient :) I have created a cross tab report in crystal that is based on tables in out time and attendance system (Kronos CENTRA). The good new is, The department heads love the report!!! the bad news(for me) is, this report has to...
  4. rickm4

    Log in Form(??)

    Sorry for the silly question but here goes, I have a d/B with the following tables Tbl1: Dept# Password Requester Tbl2: Dept# Item Qty Month Justify This database is a budget D/B, the item field in tbl2 is a combo box where the department manager can select budget...
  5. rickm4

    Can't keep Table 2 in sync!!!

    Hi all, I have created a database that includes 2 tables (Projects , Updates) The two tables are joined via the Projects ID field. If i set up a sub form using the updates table, The projects ID #'s from both table will stay in sync as i scroll through the records. I decided i would rather...
  6. rickm4

    How do i...................

    Hi, If i download a 'Employee file" from outside of access(AS/400)into an Access db and i want people to only see their record from this file, how would i set up the log in and or password? I know i could run a query based upon the users id but i need to make sure that individuals can only...
  7. rickm4

    Date related msg.

    I have a Projects Database that includes a field containes, Estimated Completion Date. I would like to have a pop up msg. appear if the Estimated Completion date (of the project) is = or > than current date. My code i am using now is as follows: Private sub completion date before update(cancel...
  8. rickm4

    Adding records to a hidden subform

    Hi, I am a new Access user, I found a way to only show a subform if the subform containes records. This works great BUT.......How do i add a new record to the subform if it is hidden?? Thanks in advance. Rick

Part and Inventory Search

Back
Top