Search results for query: *

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

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...

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 :)

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...

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...

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!! :)

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...

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...

Thank you PHV that does it

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...

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...

Thank you that works! :)

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)...

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...

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?

Thank you so much PHV it's all working now

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...

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...

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?

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...