Search results

  1. gakiss2

    More Strange Behavior

    The issue is that I get an error when a form is refreshed. Debug shows the Me.refresh line of code. The 'error' is that the due date is not a weekday. I tracked that back to a validation rule that I had put into the table. It was behaving properly, I just didn't want that behavior any more...
  2. gakiss2

    ColumnHistory results not in DateTime order

    I am using ColumnHistory to keep track of changes to a form. When a control on the form is changed then a sub is called to add an entry to the Note field. The code is very simple: Public Sub AddHistory(frmControl As Control, ctlName) Forms("frmDocDetail").Note = ctlName & " Changed to " &...
  3. gakiss2

    Access and Excel NOT playing Nice

    I want to send some data from a query to a macro enabled (.xlsm) Excel workbook and then open it (the excel workbook) from access. I have had to do some work arounds that don't make sense just to get as far as I have gotten so I would be happy to hear the 'right' way to do it so I don't need...
  4. gakiss2

    Solved Stuck on (seemingly simple) set value of Combo box on form open usin OpenArgs

    I have a form which contains a combo box named DocType. In usual operation it works fine. user selects from a list coming off a table. real simple, must be from list. I added a button on my 'Front Page' form called NewSwitchboard . I want the button to launch the above form in Add mode and...
  5. gakiss2

    Solved Payin' Cost for using Attachment - Round 2

    I've made a lot of progress with pulling attachments out and saving them in the newly revised database that uses the 'old fashioned' method of saving the files in a folder on the server then saving the file path in the database so users can still easily get to the files but the files don't live...
  6. gakiss2

    Appearance of ColumnHistory output

    I found this answer by DBGuy from a few years ago: Works great. Now I would like to remove the time stamp and/or change the date/time format so that it is shortened up. I love the feature, just don't want to use up all that real estate. I had tried doing surgery on it with Mid text string...
  7. gakiss2

    Solved stuck on not in list

    Its the simple things that are most frustrating. Trying to use a dropdown for a user to add an email to a list of recipients. It works mostly, user clicks the arrow on the combo then clicks on one of the emails listed then the email gets added to a text box which is a collection of emails...
  8. gakiss2

    Payin' Cost for using Attachment

    Yes my Db is HUGE! because I used attachments in all the wrong ways. I retooled my Db so now it stores file paths instead of files. Now I need to migrate a LOT of attached files to their new proper location and store the paths in my newly retooled Db. One of the fields in the record is now...
  9. gakiss2

    Filter on load not working correctly

    I want to utilize the Filter On Load. I have a datasheet view form that a user will use to look up a record then click to launch a form that shows detail for that specific record. There is a field in the datasheet form that had a click event which opens the single record form. When the user...
  10. gakiss2

    Solved Need to filter a query based on variables set in vba

    I have some code which sets begin date (BegDate) and end date (EndDate). I have a query (qryOutput) which filters properly however I don't filter on the field create_date (yet?). I want to use BegDate and EndDate as the condition to filter create_date. Later there is a command to export the...
  11. gakiss2

    Open Db from a Db then pass values

    I found some code to open another database off of a button. I have gotten to a point that I can open a form within the target database and open it in 'new record' status. Next I would like to pass some data between the two databases and am looking for some help with that. Any help is...
  12. gakiss2

    Logging user activity

    I have developed an MS Access database (with no small thanks to those in in this forum who helped me with various challenges) that has grown to a point that there are a half dozen users. Particularly after going through some turnover in the department and for other potential forsee-able issues...
  13. gakiss2

    Update Query

    Trying to update a record in a table based on a click. I done something similar in another db so I copied the code then changed in the right fields expecting all to work like clockwork. does is EVER go like that? I am getting a type mismatch error but I can't understand what I am doing...
  14. gakiss2

    Combo box column(1) property

    EmailSubject = " Notification: " & Me.NewLBTrackNo & " Status: " & Me.DocStep & " Due: " & Me.DueDate I am using a button to send and email. All is working well except one detail I can't figure out. In the above you can see … Me.DocStep & …. Right now that give a number which is the 'ID...
  15. gakiss2

    Question Debug Not in List Event

    Below is some code to allow user to enter a category into Combo53. It works for MRR DLog skinny but does not for MRR DLog Output skinny. for the 'Output version I had copied this form frmMRRLog then made mods and named it frmMRRLogALL, I only mention because that is the only thing I recall...
  16. gakiss2

    Export Excel then feed data to cells

    Overall function is OK. the excel file is created and the data placed into the cells as desired (mostly) then the modified file is saved as a new file. The issue is one of the fields is not outputting correctly. Attached I have screen shot of the database showing the field as "Machine No...
  17. gakiss2

    Add new item to Combo Box list from table

    I am wanting to allow the user to update (add) a category. There is a tblCategory that has three field: ID (primary), VendorName and Category. the Combo box opens only the categories associated with that vendor. Through the help of these threads, we got that to work. this is a Row Source...
  18. gakiss2

    Import Errors

    Seems like more of a nuisance but wanted to check with the experts. I import data from a source that I have no control over and all seems to work well in terms of database function. The issue is that I get an Import Error table added each time I import. I look at them but I don't get any...
  19. gakiss2

    Combo box options limited by form control

    I have a combo box which I want to provide categories based on the name of the vendor. If I literally put the name of one of my vendors in the Row Source query it works. When I put the name of the control the vendor name should come form I just get no nothing in the combo box (nothing passes...
  20. gakiss2

    Form Behavior after ReQuery

    I want to use a Tabular for to go down a list of 'records' which the user may take action or not. There is a cbo field Decision on the form. The user makes a choice which is recorded. There are two of the five choices which means the 'record' should be removed from the form view. Those...
Top Bottom