Search results

Many thanks Tevor

Good morning all, Any help with this would be greatly appreciated (I’m sure this will be a total no-brainer for some of you). I have two tables, my primary key is ACT ID, in table 1 I have another field called Earned, this field is also in table 2,, basically the value of Earned field in table 2...

Good morning all, i have a feeling this could be a simple yes or no answer,, at the moment i am using the 'Import Data Wizard' to pick-up an excel file that is up-dated on a daily basis, this file always sits in the same directory and always has the same file name, ideally i would like to have...

what can i say,, appart from a huge THANK YOU,, i now have some bedtime reading,, i have tried to bullishly fumble my way through the security wizard with Usergroups and users with various priviages but other than password protecting my database all users have the same access right,,, very much...

that is great, thank you all very much for your kind help, yes I’m working in 2003,, I’m getting the feeling from a few people now that these security issues can be alittle more hassle than they are worth,, still i shall persevere,, once again Many thanks

read only access to my database via security wizard Good morning all, I have a question regarding the security features that Access has to offer, I have a very simple database that is made up of about 20 tables, I would very much like to set up some security features that allow me entry to the...

hello all, once again, any help anyone could give would be very very much appreciated,,, i have a table that contains several fields of data,, my only problem (at this point) is one of my fields is called PL_Item,, the data in this field comes in this format: PA-1111-2222-A before i can do...

that is great,,Like "*alignment*" ,, worked a treat thanks again Jon :)

Hello all, once again I would very much appreciate anyones help on what may be quite a simple issue,, my problem (or one of!!) is as follows: I have a table that contains approx 3k records I wan to run a query that allows me to select a certain number of fields with a group. From this I mean, I...

hello all, would really appreciate some extra help with this, many thanks,, the story is as follows,,,,,,, hello all, i have a very simple databse with two table in it,, both table share a lot of common information, including a primary key called jobcard number,, i want to know if there is a...

thank you DrSnuggles, could you explain in idiot proof instructions? do i enter the diffdate code in the criteria row of the select query? also, what do i need in the field and table rows? is it the table and filed i'm comparing the data against? once again many thanks

hello all, i have a very simple databse with two table in it,, both table share a lot of common information, including a primary key called jobcard number,, i want to know if there is a simple query i can run that will find any differences in the start date fields that are found in both tables...

hello all,, any help again,, would be greatly appreciated,, i have a very simple database that has a number of tables that are all interelated by a key called JobCard,, a number of forms act as an interface to add to the data on the tables,,, what i would like to know is,, is there a method that...

hello i would very much llike some help with this as i am very rapidly running out of ideas,, i have a very very basic table with a form that represents the data in the table, i understand how to enter a combo box and how to add and change options for the users in the combo box. all i want to be...

hello all, i would very much appreciate anyone's help with this,, i have a table that contains various data,,i would like to write a query that will give me all records that have been allocated an 'issued date' in the last two weeks,, the 'issued date' is a box on my form that has a calendar...

ahh,, i think i may have sused it,, this probably isnt the best way to do things,, i copied one of the existing combo boxes and renamed the Control Source and copied nad renamed the column in the table,, is this a duff way of doing things?? once again,, thank you for your help

Hello Chris,, the form is bbased directly on the table many thanks

all, again i would very much appreciate anyones help with this,,, i have a very simple one table database with a form that represents the data in the table, the form has a very simple search feature attached, i would like to add another text box or combo box to my form, this is easy enough,, i...

,, need some help with this one, not even sure if it is possible,, i have a single table that contains data on permits that are issued,, nothing flashy but i have included the calendar function that allows users to pick dates in the usual way,,, here is what i'm after,, not even sure if this is...

Hello all, could annyone help me with this? i have a database with two tables in it, table x and table y,, i would like to find those records in table x that are not in table y, both tables contain the same ACTID key,, i have used the find un-matched query,, i'm just looking for a finid matched...