Search results

  1. S

    1 query pulling info from multiple identicle tables

    union queries is totally the wrong thing to do here. you say you are given tables each week which you need to import into the database - what you need is a master table. this would be where all the data ends up. the master table would contain all the fields from the imported tables. then what...
  2. S

    1 query pulling info from multiple identicle tables

    question: why would you want to link multiple copies of the same data and then query them together? surely the whole point of queries is to link data from 2 completely different tables by using a field or fields that can be found in both tables.
  3. S

    Rnd generates same number after closing and reopening the database.

    rather than use a constant variable with rnd (which will always produce the same results) use rnd with a field that contains a number (autonumber field for instance)
  4. S

    Access DB project

    my first ever post to this site was to that thread....read it here http://www.access-programmers.co.uk/forums/showpost.php?p=563555&postcount=39
  5. S

    Mutlipy every 2nd digit by 2

    you would put this in the OnClick event of a button and if RefNumber was the name of a field on the form then you would use strWholeNumber = me.RefNumber to reference the form object ;)
  6. S

    Mutlipy every 2nd digit by 2

    dim strWholeNumber As String dim strPartNumber As String dim intPartNumber As Integer dim intPos As Integer dim strNewString As String dim intOldNumSum As Integer dim intNewNumSum As Integer strWholeNumber = "87256002122" strNewString = "" intOldNumSum = 0 intNewNumSum = 0 for intPos = 1 to...
  7. S

    Mutlipy every 2nd digit by 2

    would the result after doubling also contain 11 digits and if so how would you strip out numbers to get down to 11 digits?
  8. S

    I've got the RUNNING SUM Blues!!!

    you could always use a DSum Function to get the sum of all transactions before the first date on the report
  9. S

    Open Access DB from .bat

    you can have the line: "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "C:\DatabaseDir\Database MDE.mde" /user dan which will open up the MDE database for user Dan
  10. S

    Protecting A Table

    your best option would be to have all users log in under user names (not admin), add a password to the admin account that only sysadmins know and set the permissions for the table so that admins have total control and non-admins have no control.
  11. S

    Accessing MySQL tables using FTP

    Hi, Just a quick question. I was asked if it was possible to append data to MySQL tables in VB using an open FTP connection. I said I was 99% sure there is no way of doing it but thought I'd ask to see if anyone else has actually tried it? :(
  12. S

    Run TIme Error 3131 - Syntax error in From Clause

    Yes but a pencil must be lead ;) or try Yes but a missile must be guided :D
  13. S

    Variable Reference in forms

    i always make a point of putting byval or byref before each module variable so that i know what i'm dealing with
  14. S

    Sum over group in Query...

    To tackle this, first I'd change the query to a make table query. this will ensure all future queries i create run quickly. then i'd create 2 queries, one for the normal pay and then one for the overtime pay but still include fields for normal pay and overtime pay and set these to 0 so that...
  15. S

    Top 10 Ways To Not Get An Answer

    aye, i dont know why they bother. if they just said i need to write a report on normalization to third normal form then i'd help out but to copy and paste the homework question word for word....almost makes me want to post an email to their course tutor and request the credit :p
  16. S

    Error Closing Form Runtime 2585

    rather than use the Current() event why not use the BeforeUpdate() event? that way you can cancel the adding of the new record and close the form
  17. S

    Top 10 Ways To Not Get An Answer

    I stumbled across this site while looking into developing something and love this post.... I work as a consultant and used to log into quite a few project forums. guys post the work they want doing, you tell them how much it will cost, you agree a figure, you do the work and they pay you. I've...
Back
Top Bottom