Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. genxiii

    Query Help

    hey guys. I need some help on a query that I'm have a lot of problems with. I have the following two tables. There's a 1 to many relationship between the two tables. Project ID Project === ======= 1 Testing 2 Planning 3 Development Status ID StatusDate Status ===...
  2. genxiii

    Not allowing next record

    i could do that but i have a lot of subforms that i also need to add to the record at the same time and it makes things a whole lot more complicated
  3. genxiii

    Not allowing next record

    hey guys, i have a problem here i can't figure. I have a form where the user will be making a record entry for the first time ever. once the entry is made they have to exit the form. i don't want them to access any other record including a new empty one. I've taken out all the controls to do...
  4. genxiii

    saving a record

    Rick, i tried that code but got the same error. None of my fields are "required" except for the primary key itself.
  5. genxiii

    saving a record

    hey guys, i'm trying to save a record on a form even before the entire for is filled out. As soon as the primary key is filled out i want it to automatically save the record. i'm running the code to save on the afterupdate event DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ...
  6. genxiii

    Using variable to refer to control on subform

    worked like a charm, thanks a lot bill. yeah n sorry bout the misunderstanding. i made a copy of the form bfor i started messin with the code.
  7. genxiii

    Using variable to refer to control on subform

    Hey guys, i was wondering if this was possible or not. I have a form call SearchCopy and a subform called SearchResultCopy, the subform is in datasheet view. On my form there is a listbox of all the controls on the subform. All the columns on the subform are hidden. When they are selected...
  8. genxiii

    Hide Unhide forms

    hey guys, i need some help on hiding and unhiding a form. i created a macro and i selected the "Select Object" Action and selected a form called Login. Next i selected the action "RunCommand" and selected the command "Window Hide". That works fine to hide the...
  9. genxiii

    Capturing current month problem

    yeah, you were right, i totally missed that. i have a field called month that that form was bounded to so it kept refering to that field instead of the month fuction. i can't believe i overlooked that. thanks a lot. problem solved.
  10. genxiii

    Capturing current month problem

    Hey guys, Hoping if someone can explain this to me and why i'm having a problem. I have a form that is bound to a table. I'm using VBA to capture and store the integer # of the current month. When I run it though I keep getting the error message "Type Mismatch". Here's my code...
  11. genxiii

    Append Query to 2 linked tables

    Hey guys, i'm kinda stuck on this little problem which probably is easy but i can't figure it out. I have two tables that are linked together with a primary key "ActionID" which is an auto number. What I need to do is copy all the records that have the "Ongoing" field...
  12. genxiii

    triggering an even based on a date

    hey guys, hope you can help with this problem i'm having. i have a table with a couple of records with a check box field called "ongoing." When this is checked, the record is to be carried over to the next year. I have to make a duplicate of the record for historical purposes...
  13. genxiii

    Move objects on a form with VBA

    it worked, thanks a lot guys. i kinda figured that's how ur suppose to do it but i wasn't sure if you were just suppose to retype the control name on the other side of the = n jus add or subtract from it.
  14. genxiii

    Move objects on a form with VBA

    Hey guys, i'm trying to figure out how you can move an object to a differnt position on a form using VBA. I don't want to use .Left =(position on screen) and designate the exact location where the object should be. I want to subtract or add a certain twip distance from/to an object's current...
  15. genxiii

    help with Access query

    hey guys. i'm stumped on a problem and i need some help. i have two tables with a 1 to many relationship. i'm need to run a query that will bring the records of the two tables together. my problem is that some records on the 1 table has many records in the many table so when i run the query...
  16. genxiii

    Query problem

    yeah, sorry for the difficulty on my explanation. I jus didn't know how to put it into words. let me guess jus show what i have now and what i'm looking for. Table1 Table2 P_ID ProjectName P_ID L_ID ---- ----------- ---------- P1 Project1 P1 L1 P2 Project2...
  17. genxiii

    Query problem

    hey guys, i'm having a problem with a query that i need help. first off i have 2 tables (1 to many relationship). I'm running the query from parameters on a form. Here's my problem. when i run the query, since its a 1 to many relationship, some of the records are duplicates except for the...

Part and Inventory Search

Back
Top