Search results

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...

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.

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)

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

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 ;)

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...

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

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

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

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.

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? :(

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

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

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...

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

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

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...