User Profile

Collapse

Profile Sidebar

Collapse
Basenji3
Basenji3
Last Activity: Nov 29 '17, 01:20 PM
Joined: Mar 7 '14
Location: Monroe, WI
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Basenji3
    started a topic Make table query not working

    Make table query not working

    I have a query from which I would like to make a table named 18H. When I run this along with some other queries as an event procedure, it does not work. If I run it manually, it works fine.

    Not sure what's happening; I do have some criteria where it makes sure it picks the correct data by stating this time is between a start and end time on the other table.


    Code:
    SELECT [SP-Pick].DDate, [SP-Pick].EmpNo, [SP-Pick].TTime,
    ...
    See more | Go to post

  • Basenji3
    replied to Fill Null Record
    Ok, I got it to work, thanks.
    See more | Go to post

    Leave a comment:


  • Basenji3
    started a topic Fill Null Record

    Fill Null Record

    I receive a daily excel file that I have to pull into Access, where the file is appended to another table. One of the fields required is a status for that product. The excel file does not list the status for each order, but, they are in order by status (a status does appear for the first order always). I need to be able to fill all the null fields with the status listed in the previous record (please see the attached screen shot). I'm not quite...
    See more | Go to post

  • Basenji3
    replied to Delete Record based on date
    Sorry if I didn't explain it well enough. I have a form that opens with the 1st of each month as default. If a user adds other dates, that's fine, but if they delete the 1st, this causes issues with all the reports, I need at least one date per month for it to work correctly. So, I'm trying to stop them from deleting the default date. In the form the date is named "day".
    See more | Go to post

    Leave a comment:


  • Basenji3
    replied to Update Query
    Thanks for the help, I forgot to post the response some time ago.
    See more | Go to post

    Leave a comment:


  • Basenji3
    started a topic Delete Record based on date

    Delete Record based on date

    I would like to stop users from deleting the first day of the month in a form. I'm running into an error of Object Required "Set X =1". Not sure what I'm missing.

    Code:
    Dim Day As Integer
    Dim db As Database
    Dim tdf As TableDef
    Dim X As Integer
    
    Set db = CurrentDb()
    Set tdf = db.TableDefs("tblPTO")
    Set X = 1
    
    If tdf.Fields("Day") = X Then
    ...
    See more | Go to post

  • Basenji3
    started a topic Update Query

    Update Query

    I have a simple update query that should apply numbers to a text field, but it keeps dropping the leading zero. Should be 054846, but ends up as 54846. Can't figure out what I'm missing.

    Code:
    Dim strsql As String
    strsql = "UPDATE [Action]" _
           & "SET [Action] = (" & "054846" & ")"
    
    DoCmd.RunSQL strsql
    I can't afford to pull anymore hair...
    See more | Go to post

  • Basenji3
    started a topic Sum units between time stamps

    Sum units between time stamps

    I have two tables; tblTime,this contains the emp#, Date, start time and end time. The 2nd table, tblUnits contains the emp#, Date and individually time stamped unit quantities.

    I need to add the units between the start and end times. Not sure how to do this. I've attached an Excel file showing what I'm working with....
    See more | Go to post

  • It may be as simple as using SUM.
    See more | Go to post

    Leave a comment:


  • Basenji3
    replied to SendObject error 2501
    Okay, I'll keep playing with it, even with your test code, it still continues to stop at the docmd.sendobjec t line, it never reaches the error handler.

    At least this is a good challenge going forward for me.

    Thanks....
    See more | Go to post

    Leave a comment:


  • Basenji3
    replied to SendObject error 2501
    Seth,

    It's stopping at the DoCmd.SendObjec t on line 19. When I press F8, it does loop and runs the next record.
    See more | Go to post

    Leave a comment:


  • Basenji3
    replied to SendObject error 2501
    Made the changes as you suggested, but it still will not resume the process....
    See more | Go to post

    Leave a comment:


  • Basenji3
    started a topic SendObject error 2501

    SendObject error 2501

    I have a statement that loops through a table to send a report via email. If I send all the emails it works fine, but if I cancel and email, I get the run-time error 2501 Can't sendobject.

    I have an error handler in place, but I can't get the code to resume.

    Code:
    On Error GoTo ErrorHandler
    Dim rsLoop As Recordset
    Dim strSQL As String
    Dim db As Database
    Dim stDocname As String
    ...
    See more | Go to post

  • Basenji3
    started a topic VBA - Loop through query and email reports

    VBA - Loop through query and email reports

    I'm a novice with VBA in Access and I have ran into a problem. If someone has some ideas I would appreciate it.

    I have a list of managers in the "tblReports To" table (reportsTo is the field). I need to loop through this table, grabbing data from the "tbl5ManagerApp roval" table, using the query "qry5MgrApp v" and generate a report(rpt5MgrA pporval)which is then emailed to that manger.

    ...
    See more | Go to post
    Last edited by Rabbit; Mar 7 '14, 10:10 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
No activity results to display
Show More
Working...