Search:

Type: Posts; User: xenou; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.61 seconds.

  1. Re: Change query, updated column based on cel value

    You could run four (or more queries) with the understanding that only one will really have an effect:


    update Table1 set Training1 = 'x' where [Table2]![TypeTraining] = 'Training1' and StaffID =...
  2. Re: Using variable instead of single file name for export to Excel, based on a form selection

    You probably should continue in the same thread, so I will close this one. Put your updated code there.

    However, this again looks wrong, for the same reasons as before.

    Set xlw =...
  3. Replies
    8
    Views
    598

    Re: Running a "Run All" using Scheduled Task

    Here is a sample of how I have done this:
    https://www.mrexcel.com/forum/microsoft-access/764991-auto-trigger-ms-access-code.html

    Others prefer to have a scheduled task that opens msaccess. Then...
  4. Replies
    8
    Views
    598

    Re: Running a "Run All" using Scheduled Task

    Looks like you will have to move the code from a private function (in a form) to a public function (in a module). Then you can run it as an automated task. That would be my preference.

    I am not...
  5. Replies
    8
    Views
    598

    Re: Running a "Run All" using Scheduled Task

    Hi, you need to analyze how the button works, so you can do the same thing without having to actually click the button. Probably it calls code or runs a macro. So you just need to be able to call the...
  6. Re: switching specific coulmns from vertical to horizantal to get one record !

    PSEUDO SQL:


    --create table [NewTable] with fields:
    -- FileNo, [RCVD Date], Country,
    -- ID_No, PID_NO,
    -- Test1, Test2, Test3, Test4, Test5, Test6, [Final Result],
    -- [Report Date]
  7. Replies
    4
    Views
    425

    Re: Table to use multiple other tables

    Logically you probably have a many-to-many relationship between kits and tooling/fixutures/etc. -- one kit has many tools, one tool goes in many kits.

    So you many need to implement linking tables...
  8. Replies
    3
    Views
    588

    Re: Show Duplicates Across 2 Queries

    Distinct, then count ...

    select count(RegNo) as Total
    from
    (
    select distinct RegNo, Status
    from [Businesses]
    ) T
    having count(T.RegNo) > 1
  9. Replies
    6
    Views
    435

    Re: Append Query to Table Issues

    Mostly this depends on how you insert these things (one at at time, all at once, from a form, from external data, from user input?).

    Anyway, one option is to make sure it doesn't already exist:
    ...
  10. Re: Access 2010 - Make Table Query Losing LookUp data

    Make table queries will not have lookups in them. If you want that you could create the table beforehand and populate it with an insert query rather than using a make table query (naturally you will...
  11. Replies
    2
    Views
    165

    Re: Adding Variable to column

    This works for me in a brand new workbook without errors (after putting some value in Cell A46900 for testing).

    You should be sure that the sheet is "selectable" - no protection set, sheet is not...
  12. Re: Number Serial Numbers in sequential order by order of appearance

    Okay you are welcome to use a ranking technique. But from what you have said it sounds like unnecessary work that may make it more difficult to maintain and continue to develop the database. Keep in...
  13. Re: Number Serial Numbers in sequential order by order of appearance

    I don't see any connection between numbering serial numbers from 1 to x and having a certain type of transaction. Are you trying to assign a unique ID number here?

    I suppose a secondary...
  14. Re: Number Serial Numbers in sequential order by order of appearance

    Google MSAccess Rank Function for ideas. What is the purpose of this numbering?
  15. Re: Mouse wheel no longer scrolling up/down in Access 2010

    Mouse problems are hard to resolve but I'd try the following:

    1) change the battery
    2) check the manufacturers website to install any updated drivers if they have them available for your mouse...
  16. Re: Combine different lines to display beside each other

    This last post is dramatically different from the first one --

    first post has four columns: RA_Num,BarCode,Date_Ent,Date_Warranty
    last post has four columns:...
  17. Re: Show all records of Main form in the subform instead of just one

    For linking subforms with main forms you set up the relationships in the subform properties with keys (fields) from the parent (main form) and the child (subform). If you are adding records on the...
  18. Replies
    1
    Views
    467

    Re: Remote Access Database?

    I wouldn't really be interested in using MSAccess for a project like this - it's not intended for online multiuser access. If you are hosting online or in the cloud you could easily get MySQL or...
  19. Replies
    6
    Views
    148

    Re: Excel save sheet as VBA but remove commas

    You can edit the file you create after you create it.

    For example:

    Sub foo()
    Dim fso As Object '//Scripting.FileSystemObject
    Dim ts(1) As Object '//Scripting.TextStream
    Dim s As String...
  20. Replies
    6
    Views
    148

    Re: Excel save sheet as VBA but remove commas

    The additional commas represent empty cells or field values with nothing in them. You could probably just leave that alone - why is it a problem?

    For instance a worksheet with these values:...
  21. Replies
    9
    Views
    234

    Re: 1004 on assignment statement

    You also best check the result you are getting for FullRange (what is the actual range you get out of this -- MARK858 this is where r is coming from, for each r in FullRange)

    Set FullRange =...
  22. Replies
    11
    Views
    1,037

    Re: Create Printer Error for testing purposes

    Raising errors:
    https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/raise-method


    this also works:

    dim i as Long
    i = 1/0
  23. Replies
    11
    Views
    1,037

    Re: Create Printer Error for testing purposes

    Partly at least that's how printers work. It should actually print the job once the jam/paper problem/electrical supply is fixed (so you don't necessarily need to hit a print button again).
  24. Re: Combine different lines to display beside each other

    I'm waiting for answer to Stumac's question - or in general some more context. The semantics are not clear - why is the second case "right" and the first case "wrong". At first glance it seems you...
  25. Replies
    6
    Views
    389

    Re: Any chance mdb to get data from xlsx

    I also believe that you can't use the new (now old?) xlsx formats with Access 2003 or earlier. mdb is strictly speaking just a file format, but Access 2003 and earlier cannot read or write the new...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4