Search results

  1. C

    Sanitizing number field on form

    agreed - but the OP is copy/pasting from other sources so there is only one keystroke
  2. C

    Linking to multiple CSV files and renaming tables without ".CSV"

    per post #10? It cannot be done in a query - only by creating the query
  3. C

    Sanitizing number field on form

    How about the change event? - ref the controls text property And your beforeupdate should be referencing the text property
  4. C

    Linking to multiple CSV files and renaming tables without ".CSV"

    no - just build the sql and substitute dim fName as string dim sqlStr as string fname=dir(C:\Users\Daniel\Documents\Test\*.txt) while fname<>"" sqlStr="SELECT * INTO NewTable FROM [Text;HDR=Yes;FMT=Delimited;Database=C:\Users\Daniel\Documents\Test]." & fname currentdb.execute sqlStr...
  5. C

    Update or Requery button

    What does ‘didn’t work’ mean? You get an error? Nothing happens? Where are the two calculated controls? Main form or subform? What is the controlsource to these two controls?
  6. C

    Report with the Same ID being printed multiple times.

    revert to or open a backup - at least to compare what it was then to what it is now
  7. C

    Which Office / MS Access Version?

    I use both - need to because some clients have 64bit installed, others 32bit but I still develop in 32bit 2010 (using ptrsafe, longptr etc as required) and test in 64 bit 365 when required. I'm expecting when I get a new pc (probably sometime this year) it will be the other way round. I do find...
  8. C

    New Outlook

    The issue for me is not sending emails - it's receiving and extracting data from them. I don't have access to new outlook but have experimented a bit with gmail in terms of downloading with occasional success to get a feel for what might be required. With gmail, it appears the structure of an...
  9. C

    Printer and performance.

    Anywhere in a local drive is Ok, just be consistent. One of my clients uses a folder on the C drive called databases, I tend to use a folder in the users appdata folder which is typically hidden
  10. C

    Dynamic/reusable forms

    I have a multi function form that by passing a recordset (DAO, ADO or value list) and a couple of parameters can be used as a multi select dropdown, an input box, a message box or used as a subform. It can also display a selected section of an existing form (I call it a quick view) by tagging...
  11. C

    Solved Open Outlook & check for new mail where search criteria is applied to the email subject line

    Also depends on what you want to do with the information- stop when a record is found? Return the folder where it was found? Keep looking until all folders have been searched?
  12. C

    Should banker's rounding work on calculated figures?

    What about using Round ([ODPrice]/100*[SLDisc] ,2) AS TOTAL
  13. C

    Cluster together seperate request events for same client within timespan

    Just check the 4 days - might need >=4. Also if your date fields included a time element (hidden due to formatting) that will also have an effect on the result
  14. C

    Cluster together seperate request events for same client within timespan

    So how would you do that in excel? I don’t have access to a computer at the moment but in access I think I would be looking at a left join to itself to return records without a record 4 days previously - something like Select a.* From mytable a left join mytable b On a.person=b.person and...
  15. C

    Syntax Error in INSERT INTO Statement

    Why are you trying to add the same value twice (saleinv) to balance and quantity?
  16. C

    Cluster together seperate request events for same client within timespan

    Your example does not include one with a date of 08/04/2024. If there was, what is to happen with that one? Exclude it because it I is within 4 days of the 5th? Or include because the 5th is excluded?
  17. C

    Automatically Refresh a form when table data changes externally, table macro perhaps?

    0.5 seems a bit too frequent. What triggers the update? When the phone rings? If someone is calling how long would they let it ring before cancelling the call? If the phone is answered how long might a call last? I would have thought 5 or 10 seconds would be sufficient?
  18. C

    Improve FE - BE performaces on LAN

    Take a look at this link - https://www.access-programmers.co.uk/forums/threads/addressing-performance-issues.291269/
  19. C

    Any idea how to change system keyboard lenguage with vba

    Sounds like all you need is the language code (LCID) for Arabic. If so, take a look at this link https://learn.microsoft.com/en-us/previous-versions/windows/embedded/ms912047(v=winembedded.10)?redirectedfrom=MSDN
  20. C

    GENERATION OF PAYSLIPS AND EMAILING THE SAME TO EMPLOYEES

    You have asked a vague question- so we can only provide vague responses A path is a path to a windows folder such as C:\myDatabases\payroll\payslips A file name might be something like [employeeID][period].pdf Where to put it? Wherever you currently print your payslip - I assume you are...
Back
Top Bottom