Search results

  1. D

    can anyone verify my sql behind a form

    You can download the sample database that I am working on. (oh, the link works) http://www.dbforums.com/attachment.php?postid=3583176 Ok, I am using following version. I don't want to put all the fields in sql (table.field1, table.field2). Instead, I want to feed two field (txtYear and...
  2. D

    tracking...

    Good Approach, but.... hi ghudson, good approach and it works, it does not insert new record. it keeps on overwriting the same record. so, let say i try form my pc, it works, then i go to ashley's pc it overwrites my info and replaces with hers. and so on. Now i don't even know if that...
  3. D

    tracking...

    That would not work... I am contineously updating the backends so no way track by modified date. Also, I can't delete the backends b/c then our department will receive thousands of new request for the job backend handles. I did think about your approach, but it simply will not work for my...
  4. D

    tracking...

    Server... Hi Dave, I agree with you. My ex worker created so many frontends and i am sure they are sitting on individual pc. However, the backends are on one server. I want to track the usage of the backends and delete the one that not in use in 30 days. Thanks Dianna
  5. D

    About to pull my last hair....

    How do I utilize openagrs? But there are two tables. tblplanmatrix should have new ga_record_id_2 (but similar to just like tbl_groups) and being able to copy the year before information. I feel like i did not make sense. Let me know if i sound confusing. Regards Dianna...
  6. D

    tracking...

    Hello, BACKGROUND: I inherited a project from another worker. She has 60 frontends and 60 backends. Currently, i can't mess with frontend anymore b/c tons of people have them on their local pc. However, I do have complete control over all the databank (backend), where we store all the data...
  7. D

    About to pull my last hair....

    If you want you can download the sample database from below. http://www.dbforums.com/attachment.php?postid=3558791 We are in a business where we have to carry some data from year to year. so, lets say I have a table with bunch of fields. My tbl_groups has three primary keys (ga_number...
  8. D

    NotInList

    step by step http://support.microsoft.com/default.aspx?scid=kb;en-us;125648
  9. D

    NotInList

    MS Link for onNotinlist http://support.microsoft.com/default.aspx?scid=kb;en-us;125648
  10. D

    Always show full menus problem

    more on toolbar Design Toolbar Extra This routine allows you to display toolbar to assist in the design of a Form or Report. There are a number of steps required to ensure this example works. Create a toolbar called "FormsTools" Add 5 buttons to the toolbar in the following order. (These must...
  11. D

    Required field on form not working

    Try Form Before update Put this on Form Properties before update Private Sub Form_BeforeUpdate(Cancel As Integer) DoCmd.SetWarnings (Not dataOK) End Sub Private Function dataOK() As Boolean 'Assume success dataOK = True 'Now test emplyness If Nz(Me![1st_rjct], "") <> "" And...
  12. D

    Here are some help full links and sample DB

    It's my windows explorer favorite. Enjoy my collection. Dianna
  13. D

    Update Form Fields with a Command Button

    You need vb Assumption: You know somewhat VBA txtnext_step is the name of the field contain next_step and so on. ============================================ you can put after update on your next_step if me.txtnext_step = something then me.txtcurrent_step =...
  14. D

    report

    Create report 1. You will need to create a report first. 2. Then put a button on your form to print that report to a file, export to file or save a snap shot. 3. http://www.dbforums.com/attachment.php?postid=3558791 4. Download my database from above link. 5. Then open the switchboard and...
  15. D

    New records don't show in form???

    spot check... > did you take a inventory of your table. meaning did you check your table for the new data. > May be system did not even created the new data. > Lets say system did populate the new data, but with a different format. What do I mean? Well, sometime if your field is set to number...
  16. D

    New Record

    Northwind Database Sample.... Open Northwind Database, then open the form called "orders" which is a subform called "Orders Subform". Go all the way to the last record, then click again on the forward arrow to create a new record. YOU SHOULD GET YOUR ANSWER. Here is link from Microsoft for...
  17. D

    Query Using Form Troubles

    I think you can create a text box on your form called txtTodaysDate then Between [Forms]![HUSubmitDteFrm]![SubmitAfterDate] And [Forms]![HUSubmitDteFrm]![txtTodaysDate] =========================================== If it's behind a form meaning behind a button: "WHERE (table.datefield Between...
  18. D

    Update Query in form

    thanks Thank mile and houstontx. appreciated your prompt respond. Dianna
  19. D

    verify update sql

    sorry and thanks Thank mile and houstontx. appreciated your prompt respond. Dianna
  20. D

    Update Query in form

    Can someone please verify my update code? this is behind form close. When closing the form I want system to look for empty field in ga_record_id_2 (text) and if it's empty then copy ga_record_id to ga_record_id_2. When I run the sql in a seperate query it works. But it does not work in the...
Back
Top Bottom