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!

  • Congratulations wOOdy-Soft 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: JSD
  • Content: Threads
  • Order by date
  1. JSD

    Different errors on different machines?

    Hello I am working with a db on a network with multiple users. There are four different computers using it. I am running this code after update of a 'wc' control: If DCount("[wc_code]", "dbo_rtemastr", "[wc_code]='" & Me!wc & "'") > 0 Then 'Do nothing Else MsgBox "This is not a...
  2. JSD

    Can't Sum a Calculated Field in a Chart?

    Hello, I am working with a query that has a calculated field that subtracts two date fields to get its value. I want the sum of this value in a chart with 'date' as a baseline. However, I am having trouble getting msaccess to do anything but count the records for the calculated field. I get...
  3. JSD

    Can't Sum a calculated date field in a chart?

    Hello, I am working with a query that has a calculated field that subtracts two date fields to get its value. I want the sum of this value in a chart with 'date' as a baseline. However, I am having trouble getting msaccess to do anything but count the records for the calculated field. I get...
  4. JSD

    Mult calc fields in one query so I can bring into chart

    Hello I am working with a query that tracks log in times and log out times of employees. When the users log in, they are either logging in to run time, set-up time, or down time. They can specify set-up or down time by checking a box for either. All in one query, I want to have calculated...
  5. JSD

    Specifying criterfia in a calculated field expression

    Hello I am working with a query that tracks log in times and log out times of employees. When the users log in, they are either logging in to run time, set-up time, or down time. They can specify set-up or down time by checking a box for either. All in one query, I want to have calculated...
  6. JSD

    Subtract a half hour from a field If it's value is greater than 6 hrs

    Hello I am working with a db that employees use to clock in and out of jobs for production/ efficiency tracking. I don't want them to have to take time to clock out for lunch. Is there a way to maybe create a calculated field that subtracts one half hour from another field called 'act hrs' if...
  7. JSD

    Front End forms open super slow

    Hello, I am working with a db that I just recently split manually. Now the forms in my front end take forever to open. Could someone possibly share some pointers on how to improve this performance? Many thanks as always. Thanks Jeremy
  8. JSD

    Hide certain buttons on a switchboard based on login username?

    Hello, I am working with a db that has a switchboard with various command buttons I would like to hide if user login name is 'shopfloor.' Can this be done? Thanks Jeremy
  9. JSD

    AfterIsNull Message, delete original entry

    Hello, I am workin with a db that has a form and a subform. The subform has a couple of controls on it that have If IsNull functions, then msg box. The only problem is that when the user clicks ok after an IsNull msg, The bogus value is still there. In fact, once I set focus away and back to...
  10. JSD

    After IsNull message, delete original entry

    Hello, I am workin with a db that has a form and a subform. The subform has a couple of controls on it that have If IsNull functions, then msg box. The only problem is that when the user clicks ok after an IsNull msg, The bogus value is still there. In fact, once I set focus away and back to...
  11. JSD

    go to new record in subform using a macro

    Hello, I was wondering if there is a way to go to a new record using a macro. I need this because I'm trying to use function keys to trigger commands instead of mouse click. I had this working in VB onclick of a button in the subform using DoCmd.GoToRecord , , acNew. This same command does...
  12. JSD

    SetValue

    Hello, I am trying to use SetValue in a macro. Whaqt I'm trying to do is set the value of a control on a subform = 1. Item: [Forms]![frmwipin_plantone2]![Text89] Expression: 1 Not sure where I'm going wrong. Any suggestions are extremely appreciated. Thanks Jeremy
  13. JSD

    Need a Way to Compact and Repair without needing exclusive access

    Hello, I was wondering if there is some kind of statement that could be written that compacts and repairs msaccess db without needing exclusive access. We have a db with about 30 users on five computers. If four computers are logged in and one is not, the fifth can't be logged in if the db...
  14. JSD

    Need a Way to Interrupt IsNull MsgBox if User Eants to Start Over

    Hello, I am trying to add a restart button to a form in case user messes up. Button does an Me.undo and sets focus back to first control on form. The problem is when they hit the start over button when they are in a required field. My required fields have If IsNull, Then MsgBox functions and...
  15. JSD

    DLookup question

    Hello, I am working with a db that has a form and a subform. On the main form, there is an unbound control called 'employeeno'. After user updates the employee number I want their name to appear in another control on the main form also. Because 'employeeno' is unbound in this case, I tried...
  16. JSD

    My own inputmask msg

    Hello, I was wondering if there is a way to have my own msgbox come up instead of the default input mask error msg. Grateful for any help on this. Jeremy
  17. JSD

    Go to new record in subform?

    Hello, I am trying to go to a new record in a subform after update of a control on the main form. I had this in the OnEnter event of the subform: DoCmd.GoToRecord , , acNewRec DoCmd.GoToControl "basketno" I tried putting this AfterUpdate of the control on the main form, adding the...
  18. JSD

    Need a way to interrupt my IsNull MsgBox if user wants to restart

    Hello, I am trying to add a restart button to a form in case user messes up. Button does an Me.undo and sets focus back to first control on form. The problem is when they hit the start over button when they are in a required field. My required fields have If IsNull, Then MsgBox functions and...
  19. JSD

    Runtime error 2110

    Hello, I am getting a runtime error when I try to move the focus away and back to a control after an error msg occurs. The error occurs on a 'jobno' field. I am trying Me!insu.SetFocus Me!jobno.SetFocus And I get a runtime error that says it can't move the focus back to jobno. Any ideas...
  20. JSD

    Subtracting two date fields

    Hello I am having a problem subtracting two date fields in a query. I had it working about four months ago, came back to it now and it's not working. Here is the query: SELECT [dbo_rtemastr].[part_no], [dbo_jbmastr2].[jbcode], [dbo_rtemastr].[route_id], [dbo_rtemastr].[wc_code]...

Part and Inventory Search

Back
Top