Search results

  1. A

    Search or Filter form using embedded macro

    Good evening, everyone! My company has disabled vba for our access database due to security reasons so I've only been able to use embedded macro actions for a tracking database I've created recently to better organize our electronic records. I'm trying to create a search form in which I could...
  2. A

    Capture username (login ID) using macro if VBA is disabled

    Hi...we've put together a database to annotate our daily workload. Unfortunately, our group policy since we migrated into Office 2010 has changed to where we can no longer use VBA scripting. The database has stopped working but managed to still run its basic functions using macro except for...
  3. A

    Allow Edit but not To Insert Record

    I'm sure this probably has a simple solution but somehow I'm having some issues trying to figure out how to prevent a form to insert a record once it has been updated that day; yet still allow edit For example: If a record has been entered for today and someone tried to add a new one later...
  4. A

    Date and Time Stamp On Main Form

    Hello Everyone, Just wondering if anyone might be able to help me with my dilemma? I'm trying to put a timestamp on my main form to record the date and time a user created a record. I only have one table consisting all of the data to include the date and user. The mainform has two tab...
  5. A

    SetFocus to a specific record in a continuous form from another form

    I have a tabbed continuous form from which I double-click on a record and displays all the details of the record in a separate form. When I close the form, I can go back as far as opening up the continuous form but focus is set on the first record with the code below: Private Sub Form_Close()...
  6. A

    Extract strings from textfield

    I was hoping if anyone could help extract strings from a textfield. In a textfield(textfield1) I would like to be able to extract words separated by delimiters and put in a separate textfield (textfield2) without the delimiter. For example: textfield1.value = "Apple, Orange, Tomatoes" After...
  7. A

    Function won't work

    I was wondering if anyone can help me with my dilemma. I have this report which I'd like for it to call a function every time it loads (see codes below): Private Sub Report_Load() lblCC.Caption = getSignBlock() End Sub This function is from a module I created (which I'm not even sure if I...
  8. A

    Assign a record to a table

    I was wondering if anyone could help me with a problem I'm having with a form... I have 2 tables, one called 'dept' and the other called 'employee.' These tables have a one-to-many relationship; basically, one department to many employees. Instead of using a combo box, how do I assign an...
  9. A

    Not sure how to code this...

    For example: - the first request for the day would be "KEZ6313001AA" ...the 2nd would be "KEZ6313002AA" ...the 3rd "KEZ6313003AA" - for the next day, it would be "KEZ6314001AA" ..."KEZ6314002AA" ...& so forth - now the 'KEZ' is a constant string so it would always begin with "KEZ"; however...
Back
Top Bottom