JPS- Can Shrink works only if there's nothing but data controls on the subform. Make each Subform about 0.01" high and set Can Grow to True. John Viescas,...
Patrica- Are you importing the Spreadsheet data? The best method would be to define an Access table for the fields that you need, define appropriate indexes ...
Patrica- Did you mean to say "replicate"? You should place a "copy" of the front end on each local computer. It's a bad idea to share a single front end over...
Merging values across records Code-less alternative ===================== Russ, If the maximum number of rows required to be merged for the given item is not...
Hello Everyone, Another module I am working on is assigning users to folders. First, I have a form which allows users to defined Folders. Data is saved to the...
Lyanne- There's no need to duplicate the Folder Name and Full User Name in your linking table. If you use a linking table, then a folder can have many users...
Dear All, Please help me on how to do this: I have two tables, one is exactly the copy of the other. What I want to do is, there will be double data entry. ...
Hi John, I will remove the Folder Name and the Full User Name from my table then. Folder Name is linked to the Folder Table and Full User Name is linked to the...
Thank you John and adt_y for your help with this challenge. I suspect there is a real use for this out there. There are some really big retailers, of course....
Lyanne- The "standard" way to do this is to add a subform to the form that edits folders that edits your linking table. Set the Link properties of the subform...
Kai- What is the structure of the two tables? What can you use to match rows? John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft...
Thanks, John I will try that one. I need to insert into the LDAPUserList table all the values from the LDAPUserListTemp table using the query below: ...
Hi Lyanne, firstly, your fieldlist should not have table aliases, just fieldnames in the table you are inserting into (L.FullUserName,L.FirstName, ... --> ...
Moderators, I posted a question last night/yesterday about combining multiple lines in a query. Please disregard. I see what I did wrong. Thanks, Russell...
Good Day, I am relatively new to using Access but I need to use it for a school project to build an Accounting Database. I am trying to combine two queries...
Can you explain a little more about your header and detail forms? Are they two different forms? How are they related? Can you post the SQL for the queries? May...
In Access when you create a new database, there is a wizard there are some templates that you can pick from. You may want to build a database from a template...
avionelle- Asking you to build an Accounting database for a school project is like asking you to pilot a jet plane when you hold only a learner's license for ...
avionelle- You should probably create a Report to produce the Invoice. Code behind your command button should open the report filtered for the current order. ...
Dear John, my table structure is as follows: HCID - AutoNumber PatientID - Number FormNumber - text CenterNumber - text AdmissionDate - Date/Time DateOfBirth -...
Kai- It appears that HCID is the Primary Key of the two tables, but it's unlikely that you'll be able to match on that. A match on PatientID seems logical, ...
God dag Crystal, I have just uploaded my present file, Tot-Ove1-3-march.zip. I have now come a bit forward and made the corrections that you suggested. I have...
Hello this is a code i created to be able to get the multiple users i have selected in the form. i was able to select the users in the form an select folder...
Lyanne- I thought you removed both the user name and folder name from your "linking" table. The UsrID that you're inserting provides a link to the Users...
Hi John, i removed the user name and folder name already. i was referring to the username since that was the value seen in the form. it should have been saving...
Lyanne- The Row Source of your list box should include the UsrID, and that should be the bound column. You can make the Column Width of that column 0" so that...
Thanks, John. I have already changed it. Now, I am having an error in Set frm = Forms!Form_Assign. what should be the value set in Set frm? John Viescas...
hello, i have updated my code the one below but i am having an error in ctl = Forms![frmAssignUserstoFolders].Form![listFolderUserList] [code] Private Sub...
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.
