Search results

  1. L

    Simple Login Form

    Password should not be displayed; replace each character, as it's entered (KeyPress event), with one or more "*". Allow only a few attempts to login, then abort the program. Keep track of those logged in, the PC, and when, when off on a multi-user system.
  2. L

    Seems silly -- but query not returning the right result...

    [Actual Close Date] is probably not a string. Look into using dates is a query, they're not usually strings.
  3. L

    hide tab on form based on text field value

    Use it on the form Load event or on the me.txtname_AfterUpdate event, probably the latter unless you have a bound form. I gave you the complete code.
  4. L

    Call sap function

    Take a look at this. Otherwise try Google.
  5. L

    How to change legend colors

    Try right clicking the color, in the legend or or chart, you want to change of and select the desired color from the color palette.
  6. L

    hide tab on form based on text field value

    If me.txtname = {whatever} then me.pagename.visible = true else me.pagename.visible=false end if
  7. L

    combining data in 2 tables via query

    Create a Union query with the 2 tables, then in another query sum the vale columns of the Union query.
  8. L

    How to Properly Create a Subdatasheet using a Table

    Create a relationship between the tables.
  9. L

    Select Statement

    How are your determining the denominator, counting rows or using 6 instead of the actual number of rows. Alternatively, use a union query, the first query of which produces one zero value row for each month and each region "unioned" with your regular query.
  10. L

    Double Check relationships?

    Your tables and relationships, in my humble option, need to be given more thought. Your naming convention is laborious. Google "Hungarian naming convention" for a commonly used scheme for naming fields, objects and controls; use will save a world of coding and immediately identify the data type...
  11. L

    Design window size and position

    Try opening all requisite forms in the form view and position each with the docmd.movesize function. When all have been opened, open each again in the design view. I think that they'll retain the original opened position.
  12. L

    Synchronized 2 or more database

    I have done this before using the following method: 1. Add a table to the back end whose records indicate a unique version number, a reason for the revision, and a date created. This gives a list of all changes. 2. Add a similar, but single, record to the (distributable) front end database on...
  13. L

    splitting imported teble into a related tables structure...

    You misunderstood what I said. I said add a foreign key to each of the 3 tables which relate them to the imported table's primary key. Tables can have multiple relationships.
  14. L

    Export Query Data From Access into an Existing Workbook need to tweak existing code

    Look carefully at the TransferSpreadSheet function arguments.
  15. L

    Synchronized 2 or more database

    It's not clear to me what you mean by "synchronize."
  16. L

    splitting imported teble into a related tables structure...

    Give you imported table a primary key and a related foreign key in all the other tables. You can create that relationship via the "Relationship" button on the Design (i thjink) ribbon.
  17. L

    Design window size and position

    The "BringToFront" and "MoveSize" commands are what you want. Yu can size your form in design view and save it will set the size. MoveSize is better.
  18. L

    Combox on form that has already been filtered

    Filter the form based on the combo box value.
  19. L

    Combox on form that has already been filtered

    Filter the records using the form FilterOn and Filter properties to indicate what data is the be displayed. Consider using the user name or a password in setting the filter for your various users.
  20. L

    Best way for managing several years of data.

    It depends on how much data you get each year, how many years will be involved, and whether, or not, Y2Y reports are to be generated. Remember Access databases, front end and back end, can be 2G each in size. Size and create your table(s) accordingly.
Back
Top Bottom