• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Search results

  1. Cronk

    Solved Insert into hanging

    If the field name is called Billing/Attorney, put square brackets around ie [Billing/Attorney]
  2. Cronk

    timestamp

    To record the logon name of the person on the PC on which the edit was made Me.Modified=Now() Me.UserName = environ("UserName")
  3. Cronk

    Subform for selecting multiple Employees to Associate with Project

    I wonder why the people who are external have to have a separate table rather than being in the same table as Staff, with an additional field to indicate Staff or External.
  4. Cronk

    Display last Record based on person

    And all the work around solutions are all propping up "It's the current way they do it on the spreadsheet". Combining two or more bits of information (eg initials of a person and a sequential number) to get a unique number is moving away from normalization.
  5. Cronk

    Compare number of columns in Imported table from CSV with target table if are the same

    If the import file is not linked, then the suggestion in #3 won't work. Another method is to read the first line of the csv file and compare it to a string of the concatenated field names of the target table. This way provides a check on correspondence in the number of fields, the order of...
  6. Cronk

    Copy record from from to a table

    Also debug your code to remove the compile errors ie missing With
  7. Cronk

    Date into field after cursor leaves

    That should also test that text box is blank otherwise the event will update the date to the current date whenever the field exit occurs in the future. if len(Me.ControlName & "") <1 then Me.ControlName = Date()
  8. Cronk

    Solved Accdb: Error Number List (see isladogs)

    I'm curious. Any reason why ? error (3211) Application-defined or object-defined error give a different, albeit less explicit, response than that listed in your table of error codes? The database engine could not lock table '|' because it is already in use by another person or process.
  9. Cronk

    Search table using calculated field.

    I still cannot see any point in generating a serial number just to generate a unique index when combined with the date. The example provided by arnelgp shows the use of an autonumber unique index. Would you do a search on that calculated unique number rather than a search by customer name or...
  10. Cronk

    Multi Contractors on One Bill of Lading

    Classic many to many relationship situation. One example here One table for bills of lading, one table for contractors and a third which has the BoL index and the contractor index.
  11. Cronk

    Search table using calculated field.

    I'm having trouble envisaging why you would need to know who was the fifteenth customer on a particular day. Or is this a way to generate a unique customer key? Just about everybody would use an autonumber as key index. If you do need to know the order of customers, record date and time in a...
  12. Cronk

    Updating the front end on local server

    Firstly, make a copy of the database if you don't have backup copies already. Then Compact/repair the database. That will probably fix the problem. If not, split the tables out by creating an empty db, import the tables into it. Then delete the tables from the FE and then link to the tables...
  13. Cronk

    Working from home with an access database over VPN

    You could add sql server backend and pass through queries.
  14. Cronk

    Solved Change name of Form instance in tabs

    I've used multiple instances of a form in situations where the user is working on one record, and either gets a query on another record or needs to work on two or more records in parallel. Use hWnd to maintain the forms collection, but after changing the forms' captions to something meaningful...
  15. Cronk

    How to step through a table one record at a time

    Maybe the OP cannot define the selection criteria for a query and wants to make the selection by "eyeball". In that case, I'd provide a multi select list box to select the records for printing labels.
  16. Cronk

    Searching specific fields vba

    I presume the 5 fields are text. If so, you can use Like "*<search string>*" to search for the occurrence of a string in the field. Use the OR operator for multiple fields. ....WHERE Field1 Like "*abc*" OR Field2 Like "*abc*" OR Field3 Like "*abc*" .....
  17. Cronk

    Multiple field search in Form

    A work around using Like with numeric values is cstr([NumberField]) like "n*"
  18. Cronk

    Unbound Multi User DAO Recordset locking

    I've never had to worry about locking with unbound forms because I deliberately don't set up unbound forms for users to edit data. I use bound forms and let Access handle locking. Your method is slower and will bloat faster with the adding/deleting of records. Being an unbound form, you can't...
  19. Cronk

    Relationships for Dummies

    @Winterwolf73 I'm surprised nobody has picked up on issues with your table structure. The Invoice Number is not a property of tblCustInfo. It's the other way around. Also name your primary keys something meaningful ie don't use ID for every PK. Have CustID, InvoiceID etc instead. An...
  20. Cronk

    Coronavirus - are we all doomed?

    Media will generally slant in a way to sell more. When times are good, they'll be good forever; when bad, it's dooms day. Follow the money.
Top Bottom