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 Chriss Miller 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: *

  1. OceanBlue

    Auto FE Updater

    Connie, Do you have separate shortcuts for each front end?
  2. OceanBlue

    Database Opening in Read-Only

    I just recently implemented a database to 90 users. I have split my DB into a FE/BE and I am using the Auto FE Updater to distribute the FE to the users. Everyone is able to access the DB fine except one person. Everytime this person opens the database it notifies her that the DB is opening...
  3. OceanBlue

    Auto FE Updater

    Bob, At first I was using the Database Splitter. But now instead I did the manual approach and everything seems to be working smoothly now. Thanks for your help :)
  4. OceanBlue

    Auto FE Updater

    Bob, Thanks for the tip. You are right the most obvious tends to be overlooked. What I did was started over and just split the database. When I split the db I tried to log on with a regular user with limited permissions and it told me that i didn't have persmission to access a table. So...
  5. OceanBlue

    Auto FE Updater

    I just recently found out about the Auto FE Updater, and wow I was truly amazed. I have everything working but it seems to strip all my permissions that I have set for my users. My .mdw file is in the same folder as the backend. I have the path set correctly in the ini file...
  6. OceanBlue

    Difference of Start Time and End Time?

    I implemented this: [LogHours] = Round((DateDiff("n", [Starttime], [Endtime]) / 60), 3) And from the table design view had to format loghours field to text, and everything is calculating correctly now. Thanks!! :)
  7. OceanBlue

    Difference of Start Time and End Time?

    TheQuestioner: Thank you for your post. I tried as you recommended but I'm still not getting the correct answer. Here's what I get: Start time: 8:35 AM End time: 9:45 AM Log hours: 1 Start time: 8:35 AM End time: 8:45 AM Log hours: 0 Start time: 8:14 AM End time: 10:46 AM Log...
  8. OceanBlue

    Difference of Start Time and End Time?

    A fellow member advised me to start a new thread concerning this problem. I don't want the user to have control on entering times so I have: Private Sub Form_BeforeInsert(Cancel As Integer) 'Fill in Start Time Me.Starttime = Format(Now, "Short Time") '",hh:mm:ss AMPM" 'Fill in Date...
  9. OceanBlue

    Validation

    Thank you PHV that does it
  10. OceanBlue

    Validation

    I need to modify this post. In the above post I have most of the things commented out for testing purposes. Below is the Correct Code On Error GoTo Err_cmdSubmit_Click If IsNull(Approval) Then MsgBox "Approval must be entered before you can submit the record.", vbCritical...
  11. OceanBlue

    Validation

    I have this validation code behind the sumit command button On Error GoTo Err_cmdSubmit_Click If IsNull(Approval) Then MsgBox "Approval must be entered before you can submit the record.", vbCritical, "Invalid Save" cboTO.SetFocus ElseIf IsNull(Type) Then...
  12. OceanBlue

    Combo Box Selection

    Thank you that works! :)
  13. OceanBlue

    Combo Box Selection

    Much appreciated! That seemed to do the trick. When I am on a new record I get an error msg "Invalid use of Null" When I click on Debug it highlights txtApproval.Visible = (JobType.Value = 7 Or cboJobType.Value = 8) txtPgsRejected.Visible = (JobType.Value = 7 Or cboJobType.Value = 8)...
  14. OceanBlue

    Combo Box Selection

    I read a similar post what I didn't get a solution the to problem I am having. If a certain selection is made from the combo box I need certain fields to be visible, else they should be not visible. I have this code as: Private Sub cboJobType_AfterUpdate() txtApproval.Visible = (JobType.Value...
  15. OceanBlue

    Calculate Time

    Here's another question. I wanted to calculate the number of days from the sum of the log hours. But I can't calculate the sum of log hours since it's formatted as time. I'd need to get the sum of log hours / 8 to get the number of days. How can I accurately get the sum of the log hours?
  16. OceanBlue

    Calculate Time

    Thank you so much PHV it's all working now
  17. OceanBlue

    Calculate Time

    Thank you PHV: I tried that and formatted my text box to short time. That output correctly but I don't know if it is outputting accurately. I did a test: Start Time 12:04:01 PM End Time 12:07:00PM Log Hours: 0:02 This may be a stupid question Shouldn't that be 0:03 Or is it because it is...
  18. OceanBlue

    Calculate Time

    On my form I have fields for StartTime, EndTime, and Log hours Private Sub Form_BeforeInsert(Cancel As Integer) Me.StartTime = Format(Now, "hh:mm:ss AMPM") End Sub Private Sub TotalWorkedPgs_AfterUpdate() Me.EndTime = Format(Now, "hh:mm:ss AMPM") End Sub I want to record the time that...
  19. OceanBlue

    Report on Sums from Combo Box?

    Thank you Lilliabeth but I would like to group my report Employee Name. I don't really want to have a grouping level for the Job Effort. I would like the totals to appear and the end for each employee. Would that be possible?
  20. OceanBlue

    Report on Sums from Combo Box?

    I have created a report based on a query. 2 of the fields I have are Total Worked Pages and Job Effort. Job Effort has 3 values: My Work, My Corrections, Others I need to see the on the report the sum of Total Worked Pages when Job Effort is My Work sum of Total Worked Pages when Job Effort...

Part and Inventory Search

Back
Top