Search results

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...

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...

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...

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

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...

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...

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...

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

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

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...

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...

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

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 =...

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...

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...

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...

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...

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

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

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...