Randoz
Last Activity: Jun 19 '09, 12:30 PM
Joined: May 22 '07
Location:
-
The priority number is based on how many records there are. It is a unique field and changes when ever another record is changed to a higher priority. The total number of records can increase or decrease depending on when jobs are completed or new ones are added. The Priority field must be able to be manualy changed for a record and then change all other priority fields in the other records so all jobs can be completed in order. -
Re numbering a field when changing another record
I have a simple data base with items that need to be worked on. Each record has a unique number assigned as a priority. The numbers are 1-100 for example, in the order that they are to be worked on. I want to be able to change record 50 form 50th priority to another priority (manualy) say to priority 5 and then change all records previously 5-49 to 6-50 priority and allows for the new priority 5. Any help on how to do this would be greatly appriceated.... -
Forgive but I'm a little confused at the first line. If my main form is frmPersEntry based on qryMainConnecto r based on all the tables linked and the subform is frmEducation, based on qryEducation then table tblEducation. tblIndex has field 'Index' linked to field 'EdIndexNo' in tblEducation. How would I write the line? Thanks.Leave a comment:
-
I'm kinda seeing where you are going with this, I just have to remember how to change it to an update form.Leave a comment:
-
Creating new records with a form and multi subforms
I have a table with 8 child tables that are suppose to be one-to-one relationship to main table (some how it got changed to one-to-many). I am haveing trouble creating a new record in a form that contains the 8 tables as subforms. I can create a new record in the main form but when I click one of the subforms, I get a message that the Microsoft jet database engine cannot find a record in the table 'tblxxx' with key matching field(s) 'qryxxx.indexno '.... -
Thank you so much, it worked great.Leave a comment:
-
Determing Current Page (Tab) on an Access Form
I have 4 different pages (Tabs) on a form filled with different data. I have a 'Save" button for the whole form. When I click on the save button I want to be able to do different funcitons based on which Tab is on top. What VBA code do I use to determine what Tab is on top. -
I get data via a spread sheet with employee information. I up load this info into a data base. Occasionaly I get future spread sheets with new employees and updated current employee information. I want to be able to bring in the new and updated info. The table in the data base and the spread sheet fields always equal each other.Leave a comment:
-
I copied the tblPersAdd tabe from tblPers table. I need a master table so the user can't mess up the master.Leave a comment:
-
I created an append query and was able to add a new record with out a problem. However, I was not able to update certain fields on the main table with the append query or update query. When I created the Update Query and ran it, I kept getting a window stating that the data base didn't updated 0 fields due to a type conversion failure, 1 record due to key violations, 0 records due to lock violations and 0 records due to validation rule violations....Leave a comment:
-
How do I update fields in one table from another table
I have two identical tables with all the same field headers. One is my master "tblPers" and the other is a user input one "tblPersAdd ". How do I incorprate the changes from the user one to my master? I have tried the append query and the update query to no avail. Maybe I am doing something wrong. The name is the one unique field between them, it will never change. Thanks for the help. -
Yes, that is the case, thanks for the help. At least I can get the computer name....Leave a comment:
-
This works great, thanks. But, why are all the UserNames "Admin"?Leave a comment:
-
I have a combo box set up to either select from existing text or add new text.Leave a comment:
-
This works great for text box, but shouldn't it work for a combo box as well. I can't seem to get it to work on a combo box.
RandyLeave a comment:
-
Problem with shared access program
I have a shared access program is a shared directory on a server. I have put no restictions are set up anything different than the defaults. Some indivduals are not having any problem at all and love the input/output of the data. However, some indivduals click on the location and the file comes to their desktop as a 'read-only' file. Another indivdual will click on an item in the switchboard and they will do a back up of the database. Does anyone... -
Thanks Linq, that will do what I need to do.Leave a comment:
-
I have field that is required uless another field is filled in with certan text.Leave a comment:
-
Turn off required property via code
I am trying to write an if/then statement to disable the "Required Property" and then to enable it after a record is saved. Almost like the visible and locked code. -
Thanks everyone, I tried Johns ideal and it works. Appreciate the help.Leave a comment:
No activity results to display
Leave a comment: