Recent content by raziel3

  1. raziel3

    Import Large Excel File

    I'm not tying to offend anyone 😨. This is just my experience. People are more comfortable using Excel so I try not to interfere with their workflow. If they are stubborn to move away from their methods I try not to change it, I just work around them. The original data source always remains...
  2. raziel3

    Import Large Excel File

    I prefer to link to the Excel file to maintain the integrity of the Excel data. If the Excel is the main source of the data (Call it Workbook A) I would create a new Excel file, Power Query the data and fix the formats etc (Call that Workbook B) then link Workbook B to Access. That way Workbook...
  3. raziel3

    stream data to excel

    By chance are you using Power Query to connect to the CoolTerm data dump?
  4. raziel3

    exporting access table data to excel

    I've had a problem with this recently. https://www.access-programmers.co.uk/forums/threads/how-to-export-current-recordset-and-remove-certain-fields-to-excel-field-column-filtering.329363/ Filtering columns was the solution to my problem.
  5. raziel3

    Import Large Excel File

    Import or Link? I would create a Link to the Excel file. One thing to also note is that if you have the Excel file open, Access cannot read from it. Close the Excel file and retry the wizard.
  6. raziel3

    Solved Problem calculating correct age from birth to death

    I think everyone pretty much covered your problem but just one more small thing. Try to limit the use of the Nz() function. If in the future you want to migrate to SQL or something else, it would be a real headache. IsNull is a better alternative.
  7. raziel3

    Hide inactive data and show active data only.

    One thing I learned the hard way was NEVER make Forms based on your Table. Make a query then use that as the RecordSource for your Forms/Reports Purchases Table Schema: Purchases Form RecordSource: If you notice on the Purchases Form RecordSource query I've included a MonthEnd and DueDate...
  8. raziel3

    The Most Powerful form Filter and Requires almost No Code

    How many records can this handle? I find sometimes with filter/search forms the load and filter times starts to get slower the more records it has to handle especially if the underlying RecordSource is a query containing a subquery. It's even worse if your db is split and the backend is on a...
  9. raziel3

    Prevent Record Cycle or Form Close unless condition is met.

    I am still able to close the form and the code works for existing records. If I enter a new record and it does not reconcile I am still able to move out of the record, but if I cycle back to it I cannot move out of it. If the form closes I want to either cancel/undo the record entry or remain...
  10. raziel3

    Prevent Record Cycle or Form Close unless condition is met.

    I used the same code from the link IF YourTextBoxName <> 0 Then Cancel = True enter here a messagebox if you like End IF See DB attached. The form "deReceipts" is the form with the problem.
  11. raziel3

    Prevent Record Cycle or Form Close unless condition is met.

    Hello Everyone, I am halfway there following this suggestion https://www.tek-tips.com/viewthread.cfm?qid=1602602 I have an unbounded textbox that calculated the totals between the Parent Form and it's Subform. My form has no buttons to cycle or save, I am using Access's navigation controls...
  12. raziel3

    Solved How to Export Current Recordset and remove certain fields to Excel (Field/Column Filtering)

    @theDBguy I figured it out. I had remove the existing query from the form and make qrySearch the form's RecordSource. Sorry about that.
  13. raziel3

    Solved How to Export Current Recordset and remove certain fields to Excel (Field/Column Filtering)

    I applied one filter in the Cheque Number text box and right clicked Supplier/Payee filtered "Contains GENERAL".
  14. raziel3

    Solved How to Export Current Recordset and remove certain fields to Excel (Field/Column Filtering)

    yes. in the debugging window in the pic i attached, look at "strFilter". Right clicking on your version works fine.
Top Bottom