I have a ReferenceDetails table and a RefAuthors table -- since some references may have multiple authors -- related by ReferenceDetailsID. I want to create a...
Hi I have a TEXT FIELD in TABLE GT5_6 as 01JUL090442 I have converted it in a query to mydate: CDate(Mid([GT5_6],3,3) & " " & Left([GT5_6],2) & ", " &...
Hi Terence C, Create a parameter, say [DateRequired] and place it in the Criteria field for your 'mydate' column. Select Query/Parameters, or Right-Click on...
This is a simple one, I just dont know what it is and what it does and why do i need it and how do i get rid of it ? Its a thin vertical rectangle running...
John- First, you cannot attach anything to a message posted to the group. If you need to upload a picture, file, or database, put it in the Assistance Needed ...
Terence- To add a date criteria to a query, you must delimit the date value with the ... On the query grid, Access is usually smart enough to interpret the...
Terence- That's the Record Selector. Set Record Selectors to No to get rid of it. Note that the icon changes to a pencil scribble when you start to make a ...
Hello A.D. my apologies for not replying earlier, I only just now noticed your post. I had a look at the sample program you uploaded but I don't know how I...
I have a form with a text box The textbox is tied to a table via the data property. I placed a procedure to update the textbox when the Form event Dirty occurs...
Actually, I'm gettimg more comfortable with the three field compound key because it can contain a null value in one of the compound fields. If the requirement...
Shay A primary key cannot contain a Null. If one of the fields in a compound primary key is null, you could, for all intents, have two records with the same...
That will work, my primary concern was that a null in the PK may cause a scenario of attempting to create a duplicate PK, But so long as you are using a tri-PK...
Bill, TY for the clarification. Using her customer contact as part of the PK was concern in the first place. I realize that a null would fail as a pk on its...
Michael - Thank you.... in regards to the 3600 pieces of equipment question - yes... in fact we have over 4000. you've given me some good things to assist...
Terence- This makes no sense. You say the text box is bound - it has a Control Source. You say the form is NOT bound. You cannot have a bound control if the...
Well learn something new every day. Any time I've set a compound PK, the "required" properties of the compound PK fields hasn't updated to to "Yes" the way it...
... Not keen? You could say that.<s> Whatever character is used, there will still be a problem with duplicate primary keys unless the initial entry is...
Using AC2000 Reading through the ULS FAQs and general web searching I'm finding references to being able to join an existing database to an existing workgroup...
Jason – Thanks for the history, always enjoy hearing the background. Let me write and think at the same time, in your table “tbEquipTransfer” First...
Hi Shay, In the DatabaseWIndow use, Tools/Security/WorkGroup_Administrator/Join then type the fullpath of the .mdw file and click OK. You will need to have the...
I do not have that option. Tools>Security only lists: Set Database Password User and Group Permissions User and Group Accounts User-Level Security Wizard ...
Follow on from yesterday where I was working on changing the path to linked images. I’m using code from John Viescas’s example posted on this sight...
Shay There is a wizard called Workgroup Administrator. With Acc2000 you will find it here: "C:\Program Files\Microsoft Office\Office\1033\WRKGADM.EXE" ...
Found an answer - http://www.techonthenet.com/access/security/wkgrp2.php the workgroup admin stuff isn't built into AC2K, which would be why I couldn't find...
Michael- As long as you have common control names on all your forms that have images, converting the code to Public Functions shouldn't be too difficult. In...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
